This data as json, CSV (advanced)
Link | rowid | target_id | ad_id |
---|---|---|---|
5057 | 5057 | 415bf | 2749 2749 |
5105 | 5105 | 415bf | 2745 2745 |
5518 | 5518 | 415bf | 2744 2744 |
5563 | 5563 | 415bf | 2750 2750 |
6088 | 6088 | 415bf | 2748 2748 |
6172 | 6172 | 415bf | 2746 2746 |
6350 | 6350 | 415bf | 2747 2747 |
6370 | 6370 | 415bf | 2751 2751 |
6890 | 6890 | 415bf | 2762 2762 |
6967 | 6967 | 415bf | 2756 2756 |
7156 | 7156 | 415bf | 2757 2757 |
7213 | 7213 | 415bf | 2761 2761 |
7596 | 7596 | 415bf | 2759 2759 |
8056 | 8056 | 415bf | 2758 2758 |
8175 | 8175 | 415bf | 2760 2760 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets ( target_id TEXT REFERENCES [targets]([id]), ad_id INTEGER REFERENCES [ads]([id]) )