 |
SELECT `part_number`, `description`, CONCAT(`color`, ' ', `material`) AS `colormat`,
`color`, `material`, `inner_diameter`, `outer_diameter`, `thru_hole`,
`type`, `thumbnail_outlines`
FROM `product`
WHERE `type` LIKE 'Female Luer%'
AND `part_number` != 'PPM0034A'
AND `part_number` NOT LIKE 'fake%'
ORDER BY FIELD(`thumbnail_outlines`,
'female_luer_5361.jpg', 'female_luer_5516.jpg', 'female_luer_5514.jpg',
'female_luer_01628.jpg', 'female_luer_01627.jpg', 'female_luer_02002.jpg',
'female_luer_02908.jpg', 'female_luer_01447.jpg', 'female_luer_5550.jpg')
|
|
|