This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 1286 | 1286 | 13ab6 | 2804 2804 |
| 5953 | 5953 | 13ab6 | 2826 2826 |
| 15637 | 15637 | 13ab6 | 3377 3377 |
| 15734 | 15734 | 13ab6 | 3324 3324 |
| 16483 | 16483 | 13ab6 | 1137 1137 |
| 16927 | 16927 | 13ab6 | 3369 3369 |
| 17020 | 17020 | 13ab6 | 1186 1186 |
| 17289 | 17289 | 13ab6 | 3317 3317 |
| 17565 | 17565 | 13ab6 | 1040 1040 |
| 17648 | 17648 | 13ab6 | 1133 1133 |
| 20328 | 20328 | 13ab6 | 943 943 |
| 21977 | 21977 | 13ab6 | 1013 1013 |
| 22827 | 22827 | 13ab6 | 1011 1011 |
| 25994 | 25994 | 13ab6 | 3335 3335 |
| 26839 | 26839 | 13ab6 | 3365 3365 |
| 27554 | 27554 | 13ab6 | 946 946 |
| 28780 | 28780 | 13ab6 | 1029 1029 |
| 30127 | 30127 | 13ab6 | 1032 1032 |
| 36432 | 36432 | 13ab6 | 1054 1054 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)