This data as json, CSV (advanced)
Link | rowid | target_id | ad_id |
---|---|---|---|
14200 | 14200 | ec3ac | 3474 3474 |
14201 | 14201 | aa8b2 | 3474 3474 |
14202 | 14202 | 5e075 | 3474 3474 |
14203 | 14203 | 59d75 | 3474 3474 |
14204 | 14204 | e6200 | 3474 3474 |
14205 | 14205 | 26bad | 3474 3474 |
14206 | 14206 | 56921 | 3474 3474 |
14207 | 14207 | 1bffd | 3474 3474 |
14208 | 14208 | b043e | 3474 3474 |
14209 | 14209 | 31a58 | 3474 3474 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets ( target_id TEXT REFERENCES [targets]([id]), ad_id INTEGER REFERENCES [ads]([id]) )