This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 11315 | 11315 | ec3ac | 1661 1661 |
| 11316 | 11316 | 4de4f | 1661 1661 |
| 11317 | 11317 | a14cf | 1661 1661 |
| 11318 | 11318 | 5e075 | 1661 1661 |
| 11319 | 11319 | a4abf | 1661 1661 |
| 11320 | 11320 | 59d75 | 1661 1661 |
| 11321 | 11321 | b1201 | 1661 1661 |
| 11322 | 11322 | a7c5b | 1661 1661 |
| 11323 | 11323 | da63e | 1661 1661 |
| 11324 | 11324 | 9800f | 1661 1661 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)