This data as json, CSV (advanced)
Link | rowid | target_id | ad_id |
---|---|---|---|
3612 | 3612 | 1ef30 | 399 399 |
3613 | 3613 | dd761 | 399 399 |
3614 | 3614 | 0c41e | 399 399 |
3615 | 3615 | d5d33 | 399 399 |
3616 | 3616 | 6fba5 | 399 399 |
3617 | 3617 | 371f0 | 399 399 |
3618 | 3618 | 5e075 | 399 399 |
3619 | 3619 | 59d75 | 399 399 |
3620 | 3620 | e6200 | 399 399 |
3621 | 3621 | b1201 | 399 399 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets ( target_id TEXT REFERENCES [targets]([id]), ad_id INTEGER REFERENCES [ads]([id]) )