This data as json, CSV (advanced)
Link | rowid | target_id | ad_id |
---|---|---|---|
5044 | 5044 | 66d45 | 2749 2749 |
5550 | 5550 | 66d45 | 2750 2750 |
6074 | 6074 | 66d45 | 2748 2748 |
6338 | 6338 | 66d45 | 2747 2747 |
7201 | 7201 | 66d45 | 2761 2761 |
7583 | 7583 | 66d45 | 2759 2759 |
8045 | 8045 | 66d45 | 2758 2758 |
8163 | 8163 | 66d45 | 2760 2760 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets ( target_id TEXT REFERENCES [targets]([id]), ad_id INTEGER REFERENCES [ads]([id]) )