This data as json, CSV (advanced)
Link | rowid | target_id | ad_id |
---|---|---|---|
320 | 320 | 2f957 | 857 857 |
598 | 598 | 2f957 | 3043 3043 |
926 | 926 | 2f957 | 853 853 |
1095 | 1095 | 2f957 | 775 775 |
1301 | 1301 | 2f957 | 3072 3072 |
1550 | 1550 | 2f957 | 863 863 |
1581 | 1581 | 2f957 | 786 786 |
7256 | 7256 | 2f957 | 803 803 |
8006 | 8006 | 2f957 | 864 864 |
29544 | 29544 | 2f957 | 3068 3068 |
30387 | 30387 | 2f957 | 3060 3060 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets ( target_id TEXT REFERENCES [targets]([id]), ad_id INTEGER REFERENCES [ads]([id]) )