This data as json, CSV (advanced)
Suggested facets: ad_id
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 11242 | 11242 | 95e7c | 1686 1686 |
| 11541 | 11541 | 95e7c | 31 31 |
| 11789 | 11789 | 95e7c | 0 0 |
| 11797 | 11797 | 95e7c | 0 0 |
| 12010 | 12010 | 95e7c | 1809 1809 |
| 13091 | 13091 | 95e7c | 34 34 |
| 33429 | 33429 | 95e7c | 35 35 |
| 33965 | 33965 | 95e7c | 1876 1876 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)