This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 31034 | 31034 | ec3ac | 1901 1901 |
| 31035 | 31035 | c4547 | 1901 1901 |
| 31036 | 31036 | d0693 | 1901 1901 |
| 31037 | 31037 | e623f | 1901 1901 |
| 31038 | 31038 | 7ac7b | 1901 1901 |
| 31039 | 31039 | 371f0 | 1901 1901 |
| 31040 | 31040 | 59d75 | 1901 1901 |
| 31041 | 31041 | 3502d | 1901 1901 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)