![]() |
|
![]() |
||||
![]() |
SELECT `part_number`, `description`, CONCAT(`color`, ' ', `material`) AS `colormat`,
`color`, `material`, `outer_diameter`, `thumbnail_outlines`,
if(`part_number` LIKE 'PPM048_A', 'Butterfly Suture Clamp', `type`) AS `type`
FROM `product`
WHERE (`category` = 'Molded Components - Clamps & ID Rings'
OR `part_number` LIKE 'PPM048_A')
AND `part_number` NOT LIKE 'fake%'
ORDER BY FIELD(`thumbnail_outlines`,
'clamp_01463.jpg', 'clamp_03967.jpg', 'suture_wing_02255.jpg', 'identification_ring.jpg')
|
|
||||