This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 26809 | 26809 | ec3ac | 3392 3392 |
| 26810 | 26810 | cba3e | 3392 3392 |
| 26811 | 26811 | 371f0 | 3392 3392 |
| 26812 | 26812 | e6200 | 3392 3392 |
| 26813 | 26813 | b1201 | 3392 3392 |
| 26814 | 26814 | 902e5 | 3392 3392 |
| 26815 | 26815 | 36919 | 3392 3392 |
| 26816 | 26816 | 7e7c6 | 3392 3392 |
| 26817 | 26817 | 2eb2b | 3392 3392 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)