This data as json, CSV (advanced)
Link | rowid | target_id | ad_id |
---|---|---|---|
33606 | 33606 | ec3ac | 920 920 |
33607 | 33607 | b668a | 920 920 |
33608 | 33608 | aaf5a | 920 920 |
33609 | 33609 | 5e075 | 920 920 |
33610 | 33610 | 59d75 | 920 920 |
33611 | 33611 | e6200 | 920 920 |
33612 | 33612 | b1201 | 920 920 |
33613 | 33613 | b42a4 | 920 920 |
33614 | 33614 | d679e | 920 920 |
33615 | 33615 | 17bc7 | 920 920 |
33616 | 33616 | aa04d | 920 920 |
33617 | 33617 | 95f91 | 920 920 |
33618 | 33618 | 7ce59 | 920 920 |
33619 | 33619 | a524c | 920 920 |
33620 | 33620 | 234f1 | 920 920 |
33621 | 33621 | 100b7 | 920 920 |
33622 | 33622 | 1518e | 920 920 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets ( target_id TEXT REFERENCES [targets]([id]), ad_id INTEGER REFERENCES [ads]([id]) )