This data as json, CSV (advanced)
Link | rowid | target_id | ad_id |
---|---|---|---|
9797 | 9797 | ec3ac | 1793 1793 |
9798 | 9798 | 398aa | 1793 1793 |
9799 | 9799 | 18789 | 1793 1793 |
9800 | 9800 | 49bfd | 1793 1793 |
9801 | 9801 | 371f0 | 1793 1793 |
9802 | 9802 | e6200 | 1793 1793 |
9803 | 9803 | b1201 | 1793 1793 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets ( target_id TEXT REFERENCES [targets]([id]), ad_id INTEGER REFERENCES [ads]([id]) )