This data as json, CSV (advanced)
Link | rowid | target_id | ad_id |
---|---|---|---|
1286 | 1286 | 13ab6 | 2804 2804 |
5953 | 5953 | 13ab6 | 2826 2826 |
15637 | 15637 | 13ab6 | 3377 3377 |
15734 | 15734 | 13ab6 | 3324 3324 |
16483 | 16483 | 13ab6 | 1137 1137 |
16927 | 16927 | 13ab6 | 3369 3369 |
17020 | 17020 | 13ab6 | 1186 1186 |
17289 | 17289 | 13ab6 | 3317 3317 |
17565 | 17565 | 13ab6 | 1040 1040 |
17648 | 17648 | 13ab6 | 1133 1133 |
20328 | 20328 | 13ab6 | 943 943 |
21977 | 21977 | 13ab6 | 1013 1013 |
22827 | 22827 | 13ab6 | 1011 1011 |
25994 | 25994 | 13ab6 | 3335 3335 |
26839 | 26839 | 13ab6 | 3365 3365 |
27554 | 27554 | 13ab6 | 946 946 |
28780 | 28780 | 13ab6 | 1029 1029 |
30127 | 30127 | 13ab6 | 1032 1032 |
36432 | 36432 | 13ab6 | 1054 1054 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets ( target_id TEXT REFERENCES [targets]([id]), ad_id INTEGER REFERENCES [ads]([id]) )