This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 16734 | 16734 | 7c76f | 2385 2385 |
| 17860 | 17860 | 7c76f | 2367 2367 |
| 26986 | 26986 | 7c76f | 3327 3327 |
| 27682 | 27682 | 7c76f | 3347 3347 |
| 27884 | 27884 | 7c76f | 3320 3320 |
| 28798 | 28798 | 7c76f | 3183 3183 |
| 28861 | 28861 | 7c76f | 3184 3184 |
| 29247 | 29247 | 7c76f | 3185 3185 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)