This data as json, CSV (advanced)
Link | rowid | target_id | ad_id |
---|---|---|---|
2396 | 2396 | fb88d | 1249 1249 |
2397 | 2397 | 28463 | 1249 1249 |
2398 | 2398 | c4902 | 1249 1249 |
2399 | 2399 | 9dc02 | 1249 1249 |
2400 | 2400 | ec4f5 | 1249 1249 |
2401 | 2401 | dad97 | 1249 1249 |
2402 | 2402 | 17a50 | 1249 1249 |
2403 | 2403 | e95f6 | 1249 1249 |
2404 | 2404 | 1c31d | 1249 1249 |
2405 | 2405 | 5e075 | 1249 1249 |
2406 | 2406 | 59d75 | 1249 1249 |
2407 | 2407 | e6200 | 1249 1249 |
2408 | 2408 | b1201 | 1249 1249 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets ( target_id TEXT REFERENCES [targets]([id]), ad_id INTEGER REFERENCES [ads]([id]) )