This data as json, CSV (advanced)
Link | rowid | target_id | ad_id |
---|---|---|---|
15765 | 15765 | 6b1c5 | 3316 3316 |
16536 | 16536 | 6b1c5 | 3372 3372 |
16602 | 16602 | 6b1c5 | 3323 3323 |
16652 | 16652 | 6b1c5 | 3373 3373 |
16919 | 16919 | 6b1c5 | 3369 3369 |
17932 | 17932 | 6b1c5 | 3342 3342 |
18093 | 18093 | 6b1c5 | 3344 3344 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets ( target_id TEXT REFERENCES [targets]([id]), ad_id INTEGER REFERENCES [ads]([id]) )