This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 34889 | 34889 | ec3ac | 1837 1837 |
| 34890 | 34890 | 371f0 | 1837 1837 |
| 34891 | 34891 | 59d75 | 1837 1837 |
| 34892 | 34892 | 3502d | 1837 1837 |
| 34893 | 34893 | 21e56 | 1837 1837 |
| 34894 | 34894 | ac298 | 1837 1837 |
| 34895 | 34895 | 10832 | 1837 1837 |
| 34896 | 34896 | b07dd | 1837 1837 |
| 34897 | 34897 | 0d501 | 1837 1837 |
| 34898 | 34898 | 1bc6c | 1837 1837 |
| 34899 | 34899 | 631df | 1837 1837 |
| 34900 | 34900 | 83345 | 1837 1837 |
| 34901 | 34901 | 8751c | 1837 1837 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)