 |
SELECT `part_number`, `description`, CONCAT(`color`, ' ', `material`) AS `colormat`,
`color`, `material`, `thru_hole`, `type`, `thumbnail_outlines`
FROM `product`
WHERE `type` = 'Suture Wing'
AND `part_number` NOT LIKE 'fake%'
ORDER BY FIELD(`thumbnail_outlines`,
'/products/thumbnail_outlines/suture_wing_02255.jpg', '/products/thumbnail_outlines/suture_wing_03010.jpg',
'/products/thumbnail_outlines/suture_wing_02686.jpg', '/products/thumbnail_outlines/suture_wing_02375.jpg',
'/products/thumbnail_outlines/suture_wing_03012.jpg', '/products/thumbnail_outlines/suture_wing_02239.jpg',
'/products/thumbnail_outlines/suture_wing_5249.jpg', '/products/thumbnail_outlines/suture_wing_5248.jpg')
|
|
|