This data as json, CSV (advanced)
Link | rowid | target_id | ad_id |
---|---|---|---|
6274 | 6274 | 9d04d | 2533 2533 |
6303 | 6303 | 9d04d | 2540 2540 |
6555 | 6555 | 9d04d | 2504 2504 |
6645 | 6645 | 9d04d | 2480 2480 |
7075 | 7075 | 9d04d | 2528 2528 |
7308 | 7308 | 9d04d | 2479 2479 |
7464 | 7464 | 9d04d | 2487 2487 |
7640 | 7640 | 9d04d | 2520 2520 |
7938 | 7938 | 9d04d | 2488 2488 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets ( target_id TEXT REFERENCES [targets]([id]), ad_id INTEGER REFERENCES [ads]([id]) )