This data as json, CSV (advanced)
Link | rowid | target_id | ad_id |
---|---|---|---|
5248 | 5248 | dfca7 | 1963 1963 |
5362 | 5362 | dfca7 | 1965 1965 |
5373 | 5373 | dfca7 | 1964 1964 |
36008 | 36008 | dfca7 | 3513 3513 |
36022 | 36022 | dfca7 | 3509 3509 |
36045 | 36045 | dfca7 | 3508 3508 |
36066 | 36066 | dfca7 | 3510 3510 |
36089 | 36089 | dfca7 | 3514 3514 |
36149 | 36149 | dfca7 | 3512 3512 |
36163 | 36163 | dfca7 | 3506 3506 |
36291 | 36291 | dfca7 | 3507 3507 |
36305 | 36305 | dfca7 | 3511 3511 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets ( target_id TEXT REFERENCES [targets]([id]), ad_id INTEGER REFERENCES [ads]([id]) )