This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 1426 | 1426 | ebcbb | 2260 2260 |
| 1427 | 1427 | 4801f | 2260 2260 |
| 1428 | 1428 | 5e075 | 2260 2260 |
| 1429 | 1429 | 59d75 | 2260 2260 |
| 1430 | 1430 | e6200 | 2260 2260 |
| 1431 | 1431 | b1201 | 2260 2260 |
| 1432 | 1432 | 8a7ee | 2260 2260 |
| 1433 | 1433 | 862ed | 2260 2260 |
| 1434 | 1434 | 18a64 | 2260 2260 |
| 1435 | 1435 | 9848a | 2260 2260 |
| 1436 | 1436 | abb72 | 2260 2260 |
| 1437 | 1437 | 93975 | 2260 2260 |
| 1438 | 1438 | 27369 | 2260 2260 |
| 1439 | 1439 | 7ee91 | 2260 2260 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)