This data as json, CSV (advanced)
Link | rowid | target_id | ad_id |
---|---|---|---|
16383 | 16383 | f678f | 3338 3338 |
17755 | 17755 | f678f | 3340 3340 |
23225 | 23225 | f678f | 3351 3351 |
23434 | 23434 | f678f | 3325 3325 |
23518 | 23518 | f678f | 3319 3319 |
24499 | 24499 | f678f | 3318 3318 |
24590 | 24590 | f678f | 3332 3332 |
26166 | 26166 | f678f | 3326 3326 |
27487 | 27487 | f678f | 3341 3341 |
27794 | 27794 | f678f | 3322 3322 |
27934 | 27934 | f678f | 3361 3361 |
28030 | 28030 | f678f | 3321 3321 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets ( target_id TEXT REFERENCES [targets]([id]), ad_id INTEGER REFERENCES [ads]([id]) )