This data as json, CSV (advanced)
Link | rowid | target_id | ad_id |
---|---|---|---|
7602 | 7602 | f6566 | 686 686 |
7603 | 7603 | 384b9 | 686 686 |
7604 | 7604 | b733d | 686 686 |
7605 | 7605 | a1291 | 686 686 |
7606 | 7606 | c237c | 686 686 |
7607 | 7607 | 85029 | 686 686 |
7608 | 7608 | bf1e7 | 686 686 |
7609 | 7609 | e6200 | 686 686 |
7610 | 7610 | b1201 | 686 686 |
7611 | 7611 | bc1ac | 686 686 |
7612 | 7612 | b918e | 686 686 |
7613 | 7613 | 8123a | 686 686 |
7614 | 7614 | 5b456 | 686 686 |
7615 | 7615 | 40a0a | 686 686 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets ( target_id TEXT REFERENCES [targets]([id]), ad_id INTEGER REFERENCES [ads]([id]) )