This data as json, CSV (advanced)
Link | rowid | target_id | ad_id |
---|---|---|---|
33502 | 33502 | ec3ac | 848 848 |
33503 | 33503 | 1c31d | 848 848 |
33504 | 33504 | 5e075 | 848 848 |
33505 | 33505 | 59d75 | 848 848 |
33506 | 33506 | e6200 | 848 848 |
33507 | 33507 | b1201 | 848 848 |
33508 | 33508 | 0b529 | 848 848 |
33509 | 33509 | 65a38 | 848 848 |
33510 | 33510 | be4a2 | 848 848 |
33511 | 33511 | d75c0 | 848 848 |
33512 | 33512 | 16071 | 848 848 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets ( target_id TEXT REFERENCES [targets]([id]), ad_id INTEGER REFERENCES [ads]([id]) )