This data as json, CSV (advanced)
Link | rowid | target_id | ad_id |
---|---|---|---|
2762 | 2762 | fb88d | 1156 1156 |
2763 | 2763 | 28463 | 1156 1156 |
2764 | 2764 | c4902 | 1156 1156 |
2765 | 2765 | 9dc02 | 1156 1156 |
2766 | 2766 | ec4f5 | 1156 1156 |
2767 | 2767 | dad97 | 1156 1156 |
2768 | 2768 | 17a50 | 1156 1156 |
2769 | 2769 | e95f6 | 1156 1156 |
2770 | 2770 | 1c31d | 1156 1156 |
2771 | 2771 | 5e075 | 1156 1156 |
2772 | 2772 | 59d75 | 1156 1156 |
2773 | 2773 | e6200 | 1156 1156 |
2774 | 2774 | b1201 | 1156 1156 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets ( target_id TEXT REFERENCES [targets]([id]), ad_id INTEGER REFERENCES [ads]([id]) )