This data as json, CSV (advanced)
Link | rowid | target_id | ad_id |
---|---|---|---|
31680 | 31680 | bae1c | 51 51 |
32281 | 32281 | bae1c | 50 50 |
32485 | 32485 | bae1c | 98 98 |
32686 | 32686 | bae1c | 63 63 |
32695 | 32695 | bae1c | 99 99 |
32779 | 32779 | bae1c | 109 109 |
34516 | 34516 | bae1c | 292 292 |
34528 | 34528 | bae1c | 296 296 |
34730 | 34730 | bae1c | 300 300 |
34759 | 34759 | bae1c | 294 294 |
35096 | 35096 | bae1c | 293 293 |
35101 | 35101 | bae1c | 297 297 |
35136 | 35136 | bae1c | 301 301 |
35146 | 35146 | bae1c | 295 295 |
35221 | 35221 | bae1c | 291 291 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets ( target_id TEXT REFERENCES [targets]([id]), ad_id INTEGER REFERENCES [ads]([id]) )