This data as json, CSV (advanced)
Link | rowid | target_id | ad_id |
---|---|---|---|
1751 | 1751 | cc5ed | 2983 2983 |
1752 | 1752 | a2b0d | 2983 2983 |
1753 | 1753 | 371f0 | 2983 2983 |
1754 | 1754 | 59d75 | 2983 2983 |
1755 | 1755 | e6200 | 2983 2983 |
1756 | 1756 | b1201 | 2983 2983 |
1757 | 1757 | 902e5 | 2983 2983 |
1758 | 1758 | 67cbf | 2983 2983 |
1759 | 1759 | 31177 | 2983 2983 |
1760 | 1760 | d83f4 | 2983 2983 |
1761 | 1761 | a1307 | 2983 2983 |
1762 | 1762 | 5b8a4 | 2983 2983 |
1763 | 1763 | 7ee91 | 2983 2983 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets ( target_id TEXT REFERENCES [targets]([id]), ad_id INTEGER REFERENCES [ads]([id]) )