PICC Line  
[an error occurred while processing this directive]
SELECT p.`part_number`, p.`type`, p.`description`, p.`material`, p.`thumbnail_photo`, p.`thumbnail_photo` AS `thumbnail_outlines`, CONCAT(p.`size`, p.`size_unit`) AS `size`, CONCAT(p.`length`, p.`length_unit`) AS `catheter_length`, IF(p.`type` LIKE 'Single Lumen%', '1', '2') AS `lumens`, j.`color` AS `hub_color` FROM `product` p LEFT JOIN `product` j ON p.`hub` = j.`part_number` WHERE p.`category` LIKE '%PICC Line' AND p.`part_number` NOT LIKE 'fake%' ORDER BY p.`thumbnail_photo` DESC, `lumens`, p.`size` ${data}
IMG
PART NUMBER DESCRIPTION
${type}
  ${part_number}  ${description} 
« Click a Product to Begin
LEAVE AS-IS CUSTOMIZE
Part Number:
Description:
Size:
Length:
Lumens:
Hub Color:

Other Specs:
ADD TO SAMPLES REQUEST

ADD TO QUOTE REQUEST