This data as json, CSV (advanced)
Link | rowid | target_id | ad_id |
---|---|---|---|
35507 | 35507 | 28463 | 1214 1214 |
35508 | 35508 | 24da8 | 1214 1214 |
35509 | 35509 | d5b86 | 1214 1214 |
35510 | 35510 | 36203 | 1214 1214 |
35511 | 35511 | 17a50 | 1214 1214 |
35512 | 35512 | aa5af | 1214 1214 |
35513 | 35513 | 16102 | 1214 1214 |
35514 | 35514 | 59677 | 1214 1214 |
35515 | 35515 | 40ff5 | 1214 1214 |
35516 | 35516 | e95f6 | 1214 1214 |
35517 | 35517 | 371f0 | 1214 1214 |
35518 | 35518 | 5e075 | 1214 1214 |
35519 | 35519 | 59d75 | 1214 1214 |
35520 | 35520 | e6200 | 1214 1214 |
35521 | 35521 | b1201 | 1214 1214 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets ( target_id TEXT REFERENCES [targets]([id]), ad_id INTEGER REFERENCES [ads]([id]) )