This data as json, CSV (advanced)
Link | rowid | target_id | ad_id |
---|---|---|---|
18292 | 18292 | cc5ed | 2959 2959 |
18293 | 18293 | cb80d | 2959 2959 |
18294 | 18294 | 371f0 | 2959 2959 |
18295 | 18295 | 59d75 | 2959 2959 |
18296 | 18296 | e6200 | 2959 2959 |
18297 | 18297 | b1201 | 2959 2959 |
18298 | 18298 | 902e5 | 2959 2959 |
18299 | 18299 | b918e | 2959 2959 |
18300 | 18300 | 597b7 | 2959 2959 |
18301 | 18301 | 53be8 | 2959 2959 |
18302 | 18302 | 72d8e | 2959 2959 |
18303 | 18303 | 1fd76 | 2959 2959 |
18304 | 18304 | b68ec | 2959 2959 |
18305 | 18305 | feaa7 | 2959 2959 |
18306 | 18306 | 42fde | 2959 2959 |
18307 | 18307 | e92f4 | 2959 2959 |
18308 | 18308 | dbf07 | 2959 2959 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets ( target_id TEXT REFERENCES [targets]([id]), ad_id INTEGER REFERENCES [ads]([id]) )