![]() |
|
![]() |
|||
![]() |
SELECT `type`, `part_number`, `description`,
`inner_diameter`, `outer_diameter`,`wall_thickness`,
CONCAT(`length`, `length_unit`) AS `protector_length`,
`material`, `profile`, `thumbnail_outlines`
FROM `product`
WHERE (`type` = 'Needle Protector'
OR `type` = 'OTN Catheter Protector')
AND `part_number` NOT LIKE 'fake%'
ORDER BY `type`, `part_number`
|
|
|||