This data as json, CSV (advanced)
Link | rowid | target_id | ad_id |
---|---|---|---|
6533 | 6533 | 3909d | 2774 2774 |
15681 | 15681 | 3909d | 2776 2776 |
16574 | 16574 | 3909d | 2763 2763 |
17090 | 17090 | 3909d | 2778 2778 |
17211 | 17211 | 3909d | 2777 2777 |
17614 | 17614 | 3909d | 2765 2765 |
17628 | 17628 | 3909d | 2767 2767 |
18132 | 18132 | 3909d | 2766 2766 |
18246 | 18246 | 3909d | 2768 2768 |
26031 | 26031 | 3909d | 2764 2764 |
26197 | 26197 | 3909d | 2771 2771 |
26673 | 26673 | 3909d | 2773 2773 |
27298 | 27298 | 3909d | 2770 2770 |
27740 | 27740 | 3909d | 2769 2769 |
36099 | 36099 | 3909d | 2775 2775 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets ( target_id TEXT REFERENCES [targets]([id]), ad_id INTEGER REFERENCES [ads]([id]) )