This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 6734 | 6734 | 5185c | 1611 1611 |
| 7846 | 7846 | 5185c | 1654 1654 |
| 31657 | 31657 | 5185c | 1903 1903 |
| 31708 | 31708 | 5185c | 1628 1628 |
| 31828 | 31828 | 5185c | 1627 1627 |
| 31871 | 31871 | 5185c | 1648 1648 |
| 31970 | 31970 | 5185c | 1626 1626 |
| 32031 | 32031 | 5185c | 1649 1649 |
| 32827 | 32827 | 5185c | 1656 1656 |
| 33171 | 33171 | 5185c | 1657 1657 |
| 33209 | 33209 | 5185c | 1624 1624 |
| 33288 | 33288 | 5185c | 1646 1646 |
| 35219 | 35219 | 5185c | 1637 1637 |
| 35239 | 35239 | 5185c | 1639 1639 |
| 35448 | 35448 | 5185c | 1638 1638 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)