This data as json, CSV (advanced)
Link | rowid | target_id | ad_id |
---|---|---|---|
15089 | 15089 | ec3ac | 3413 3413 |
15090 | 15090 | 21b44 | 3413 3413 |
15091 | 15091 | 00d26 | 3413 3413 |
15092 | 15092 | 5e075 | 3413 3413 |
15093 | 15093 | 59d75 | 3413 3413 |
15094 | 15094 | e6200 | 3413 3413 |
15095 | 15095 | 26bad | 3413 3413 |
15096 | 15096 | cd1a8 | 3413 3413 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets ( target_id TEXT REFERENCES [targets]([id]), ad_id INTEGER REFERENCES [ads]([id]) )