This data as json, CSV (advanced)
Link | rowid | target_id | ad_id |
---|---|---|---|
27281 | 27281 | ec3ac | 968 968 |
27282 | 27282 | 4801f | 968 968 |
27283 | 27283 | 5e075 | 968 968 |
27284 | 27284 | 59d75 | 968 968 |
27285 | 27285 | e6200 | 968 968 |
27286 | 27286 | b1201 | 968 968 |
27287 | 27287 | d6347 | 968 968 |
27288 | 27288 | ebf60 | 968 968 |
27289 | 27289 | 9a8c6 | 968 968 |
27290 | 27290 | 91693 | 968 968 |
27291 | 27291 | 1d2ab | 968 968 |
27292 | 27292 | abb72 | 968 968 |
27293 | 27293 | 41b26 | 968 968 |
27294 | 27294 | 2db78 | 968 968 |
27295 | 27295 | 6a38c | 968 968 |
27296 | 27296 | e128e | 968 968 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets ( target_id TEXT REFERENCES [targets]([id]), ad_id INTEGER REFERENCES [ads]([id]) )