"T" Adapters  
IMG
PART NUMBER DESCRIPTION ADAPTER MATERIAL SWIVEL MATERIAL
"T" Adapter
  AC1870  "T" Adapter with 1 Male, 2 Females, Without Swivel  Clear PVC  
"T" Adapter with Swivel
  AC1871  "T" Adapter with 1 Male, 2 Females, With Swivel  Clear PVC Clear Polycarbonate 
  AC1871G  "T" Adapter with 1 Male, 2 Females, With Swivel  Radiation Stabilized PVC Clear Polycarbonate 
SELECT p.`part_number`, p.`description`, if(p.`color` IS NULL, j.`color`, p.`color`) AS `adapter_color`, if(p.`material` IS NULL, j.`material`,p.`material`) AS `adapter_material`, j2.`color` AS `swivel_color`, j2.`material` AS `swivel_material`, CONCAT(if(p.`color` IS NULL, j.`color`, p.`color`), ' ', if(p.material IS NULL, j.`material`,p.material)) AS `adaptermat`, CONCAT(j2.`color`, ' ', j2.`material`) AS `swivelmat`, p.`type`, p.`thumbnail_outlines` FROM `product` p LEFT JOIN `product` j ON p.`adapter` = j.`part_number` LEFT JOIN `product` j2 ON p.`swivel` = j2.`part_number` WHERE p.`type` LIKE '"T" Adapter%' AND p.`part_number` NOT LIKE 'fake%' ${data}
IMG
PART NUMBER DESCRIPTION ADAPTER MATERIAL SWIVEL MATERIAL
${type}
  ${part_number}  ${description}  ${adaptermat} ${swivelmat} 
« Click a Product to Begin
LEAVE AS-IS CUSTOMIZE
Part Number:
Description:
Color:
Material:
Swivel Color:
Swivel Material:

Other Specs:
ADD TO SAMPLES REQUEST

ADD TO QUOTE REQUEST