This data as json, CSV (advanced)
Link | rowid | target_id | ad_id |
---|---|---|---|
16123 | 16123 | 32bde | 3329 3329 |
16398 | 16398 | 32bde | 3338 3338 |
17399 | 17399 | 32bde | 3357 3357 |
17770 | 17770 | 32bde | 3340 3340 |
17947 | 17947 | 32bde | 3342 3342 |
23240 | 23240 | 32bde | 3351 3351 |
23316 | 23316 | 32bde | 3331 3331 |
23449 | 23449 | 32bde | 3325 3325 |
23533 | 23533 | 32bde | 3319 3319 |
24514 | 24514 | 32bde | 3318 3318 |
24605 | 24605 | 32bde | 3332 3332 |
24723 | 24723 | 32bde | 3352 3352 |
25959 | 25959 | 32bde | 3362 3362 |
26181 | 26181 | 32bde | 3326 3326 |
26977 | 26977 | 32bde | 3327 3327 |
27373 | 27373 | 32bde | 3339 3339 |
27502 | 27502 | 32bde | 3341 3341 |
27673 | 27673 | 32bde | 3347 3347 |
27809 | 27809 | 32bde | 3322 3322 |
27875 | 27875 | 32bde | 3320 3320 |
27949 | 27949 | 32bde | 3361 3361 |
28045 | 28045 | 32bde | 3321 3321 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets ( target_id TEXT REFERENCES [targets]([id]), ad_id INTEGER REFERENCES [ads]([id]) )