This data as json, CSV (advanced)
Link | rowid | target_id | ad_id |
---|---|---|---|
32980 | 32980 | f6566 | 2442 2442 |
32981 | 32981 | 8657c | 2442 2442 |
32982 | 32982 | bffb8 | 2442 2442 |
32983 | 32983 | 49b74 | 2442 2442 |
32984 | 32984 | 384b9 | 2442 2442 |
32985 | 32985 | aa920 | 2442 2442 |
32986 | 32986 | b733d | 2442 2442 |
32987 | 32987 | 57006 | 2442 2442 |
32988 | 32988 | bfd83 | 2442 2442 |
32989 | 32989 | 9eadd | 2442 2442 |
32990 | 32990 | 0d4bc | 2442 2442 |
32991 | 32991 | 73122 | 2442 2442 |
32992 | 32992 | e35f3 | 2442 2442 |
32993 | 32993 | f38f6 | 2442 2442 |
32994 | 32994 | d4179 | 2442 2442 |
32995 | 32995 | 8a526 | 2442 2442 |
32996 | 32996 | 1073c | 2442 2442 |
32997 | 32997 | 9e156 | 2442 2442 |
32998 | 32998 | e6200 | 2442 2442 |
32999 | 32999 | b1201 | 2442 2442 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets ( target_id TEXT REFERENCES [targets]([id]), ad_id INTEGER REFERENCES [ads]([id]) )