This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 9488 | 9488 | e5ea3 | 1382 1382 |
| 9536 | 9536 | e5ea3 | 1388 1388 |
| 9845 | 9845 | e5ea3 | 1385 1385 |
| 10218 | 10218 | e5ea3 | 1379 1379 |
| 10485 | 10485 | e5ea3 | 1281 1281 |
| 10897 | 10897 | e5ea3 | 1311 1311 |
| 10917 | 10917 | e5ea3 | 1288 1288 |
| 11413 | 11413 | e5ea3 | 1381 1381 |
| 11436 | 11436 | e5ea3 | 1387 1387 |
| 11565 | 11565 | e5ea3 | 1384 1384 |
| 11578 | 11578 | e5ea3 | 1378 1378 |
| 11825 | 11825 | e5ea3 | 1280 1280 |
| 11956 | 11956 | e5ea3 | 1287 1287 |
| 12014 | 12014 | e5ea3 | 1310 1310 |
| 33366 | 33366 | e5ea3 | 1380 1380 |
| 33404 | 33404 | e5ea3 | 1386 1386 |
| 33579 | 33579 | e5ea3 | 1296 1296 |
| 33709 | 33709 | e5ea3 | 1294 1294 |
| 33718 | 33718 | e5ea3 | 1383 1383 |
| 33796 | 33796 | e5ea3 | 1297 1297 |
| 33839 | 33839 | e5ea3 | 1276 1276 |
| 33913 | 33913 | e5ea3 | 1279 1279 |
| 33954 | 33954 | e5ea3 | 1308 1308 |
| 33970 | 33970 | e5ea3 | 1377 1377 |
| 34015 | 34015 | e5ea3 | 1309 1309 |
| 34071 | 34071 | e5ea3 | 1273 1273 |
| 34098 | 34098 | e5ea3 | 1277 1277 |
| 34157 | 34157 | e5ea3 | 1286 1286 |
| 34181 | 34181 | e5ea3 | 1316 1316 |
| 34190 | 34190 | e5ea3 | 1307 1307 |
| 34443 | 34443 | e5ea3 | 1322 1322 |
| 34475 | 34475 | e5ea3 | 1318 1318 |
| 34485 | 34485 | e5ea3 | 1315 1315 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)