Female Luers  
[an error occurred while processing this directive]
SELECT `part_number`, `description`, CONCAT(`color`, ' ', `material`) AS `colormat`, `color`, `material`, `inner_diameter`, `outer_diameter`, `thru_hole`, `type`, `thumbnail_outlines` FROM `product` WHERE `type` LIKE 'Female Luer%' AND `part_number` != 'PPM0034A' AND `part_number` NOT LIKE 'fake%' ORDER BY FIELD(`thumbnail_outlines`, '/products/thumbnail_outlines/female_luer_5361.jpg', '/products/thumbnail_outlines/female_luer_5516.jpg', '/products/thumbnail_outlines/female_luer_5514.jpg', '/products/thumbnail_outlines/female_luer_01628.jpg', '/products/thumbnail_outlines/female_luer_01627.jpg', '/products/thumbnail_outlines/female_luer_02002.jpg', '/products/thumbnail_outlines/female_luer_02908.jpg', '/products/thumbnail_outlines/female_luer_01447.jpg', '/products/thumbnail_outlines/female_luer_5550.jpg') ${data}
IMG
PART NUMBER DESCRIPTION COLOR/MATERIAL
${type}
  ${part_number}  ${description}  ${colormat} 
« Click a Product to Begin
LEAVE AS-IS CUSTOMIZE
Part Number:
Description:
Color:
Material:
Thru Hole:
Tube I.D.:
Tube O.D.:

Other Specs:
ADD TO SAMPLES REQUEST

ADD TO QUOTE REQUEST