This data as json, CSV (advanced)
Link | rowid | target_id | ad_id |
---|---|---|---|
5052 | 5052 | afd28 | 2749 2749 |
5557 | 5557 | afd28 | 2750 2750 |
6082 | 6082 | afd28 | 2748 2748 |
6365 | 6365 | afd28 | 2751 2751 |
6885 | 6885 | afd28 | 2762 2762 |
7207 | 7207 | afd28 | 2761 2761 |
7590 | 7590 | afd28 | 2759 2759 |
8170 | 8170 | afd28 | 2760 2760 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets ( target_id TEXT REFERENCES [targets]([id]), ad_id INTEGER REFERENCES [ads]([id]) )