This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 8822 | 8822 | 9800f | 1666 1666 |
| 8968 | 8968 | 9800f | 1629 1629 |
| 9242 | 9242 | 9800f | 1655 1655 |
| 9293 | 9293 | 9800f | 1659 1659 |
| 9304 | 9304 | 9800f | 1614 1614 |
| 11262 | 11262 | 9800f | 1631 1631 |
| 11324 | 11324 | 9800f | 1661 1661 |
| 11451 | 11451 | 9800f | 1632 1632 |
| 11485 | 11485 | 9800f | 1662 1662 |
| 11507 | 11507 | 9800f | 1668 1668 |
| 11717 | 11717 | 9800f | 1669 1669 |
| 11922 | 11922 | 9800f | 1616 1616 |
| 12008 | 12008 | 9800f | 1617 1617 |
| 12082 | 12082 | 9800f | 1660 1660 |
| 12152 | 12152 | 9800f | 1630 1630 |
| 12265 | 12265 | 9800f | 1667 1667 |
| 12564 | 12564 | 9800f | 1615 1615 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)