This data as json, CSV (advanced)
Link | rowid | target_id | ad_id |
---|---|---|---|
12966 | 12966 | e91c0 | 3498 3498 |
13114 | 13114 | e91c0 | 3486 3486 |
13249 | 13249 | e91c0 | 3494 3494 |
13280 | 13280 | e91c0 | 3490 3490 |
14057 | 14057 | e91c0 | 3482 3482 |
14398 | 14398 | e91c0 | 3469 3469 |
14510 | 14510 | e91c0 | 3473 3473 |
15498 | 15498 | e91c0 | 3478 3478 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets ( target_id TEXT REFERENCES [targets]([id]), ad_id INTEGER REFERENCES [ads]([id]) )