This data as json, CSV (advanced)
Link | rowid | target_id | ad_id |
---|---|---|---|
6399 | 6399 | ec3ac | 2895 2895 |
6400 | 6400 | 81c0c | 2895 2895 |
6401 | 6401 | bbe9d | 2895 2895 |
6402 | 6402 | e6200 | 2895 2895 |
6403 | 6403 | b1201 | 2895 2895 |
6404 | 6404 | 902e5 | 2895 2895 |
6405 | 6405 | b32b4 | 2895 2895 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets ( target_id TEXT REFERENCES [targets]([id]), ad_id INTEGER REFERENCES [ads]([id]) )