This data as json, CSV (advanced)
Link | rowid | target_id | ad_id |
---|---|---|---|
15866 | 15866 | 6d811 | 3376 3376 |
16189 | 16189 | 6d811 | 3375 3375 |
16315 | 16315 | 6d811 | 3374 3374 |
18169 | 18169 | 6d811 | 3353 3353 |
21064 | 21064 | 6d811 | 3355 3355 |
23778 | 23778 | 6d811 | 3315 3315 |
23823 | 23823 | 6d811 | 3350 3350 |
25460 | 25460 | 6d811 | 3333 3333 |
25550 | 25550 | 6d811 | 3346 3346 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets ( target_id TEXT REFERENCES [targets]([id]), ad_id INTEGER REFERENCES [ads]([id]) )