![]() |
|
![]() |
||||
![]() |
SELECT `part_number`, `description`, CONCAT(`color`, ' ', `material`) AS `colormat`,
`color`, `material`, `type`, `thumbnail_outlines`
FROM `product`
WHERE `category` = 'Molded Components - Caps & Plugs'
AND `part_number` NOT LIKE 'fake%'
ORDER BY FIELD(`thumbnail_outlines`,
'male_cap_plug.jpg', 'male_luer_dead-end_cap.jpg', 'hemostasis_cap.jpg',
'female_vented_dust_cap.jpg', 'esophageal_stethoscope_cap.jpg', 'injection_cap.jpg')
|
|
||||