// select pattern_id from patterns where descriptive_image != "" and deleted = 'N' and public = 'Y' order by pattern_id; 1 3 4 6 8 9 10 25 34 36 39 40 45 46 48 53 54 57 70 74 76 77 78 79 83 85 91 92 93 96 115 116 124 125 126 135 136 137 140 141 159 168 169 171 172 175 176 177 179 183 184 186 237 292 293 294 298 312 353 354 355 357 358 359