This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 3077 | 3077 | 18d8d | 323 323 |
| 3087 | 3087 | 18d8d | 94 94 |
| 3270 | 3270 | 18d8d | 319 319 |
| 3304 | 3304 | 18d8d | 324 324 |
| 3324 | 3324 | 18d8d | 322 322 |
| 3406 | 3406 | 18d8d | 95 95 |
| 3424 | 3424 | 18d8d | 320 320 |
| 3463 | 3463 | 18d8d | 100 100 |
| 3564 | 3564 | 18d8d | 321 321 |
| 3734 | 3734 | 18d8d | 101 101 |
| 3760 | 3760 | 18d8d | 54 54 |
| 3786 | 3786 | 18d8d | 53 53 |
| 3995 | 3995 | 18d8d | 111 111 |
| 4048 | 4048 | 18d8d | 110 110 |
| 5741 | 5741 | 18d8d | 1670 1670 |
| 5814 | 5814 | 18d8d | 1664 1664 |
| 6032 | 6032 | 18d8d | 1634 1634 |
| 6227 | 6227 | 18d8d | 1633 1633 |
| 6413 | 6413 | 18d8d | 1671 1671 |
| 6477 | 6477 | 18d8d | 1663 1663 |
| 6624 | 6624 | 18d8d | 1619 1619 |
| 7325 | 7325 | 18d8d | 1618 1618 |
| 14046 | 14046 | 18d8d | 1709 1709 |
| 35300 | 35300 | 18d8d | 32 32 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)