This data as json, CSV (advanced)
Link | rowid | target_id | ad_id |
---|---|---|---|
310 | 310 | ec3ac | 857 857 |
311 | 311 | d6ade | 857 857 |
312 | 312 | 8e7b3 | 857 857 |
313 | 313 | 40c27 | 857 857 |
314 | 314 | d4179 | 857 857 |
315 | 315 | 313af | 857 857 |
316 | 316 | ebe26 | 857 857 |
317 | 317 | a06cb | 857 857 |
318 | 318 | 87fac | 857 857 |
319 | 319 | a0f55 | 857 857 |
320 | 320 | 2f957 | 857 857 |
321 | 321 | 61c1a | 857 857 |
322 | 322 | e6200 | 857 857 |
323 | 323 | b1201 | 857 857 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets ( target_id TEXT REFERENCES [targets]([id]), ad_id INTEGER REFERENCES [ads]([id]) )