This data as json, CSV (advanced)
Link | rowid | target_id | ad_id |
---|---|---|---|
32061 | 32061 | ec3ac | 285 285 |
32062 | 32062 | eaba0 | 285 285 |
32063 | 32063 | 37b6b | 285 285 |
32064 | 32064 | 40ff5 | 285 285 |
32065 | 32065 | 6fba5 | 285 285 |
32066 | 32066 | 1c31d | 285 285 |
32067 | 32067 | 5e075 | 285 285 |
32068 | 32068 | 59d75 | 285 285 |
32069 | 32069 | e6200 | 285 285 |
32070 | 32070 | b1201 | 285 285 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets ( target_id TEXT REFERENCES [targets]([id]), ad_id INTEGER REFERENCES [ads]([id]) )