This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 5173 | 5173 | 46194 | 1635 1635 |
| 5284 | 5284 | 46194 | 1665 1665 |
| 5454 | 5454 | 46194 | 1672 1672 |
| 5754 | 5754 | 46194 | 1670 1670 |
| 5829 | 5829 | 46194 | 1664 1664 |
| 6047 | 6047 | 46194 | 1634 1634 |
| 6240 | 6240 | 46194 | 1633 1633 |
| 6428 | 6428 | 46194 | 1671 1671 |
| 6490 | 6490 | 46194 | 1663 1663 |
| 6639 | 6639 | 46194 | 1619 1619 |
| 7275 | 7275 | 46194 | 1620 1620 |
| 7338 | 7338 | 46194 | 1618 1618 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)