This data as json, CSV (advanced)
Link | rowid | target_id | ad_id |
---|---|---|---|
28547 | 28547 | d1b15 | 3199 3199 |
28900 | 28900 | d1b15 | 3219 3219 |
29466 | 29466 | d1b15 | 3220 3220 |
29701 | 29701 | d1b15 | 3228 3228 |
30092 | 30092 | d1b15 | 3224 3224 |
30238 | 30238 | d1b15 | 3227 3227 |
36267 | 36267 | d1b15 | 3230 3230 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets ( target_id TEXT REFERENCES [targets]([id]), ad_id INTEGER REFERENCES [ads]([id]) )