![]() |
|
![]() |
|||
![]() |
SELECT `part_number`, `type`, `description`, `material`,
`thumbnail_photo`, `thumbnail_photo` AS `thumbnail_outlines`,
CONCAT(`size`, `size_unit`) AS `size`,
CONCAT(`length`, `length_unit`) AS `catheter_length`,
'2' AS `lumens`
FROM `product`
WHERE `category` LIKE '%Short Term Silicone Catheters'
AND `part_number` NOT LIKE 'fake%'
ORDER BY `size` DESC, `length`
|
|
|||