This data as json, CSV (advanced)
Link | rowid | target_id | ad_id |
---|---|---|---|
17013 | 17013 | ec3ac | 1186 1186 |
17014 | 17014 | c3b9b | 1186 1186 |
17015 | 17015 | 5e075 | 1186 1186 |
17016 | 17016 | 59d75 | 1186 1186 |
17017 | 17017 | e6200 | 1186 1186 |
17018 | 17018 | b1201 | 1186 1186 |
17019 | 17019 | d6347 | 1186 1186 |
17020 | 17020 | 13ab6 | 1186 1186 |
17021 | 17021 | 9a8c6 | 1186 1186 |
17022 | 17022 | a2d21 | 1186 1186 |
17023 | 17023 | a1307 | 1186 1186 |
17024 | 17024 | abb72 | 1186 1186 |
17025 | 17025 | 41b26 | 1186 1186 |
17026 | 17026 | 2db78 | 1186 1186 |
17027 | 17027 | 6a38c | 1186 1186 |
17028 | 17028 | e128e | 1186 1186 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets ( target_id TEXT REFERENCES [targets]([id]), ad_id INTEGER REFERENCES [ads]([id]) )