This data as json, CSV (advanced)
Link | rowid | target_id | ad_id |
---|---|---|---|
11848 | 11848 | ec3ac | 810 810 |
11849 | 11849 | 1c31d | 810 810 |
11850 | 11850 | 5e075 | 810 810 |
11851 | 11851 | 59d75 | 810 810 |
11852 | 11852 | e6200 | 810 810 |
11853 | 11853 | b1201 | 810 810 |
11854 | 11854 | b42a4 | 810 810 |
11855 | 11855 | d679e | 810 810 |
11856 | 11856 | 17bc7 | 810 810 |
11857 | 11857 | aa04d | 810 810 |
11858 | 11858 | 95f91 | 810 810 |
11859 | 11859 | 9faf6 | 810 810 |
11860 | 11860 | e7597 | 810 810 |
11861 | 11861 | 13f83 | 810 810 |
11862 | 11862 | ecb59 | 810 810 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets ( target_id TEXT REFERENCES [targets]([id]), ad_id INTEGER REFERENCES [ads]([id]) )