Standard Introducer Sets  
[an error occurred while processing this directive]
SELECT p.`part_number`, p.`type`, p.`thumbnail_outlines`, CONCAT(p.`size`, p.`size_unit`) AS `size`, CAST(p.`size` AS UNSIGNED) AS `sort`, CONCAT(j.`length`, j.`length_unit`) AS `dilator_length`, j.`material` as `dilator_material`, CONCAT(j2.`length`, j2.`length_unit`) AS `sheath_length`, j2.`material` AS `sheath_material` FROM `product` p LEFT JOIN `product` j ON p.`dilator` = j.`part_number` LEFT JOIN `product` j2 ON p.`sheath` = j2.`part_number` WHERE p.`type` = 'Standard Introducer Set' AND p.`part_number` NOT LIKE 'fake%' ORDER BY `sort` ${data}
IMG
PART NUMBER SIZE DILATOR MATERIAL DILATOR LENGTH SHEATH MATERIAL SHEATH LENGTH
${type}
  ${part_number}  ${size}  ${dilator_material}  ${dilator_length}  ${sheath_material}  ${sheath_length} 
« Click a Product to Begin
LEAVE AS-IS CUSTOMIZE
Part Number:
Size:
Dilator Length:
Dilator Material:
Sheath Length:
Sheath Material:

Other Specs:
ADD TO SAMPLES REQUEST

ADD TO QUOTE REQUEST