This data as json, CSV (advanced)
Link | rowid | target_id | ad_id |
---|---|---|---|
16328 | 16328 | f7021 | 3298 3298 |
16858 | 16858 | f7021 | 3306 3306 |
17149 | 17149 | f7021 | 3288 3288 |
17167 | 17167 | f7021 | 3294 3294 |
17337 | 17337 | f7021 | 3293 3293 |
17375 | 17375 | f7021 | 3289 3289 |
17596 | 17596 | f7021 | 3291 3291 |
17989 | 17989 | f7021 | 3287 3287 |
18130 | 18130 | f7021 | 3292 3292 |
18234 | 18234 | f7021 | 3305 3305 |
18275 | 18275 | f7021 | 3299 3299 |
36348 | 36348 | f7021 | 3301 3301 |
36391 | 36391 | f7021 | 3303 3303 |
36405 | 36405 | f7021 | 3302 3302 |
36414 | 36414 | f7021 | 3297 3297 |
36448 | 36448 | f7021 | 3295 3295 |
36461 | 36461 | f7021 | 3300 3300 |
36484 | 36484 | f7021 | 3304 3304 |
36503 | 36503 | f7021 | 3296 3296 |
36511 | 36511 | f7021 | 3290 3290 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets ( target_id TEXT REFERENCES [targets]([id]), ad_id INTEGER REFERENCES [ads]([id]) )