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 » Audio & Video » Altavoces » De Pared

De Pared

   
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 = '102' and ptpef2.products_extra_fields_value = 'Exterior') and ptc.categories_id = 235 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 = '102' and ptpef2.products_extra_fields_value = 'Exterior') and ptc.categories_id = 235 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 = '102' and ptpef2.products_extra_fields_value = 'Exterior') and ptc.categories_id = 235 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 = '102' and ptpef2.products_extra_fields_value = 'Exterior') and ptc.categories_id = 235 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 = '102' and ptpef2.products_extra_fields_value = 'Exterior') and ptc.categories_id = 235 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 = '102' and ptpef2.products_extra_fields_value = 'Exterior') and ptc.categories_id = 235 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 = '102' and ptpef2.products_extra_fields_value = 'Exterior') and ptc.categories_id = 235 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 = '102' and ptpef2.products_extra_fields_value = 'Exterior') and ptc.categories_id = 235 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 = '102' and ptpef2.products_extra_fields_value = 'Exterior') and ptc.categories_id = 235 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 = '102' and ptpef2.products_extra_fields_value = 'Interior') and ptc.categories_id = 235 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 = '102' and ptpef2.products_extra_fields_value = 'Interior') and ptc.categories_id = 235 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 = '102' and ptpef2.products_extra_fields_value = 'Interior') and ptc.categories_id = 235 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 = '102' and ptpef2.products_extra_fields_value = 'Interior') and ptc.categories_id = 235 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 = '102' and ptpef2.products_extra_fields_value = 'Interior') and ptc.categories_id = 235 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 = '102' and ptpef2.products_extra_fields_value = 'Interior') and ptc.categories_id = 235 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 = '102' and ptpef2.products_extra_fields_value = 'Interior') and ptc.categories_id = 235 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 = '102' and ptpef2.products_extra_fields_value = 'Interior') and ptc.categories_id = 235 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 = '102' and ptpef2.products_extra_fields_value = 'Interior') and ptc.categories_id = 235 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 = '102' and ptpef2.products_extra_fields_value = 'Interior') and ptc.categories_id = 235 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 = '107' and ptpef2.products_extra_fields_value = 'IP66') and ptc.categories_id = 235 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 = '107' and ptpef2.products_extra_fields_value = 'IPX4') and ptc.categories_id = 235 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 = '107' and ptpef2.products_extra_fields_value = 'IPX4') and ptc.categories_id = 235 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 = '107' and ptpef2.products_extra_fields_value = 'IPX4') and ptc.categories_id = 235 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 = '107' and ptpef2.products_extra_fields_value = 'IPX4') and ptc.categories_id = 235 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 = '107' and ptpef2.products_extra_fields_value = 'IPX4') and ptc.categories_id = 235 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 = '107' and ptpef2.products_extra_fields_value = 'IPX4') and ptc.categories_id = 235 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 = 'Blanco') and ptc.categories_id = 235 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 = 'Blanco') and ptc.categories_id = 235 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 = 'Blanco') and ptc.categories_id = 235 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 = 'Gris') and ptc.categories_id = 235 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 = 'Marrón') and ptc.categories_id = 235 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 = 235 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 = 235 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 = 235 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 = 235 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 = 235 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 = 235 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 = 235 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 = 235 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 / Blanco') and ptc.categories_id = 235 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 = '108' and ptpef2.products_extra_fields_value = '5.25') and ptc.categories_id = 235 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 = '108' and ptpef2.products_extra_fields_value = '5.25') and ptc.categories_id = 235 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 = '108' and ptpef2.products_extra_fields_value = '6.5') and ptc.categories_id = 235 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 = '108' and ptpef2.products_extra_fields_value = '6.5') and ptc.categories_id = 235 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 = '108' and ptpef2.products_extra_fields_value = '8') and ptc.categories_id = 235 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 = '108' and ptpef2.products_extra_fields_value = '8') and ptc.categories_id = 235 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 = '108' and ptpef2.products_extra_fields_value = '20') and ptc.categories_id = 235 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 = '133' and ptpef2.products_extra_fields_value = '6') and ptc.categories_id = 235 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 = '133' and ptpef2.products_extra_fields_value = '6') and ptc.categories_id = 235 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 = '133' and ptpef2.products_extra_fields_value = '6') and ptc.categories_id = 235 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 = '133' and ptpef2.products_extra_fields_value = '6') and ptc.categories_id = 235 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 = '133' and ptpef2.products_extra_fields_value = '6') and ptc.categories_id = 235 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 = '133' and ptpef2.products_extra_fields_value = '8') and ptc.categories_id = 235 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 = '133' and ptpef2.products_extra_fields_value = '8') and ptc.categories_id = 235 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 = '133' and ptpef2.products_extra_fields_value = '8') and ptc.categories_id = 235 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 = '133' and ptpef2.products_extra_fields_value = '8') and ptc.categories_id = 235 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 = '133' and ptpef2.products_extra_fields_value = '8') and ptc.categories_id = 235 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 = '133' and ptpef2.products_extra_fields_value = '8') and ptc.categories_id = 235 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 = '133' and ptpef2.products_extra_fields_value = '8') and ptc.categories_id = 235 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 = '133' and ptpef2.products_extra_fields_value = '8') and ptc.categories_id = 235 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 = '133' and ptpef2.products_extra_fields_value = '8') and ptc.categories_id = 235 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 = '133' and ptpef2.products_extra_fields_value = '8') and ptc.categories_id = 235 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 = '133' and ptpef2.products_extra_fields_value = '8') and ptc.categories_id = 235 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 = '133' and ptpef2.products_extra_fields_value = '8') and ptc.categories_id = 235 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 = '133' and ptpef2.products_extra_fields_value = '8') and ptc.categories_id = 235 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 = '179' and ptpef2.products_extra_fields_value = 'Pared') and ptc.categories_id = 235 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 = '179' and ptpef2.products_extra_fields_value = 'Pared') and ptc.categories_id = 235 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 = '179' and ptpef2.products_extra_fields_value = 'Pared') and ptc.categories_id = 235 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 = '179' and ptpef2.products_extra_fields_value = 'Pared') and ptc.categories_id = 235 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 = '179' and ptpef2.products_extra_fields_value = 'Pared') and ptc.categories_id = 235 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 = '179' and ptpef2.products_extra_fields_value = 'Pared') and ptc.categories_id = 235 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 = '179' and ptpef2.products_extra_fields_value = 'Pared') and ptc.categories_id = 235 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 = '179' and ptpef2.products_extra_fields_value = 'Pared') and ptc.categories_id = 235 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 = '179' and ptpef2.products_extra_fields_value = 'Pared') and ptc.categories_id = 235 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 = '179' and ptpef2.products_extra_fields_value = 'Pared') and ptc.categories_id = 235 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 = '179' and ptpef2.products_extra_fields_value = 'Pared') and ptc.categories_id = 235 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 = '179' and ptpef2.products_extra_fields_value = 'Pared') and ptc.categories_id = 235 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 = '179' and ptpef2.products_extra_fields_value = 'Pared') and ptc.categories_id = 235 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 = '179' and ptpef2.products_extra_fields_value = 'Pared') and ptc.categories_id = 235 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 = '179' and ptpef2.products_extra_fields_value = 'Pared') and ptc.categories_id = 235 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 = '179' and ptpef2.products_extra_fields_value = 'Pared / Escritorio') and ptc.categories_id = 235 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 = '166' and ptpef2.products_extra_fields_value = 'Fibra de vidrio') and ptc.categories_id = 235 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 = '166' and ptpef2.products_extra_fields_value = 'Grafito') and ptc.categories_id = 235 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 = '166' and ptpef2.products_extra_fields_value = 'Grafito') and ptc.categories_id = 235 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 = '166' and ptpef2.products_extra_fields_value = 'Grafito') and ptc.categories_id = 235 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 = '166' and ptpef2.products_extra_fields_value = 'Grafito') and ptc.categories_id = 235 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 = '166' and ptpef2.products_extra_fields_value = 'Grafito') and ptc.categories_id = 235 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 = '166' and ptpef2.products_extra_fields_value = 'Grafito') and ptc.categories_id = 235 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 = '166' and ptpef2.products_extra_fields_value = 'Kevlar') and ptc.categories_id = 235 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 = '166' and ptpef2.products_extra_fields_value = 'Kevlar') and ptc.categories_id = 235 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 = '166' and ptpef2.products_extra_fields_value = 'Polipropileno') and ptc.categories_id = 235 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 = '166' and ptpef2.products_extra_fields_value = 'Polipropileno') and ptc.categories_id = 235 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 = '166' and ptpef2.products_extra_fields_value = 'Polipropileno') and ptc.categories_id = 235 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 = '166' and ptpef2.products_extra_fields_value = 'Polipropileno') and ptc.categories_id = 235 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 = '166' and ptpef2.products_extra_fields_value = 'Polipropileno') and ptc.categories_id = 235 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 = '166' and ptpef2.products_extra_fields_value = 'Polipropileno') and ptc.categories_id = 235 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 = '166' and ptpef2.products_extra_fields_value = 'Polipropileno') and ptc.categories_id = 235 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 = '166' and ptpef2.products_extra_fields_value = 'Polipropileno') and ptc.categories_id = 235 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 = '166' and ptpef2.products_extra_fields_value = 'Polipropileno') and ptc.categories_id = 235 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 = '120' and ptpef2.products_extra_fields_value = '30 W') and ptc.categories_id = 235 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 = '120' and ptpef2.products_extra_fields_value = '60 W') and ptc.categories_id = 235 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 = '120' and ptpef2.products_extra_fields_value = '60 W') and ptc.categories_id = 235 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 = '120' and ptpef2.products_extra_fields_value = '75 W') and ptc.categories_id = 235 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 = '120' and ptpef2.products_extra_fields_value = '75 W') and ptc.categories_id = 235 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 = '120' and ptpef2.products_extra_fields_value = '100 W') and ptc.categories_id = 235 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 = '120' and ptpef2.products_extra_fields_value = '100 W') and ptc.categories_id = 235 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 = '120' and ptpef2.products_extra_fields_value = '100 W') and ptc.categories_id = 235 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 = '120' and ptpef2.products_extra_fields_value = '100 W') and ptc.categories_id = 235 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 = '120' and ptpef2.products_extra_fields_value = '100 W') and ptc.categories_id = 235 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 = '120' and ptpef2.products_extra_fields_value = '100 W') and ptc.categories_id = 235 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 = '120' and ptpef2.products_extra_fields_value = '125 W') and ptc.categories_id = 235 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 = '120' and ptpef2.products_extra_fields_value = '125 W') and ptc.categories_id = 235 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 = '120' and ptpef2.products_extra_fields_value = '150 W') and ptc.categories_id = 235 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 = '120' and ptpef2.products_extra_fields_value = '150 W') and ptc.categories_id = 235 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 = '120' and ptpef2.products_extra_fields_value = '150 W') and ptc.categories_id = 235 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 = '120' and ptpef2.products_extra_fields_value = '150 W') and ptc.categories_id = 235 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 = '175' and ptpef2.products_extra_fields_value = '3\" (76mm)') and ptc.categories_id = 235 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 = '175' and ptpef2.products_extra_fields_value = '3\" (76mm)') and ptc.categories_id = 235 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 = '168' and ptpef2.products_extra_fields_value = 'Two 5 1/4\" (133.25mm)') and ptc.categories_id = 235 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 = '168' and ptpef2.products_extra_fields_value = '3\" (76.2mm)') and ptc.categories_id = 235 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 = '168' and ptpef2.products_extra_fields_value = '5 1/4\" (133.25mm)') and ptc.categories_id = 235 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 = '168' and ptpef2.products_extra_fields_value = '5 1/4\" (133.25mm)') and ptc.categories_id = 235 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 = '168' and ptpef2.products_extra_fields_value = '5 1/4\" (133.25mm)') and ptc.categories_id = 235 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 = '168' and ptpef2.products_extra_fields_value = '5\" (127mm)') and ptc.categories_id = 235 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 = '168' and ptpef2.products_extra_fields_value = '5\" (127mm)') and ptc.categories_id = 235 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 = '168' and ptpef2.products_extra_fields_value = '6 1/2\" (165mm)') and ptc.categories_id = 235 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 = '168' and ptpef2.products_extra_fields_value = '6 1/2\" (165mm)') and ptc.categories_id = 235 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 = '168' and ptpef2.products_extra_fields_value = '6 1/2\" (165mm)') and ptc.categories_id = 235 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 = '168' and ptpef2.products_extra_fields_value = '6 1/2\" (165mm)') and ptc.categories_id = 235 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 = '168' and ptpef2.products_extra_fields_value = '6 1/2\" (165mm)') and ptc.categories_id = 235 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 = '168' and ptpef2.products_extra_fields_value = '6 1/2\" (165mm)') and ptc.categories_id = 235 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 = '168' and ptpef2.products_extra_fields_value = '6 1/2\" (165mm)') and ptc.categories_id = 235 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 = '168' and ptpef2.products_extra_fields_value = '8\" (203mm)') and ptc.categories_id = 235 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 = '168' and ptpef2.products_extra_fields_value = '8\" (203mm)') and ptc.categories_id = 235 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 = '168' and ptpef2.products_extra_fields_value = '8\" (203mm)') and ptc.categories_id = 235 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 = '167' and ptpef2.products_extra_fields_value = '1\" (25.5mm)') and ptc.categories_id = 235 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 = '167' and ptpef2.products_extra_fields_value = '1\" (25.5mm)') and ptc.categories_id = 235 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 = '167' and ptpef2.products_extra_fields_value = '1\" (25.5mm)') and ptc.categories_id = 235 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 = '167' and ptpef2.products_extra_fields_value = '1\" (25.5mm)') and ptc.categories_id = 235 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 = '167' and ptpef2.products_extra_fields_value = '1\" (25.5mm)') and ptc.categories_id = 235 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 = '167' and ptpef2.products_extra_fields_value = '1\" (25.5mm)') and ptc.categories_id = 235 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 = '167' and ptpef2.products_extra_fields_value = '1\" (25.5mm)') and ptc.categories_id = 235 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 = '167' and ptpef2.products_extra_fields_value = '1\" (25.5mm)') and ptc.categories_id = 235 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 = '167' and ptpef2.products_extra_fields_value = '1\" (25.5mm)') and ptc.categories_id = 235 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 = '167' and ptpef2.products_extra_fields_value = '1\" (25.5mm)') and ptc.categories_id = 235 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 = '167' and ptpef2.products_extra_fields_value = '1\" (25.5mm)') and ptc.categories_id = 235 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 = '167' and ptpef2.products_extra_fields_value = '1\" (25.5mm)') and ptc.categories_id = 235 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 = '167' and ptpef2.products_extra_fields_value = '1\" (25.5mm)') and ptc.categories_id = 235 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 = '167' and ptpef2.products_extra_fields_value = '1\" (25.5mm)') and ptc.categories_id = 235 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 = '167' and ptpef2.products_extra_fields_value = '1\" (25.5mm)') and ptc.categories_id = 235 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 = '167' and ptpef2.products_extra_fields_value = '3\" (76.2mm)') and ptc.categories_id = 235 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
Adept
Proficient Audio Systems
Speco Technologies
Ambiente
Exterior
Interior
Clasificación
IP66
IPX4
Color
Blanco
Gris
Marrón
Negro
Negro / Blanco
Diámetro (In)
5.25
6.5
8
20
Impedancia (Ohms)
6
8
Instalación
Pared
Pared / Escritorio
Material
Fibra de vidrio
Grafito
Kevlar
Polipropileno
Mx. Potencia de Salida (VA / W)
30 W
60 W
75 W
100 W
125 W
150 W
Rango Medio
3" (76mm)
Tamaño de Woofer
Two 5 1/4" (133.25mm)
3" (76.2mm)
5 1/4" (133.25mm)
5" (127mm)
6 1/2" (165mm)
8" (203mm)
Tweeter
1" (25.5mm)
3" (76.2mm)
Pixel Trans
Pixel Trans
 Cuadrícula  List      22 artículos
Altavoces de Gabinete de 5.25" con Tweeter de Cúpula de Aluminio Pivotante de 1" - 75 W
Altavoces de Gabinete de 5.25" con Tweeter de Cúpula de Al...
# IO50W
Adept
Inicie sesión para ver precios
 
Altavoces de gabinete de 5.25" con tweeter de cúpula de aluminio pivotante de 1" - 75 W
Altavoces de gabinete de 5.25" con tweeter de cúpula de al...
# IO50B
Adept
Inicie sesión para ver precios
 
Altavoces de gabinete de 6.5" con tweeter de cúpula de aluminio pivotante de 1" - 75 W
Altavoces de gabinete de 6.5" con tweeter de cúpula de alu...
# IO60B
Adept
Inicie sesión para ver precios
 
Altavoces de gabinete de 6.5" con tweeter de cúpula de aluminio pivotante de 1" - 75 W
Altavoces de gabinete de 6.5" con tweeter de cúpula de alu...
# IO60W
Adept
Inicie sesión para ver precios
 
Altavoces de montaje en superficie de 8" y 3 vías
Altavoces de montaje en superficie de 8" y 3 vías
# IO80B
Adept
Inicie sesión para ver precios
 
Altavoces de montaje en superficie de 8" y 3 vías
Altavoces de montaje en superficie de 8" y 3 vías
# IO80W
Adept
Inicie sesión para ver precios
 
Altavoz de efectos y LCR doble de 5"
Altavoz de efectos y LCR doble de 5"
# LCRE5
Proficient Audio Systems
Inicie sesión para ver precios
 
Altavoz de Gabinete Dolby Atmos de 5" - Un Par
Altavoz de Gabinete Dolby Atmos de 5" - Un Par
# LDA5
Proficient Audio Systems
Inicie sesión para ver precios
 
Altavoz de Montaje en Pared de 8" con Transformador - 140 W
Altavoz de Montaje en Pared de 8" con Transformador - 140 W
# SPCE8OTB
Speco Technologies
Inicie sesión para ver precios
 
Altavoz de pared 100W - Un Par
Altavoz de pared 100W - Un Par
# W672
Proficient Audio Systems
Inicie sesión para ver precios
 
Altavoz de Pared de 6,5" Dos Vías
Altavoz de Pared de 6,5" Dos Vías
# IW62
Adept
Inicie sesión para ver precios
 
Altavoz de pared de 6.5"
Altavoz de pared de 6.5"
# W695S
Proficient Audio Systems
Inicie sesión para ver precios
 
Altavoz de pared LCR 125W
Altavoz de pared LCR 125W
# IW575S
Proficient Audio Systems
Inicie sesión para ver precios
 
Altavoz de pared LCR 150W
Altavoz de pared LCR 150W
# IW675S
Proficient Audio Systems
Inicie sesión para ver precios
 
Altavoz de proyección de 5” 70V
Altavoz de proyección de 5” 70V
# SPP20T
Speco Technologies
Inicie sesión para ver precios
 
Altavoz LCR de Pared
Altavoz LCR de Pared
# IWLCR66
Adept
Inicie sesión para ver precios
 
Altavoz LCR de pared con dos woofers de grafito de 5 1/4" y tweeter de aluminio pivotante de 1"
Altavoz LCR de pared con dos woofers de grafito de 5 1/4" y tweet...
# IW530
Proficient Audio Systems
Inicie sesión para ver precios
 
Altavoz LCR Doble de Grafito de 5" para Empotrar en la Pared
Altavoz LCR Doble de Grafito de 5" para Empotrar en la Pared
# IWLCR56
Adept
Inicie sesión para ver precios
 
Barra de sonido pasiva de 3 canales
Barra de sonido pasiva de 3 canales
# LSB3
Proficient Audio Systems
Inicie sesión para ver precios
 
Bocina de proyección resistente a la intemperie de 20"
Bocina de proyección resistente a la intemperie de 20"
# SRH20
Speco Technologies
Inicie sesión para ver precios
 
Subwoofer de 10" para empotrar en la pared 250W
Subwoofer de 10" para empotrar en la pared 250W
# IWS105
Proficient Audio Systems
Inicie sesión para ver precios
 
Subwoofer Doble de 8" para Empotrar en la Pared
Subwoofer Doble de 8" para Empotrar en la Pared
# PAS-HRSIW8-CAB
Proficient Audio Systems
Inicie sesión para ver precios
 
22 artículos