This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 8820 | 8820 | a7c5b | 1666 1666 |
| 8966 | 8966 | a7c5b | 1629 1629 |
| 9240 | 9240 | a7c5b | 1655 1655 |
| 9291 | 9291 | a7c5b | 1659 1659 |
| 9302 | 9302 | a7c5b | 1614 1614 |
| 11260 | 11260 | a7c5b | 1631 1631 |
| 11322 | 11322 | a7c5b | 1661 1661 |
| 11449 | 11449 | a7c5b | 1632 1632 |
| 11483 | 11483 | a7c5b | 1662 1662 |
| 11505 | 11505 | a7c5b | 1668 1668 |
| 11715 | 11715 | a7c5b | 1669 1669 |
| 11920 | 11920 | a7c5b | 1616 1616 |
| 12006 | 12006 | a7c5b | 1617 1617 |
| 12080 | 12080 | a7c5b | 1660 1660 |
| 12150 | 12150 | a7c5b | 1630 1630 |
| 12263 | 12263 | a7c5b | 1667 1667 |
| 12562 | 12562 | a7c5b | 1615 1615 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)