This data as json, CSV (advanced)
Link | rowid | target_id | ad_id |
---|---|---|---|
32828 | 32828 | ec3ac | 1815 1815 |
32829 | 32829 | e3fd2 | 1815 1815 |
32830 | 32830 | 18789 | 1815 1815 |
32831 | 32831 | 49bfd | 1815 1815 |
32832 | 32832 | 423ed | 1815 1815 |
32833 | 32833 | 674d7 | 1815 1815 |
32834 | 32834 | aa8b2 | 1815 1815 |
32835 | 32835 | e6200 | 1815 1815 |
32836 | 32836 | b1201 | 1815 1815 |
32837 | 32837 | 902e5 | 1815 1815 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets ( target_id TEXT REFERENCES [targets]([id]), ad_id INTEGER REFERENCES [ads]([id]) )