This data as json, CSV (advanced)
Link | rowid | target_id | ad_id |
---|---|---|---|
32524 | 32524 | b08d4 | 526 526 |
32525 | 32525 | 9527f | 526 526 |
32526 | 32526 | f4bd7 | 526 526 |
32527 | 32527 | ae23f | 526 526 |
32528 | 32528 | 371f0 | 526 526 |
32529 | 32529 | 5e075 | 526 526 |
32530 | 32530 | 59d75 | 526 526 |
32531 | 32531 | e6200 | 526 526 |
32532 | 32532 | b1201 | 526 526 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets ( target_id TEXT REFERENCES [targets]([id]), ad_id INTEGER REFERENCES [ads]([id]) )