This data as json, CSV (advanced)
Link | rowid | target_id | ad_id |
---|---|---|---|
17641 | 17641 | ec3ac | 1133 1133 |
17642 | 17642 | c3b9b | 1133 1133 |
17643 | 17643 | 5e075 | 1133 1133 |
17644 | 17644 | 59d75 | 1133 1133 |
17645 | 17645 | e6200 | 1133 1133 |
17646 | 17646 | b1201 | 1133 1133 |
17647 | 17647 | d6347 | 1133 1133 |
17648 | 17648 | 13ab6 | 1133 1133 |
17649 | 17649 | 9a8c6 | 1133 1133 |
17650 | 17650 | a2d21 | 1133 1133 |
17651 | 17651 | a1307 | 1133 1133 |
17652 | 17652 | abb72 | 1133 1133 |
17653 | 17653 | 41b26 | 1133 1133 |
17654 | 17654 | 2db78 | 1133 1133 |
17655 | 17655 | 6a38c | 1133 1133 |
17656 | 17656 | e128e | 1133 1133 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets ( target_id TEXT REFERENCES [targets]([id]), ad_id INTEGER REFERENCES [ads]([id]) )