This data as json, CSV (advanced)
Link | rowid | target_id | ad_id |
---|---|---|---|
13772 | 13772 | 810be | 566 566 |
13773 | 13773 | 4d271 | 566 566 |
13774 | 13774 | e6200 | 566 566 |
13775 | 13775 | b1201 | 566 566 |
13776 | 13776 | 179a3 | 566 566 |
13777 | 13777 | 56aa3 | 566 566 |
13778 | 13778 | f22cf | 566 566 |
13779 | 13779 | 10585 | 566 566 |
13780 | 13780 | c08cd | 566 566 |
13781 | 13781 | 9ced8 | 566 566 |
13782 | 13782 | 9ec28 | 566 566 |
13783 | 13783 | a1291 | 566 566 |
13784 | 13784 | 6341e | 566 566 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets ( target_id TEXT REFERENCES [targets]([id]), ad_id INTEGER REFERENCES [ads]([id]) )