This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 33173 | 33173 | a2353 | 5 5 |
| 33174 | 33174 | 371f0 | 5 5 |
| 33175 | 33175 | 3502d | 5 5 |
| 33176 | 33176 | 9fe34 | 5 5 |
| 33177 | 33177 | b83a3 | 5 5 |
| 33178 | 33178 | c3973 | 5 5 |
| 33179 | 33179 | 99241 | 5 5 |
| 33180 | 33180 | 40ff5 | 5 5 |
| 33181 | 33181 | ba9f6 | 5 5 |
| 33182 | 33182 | 8fb0c | 5 5 |
| 33183 | 33183 | 4acaf | 5 5 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)