This data as json, CSV (advanced)
Link | rowid | target_id | ad_id |
---|---|---|---|
3992 | 3992 | 1ef30 | 111 111 |
3993 | 3993 | c448c | 111 111 |
3994 | 3994 | 69e43 | 111 111 |
3995 | 3995 | 18d8d | 111 111 |
3996 | 3996 | 6fba5 | 111 111 |
3997 | 3997 | 371f0 | 111 111 |
3998 | 3998 | 5e075 | 111 111 |
3999 | 3999 | 59d75 | 111 111 |
4000 | 4000 | e6200 | 111 111 |
4001 | 4001 | b1201 | 111 111 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets ( target_id TEXT REFERENCES [targets]([id]), ad_id INTEGER REFERENCES [ads]([id]) )