This data as json, CSV (advanced)
Link | rowid | target_id | ad_id |
---|---|---|---|
11831 | 11831 | ec3ac | 785 785 |
11832 | 11832 | b668a | 785 785 |
11833 | 11833 | aaf5a | 785 785 |
11834 | 11834 | 5e075 | 785 785 |
11835 | 11835 | 59d75 | 785 785 |
11836 | 11836 | e6200 | 785 785 |
11837 | 11837 | b1201 | 785 785 |
11838 | 11838 | b42a4 | 785 785 |
11839 | 11839 | d679e | 785 785 |
11840 | 11840 | 17bc7 | 785 785 |
11841 | 11841 | aa04d | 785 785 |
11842 | 11842 | 95f91 | 785 785 |
11843 | 11843 | 7ce59 | 785 785 |
11844 | 11844 | a524c | 785 785 |
11845 | 11845 | 234f1 | 785 785 |
11846 | 11846 | 100b7 | 785 785 |
11847 | 11847 | 1518e | 785 785 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets ( target_id TEXT REFERENCES [targets]([id]), ad_id INTEGER REFERENCES [ads]([id]) )