This data as json, CSV (advanced)
Link | rowid | target_id | ad_id |
---|---|---|---|
2263 | 2263 | ebcbb | 2339 2339 |
2264 | 2264 | 4801f | 2339 2339 |
2265 | 2265 | 5e075 | 2339 2339 |
2266 | 2266 | 59d75 | 2339 2339 |
2267 | 2267 | e6200 | 2339 2339 |
2268 | 2268 | b1201 | 2339 2339 |
2269 | 2269 | 8a7ee | 2339 2339 |
2270 | 2270 | 862ed | 2339 2339 |
2271 | 2271 | 18a64 | 2339 2339 |
2272 | 2272 | 9848a | 2339 2339 |
2273 | 2273 | abb72 | 2339 2339 |
2274 | 2274 | 93975 | 2339 2339 |
2275 | 2275 | 27369 | 2339 2339 |
2276 | 2276 | 7ee91 | 2339 2339 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets ( target_id TEXT REFERENCES [targets]([id]), ad_id INTEGER REFERENCES [ads]([id]) )