This data as json, CSV (advanced)
Link | rowid | target_id | ad_id |
---|---|---|---|
12695 | 12695 | ad989 | 3401 3401 |
13364 | 13364 | ad989 | 3398 3398 |
13419 | 13419 | ad989 | 3404 3404 |
13985 | 13985 | ad989 | 3411 3411 |
14248 | 14248 | ad989 | 3418 3418 |
15008 | 15008 | ad989 | 3408 3408 |
15053 | 15053 | ad989 | 3414 3414 |
15397 | 15397 | ad989 | 3422 3422 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets ( target_id TEXT REFERENCES [targets]([id]), ad_id INTEGER REFERENCES [ads]([id]) )