This data as json, CSV (advanced)
Link | rowid | target_id | ad_id |
---|---|---|---|
10834 | 10834 | ec3ac | 1851 1851 |
10835 | 10835 | 674d7 | 1851 1851 |
10836 | 10836 | 863e5 | 1851 1851 |
10837 | 10837 | e6200 | 1851 1851 |
10838 | 10838 | b1201 | 1851 1851 |
10839 | 10839 | 902e5 | 1851 1851 |
10840 | 10840 | 3c3e3 | 1851 1851 |
10841 | 10841 | e456e | 1851 1851 |
10842 | 10842 | c2c21 | 1851 1851 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets ( target_id TEXT REFERENCES [targets]([id]), ad_id INTEGER REFERENCES [ads]([id]) )