Martech® Medical Products » Finished Catheters » Short Term Polyurethane Catheters

IMG	PART NUMBER	DESCRIPTION
	Double Lumen Catheter
	AC1705G	9F x 12cm Double Lumen Catheter
	AC1706G	9F x 15cm Double Lumen Catheter
	AC1707G	9F x 20cm Double Lumen Catheter
	Double Lumen Catheter
	AC1940G	14FR x 12cm Double Lumen Catheter
	AC1941G	14FR x 15cm Double Lumen Catheter
	AC1942G	14FR x 20cm Double Lumen Catheter
	AC1943G	14FR x 24cm Double Lumen Catheter
	Curved Double Lumen Catheter
	AC1940IJSWG	14FR x 12cm Curved Double Lumen Catheter
	AC1941IJSWG	14FR x 15cm Curved Double Lumen Catheter
	AC1942IJSWG	14FR x 20cm Curved Double Lumen Catheter
	AC1943IJSWG	14FR x 24cm Curved Double Lumen Catheter
	Double Lumen Catheter
	AC4210	12F x 13cm Double Lumen Catheter
	AC4211	12F x 15cm Double Lumen Catheter
	AC4212	12F x 20cm Double Lumen Catheter
	AC4213	12F x 24cm Double Lumen Catheter
	Double Lumen Catheter
	AC1700G	11.5FR x 12cm Double Lumen Catheter
	AC1701G	11.5FR x 15cm Double Lumen Catheter
	AC1702G	11.5FR x 20cm Double Lumen Catheter
	Triple Lumen Catheter
	AC1954G	11.5FR x 12cm Double Lumen Catheter
	AC1955G	11.5FR x 15cm Double Lumen Catheter
	AC1956G	11.5FR x 20cm Double 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`, '2' AS `lumens`, IF(`description` LIKE '%Curved%', 'Curved', '') AS `curved` FROM `product` WHERE `category` LIKE '%Short Term Polyurethane%Catheters' AND `part_number` NOT LIKE 'fake%' ORDER BY FIELD(`thumbnail_photo`, 'st_polyurethane_14f_double_lumen.jpg', 'st_polyurethane_14f_double_lumen_curved.jpg', 'st_polyurethane_12f_double_lumen.jpg', 'st_polyurethane_9f_double_lumen.jpg', 'st_polyurethane_triple_lumen.jpg'), `size` DESC ${data}

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