This data as json, CSV (advanced)
Link | rowid | target_id | ad_id |
---|---|---|---|
13984 | 13984 | ec3ac | 3411 3411 |
13985 | 13985 | ad989 | 3411 3411 |
13986 | 13986 | 00d26 | 3411 3411 |
13987 | 13987 | 5e075 | 3411 3411 |
13988 | 13988 | 59d75 | 3411 3411 |
13989 | 13989 | e6200 | 3411 3411 |
13990 | 13990 | 26bad | 3411 3411 |
13991 | 13991 | cd1a8 | 3411 3411 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets ( target_id TEXT REFERENCES [targets]([id]), ad_id INTEGER REFERENCES [ads]([id]) )