Martech® Medical Products » Valved Products

IMG	PART NUMBER	DESCRIPTION	MATERIAL	SIDEPORT
	TBA Body
	PPM0766A	.052" Thru Hole	Clear PVC	No
	PPM1079	.120" Thru Hole	Clear PVC	No
	PPM0260R	.120" Thru Hole	Radiation Stabilized PVC	No
	TBA Body with Sideport
	PPM0267B	.115" Thru Hole	Clear PVC	Yes
	PPM0266A	.120" Thru Hole	Clear PVC	Yes
	PPM0266R	.120" Thru Hole	Radiation Stabilized PVC	Yes

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

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