This data as JSON, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 10305 | 10305 | 26b5a | 74 74 |
| 11520 | 11520 | 26b5a | 830 830 |
| 11608 | 11608 | 26b5a | 900 900 |
| 11757 | 11757 | 26b5a | 805 805 |
| 12349 | 12349 | 26b5a | 73 73 |
| 12847 | 12847 | 26b5a | 76 76 |
| 13225 | 13225 | 26b5a | 75 75 |
| 32362 | 32362 | 26b5a | 77 77 |
| 32555 | 32555 | 26b5a | 78 78 |
| 33550 | 33550 | 26b5a | 849 849 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)