This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 22469 | 22469 | cc5ed | 2559 2559 |
| 22470 | 22470 | 371f0 | 2559 2559 |
| 22471 | 22471 | e6200 | 2559 2559 |
| 22472 | 22472 | b1201 | 2559 2559 |
| 22473 | 22473 | d9d8c | 2559 2559 |
| 22474 | 22474 | 5f10e | 2559 2559 |
| 22475 | 22475 | 81cf6 | 2559 2559 |
| 22476 | 22476 | 5849a | 2559 2559 |
| 22477 | 22477 | eab5e | 2559 2559 |
| 22478 | 22478 | 8b401 | 2559 2559 |
| 22479 | 22479 | 007df | 2559 2559 |
| 22480 | 22480 | 5dcb2 | 2559 2559 |
| 22481 | 22481 | d3539 | 2559 2559 |
| 22482 | 22482 | 60626 | 2559 2559 |
| 22483 | 22483 | 4a957 | 2559 2559 |
| 22484 | 22484 | 839f9 | 2559 2559 |
| 22485 | 22485 | ffca2 | 2559 2559 |
| 22486 | 22486 | 4f89e | 2559 2559 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)