This data as json, CSV (advanced)
Link | rowid | target_id | ad_id |
---|---|---|---|
4055 | 4055 | ec3ac | 585 585 |
4056 | 4056 | 7d863 | 585 585 |
4057 | 4057 | cda75 | 585 585 |
4058 | 4058 | eed19 | 585 585 |
4059 | 4059 | bde08 | 585 585 |
4060 | 4060 | 84f2d | 585 585 |
4061 | 4061 | 7a280 | 585 585 |
4062 | 4062 | 1aff9 | 585 585 |
4063 | 4063 | 6816d | 585 585 |
4064 | 4064 | f7146 | 585 585 |
4065 | 4065 | b23d5 | 585 585 |
4066 | 4066 | 0b2ab | 585 585 |
4067 | 4067 | 371f0 | 585 585 |
4068 | 4068 | 5e075 | 585 585 |
4069 | 4069 | 59d75 | 585 585 |
4070 | 4070 | e6200 | 585 585 |
4071 | 4071 | b1201 | 585 585 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets ( target_id TEXT REFERENCES [targets]([id]), ad_id INTEGER REFERENCES [ads]([id]) )