This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 1279 | 1279 | ec3ac | 2804 2804 |
| 1280 | 1280 | e4503 | 2804 2804 |
| 1281 | 1281 | 70feb | 2804 2804 |
| 1282 | 1282 | 59d75 | 2804 2804 |
| 1283 | 1283 | e6200 | 2804 2804 |
| 1284 | 1284 | b1201 | 2804 2804 |
| 1285 | 1285 | 3848b | 2804 2804 |
| 1286 | 1286 | 13ab6 | 2804 2804 |
| 1287 | 1287 | c69de | 2804 2804 |
| 1288 | 1288 | 14760 | 2804 2804 |
| 1289 | 1289 | 219a5 | 2804 2804 |
| 1290 | 1290 | e128e | 2804 2804 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)