This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 17850 | 17850 | 189ac | 2367 2367 |
| 17851 | 17851 | 371f0 | 2367 2367 |
| 17852 | 17852 | e6200 | 2367 2367 |
| 17853 | 17853 | b1201 | 2367 2367 |
| 17854 | 17854 | 5e6f8 | 2367 2367 |
| 17855 | 17855 | 463ae | 2367 2367 |
| 17856 | 17856 | 93324 | 2367 2367 |
| 17857 | 17857 | f9b79 | 2367 2367 |
| 17858 | 17858 | 06ae5 | 2367 2367 |
| 17859 | 17859 | 710d1 | 2367 2367 |
| 17860 | 17860 | 7c76f | 2367 2367 |
| 17861 | 17861 | e737a | 2367 2367 |
| 17862 | 17862 | c45c4 | 2367 2367 |
| 17863 | 17863 | 60bee | 2367 2367 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)