This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 12710 | 12710 | 4a670 | 1336 1336 |
| 12758 | 12758 | 4a670 | 1338 1338 |
| 12798 | 12798 | 4a670 | 1344 1344 |
| 13484 | 13484 | 4a670 | 1342 1342 |
| 13529 | 13529 | 4a670 | 1346 1346 |
| 13577 | 13577 | 4a670 | 1340 1340 |
| 13646 | 13646 | 4a670 | 1334 1334 |
| 13856 | 13856 | 4a670 | 1348 1348 |
| 13916 | 13916 | 4a670 | 1272 1272 |
| 13926 | 13926 | 4a670 | 1354 1354 |
| 14132 | 14132 | 4a670 | 1326 1326 |
| 14270 | 14270 | 4a670 | 1364 1364 |
| 14338 | 14338 | 4a670 | 1358 1358 |
| 14375 | 14375 | 4a670 | 1376 1376 |
| 14424 | 14424 | 4a670 | 1372 1372 |
| 14473 | 14473 | 4a670 | 1370 1370 |
| 14710 | 14710 | 4a670 | 1368 1368 |
| 14815 | 14815 | 4a670 | 1374 1374 |
| 14866 | 14866 | 4a670 | 1360 1360 |
| 14901 | 14901 | 4a670 | 1366 1366 |
| 14947 | 14947 | 4a670 | 1362 1362 |
| 15105 | 15105 | 4a670 | 1283 1283 |
| 15231 | 15231 | 4a670 | 1352 1352 |
| 15241 | 15241 | 4a670 | 1356 1356 |
| 15311 | 15311 | 4a670 | 1350 1350 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)