This data as json, CSV (advanced)
Link | rowid | target_id | ad_id |
---|---|---|---|
10991 | 10991 | 77d5d | 486 486 |
10992 | 10992 | 7b150 | 486 486 |
10993 | 10993 | 5e075 | 486 486 |
10994 | 10994 | 59d75 | 486 486 |
10995 | 10995 | e6200 | 486 486 |
10996 | 10996 | b1201 | 486 486 |
10997 | 10997 | 201fd | 486 486 |
10998 | 10998 | 326e8 | 486 486 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets ( target_id TEXT REFERENCES [targets]([id]), ad_id INTEGER REFERENCES [ads]([id]) )