Martech® Medical Products » Machined Devices

[an error occurred while processing this directive]

SELECT `part_number`, `description`, `type`, `material`, `color`, `thumbnail_outlines`, `annealable`, `use_any_football`, `use_any_sleeve`, CONCAT(`length`, `length_unit`) AS `trocar_length`, CONCAT(`diameter`, `diameter_unit`) AS `diameter`, if(`annealable` = 'Yes', ' Fully Annealable Stainless Steel

', '') AS `icon_annealable`, if(`use_any_football` = 'Yes', ' Use with any Martech® Football Tunneler

', '') AS `icon_football`, if(`use_any_sleeve` = 'Yes', ' Use with any Martech® Sleeve

', '') AS `icon_sleeve`, if(`material` LIKE '%Stainless Steel', '

', '') AS `icon_steel` FROM `product` WHERE `type` REGEXP '^Trocar|Tunneler$' AND `part_number` NOT LIKE 'fake%' ORDER BY FIELD(`thumbnail_outlines`, '/products/thumbnail_outlines/trocar_1500.jpg', '/products/thumbnail_outlines/trocar_00129.jpg', '/products/thumbnail_outlines/trocar_3744.jpg', '/products/thumbnail_outlines/tunneler_3643.jpg', '/products/thumbnail_outlines/tunneler_5241.jpg', '/products/thumbnail_outlines/tunneler_5081.jpg', '/products/thumbnail_outlines/tunneler_3788.jpg', '/products/thumbnail_outlines/tunneler_04440.jpg', '/products/thumbnail_outlines/tunneler_03593.jpg', '/products/thumbnail_outlines/tunneler_football.jpg') ${data}

IMG	PART NUMBER	DESCRIPTION	* MATERIAL	LENGTH	DIAMETER
	${icon_annealable} ${icon_football} ${icon_sleeve} ${icon_steel} ${type}
	${part_number}	${description}	${material}	${trocar_length}	${diameter}