This data as json, CSV (advanced)
Link | rowid | target_id | ad_id |
---|---|---|---|
15811 | 15811 | ccbed | 2794 2794 |
15850 | 15850 | ccbed | 2788 2788 |
15885 | 15885 | ccbed | 2786 2786 |
16036 | 16036 | ccbed | 2795 2795 |
16068 | 16068 | ccbed | 2787 2787 |
16106 | 16106 | ccbed | 2793 2793 |
16353 | 16353 | ccbed | 2781 2781 |
16811 | 16811 | ccbed | 2782 2782 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets ( target_id TEXT REFERENCES [targets]([id]), ad_id INTEGER REFERENCES [ads]([id]) )