This data as json, CSV (advanced)
Link | rowid | target_id | ad_id |
---|---|---|---|
27547 | 27547 | ec3ac | 946 946 |
27548 | 27548 | c3b9b | 946 946 |
27549 | 27549 | 5e075 | 946 946 |
27550 | 27550 | 59d75 | 946 946 |
27551 | 27551 | e6200 | 946 946 |
27552 | 27552 | b1201 | 946 946 |
27553 | 27553 | d6347 | 946 946 |
27554 | 27554 | 13ab6 | 946 946 |
27555 | 27555 | 9a8c6 | 946 946 |
27556 | 27556 | a2d21 | 946 946 |
27557 | 27557 | a1307 | 946 946 |
27558 | 27558 | abb72 | 946 946 |
27559 | 27559 | 41b26 | 946 946 |
27560 | 27560 | 2db78 | 946 946 |
27561 | 27561 | 6a38c | 946 946 |
27562 | 27562 | e128e | 946 946 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets ( target_id TEXT REFERENCES [targets]([id]), ad_id INTEGER REFERENCES [ads]([id]) )