This data as JSON, CSV (advanced)
Link | rowid | target_id | ad_id |
---|---|---|---|
36010 | 36010 | 33643 | 3513 3513 |
36024 | 36024 | 33643 | 3509 3509 |
36047 | 36047 | 33643 | 3508 3508 |
36068 | 36068 | 33643 | 3510 3510 |
36091 | 36091 | 33643 | 3514 3514 |
36151 | 36151 | 33643 | 3512 3512 |
36165 | 36165 | 33643 | 3506 3506 |
36293 | 36293 | 33643 | 3507 3507 |
36307 | 36307 | 33643 | 3511 3511 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets ( target_id TEXT REFERENCES [targets]([id]), ad_id INTEGER REFERENCES [ads]([id]) )