Martech® Medical Products » Finished Catheters » Polyurethane Central Vein Catheters

IMG	PART NUMBER	DESCRIPTION
	Single Lumen Catheter
	AC2110C	14ga x 15cm Single Lumen Catheter
	AC2111C	14ga x 20cm Single Lumen Catheter
	AC2112C	14ga x 30cm Single Lumen Catheter
	AC2120C	16ga x 15cm Single Lumen Catheter
	AC2121C	16ga x 20cm Single Lumen Catheter
	AC2122C	16ga x 30cm Single Lumen Catheter
	AC2130C	18ga x 15cm Single Lumen Catheter
	AC2131C	18ga x 20cm Single Lumen Catheter
	AC2132C	18ga x 30cm Single Lumen Catheter
	AC2140C	20ga x 13cm Single Lumen Catheter
	Double Lumen Catheter
	AC1720G	7FR x 15cm Double Lumen Catheter
	AC1721G	7FR x 20cm Double Lumen Catheter
	AC1722G	7FR x 30cm Double Lumen Catheter
	Triple Lumen Catheter
	AC1730G	7FR x 15cm Triple Lumen Catheter
	AC1731G	7FR x 20cm Triple Lumen Catheter
	AC1732G	7FR x 30cm Triple Lumen Catheter
	Quad Lumen Catheter
	AC4095G	8.5FR x 15cm Quad Lumen Catheter
	AC4094G	8.5FR x 20cm Quad Lumen Catheter
	AC4096G	8.5FR x 30cm Quad Lumen Catheter
	Small Bore Double Lumen Catheter
	AC1738G	4FR x 13cm Double Lumen Catheter
	AC1923G	4FR x 18cm Double Lumen Catheter
	AC1739G	4FR x 30cm Double Lumen Catheter
	AC1736G	4FR x 5cm Double Lumen Catheter
	AC1737G	4FR x 8cm Double Lumen Catheter
	AC1725G	5FR x 13cm Double Lumen Catheter
	AC1729G	5FR x 20cm Double Lumen Catheter
	AC1724G	5FR x 30cm Double Lumen Catheter
	AC1726G	5FR x 5cm Double Lumen Catheter
	AC1727G	5FR x 8cm Double Lumen Catheter
	Small Bore Triple Lumen Catheter
	AC1735G	5.5FR x 13cm Triple Lumen Catheter
	AC1733G	5.5FR x 30cm Triple Lumen Catheter
	AC1734G	5.5FR x 8cm 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, IF(`type` LIKE 'Triple%', 3, 4) ) ) AS `lumens`, IF(`size` < 6, 'Small Bore', '') AS `small_bore` FROM `product` WHERE `category` LIKE '%Polyurethane Central Vein Catheters' AND `part_number` NOT LIKE 'fake%' ORDER BY `small_bore`, `lumens`, `size`, `catheter_length` ${data}

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