This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 17484 | 17484 | b7cc8 | 2964 2964 |
| 17485 | 17485 | 7b150 | 2964 2964 |
| 17486 | 17486 | bf1e7 | 2964 2964 |
| 17487 | 17487 | e6200 | 2964 2964 |
| 17488 | 17488 | b1201 | 2964 2964 |
| 17489 | 17489 | 46d55 | 2964 2964 |
| 17490 | 17490 | 77d7e | 2964 2964 |
| 17491 | 17491 | a5efc | 2964 2964 |
| 17492 | 17492 | e5437 | 2964 2964 |
| 17493 | 17493 | 469ba | 2964 2964 |
| 17494 | 17494 | feaa7 | 2964 2964 |
| 17495 | 17495 | 71d36 | 2964 2964 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)