Martech® Medical Products » Finished Catheters

IMG	PART NUMBER	DESCRIPTION
	Single Lumen Infusion Catheter
	AC1657	3FR x 60cm Single Lumen Catheter with Reverse Taper; Blue Hub
	AC3199	3FR x 60cm Single Lumen Catheter with Reverse Taper; White Hub
	AC1658	4FR x 60cm Single Lumen Catheter with Reverse Taper; Blue Hub
	AC3198	4FR x 60cm Single Lumen Catheter with Reverse Taper; White Hub
	AC1659	5FR x 60cm Single Lumen Catheter with Reverse Taper; Blue Hub
	AC3197	5FR x 60cm Single Lumen Catheter with Reverse Taper; White Hub
	AC1668	3FR x 60cm Double Lumen Catheter with Reverse Taper; White Hub
	AC2647	4FR x 60cm Double Lumen Catheter with Reverse Taper; Blue Hub
	AC2650	4FR x 60cm Double Lumen Catheter with Reverse Taper; White Hub
	AC2652	5FR x 60cm Double Lumen Catheter with Reverse Taper; White Hub
	AC2653	5FR x 60cm Double Lumen Catheter with Reverse Taper; Blue Hub
	Single Lumen High Pressure Catheter
	AC2661G	5FR x 60cm Single Lumen Catheter with Reverse Taper
	AC2646G	6FR x 60cm Double Lumen Catheter with Reverse Taper

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}