This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 10424 | 10424 | ec3ac | 1917 1917 |
| 10425 | 10425 | d1e7b | 1917 1917 |
| 10426 | 10426 | 3502d | 1917 1917 |
| 10427 | 10427 | bb3a2 | 1917 1917 |
| 10428 | 10428 | 9c156 | 1917 1917 |
| 10429 | 10429 | 40a0a | 1917 1917 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)