This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 11118 | 11118 | ec3ac | 1908 1908 |
| 11119 | 11119 | d1e7b | 1908 1908 |
| 11120 | 11120 | 3502d | 1908 1908 |
| 11121 | 11121 | bb3a2 | 1908 1908 |
| 11122 | 11122 | ab8e0 | 1908 1908 |
| 11123 | 11123 | 6db25 | 1908 1908 |
| 11124 | 11124 | 40a0a | 1908 1908 |
| 11125 | 11125 | f32cf | 1908 1908 |
| 11126 | 11126 | a52bd | 1908 1908 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)