This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 116 | 116 | 9f5e5 | 475 475 |
| 433 | 433 | 9f5e5 | 2381 2381 |
| 734 | 734 | 9f5e5 | 474 474 |
| 959 | 959 | 9f5e5 | 473 473 |
| 1566 | 1566 | 9f5e5 | 472 472 |
| 1603 | 1603 | 9f5e5 | 2359 2359 |
| 20204 | 20204 | 9f5e5 | 2451 2451 |
| 20466 | 20466 | 9f5e5 | 2450 2450 |
| 30456 | 30456 | 9f5e5 | 2326 2326 |
| 30884 | 30884 | 9f5e5 | 467 467 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)