Martech® Medical Products » Dilators & Tearaways

IMG	PART NUMBER	SIZE	DILATOR MATERIAL	DILATOR LENGTH	SHEATH MATERIAL	SHEATH LENGTH
	Standard Introducer Set
	AC1176B	5FR	Polypropylene with Barium	8"	Teflon with Barium	4.25"
	AC1178	6FR	Polypropylene	8"	Teflon with Barium	4.25"
	AC1050AB	7FR	Polypropylene with Barium	8"	Teflon with Barium	4.25"
	AC1060B	8FR	Polypropylene with Barium	8"	Teflon with Barium	4.25"
	AC1150B	8.5FR	Polypropylene with Barium	8"	Teflon with Barium	4.25"
	AC1057	9FR	Polypropylene	8"	Teflon with Barium	4.25"
	AC1132B	10FR	Polypropylene with Barium	8"	Teflon with Barium	4.00"
	AC1308B	11FR	Polypropylene with Barium	8"	Teflon with Barium	6.00"
	AC1314B-6	13FR	Polypropylene with Barium	6"	Teflon with Barium	4.85"

SELECT p.`part_number`, p.`type`, p.`thumbnail_outlines`, CONCAT(p.`size`, p.`size_unit`) AS `size`, CAST(p.`size` AS UNSIGNED) AS `sort`, CONCAT(j.`length`, j.`length_unit`) AS `dilator_length`, j.`material` as `dilator_material`, CONCAT(j2.`length`, j2.`length_unit`) AS `sheath_length`, j2.`material` AS `sheath_material` FROM `product` p LEFT JOIN `product` j ON p.`dilator` = j.`part_number` LEFT JOIN `product` j2 ON p.`sheath` = j2.`part_number` WHERE p.`type` = 'Standard Introducer Set' AND p.`part_number` NOT LIKE 'fake%' ORDER BY `sort` ${data}

IMG	PART NUMBER	SIZE	DILATOR MATERIAL	DILATOR LENGTH	SHEATH MATERIAL	SHEATH LENGTH
	${type}
	${part_number}	${size}	${dilator_material}	${dilator_length}	${sheath_material}	${sheath_length}