This data as json, CSV (advanced)
Link | rowid | target_id | ad_id |
---|---|---|---|
18504 | 18504 | ec3ac | 980 980 |
18505 | 18505 | 4801f | 980 980 |
18506 | 18506 | 5e075 | 980 980 |
18507 | 18507 | 59d75 | 980 980 |
18508 | 18508 | e6200 | 980 980 |
18509 | 18509 | b1201 | 980 980 |
18510 | 18510 | d6347 | 980 980 |
18511 | 18511 | ebf60 | 980 980 |
18512 | 18512 | 9a8c6 | 980 980 |
18513 | 18513 | a2d21 | 980 980 |
18514 | 18514 | a1307 | 980 980 |
18515 | 18515 | abb72 | 980 980 |
18516 | 18516 | 41b26 | 980 980 |
18517 | 18517 | 2db78 | 980 980 |
18518 | 18518 | 6a38c | 980 980 |
18519 | 18519 | e128e | 980 980 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets ( target_id TEXT REFERENCES [targets]([id]), ad_id INTEGER REFERENCES [ads]([id]) )