This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 27243 | 27243 | cc5ed | 3114 3114 |
| 27244 | 27244 | d6ade | 3114 3114 |
| 27245 | 27245 | 8e7b3 | 3114 3114 |
| 27246 | 27246 | d4179 | 3114 3114 |
| 27247 | 27247 | 313af | 3114 3114 |
| 27248 | 27248 | ebe26 | 3114 3114 |
| 27249 | 27249 | aabe0 | 3114 3114 |
| 27250 | 27250 | a0f55 | 3114 3114 |
| 27251 | 27251 | 7b150 | 3114 3114 |
| 27252 | 27252 | e6200 | 3114 3114 |
| 27253 | 27253 | b1201 | 3114 3114 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)