This data as json, CSV (advanced)
Link | rowid | target_id | ad_id |
---|---|---|---|
12427 | 12427 | ec3ac | 776 776 |
12428 | 12428 | b668a | 776 776 |
12429 | 12429 | a14cf | 776 776 |
12430 | 12430 | 5e075 | 776 776 |
12431 | 12431 | 59d75 | 776 776 |
12432 | 12432 | e6200 | 776 776 |
12433 | 12433 | b1201 | 776 776 |
12434 | 12434 | b42a4 | 776 776 |
12435 | 12435 | d679e | 776 776 |
12436 | 12436 | 17bc7 | 776 776 |
12437 | 12437 | aa04d | 776 776 |
12438 | 12438 | 95f91 | 776 776 |
12439 | 12439 | 65a38 | 776 776 |
12440 | 12440 | e128e | 776 776 |
12441 | 12441 | d75c0 | 776 776 |
12442 | 12442 | 16071 | 776 776 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets ( target_id TEXT REFERENCES [targets]([id]), ad_id INTEGER REFERENCES [ads]([id]) )