This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 9224 | 9224 | ec3ac | 1887 1887 |
| 9225 | 9225 | e3356 | 1887 1887 |
| 9226 | 9226 | 680d4 | 1887 1887 |
| 9227 | 9227 | 27c20 | 1887 1887 |
| 9228 | 9228 | fe1e7 | 1887 1887 |
| 9229 | 9229 | 371f0 | 1887 1887 |
| 9230 | 9230 | 59d75 | 1887 1887 |
| 9231 | 9231 | 3502d | 1887 1887 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)