This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 17268 | 17268 | a26ae | 2960 2960 |
| 17269 | 17269 | c3503 | 2960 2960 |
| 17270 | 17270 | ec3ac | 2960 2960 |
| 17271 | 17271 | cb80d | 2960 2960 |
| 17272 | 17272 | 371f0 | 2960 2960 |
| 17273 | 17273 | 5e075 | 2960 2960 |
| 17274 | 17274 | 59d75 | 2960 2960 |
| 17275 | 17275 | e6200 | 2960 2960 |
| 17276 | 17276 | b1201 | 2960 2960 |
| 17277 | 17277 | 902e5 | 2960 2960 |
| 17278 | 17278 | bc1ac | 2960 2960 |
| 17279 | 17279 | 77d7e | 2960 2960 |
| 17280 | 17280 | c46d7 | 2960 2960 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)