Martech® Medical Products » Dilators & Tearaways

IMG	PART NUMBER	SIZE	LENGTH	SHEATH HUB COLOR	DILATOR HUB COLOR	GUIDEWIRE SIZE
	Super Sheath
	10356-05-040	4FR	5cm	Dark Grey	Red	.018
	10356-05-045	4.5FR	5cm	Dark Grey	Yellow	.018
	10356-05-050	5FR	5cm	Dark Grey	Light Grey	.018
	10356-05-055	5.5FR	5cm	Dark Grey	Dark Grey	.018
	10356-05-060	6FR	5cm	Dark Grey	Green	.018
	10356-05-065	6.5FR	5cm	Dark Grey	Light Green	.018
	10356-05-070	7FR	5cm	Dark Grey	Orange	.018
	10356-10-040	4FR	10cm	Dark Grey	Red	.018
	10356-10-045	4.5FR	10cm	Dark Grey	Yellow	.018
	10356-10-050	5FR	10cm	Dark Grey	Light Grey	.018
	10356-10-055	5.5FR	10cm	Dark Grey	Dark Grey	.018
	10356-10-060	6FR	10cm	Dark Grey	Green	.018
	10356-10-065	6.5FR	10cm	Dark Grey	Light Green	.018
	10356-10-070	7FR	10cm	Dark Grey	Orange	.018
	10356-10-080	8FR	10cm	Dark Grey	Blue	.018
	10356-10-090	9FR	10cm	Dark Grey	White	.018
	10526-10-050	5FR	10cm	Dark Grey	Light Grey	.038
	10526-10-055	5.5FR	10cm	Dark Grey	Dark Grey	.038
	10526-10-060	6FR	10cm	Dark Grey	Green	.038
	10526-10-065	6.5FR	10cm	Dark Grey	Light Green	.038
	10526-10-070	7FR	10cm	Dark Grey	Orange	.038
	10526-10-090	9FR	5cm	Dark Grey	White	.038
	10526-15-050	5FR	5cm	Dark Grey	Light Grey	.038
	10526-15-055	5.5FR	5cm	Dark Grey	Dark Grey	.038
	10526-15-060	6FR	5cm	Dark Grey	Green	.038
	10526-15-065	6.5FR	5cm	Dark Grey	Light Green	.038
	10526-15-070	7FR	5cm	Dark Grey	Orange	.038
	10526-15-080	8FR	5cm	Dark Grey	Blue	.038

SELECT p.`part_number`, p.`type`, p.`thumbnail_outlines`, CONCAT(p.`size`, p.`size_unit`) AS `size`, CONCAT(p.`length`, p.`length_unit`) AS `length`, p.`color` AS `sheath_hub_color`, p.`material` AS `sheath_material`, j.`color` AS `dilator_color`, j.`material` AS `dilator_material`, j2.`color` AS `dilator_hub_color`, j2.`material` AS `hub_material`, p.`guidewire` AS `guidewire_size` FROM `product` p LEFT JOIN `product` j ON p.`dilator` = j.`part_number` LEFT JOIN `product` j2 ON j.`hub` = j2.`part_number` WHERE p.`type` = 'Super Sheath' AND p.`part_number` NOT LIKE 'fake%' ${data}

IMG	PART NUMBER	SIZE	LENGTH	SHEATH HUB COLOR	DILATOR HUB COLOR	GUIDEWIRE SIZE
	${type}
	${part_number}	${size}	${length}	${sheath_hub_color}	${dilator_hub_color}	${guidewire_size}