This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 6052 | 6052 | a1291 | 691 691 |
| 7605 | 7605 | a1291 | 686 686 |
| 11278 | 11278 | a1291 | 591 591 |
| 12857 | 12857 | a1291 | 618 618 |
| 12903 | 12903 | a1291 | 619 619 |
| 13783 | 13783 | a1291 | 566 566 |
| 34744 | 34744 | a1291 | 592 592 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)