This data as JSON, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 11395 | 11395 | f36eb | 1674 1674 |
| 11468 | 11468 | f36eb | 1676 1676 |
| 11496 | 11496 | f36eb | 1610 1610 |
| 11588 | 11588 | f36eb | 1675 1675 |
| 11780 | 11780 | f36eb | 1621 1621 |
| 11813 | 11813 | f36eb | 1643 1643 |
| 11884 | 11884 | f36eb | 1677 1677 |
| 11927 | 11927 | f36eb | 1641 1641 |
| 11966 | 11966 | f36eb | 1652 1652 |
| 32325 | 32325 | f36eb | 1673 1673 |
| 32733 | 32733 | f36eb | 1642 1642 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)