This data as json, CSV (advanced)
Link | rowid | target_id | ad_id |
---|---|---|---|
1672 | 1672 | ec3ac | 772 772 |
1673 | 1673 | d6ade | 772 772 |
1674 | 1674 | 8e7b3 | 772 772 |
1675 | 1675 | 313af | 772 772 |
1676 | 1676 | ebe26 | 772 772 |
1677 | 1677 | a0f55 | 772 772 |
1678 | 1678 | 61c1a | 772 772 |
1679 | 1679 | e6200 | 772 772 |
1680 | 1680 | b1201 | 772 772 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets ( target_id TEXT REFERENCES [targets]([id]), ad_id INTEGER REFERENCES [ads]([id]) )