Pediatric TBA Bodies  
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} 
« Click a Product to Begin
LEAVE AS-IS CUSTOMIZE
Part Number:
Description:
Color:
Material:
Thru Hole:
Sideport:
Size:

Other Specs:
ADD TO SAMPLES REQUEST

ADD TO QUOTE REQUEST