Martech® Medical Products » Finished Catheters » Long Term Silicone Central Vein Catheters

IMG	PART NUMBER	DESCRIPTION
	Single Lumen Catheter
	AC5200	6FR x 90cm Single Lumen Catheter
	AC5201	7FR x 90cm Single Lumen Catheter
	AC5202	9.5FR x 90cm Single Lumen Catheter
	Double Lumen Catheter
	AC5203	7FR x 90cm Double Lumen Catheter
	AC5204	9.5FR x 90cm Double Lumen Catheter
	AC5205	11FR x 90cm Double Lumen Catheter
	AC5206	14FR x 90cm Double Lumen Catheter
	Triple Lumen Catheter
	AC5207	12.5FR x 90cm Triple Lumen Catheter

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`, IF(`type` LIKE 'Single%', 1, IF(`type` LIKE 'Double%', 2, 3) ) AS `lumens` FROM `product` WHERE `category` LIKE '%Long Term Silicone Central Vein Catheters' AND `part_number` NOT LIKE 'fake%' ${data}

IMG	PART NUMBER	DESCRIPTION
	${type}
	${part_number}	${description}