This data as json, CSV (advanced)
Link | rowid | target_id | ad_id |
---|---|---|---|
15255 | 15255 | db9ea | 16 16 |
15806 | 15806 | db9ea | 2794 2794 |
15880 | 15880 | db9ea | 2786 2786 |
16063 | 16063 | db9ea | 2787 2787 |
16101 | 16101 | db9ea | 2793 2793 |
16301 | 16301 | db9ea | 2785 2785 |
16712 | 16712 | db9ea | 2792 2792 |
16806 | 16806 | db9ea | 2782 2782 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets ( target_id TEXT REFERENCES [targets]([id]), ad_id INTEGER REFERENCES [ads]([id]) )