This data as json, CSV (advanced)
Link | rowid | target_id | ad_id |
---|---|---|---|
28226 | 28226 | ec3ac | 960 960 |
28227 | 28227 | 4801f | 960 960 |
28228 | 28228 | 5e075 | 960 960 |
28229 | 28229 | 59d75 | 960 960 |
28230 | 28230 | e6200 | 960 960 |
28231 | 28231 | b1201 | 960 960 |
28232 | 28232 | d6347 | 960 960 |
28233 | 28233 | ebf60 | 960 960 |
28234 | 28234 | 9a8c6 | 960 960 |
28235 | 28235 | 91693 | 960 960 |
28236 | 28236 | 1d2ab | 960 960 |
28237 | 28237 | abb72 | 960 960 |
28238 | 28238 | 41b26 | 960 960 |
28239 | 28239 | 2db78 | 960 960 |
28240 | 28240 | 6a38c | 960 960 |
28241 | 28241 | e128e | 960 960 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets ( target_id TEXT REFERENCES [targets]([id]), ad_id INTEGER REFERENCES [ads]([id]) )