This data as json, CSV (advanced)
Link | rowid | target_id | ad_id |
---|---|---|---|
2133 | 2133 | ec3ac | 1021 1021 |
2134 | 2134 | 17183 | 1021 1021 |
2135 | 2135 | 96bbd | 1021 1021 |
2136 | 2136 | 550f6 | 1021 1021 |
2137 | 2137 | 343d8 | 1021 1021 |
2138 | 2138 | 313af | 1021 1021 |
2139 | 2139 | f9cc2 | 1021 1021 |
2140 | 2140 | aabe0 | 1021 1021 |
2141 | 2141 | 3e5f6 | 1021 1021 |
2142 | 2142 | 87fac | 1021 1021 |
2143 | 2143 | 1073c | 1021 1021 |
2144 | 2144 | 4801f | 1021 1021 |
2145 | 2145 | 5e075 | 1021 1021 |
2146 | 2146 | 59d75 | 1021 1021 |
2147 | 2147 | e6200 | 1021 1021 |
2148 | 2148 | b1201 | 1021 1021 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets ( target_id TEXT REFERENCES [targets]([id]), ad_id INTEGER REFERENCES [ads]([id]) )