This data as json, CSV (advanced)
Link | rowid | target_id | ad_id |
---|---|---|---|
21160 | 21160 | ec3ac | 996 996 |
21161 | 21161 | 4801f | 996 996 |
21162 | 21162 | 5e075 | 996 996 |
21163 | 21163 | 59d75 | 996 996 |
21164 | 21164 | e6200 | 996 996 |
21165 | 21165 | b1201 | 996 996 |
21166 | 21166 | d6347 | 996 996 |
21167 | 21167 | ebf60 | 996 996 |
21168 | 21168 | 9a8c6 | 996 996 |
21169 | 21169 | a2d21 | 996 996 |
21170 | 21170 | a1307 | 996 996 |
21171 | 21171 | abb72 | 996 996 |
21172 | 21172 | 41b26 | 996 996 |
21173 | 21173 | 2db78 | 996 996 |
21174 | 21174 | 6a38c | 996 996 |
21175 | 21175 | e128e | 996 996 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets ( target_id TEXT REFERENCES [targets]([id]), ad_id INTEGER REFERENCES [ads]([id]) )