This data as json, CSV (advanced)
Link | rowid | target_id | ad_id |
---|---|---|---|
25508 | 25508 | cc5ed | 2924 2924 |
25509 | 25509 | cb80d | 2924 2924 |
25510 | 25510 | 371f0 | 2924 2924 |
25511 | 25511 | bf1e7 | 2924 2924 |
25512 | 25512 | e6200 | 2924 2924 |
25513 | 25513 | b1201 | 2924 2924 |
25514 | 25514 | 902e5 | 2924 2924 |
25515 | 25515 | bc1ac | 2924 2924 |
25516 | 25516 | 22955 | 2924 2924 |
25517 | 25517 | 6ec75 | 2924 2924 |
25518 | 25518 | 77d7e | 2924 2924 |
25519 | 25519 | feaa7 | 2924 2924 |
25520 | 25520 | 07bb3 | 2924 2924 |
25521 | 25521 | a7f5a | 2924 2924 |
25522 | 25522 | 4a7fd | 2924 2924 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets ( target_id TEXT REFERENCES [targets]([id]), ad_id INTEGER REFERENCES [ads]([id]) )