This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 8788 | 8788 | 2951c | 1899 1899 |
| 8807 | 8807 | 2951c | 1898 1898 |
| 8879 | 8879 | 2951c | 1397 1397 |
| 8891 | 8891 | 2951c | 1395 1395 |
| 8917 | 8917 | 2951c | 1392 1392 |
| 8947 | 8947 | 2951c | 1390 1390 |
| 9044 | 9044 | 2951c | 1285 1285 |
| 9077 | 9077 | 2951c | 1320 1320 |
| 9122 | 9122 | 2951c | 1303 1303 |
| 9164 | 9164 | 2951c | 1403 1403 |
| 9213 | 9213 | 2951c | 1399 1399 |
| 9317 | 9317 | 2951c | 1401 1401 |
| 9329 | 9329 | 2951c | 1407 1407 |
| 9347 | 9347 | 2951c | 1405 1405 |
| 31068 | 31068 | 2951c | 27 27 |
| 31109 | 31109 | 2951c | 21 21 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)