Log Out Log Out Log Out Cerrar sesiónopen invoices
Idioma:
EnglishEspañol
Shopping Cart Icon
Mi carrito (0)
Arror Down Icon
Mi carrito de compras
alt"Ajax close button images"
Su cesta está vacía
Necesitas ayuda? Contáctanos en 1800.325.9708 Soporte vital
Inicio » Infraestructura » Fibra Óptica » Paneles de Conexión de Fibra Óptica

Paneles de Conexión de Fibra Óptica

   
select count(distinct(p.products_id)) as total from products p left join products_to_categories ptc on p.products_id = ptc.products_id left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id left join products_models_to_products p2m on p2m.products_id = p.products_id left join products_models pm on pm.ID = p2m.model_id where (p.products_status = 1) and (ptpef2.products_extra_fields_id = '71' and ptpef2.products_extra_fields_value = 'Azul') and ptc.categories_id = 362 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G") select count(distinct(p.products_id)) as total from products p left join products_to_categories ptc on p.products_id = ptc.products_id left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id left join products_models_to_products p2m on p2m.products_id = p.products_id left join products_models pm on pm.ID = p2m.model_id where (p.products_status = 1) and (ptpef2.products_extra_fields_id = '71' and ptpef2.products_extra_fields_value = 'Negro') and ptc.categories_id = 362 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G") select count(distinct(p.products_id)) as total from products p left join products_to_categories ptc on p.products_id = ptc.products_id left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id left join products_models_to_products p2m on p2m.products_id = p.products_id left join products_models pm on pm.ID = p2m.model_id where (p.products_status = 1) and (ptpef2.products_extra_fields_id = '131' and ptpef2.products_extra_fields_value = '6') and ptc.categories_id = 362 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
Marca
LYNN
OCC
Color
Azul
Negro
Puertos
6
Pixel Trans
Pixel Trans
 Cuadrícula  List      7 artículos
Caja para Riel DIN - 1 Placa Adaptadora, Vacía
Caja para Riel DIN - 1 Placa Adaptadora, Vacía
# DTC1AP
OCC
Inicie sesión para ver precios
 
Inserción LGX - Cubierta de Panel
Inserción LGX - Cubierta de Panel
# FPP-AD-BLANK
LYNN
Inicie sesión para ver precios
 
Panel Adaptador de Fibra LGX con 6 Puertos/Adaptadores LC Dúplex
Panel Adaptador de Fibra LGX con 6 Puertos/Adaptadores LC Dúplex
# FPP-AD-L32-06
LYNN
Inicie sesión para ver precios
 
Panel de Insertar LGX - Monomodo, 6 LC Dúplex para 12F en Total
Panel de Insertar LGX - Monomodo, 6 LC Dúplex para 12F en Total
# FPP-AD-LU2-06
LYNN
Inicie sesión para ver precios
 
Placa Adaptadora de 6 Puertos para Fibra Optica - Single Mode
Placa Adaptadora de 6 Puertos para Fibra Optica - Single Mode
# 616SMDLC
OCC
Inicie sesión para ver precios
 
Placa Adaptadora LC Dual de 6 Puertos - Multimodo/Monomodo
Placa Adaptadora LC Dual de 6 Puertos - Multimodo/Monomodo
# 616DLC
OCC
Inicie sesión para ver precios
 
Placas Adaptadoras LGX - 6 LC Cuádruple Multimodo OM3/4
Placas Adaptadoras LGX - 6 LC Cuádruple Multimodo OM3/4
# FPP-AD-L3Q-06
LYNN
Inicie sesión para ver precios
 
7 artículos