This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 608 | 608 | d003e | 2378 2378 |
| 1105 | 1105 | d003e | 2377 2377 |
| 1943 | 1943 | d003e | 2343 2343 |
| 2068 | 2068 | d003e | 2344 2344 |
| 5330 | 5330 | d003e | 2375 2375 |
| 5709 | 5709 | d003e | 2376 2376 |
| 6324 | 6324 | d003e | 844 844 |
| 6440 | 6440 | d003e | 2512 2512 |
| 6712 | 6712 | d003e | 801 801 |
| 7122 | 7122 | d003e | 2526 2526 |
| 7346 | 7346 | d003e | 2341 2341 |
| 7983 | 7983 | d003e | 800 800 |
| 8037 | 8037 | d003e | 2342 2342 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)