This data as json, CSV (advanced)
Link | rowid | target_id | ad_id |
---|---|---|---|
14503 | 14503 | ec3ac | 3473 3473 |
14504 | 14504 | 371f0 | 3473 3473 |
14505 | 14505 | 5e075 | 3473 3473 |
14506 | 14506 | 59d75 | 3473 3473 |
14507 | 14507 | e6200 | 3473 3473 |
14508 | 14508 | 973a3 | 3473 3473 |
14509 | 14509 | f52db | 3473 3473 |
14510 | 14510 | e91c0 | 3473 3473 |
14511 | 14511 | 016a4 | 3473 3473 |
14512 | 14512 | 15a9f | 3473 3473 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets ( target_id TEXT REFERENCES [targets]([id]), ad_id INTEGER REFERENCES [ads]([id]) )