This data as json, CSV (advanced)
Link | rowid | target_id | ad_id |
---|---|---|---|
15722 | 15722 | bb729 | 3308 3308 |
15997 | 15997 | bb729 | 3307 3307 |
17122 | 17122 | bb729 | 3310 3310 |
17229 | 17229 | bb729 | 3309 3309 |
17242 | 17242 | bb729 | 3311 3311 |
17814 | 17814 | bb729 | 3286 3286 |
29499 | 29499 | bb729 | 3282 3282 |
29867 | 29867 | bb729 | 3283 3283 |
30147 | 30147 | bb729 | 3281 3281 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets ( target_id TEXT REFERENCES [targets]([id]), ad_id INTEGER REFERENCES [ads]([id]) )