This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 36350 | 36350 | cc5ed | 2968 2968 |
| 36351 | 36351 | cb80d | 2968 2968 |
| 36352 | 36352 | 371f0 | 2968 2968 |
| 36353 | 36353 | 59d75 | 2968 2968 |
| 36354 | 36354 | e6200 | 2968 2968 |
| 36355 | 36355 | b1201 | 2968 2968 |
| 36356 | 36356 | 902e5 | 2968 2968 |
| 36357 | 36357 | bc1ac | 2968 2968 |
| 36358 | 36358 | b918e | 2968 2968 |
| 36359 | 36359 | 5b456 | 2968 2968 |
| 36360 | 36360 | 8a7eb | 2968 2968 |
| 36361 | 36361 | 72d8e | 2968 2968 |
| 36362 | 36362 | 77d7e | 2968 2968 |
| 36363 | 36363 | c46d7 | 2968 2968 |
| 36364 | 36364 | e5437 | 2968 2968 |
| 36365 | 36365 | 1fd76 | 2968 2968 |
| 36366 | 36366 | 469ba | 2968 2968 |
| 36367 | 36367 | feaa7 | 2968 2968 |
| 36368 | 36368 | b0879 | 2968 2968 |
| 36369 | 36369 | 927de | 2968 2968 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)