This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 7086 | 7086 | 685a3 | 2979 2979 |
| 9854 | 9854 | 685a3 | 1335 1335 |
| 9890 | 9890 | 685a3 | 1337 1337 |
| 9920 | 9920 | 685a3 | 1343 1343 |
| 9974 | 9974 | 685a3 | 1339 1339 |
| 10120 | 10120 | 685a3 | 1341 1341 |
| 10153 | 10153 | 685a3 | 1347 1347 |
| 10182 | 10182 | 685a3 | 1345 1345 |
| 10234 | 10234 | 685a3 | 1333 1333 |
| 10520 | 10520 | 685a3 | 1359 1359 |
| 10571 | 10571 | 685a3 | 1363 1363 |
| 10617 | 10617 | 685a3 | 1371 1371 |
| 10639 | 10639 | 685a3 | 1375 1375 |
| 10696 | 10696 | 685a3 | 1325 1325 |
| 10741 | 10741 | 685a3 | 1353 1353 |
| 10757 | 10757 | 685a3 | 1271 1271 |
| 10775 | 10775 | 685a3 | 1349 1349 |
| 10944 | 10944 | 685a3 | 1282 1282 |
| 10977 | 10977 | 685a3 | 1351 1351 |
| 11015 | 11015 | 685a3 | 1357 1357 |
| 11024 | 11024 | 685a3 | 1355 1355 |
| 11129 | 11129 | 685a3 | 1373 1373 |
| 11138 | 11138 | 685a3 | 1369 1369 |
| 11179 | 11179 | 685a3 | 1365 1365 |
| 11198 | 11198 | 685a3 | 1367 1367 |
| 11221 | 11221 | 685a3 | 1361 1361 |
| 19982 | 19982 | 685a3 | 764 764 |
| 20189 | 20189 | 685a3 | 763 763 |
| 20859 | 20859 | 685a3 | 762 762 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)