This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 33010 | 33010 | ec3ac | 1816 1816 |
| 33011 | 33011 | 674d7 | 1816 1816 |
| 33012 | 33012 | aa8b2 | 1816 1816 |
| 33013 | 33013 | e6200 | 1816 1816 |
| 33014 | 33014 | b1201 | 1816 1816 |
| 33015 | 33015 | 902e5 | 1816 1816 |
| 33016 | 33016 | c30e5 | 1816 1816 |
| 33017 | 33017 | e456e | 1816 1816 |
| 33018 | 33018 | cebf9 | 1816 1816 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)