This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 5337 | 5337 | ec3ac | 2955 2955 |
| 5338 | 5338 | cb80d | 2955 2955 |
| 5339 | 5339 | 371f0 | 2955 2955 |
| 5340 | 5340 | 5e075 | 2955 2955 |
| 5341 | 5341 | 59d75 | 2955 2955 |
| 5342 | 5342 | e6200 | 2955 2955 |
| 5343 | 5343 | b1201 | 2955 2955 |
| 5344 | 5344 | 902e5 | 2955 2955 |
| 5345 | 5345 | bc1ac | 2955 2955 |
| 5346 | 5346 | 6ec75 | 2955 2955 |
| 5347 | 5347 | 5b456 | 2955 2955 |
| 5348 | 5348 | 72d8e | 2955 2955 |
| 5349 | 5349 | 77d7e | 2955 2955 |
| 5350 | 5350 | c46d7 | 2955 2955 |
| 5351 | 5351 | e5437 | 2955 2955 |
| 5352 | 5352 | b3b48 | 2955 2955 |
| 5353 | 5353 | 469ba | 2955 2955 |
| 5354 | 5354 | feaa7 | 2955 2955 |
| 5355 | 5355 | 4fcc4 | 2955 2955 |
| 5356 | 5356 | b8d9b | 2955 2955 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)