This data as json, CSV (advanced)
Link | rowid | target_id | ad_id |
---|---|---|---|
16128 | 16128 | fa448 | 3329 3329 |
16403 | 16403 | fa448 | 3338 3338 |
17775 | 17775 | fa448 | 3340 3340 |
17952 | 17952 | fa448 | 3342 3342 |
23245 | 23245 | fa448 | 3351 3351 |
23322 | 23322 | fa448 | 3331 3331 |
23454 | 23454 | fa448 | 3325 3325 |
23538 | 23538 | fa448 | 3319 3319 |
24519 | 24519 | fa448 | 3318 3318 |
24610 | 24610 | fa448 | 3332 3332 |
24729 | 24729 | fa448 | 3352 3352 |
25964 | 25964 | fa448 | 3362 3362 |
26186 | 26186 | fa448 | 3326 3326 |
26983 | 26983 | fa448 | 3327 3327 |
27378 | 27378 | fa448 | 3339 3339 |
27507 | 27507 | fa448 | 3341 3341 |
27679 | 27679 | fa448 | 3347 3347 |
27814 | 27814 | fa448 | 3322 3322 |
27881 | 27881 | fa448 | 3320 3320 |
27954 | 27954 | fa448 | 3361 3361 |
28050 | 28050 | fa448 | 3321 3321 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets ( target_id TEXT REFERENCES [targets]([id]), ad_id INTEGER REFERENCES [ads]([id]) )