Martech® Medical Products » Valved Products

IMG	PART NUMBER	DESCRIPTION	MATERIAL
	Pediatric TBA Body
	PPM1100	.055" Thru Hole, Snap Body	Clear PVC
	PPM0263B	.055" Thru Hole, Snap Body	Radiation Stabilized PVC
	PPM0305B	.071" Thru Hole, No Snap Body	Clear PVC
	PPM0309A	.071" Thru Hole, Snap Body	Clear PVC
	PPM0310	.089" Thru Hole, Snap Body	Clear PVC
	Pediatric TBA Body with Sideport
	PPM0277A	9FR with Side Port	Clear PVC

SELECT `part_number`, `description`, `color`, `material`, `type`, `thumbnail_outlines`, `sideport`, IF(`sideport` = 'Yes', 'with Sideport', '') AS `with_sideport`, CONCAT(`size`, `size_unit`) AS `size`, CONCAT(`thru_hole`, `diameter_unit`) AS `thru_hole` FROM `product` WHERE `type` = 'Pediatric TBA Body' AND `part_number` NOT LIKE 'fake%' ORDER BY `thumbnail_outlines`, `thru_hole` ${data}

IMG	PART NUMBER	DESCRIPTION	MATERIAL
	${type} ${with_sideport}
	${part_number}	${description}	${color} ${material}