Low Pressure Roentgenography Connecting Tubes (500psi)
*All tubes listed are PVC, .210" OD x .110" ID
 
[an error occurred while processing this directive]
SELECT p.`part_number`, p.`material`, CONCAT(p.`length`, p.`length_unit`) AS `tube_length`, CONCAT(p.`outer_diameter`, p.`diameter_unit`) AS `outer_diameter`, CONCAT(p.`inner_diameter`, p.`diameter_unit`) AS `inner_diameter`, p.`type`, p.`thumbnail_outlines`, CAST( GROUP_CONCAT(j.`gender` SEPARATOR '/') AS CHAR ) AS `luers`, if(p.`swivel` IS NULL, 'No', 'Yes') AS `swivel`, if(j2.`material` IS NULL, 'N/A', j2.`material`) AS `swivel_material` FROM `product` p LEFT JOIN `product` j ON j.`part_number` REGEXP(p.`luer`) LEFT JOIN `product` j2 ON p.`swivel` = j2.`part_number` WHERE p.`type` LIKE 'Low Pressure Roentgenography%' AND p.`part_number` NOT LIKE 'fake%' GROUP BY p.`part_number` ${data}
IMG
PART NUMBER LENGTH LUERS SWIVEL SWIVEL MATERIAL
${type}
  ${part_number}  ${tube_length}  ${luers}  ${swivel}  ${swivel_material} 
« Click a Product to Begin
LEAVE AS-IS CUSTOMIZE
Part Number:
Material:
Length:
O.D.:
I.D.:
Luers:
Swivel:
Swivel Material:

Other Specs:
ADD TO SAMPLES REQUEST

ADD TO QUOTE REQUEST