This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 9613 | 9613 | 4dc48 | 1464 1464 |
| 10085 | 10085 | 4dc48 | 1451 1451 |
| 10513 | 10513 | 4dc48 | 1437 1437 |
| 10545 | 10545 | 4dc48 | 1436 1436 |
| 10558 | 10558 | 4dc48 | 1440 1440 |
| 10597 | 10597 | 4dc48 | 1447 1447 |
| 10610 | 10610 | 4dc48 | 1454 1454 |
| 10654 | 10654 | 4dc48 | 1445 1445 |
| 10683 | 10683 | 4dc48 | 1438 1438 |
| 10711 | 10711 | 4dc48 | 1446 1446 |
| 10724 | 10724 | 4dc48 | 1453 1453 |
| 10873 | 10873 | 4dc48 | 1444 1444 |
| 10892 | 10892 | 4dc48 | 1448 1448 |
| 11153 | 11153 | 4dc48 | 1452 1452 |
| 11172 | 11172 | 4dc48 | 1450 1450 |
| 11236 | 11236 | 4dc48 | 1441 1441 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)