This data as json, CSV (advanced)
Link | rowid | target_id | ad_id |
---|---|---|---|
760 | 760 | ec3ac | 1134 1134 |
761 | 761 | 96bbd | 1134 1134 |
762 | 762 | 313af | 1134 1134 |
763 | 763 | ebe26 | 1134 1134 |
764 | 764 | 1073c | 1134 1134 |
765 | 765 | 4801f | 1134 1134 |
766 | 766 | 5e075 | 1134 1134 |
767 | 767 | 59d75 | 1134 1134 |
768 | 768 | e6200 | 1134 1134 |
769 | 769 | b1201 | 1134 1134 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets ( target_id TEXT REFERENCES [targets]([id]), ad_id INTEGER REFERENCES [ads]([id]) )