This data as json, CSV (advanced)
Link | rowid | target_id | ad_id |
---|---|---|---|
34398 | 34398 | ec3ac | 792 792 |
34399 | 34399 | b668a | 792 792 |
34400 | 34400 | a14cf | 792 792 |
34401 | 34401 | 5e075 | 792 792 |
34402 | 34402 | 59d75 | 792 792 |
34403 | 34403 | e6200 | 792 792 |
34404 | 34404 | b1201 | 792 792 |
34405 | 34405 | b42a4 | 792 792 |
34406 | 34406 | d679e | 792 792 |
34407 | 34407 | 17bc7 | 792 792 |
34408 | 34408 | aa04d | 792 792 |
34409 | 34409 | 95f91 | 792 792 |
34410 | 34410 | 65a38 | 792 792 |
34411 | 34411 | e128e | 792 792 |
34412 | 34412 | d75c0 | 792 792 |
34413 | 34413 | 16071 | 792 792 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets ( target_id TEXT REFERENCES [targets]([id]), ad_id INTEGER REFERENCES [ads]([id]) )