This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 169 | 169 | f9cc2 | 1098 1098 |
| 594 | 594 | f9cc2 | 3043 3043 |
| 714 | 714 | f9cc2 | 1095 1095 |
| 1297 | 1297 | f9cc2 | 3072 3072 |
| 1406 | 1406 | f9cc2 | 1179 1179 |
| 1453 | 1453 | f9cc2 | 1057 1057 |
| 1798 | 1798 | f9cc2 | 1074 1074 |
| 2042 | 2042 | f9cc2 | 1041 1041 |
| 2139 | 2139 | f9cc2 | 1021 1021 |
| 8231 | 8231 | f9cc2 | 0 0 |
| 29540 | 29540 | f9cc2 | 3068 3068 |
| 30383 | 30383 | f9cc2 | 3060 3060 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)