This data as json, CSV (advanced)
Link | rowid | target_id | ad_id |
---|---|---|---|
18794 | 18794 | cc5ed | 2161 2161 |
18795 | 18795 | 371f0 | 2161 2161 |
18796 | 18796 | e6200 | 2161 2161 |
18797 | 18797 | b1201 | 2161 2161 |
18798 | 18798 | 8a7ee | 2161 2161 |
18799 | 18799 | 862ed | 2161 2161 |
18800 | 18800 | a1307 | 2161 2161 |
18801 | 18801 | abb72 | 2161 2161 |
18802 | 18802 | 27369 | 2161 2161 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets ( target_id TEXT REFERENCES [targets]([id]), ad_id INTEGER REFERENCES [ads]([id]) )