![]() |
|
![]() |
|||
![]() |
SELECT `part_number`, `description`, CONCAT(`color`, ' ', `material`) AS `colormat`,
`type`, `thumbnail_outlines`, `color`, `material`, `inner_diameter`, `outer_diameter`
FROM `product`
WHERE `category` = 'Molded Components - Male Adapters'
AND `part_number` NOT LIKE 'fake%'
ORDER BY FIELD(`type`,
'Male Luer Adapter',
'Male Heavy Wall Connector',
'Male Heavy Wall Connector with Snap')
|
|
|||