This data as json, CSV (advanced)
Link | rowid | target_id | ad_id |
---|---|---|---|
11298 | 11298 | ec3ac | 842 842 |
11299 | 11299 | b668a | 842 842 |
11300 | 11300 | aaf5a | 842 842 |
11301 | 11301 | 5e075 | 842 842 |
11302 | 11302 | 59d75 | 842 842 |
11303 | 11303 | e6200 | 842 842 |
11304 | 11304 | b1201 | 842 842 |
11305 | 11305 | b42a4 | 842 842 |
11306 | 11306 | d679e | 842 842 |
11307 | 11307 | 17bc7 | 842 842 |
11308 | 11308 | aa04d | 842 842 |
11309 | 11309 | 95f91 | 842 842 |
11310 | 11310 | 7ce59 | 842 842 |
11311 | 11311 | a524c | 842 842 |
11312 | 11312 | 234f1 | 842 842 |
11313 | 11313 | 100b7 | 842 842 |
11314 | 11314 | 1518e | 842 842 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets ( target_id TEXT REFERENCES [targets]([id]), ad_id INTEGER REFERENCES [ads]([id]) )