This data as json, CSV (advanced)
Link | rowid | target_id | ad_id |
---|---|---|---|
212 | 212 | 6a7d5 | 725 725 |
213 | 213 | c9109 | 725 725 |
214 | 214 | ff144 | 725 725 |
215 | 215 | fb7e7 | 725 725 |
216 | 216 | c7490 | 725 725 |
217 | 217 | 7b958 | 725 725 |
218 | 218 | 9590d | 725 725 |
219 | 219 | c803f | 725 725 |
220 | 220 | 660a5 | 725 725 |
221 | 221 | d7bec | 725 725 |
222 | 222 | 669e2 | 725 725 |
223 | 223 | b023d | 725 725 |
224 | 224 | f5d04 | 725 725 |
225 | 225 | 814aa | 725 725 |
226 | 226 | 7fc32 | 725 725 |
227 | 227 | 8f694 | 725 725 |
228 | 228 | 2482b | 725 725 |
229 | 229 | 9d6fe | 725 725 |
230 | 230 | c552d | 725 725 |
231 | 231 | 073d4 | 725 725 |
232 | 232 | ed665 | 725 725 |
233 | 233 | b6fd0 | 725 725 |
234 | 234 | 7b150 | 725 725 |
235 | 235 | e6200 | 725 725 |
236 | 236 | b1201 | 725 725 |
237 | 237 | 902e5 | 725 725 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets ( target_id TEXT REFERENCES [targets]([id]), ad_id INTEGER REFERENCES [ads]([id]) )