This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 6470 | 6470 | bffb8 | 1663 1663 |
| 6471 | 6471 | 49b74 | 1663 1663 |
| 6472 | 6472 | 169d2 | 1663 1663 |
| 6473 | 6473 | 70544 | 1663 1663 |
| 6474 | 6474 | 2a4ca | 1663 1663 |
| 6475 | 6475 | 57006 | 1663 1663 |
| 6476 | 6476 | 9eadd | 1663 1663 |
| 6477 | 6477 | 18d8d | 1663 1663 |
| 6478 | 6478 | 4de4f | 1663 1663 |
| 6479 | 6479 | a14cf | 1663 1663 |
| 6480 | 6480 | 5e075 | 1663 1663 |
| 6481 | 6481 | 59d75 | 1663 1663 |
| 6482 | 6482 | b1201 | 1663 1663 |
| 6483 | 6483 | 03f36 | 1663 1663 |
| 6484 | 6484 | cf7f4 | 1663 1663 |
| 6485 | 6485 | a9066 | 1663 1663 |
| 6486 | 6486 | d976f | 1663 1663 |
| 6487 | 6487 | d7035 | 1663 1663 |
| 6488 | 6488 | e31e2 | 1663 1663 |
| 6489 | 6489 | a4c1d | 1663 1663 |
| 6490 | 6490 | 46194 | 1663 1663 |
| 6491 | 6491 | d8324 | 1663 1663 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)