This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 23334 | 23334 | cc5ed | 2920 2920 |
| 23335 | 23335 | c1190 | 2920 2920 |
| 23336 | 23336 | cb80d | 2920 2920 |
| 23337 | 23337 | 371f0 | 2920 2920 |
| 23338 | 23338 | bf1e7 | 2920 2920 |
| 23339 | 23339 | e6200 | 2920 2920 |
| 23340 | 23340 | b1201 | 2920 2920 |
| 23341 | 23341 | 902e5 | 2920 2920 |
| 23342 | 23342 | bc1ac | 2920 2920 |
| 23343 | 23343 | 6ec75 | 2920 2920 |
| 23344 | 23344 | 5b456 | 2920 2920 |
| 23345 | 23345 | 77d7e | 2920 2920 |
| 23346 | 23346 | 469ba | 2920 2920 |
| 23347 | 23347 | 1aa29 | 2920 2920 |
| 23348 | 23348 | b0c29 | 2920 2920 |
| 23349 | 23349 | 87529 | 2920 2920 |
| 23350 | 23350 | 266f1 | 2920 2920 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)