This data as json, CSV (advanced)
Link | rowid | target_id | ad_id |
---|---|---|---|
11521 | 11521 | 13f83 | 830 830 |
11609 | 11609 | 13f83 | 900 900 |
11758 | 11758 | 13f83 | 805 805 |
11861 | 11861 | 13f83 | 810 810 |
33386 | 33386 | 13f83 | 907 907 |
33551 | 33551 | 13f83 | 849 849 |
33577 | 33577 | 13f83 | 908 908 |
33688 | 33688 | 13f83 | 909 909 |
33733 | 33733 | 13f83 | 906 906 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets ( target_id TEXT REFERENCES [targets]([id]), ad_id INTEGER REFERENCES [ads]([id]) )