Log Out Log Out Log Out Cerrar sesiónopen invoices
Idioma:
EnglishEspañol
Shopping Cart Icon
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 » Seguridad » Contactos » Superficie

Superficie

   
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 = '111' and ptpef2.products_extra_fields_value = 'Aluminio') and ptc.categories_id = 95 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 = '111' and ptpef2.products_extra_fields_value = 'Aluminio') and ptc.categories_id = 95 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 = '111' and ptpef2.products_extra_fields_value = 'Aluminio') and ptc.categories_id = 95 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 = '111' and ptpef2.products_extra_fields_value = 'Aluminio') and ptc.categories_id = 95 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 = 95 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 = 95 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 = 95 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 = 95 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 = 95 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 = 95 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 = 95 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 = 95 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 = 95 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 = 95 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 = 95 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 = 95 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 = 95 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 = 95 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 = 95 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 = 95 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 = 95 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 = 95 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 = 95 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 = 95 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 = 95 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 = 95 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 = 95 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 = 95 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 = 95 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 = 95 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 = '93' and ptpef2.products_extra_fields_value = '345 MHz') and ptc.categories_id = 95 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 = '93' and ptpef2.products_extra_fields_value = '433 MHz') and ptc.categories_id = 95 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 = '93' and ptpef2.products_extra_fields_value = '915 MHz') and ptc.categories_id = 95 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 = '129' and ptpef2.products_extra_fields_value = '22') and ptc.categories_id = 95 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 = '144' and ptpef2.products_extra_fields_value = 'cerrado') and ptc.categories_id = 95 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 = '144' and ptpef2.products_extra_fields_value = 'DPDT') and ptc.categories_id = 95 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 = '144' and ptpef2.products_extra_fields_value = 'DPDT') and ptc.categories_id = 95 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 = '144' and ptpef2.products_extra_fields_value = 'DPDT') and ptc.categories_id = 95 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 = '144' and ptpef2.products_extra_fields_value = 'N/C') and ptc.categories_id = 95 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 = '144' and ptpef2.products_extra_fields_value = 'N/C') and ptc.categories_id = 95 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 = '144' and ptpef2.products_extra_fields_value = 'N/C') and ptc.categories_id = 95 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 = '144' and ptpef2.products_extra_fields_value = 'N/C') and ptc.categories_id = 95 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 = '144' and ptpef2.products_extra_fields_value = 'N/C') and ptc.categories_id = 95 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 = '144' and ptpef2.products_extra_fields_value = 'N/C') and ptc.categories_id = 95 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 = '144' and ptpef2.products_extra_fields_value = 'N/C') and ptc.categories_id = 95 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 = '144' and ptpef2.products_extra_fields_value = 'N/C') and ptc.categories_id = 95 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 = '144' and ptpef2.products_extra_fields_value = 'N/C') and ptc.categories_id = 95 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 = '144' and ptpef2.products_extra_fields_value = 'N/C') and ptc.categories_id = 95 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 = '144' and ptpef2.products_extra_fields_value = 'N/C') and ptc.categories_id = 95 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 = '144' and ptpef2.products_extra_fields_value = 'N/C') and ptc.categories_id = 95 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 = '144' and ptpef2.products_extra_fields_value = 'N/C') and ptc.categories_id = 95 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 = '144' and ptpef2.products_extra_fields_value = 'N/C') and ptc.categories_id = 95 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 = '144' and ptpef2.products_extra_fields_value = 'N/C') and ptc.categories_id = 95 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 = '144' and ptpef2.products_extra_fields_value = 'N/C') and ptc.categories_id = 95 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 = '144' and ptpef2.products_extra_fields_value = 'N/C') and ptc.categories_id = 95 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 = '144' and ptpef2.products_extra_fields_value = 'N/C') and ptc.categories_id = 95 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 = '144' and ptpef2.products_extra_fields_value = 'N/C') and ptc.categories_id = 95 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 = '144' and ptpef2.products_extra_fields_value = 'N/C') and ptc.categories_id = 95 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 = '144' and ptpef2.products_extra_fields_value = 'N/C') and ptc.categories_id = 95 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 = '144' and ptpef2.products_extra_fields_value = 'N/C') and ptc.categories_id = 95 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 = '144' and ptpef2.products_extra_fields_value = 'N/C') and ptc.categories_id = 95 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 = '144' and ptpef2.products_extra_fields_value = 'N/C') and ptc.categories_id = 95 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 = '144' and ptpef2.products_extra_fields_value = 'N/C') and ptc.categories_id = 95 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 = '144' and ptpef2.products_extra_fields_value = 'N/C') and ptc.categories_id = 95 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 = '144' and ptpef2.products_extra_fields_value = 'N/C') and ptc.categories_id = 95 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 = '144' and ptpef2.products_extra_fields_value = 'N/C') and ptc.categories_id = 95 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 = '144' and ptpef2.products_extra_fields_value = 'N/C') and ptc.categories_id = 95 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 = '144' and ptpef2.products_extra_fields_value = 'N/C') and ptc.categories_id = 95 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 = '144' and ptpef2.products_extra_fields_value = 'N/C') and ptc.categories_id = 95 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 = '144' and ptpef2.products_extra_fields_value = 'N/C') and ptc.categories_id = 95 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 = '144' and ptpef2.products_extra_fields_value = 'N/C') and ptc.categories_id = 95 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 = '144' and ptpef2.products_extra_fields_value = 'N/C') and ptc.categories_id = 95 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 = '144' and ptpef2.products_extra_fields_value = 'N/C') and ptc.categories_id = 95 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 = '144' and ptpef2.products_extra_fields_value = 'N/C') and ptc.categories_id = 95 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 = '144' and ptpef2.products_extra_fields_value = 'N/C') and ptc.categories_id = 95 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 = '144' and ptpef2.products_extra_fields_value = 'N/C') and ptc.categories_id = 95 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 = '144' and ptpef2.products_extra_fields_value = 'N/O') and ptc.categories_id = 95 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 = '144' and ptpef2.products_extra_fields_value = 'NO/NC') and ptc.categories_id = 95 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 = '144' and ptpef2.products_extra_fields_value = 'NO/NC') and ptc.categories_id = 95 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 = '144' and ptpef2.products_extra_fields_value = 'NO/NC') and ptc.categories_id = 95 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 = '144' and ptpef2.products_extra_fields_value = 'SPDT') and ptc.categories_id = 95 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 = '144' and ptpef2.products_extra_fields_value = 'SPDT') and ptc.categories_id = 95 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 = '144' and ptpef2.products_extra_fields_value = 'SPDT') and ptc.categories_id = 95 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 = '160 VDC') and ptc.categories_id = 95 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 = '175 VDC') and ptc.categories_id = 95 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 = 95 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 = 95 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 = 95 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 = 95 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 = 95 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 = 95 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 = 95 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 = 95 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 = 95 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 = 95 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 = 95 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 = 95 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 = 95 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 = 95 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 = 95 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 = 95 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 = 95 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 = 95 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 = 95 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 = 95 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 = 95 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 = 95 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 = 95 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 = 95 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 = 95 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 = 95 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 = 95 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 = 95 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 = 95 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 = 95 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 = 95 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 = 95 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 = 95 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 = 95 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 = 95 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 = 95 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 = 95 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 = 95 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 = 95 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 = 95 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 = 95 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 = 95 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 = 95 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 = 95 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 = 95 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 = 95 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 = 95 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 = 95 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 = 95 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 = 95 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 = 95 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 = 95 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 = 95 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 = 95 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 = 95 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 = 95 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 = 'Plata') and ptc.categories_id = 95 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 = '92' and ptpef2.products_extra_fields_value = 'Cableado') and ptc.categories_id = 95 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 = '92' and ptpef2.products_extra_fields_value = 'Cableado') and ptc.categories_id = 95 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 = '92' and ptpef2.products_extra_fields_value = 'Cableado') and ptc.categories_id = 95 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 = '92' and ptpef2.products_extra_fields_value = 'Cableado') and ptc.categories_id = 95 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 = '92' and ptpef2.products_extra_fields_value = 'Cableado') and ptc.categories_id = 95 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 = '92' and ptpef2.products_extra_fields_value = 'Cableado') and ptc.categories_id = 95 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 = '92' and ptpef2.products_extra_fields_value = 'Cableado') and ptc.categories_id = 95 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 = '92' and ptpef2.products_extra_fields_value = 'Cableado') and ptc.categories_id = 95 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 = '92' and ptpef2.products_extra_fields_value = 'Cableado') and ptc.categories_id = 95 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 = '92' and ptpef2.products_extra_fields_value = 'Cableado') and ptc.categories_id = 95 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 = '92' and ptpef2.products_extra_fields_value = 'Cableado') and ptc.categories_id = 95 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 = '92' and ptpef2.products_extra_fields_value = 'Cableado') and ptc.categories_id = 95 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 = '92' and ptpef2.products_extra_fields_value = 'Cableado') and ptc.categories_id = 95 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 = '92' and ptpef2.products_extra_fields_value = 'Cableado') and ptc.categories_id = 95 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 = '92' and ptpef2.products_extra_fields_value = 'Cableado') and ptc.categories_id = 95 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 = '92' and ptpef2.products_extra_fields_value = 'Cableado') and ptc.categories_id = 95 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 = '92' and ptpef2.products_extra_fields_value = 'Cableado') and ptc.categories_id = 95 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 = '92' and ptpef2.products_extra_fields_value = 'Cableado') and ptc.categories_id = 95 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 = '92' and ptpef2.products_extra_fields_value = 'Cableado') and ptc.categories_id = 95 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 = '92' and ptpef2.products_extra_fields_value = 'Cableado') and ptc.categories_id = 95 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 = '92' and ptpef2.products_extra_fields_value = 'Cableado') and ptc.categories_id = 95 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 = '92' and ptpef2.products_extra_fields_value = 'Cableado') and ptc.categories_id = 95 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 = '92' and ptpef2.products_extra_fields_value = 'Cableado') and ptc.categories_id = 95 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 = '92' and ptpef2.products_extra_fields_value = 'Cableado') and ptc.categories_id = 95 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 = '92' and ptpef2.products_extra_fields_value = 'Cableado') and ptc.categories_id = 95 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 = '92' and ptpef2.products_extra_fields_value = 'Cableado') and ptc.categories_id = 95 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 = '92' and ptpef2.products_extra_fields_value = 'Cableado') and ptc.categories_id = 95 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 = '92' and ptpef2.products_extra_fields_value = 'Cableado') and ptc.categories_id = 95 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 = '92' and ptpef2.products_extra_fields_value = 'Cableado') and ptc.categories_id = 95 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 = '92' and ptpef2.products_extra_fields_value = 'Cableado') and ptc.categories_id = 95 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 = '92' and ptpef2.products_extra_fields_value = 'Cableado') and ptc.categories_id = 95 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 = '92' and ptpef2.products_extra_fields_value = 'Cableado') and ptc.categories_id = 95 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 = '92' and ptpef2.products_extra_fields_value = 'Cableado') and ptc.categories_id = 95 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 = '92' and ptpef2.products_extra_fields_value = 'Cableado') and ptc.categories_id = 95 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 = '92' and ptpef2.products_extra_fields_value = 'Inalámbrico') and ptc.categories_id = 95 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 = '92' and ptpef2.products_extra_fields_value = 'Inalámbrico') and ptc.categories_id = 95 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 = '92' and ptpef2.products_extra_fields_value = 'Inalámbrico') and ptc.categories_id = 95 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 = '92' and ptpef2.products_extra_fields_value = 'Inalámbrico') and ptc.categories_id = 95 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 = '92' and ptpef2.products_extra_fields_value = 'Inalámbrico') and ptc.categories_id = 95 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 = '92' and ptpef2.products_extra_fields_value = 'Inalámbrico') and ptc.categories_id = 95 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 = '92' and ptpef2.products_extra_fields_value = 'Inalámbrico') and ptc.categories_id = 95 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 = '116' and ptpef2.products_extra_fields_value = '3') and ptc.categories_id = 95 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 = '116' and ptpef2.products_extra_fields_value = '3') and ptc.categories_id = 95 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 = '0.4') and ptc.categories_id = 95 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 = '0.4') and ptc.categories_id = 95 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 = '0.75') and ptc.categories_id = 95 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 = '1') and ptc.categories_id = 95 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 = '97' and ptpef2.products_extra_fields_value = 'Aml') and ptc.categories_id = 95 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 = '97' and ptpef2.products_extra_fields_value = 'Power Series') and ptc.categories_id = 95 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 = '97' and ptpef2.products_extra_fields_value = 'Powerg') and ptc.categories_id = 95 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 = 'Superficial') and ptc.categories_id = 95 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 = 'Superficial') and ptc.categories_id = 95 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 = 'Superficial') and ptc.categories_id = 95 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 = 'Superficial') and ptc.categories_id = 95 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 = 'Superficial') and ptc.categories_id = 95 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 = 'Superficial') and ptc.categories_id = 95 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 = 'Superficial') and ptc.categories_id = 95 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 = 'Superficial') and ptc.categories_id = 95 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 = 'Superficial') and ptc.categories_id = 95 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 = 'Superficial') and ptc.categories_id = 95 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 = 'Superficial') and ptc.categories_id = 95 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 = 'Superficial') and ptc.categories_id = 95 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 = 'Superficial') and ptc.categories_id = 95 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 = 'Superficial') and ptc.categories_id = 95 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 = 'Superficial') and ptc.categories_id = 95 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 = 'Superficial') and ptc.categories_id = 95 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 = 'Superficial') and ptc.categories_id = 95 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 = 'Superficial') and ptc.categories_id = 95 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 = 'Superficie') and ptc.categories_id = 95 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 = 'Superficie') and ptc.categories_id = 95 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 = 'Superficie') and ptc.categories_id = 95 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 = 'Superficie') and ptc.categories_id = 95 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 = 'Superficie') and ptc.categories_id = 95 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 = 'Superficie') and ptc.categories_id = 95 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 = 'Superficie') and ptc.categories_id = 95 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 = '143' and ptpef2.products_extra_fields_value = '1') and ptc.categories_id = 95 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 = '143' and ptpef2.products_extra_fields_value = '1\" (25mm)') and ptc.categories_id = 95 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 = '143' and ptpef2.products_extra_fields_value = '1\" (25mm)') and ptc.categories_id = 95 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 = '143' and ptpef2.products_extra_fields_value = '1\" (25mm)') and ptc.categories_id = 95 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 = '143' and ptpef2.products_extra_fields_value = '1\" (25mm)') and ptc.categories_id = 95 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 = '143' and ptpef2.products_extra_fields_value = '1\" (25mm)') and ptc.categories_id = 95 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 = '143' and ptpef2.products_extra_fields_value = '1\" (25mm)') and ptc.categories_id = 95 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 = '143' and ptpef2.products_extra_fields_value = '1\" (25mm)') and ptc.categories_id = 95 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 = '143' and ptpef2.products_extra_fields_value = '1\" (25mm)') and ptc.categories_id = 95 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 = '143' and ptpef2.products_extra_fields_value = '1\" (25mm)') and ptc.categories_id = 95 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 = '143' and ptpef2.products_extra_fields_value = '1\" (25mm)') and ptc.categories_id = 95 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 = '143' and ptpef2.products_extra_fields_value = '1\" (25mm)') and ptc.categories_id = 95 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 = '143' and ptpef2.products_extra_fields_value = '1\" (25mm)') and ptc.categories_id = 95 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 = '143' and ptpef2.products_extra_fields_value = '1\" (25mm)') and ptc.categories_id = 95 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 = '143' and ptpef2.products_extra_fields_value = '1\" (25mm)') and ptc.categories_id = 95 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 = '143' and ptpef2.products_extra_fields_value = '1\" (25mm)') and ptc.categories_id = 95 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 = '143' and ptpef2.products_extra_fields_value = '1\" (25mm)') and ptc.categories_id = 95 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 = '143' and ptpef2.products_extra_fields_value = '1\" (25mm)') and ptc.categories_id = 95 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 = '143' and ptpef2.products_extra_fields_value = '1\" (25mm)') and ptc.categories_id = 95 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 = '143' and ptpef2.products_extra_fields_value = '1\" (25mm)') and ptc.categories_id = 95 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 = '143' and ptpef2.products_extra_fields_value = '1/2\" (12.5mm)') and ptc.categories_id = 95 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 = '143' and ptpef2.products_extra_fields_value = '1/2\" (12.5mm)') and ptc.categories_id = 95 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 = '143' and ptpef2.products_extra_fields_value = '1/2\" (12.5mm)') and ptc.categories_id = 95 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 = '143' and ptpef2.products_extra_fields_value = '1/2\" (12.5mm)') and ptc.categories_id = 95 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 = '143' and ptpef2.products_extra_fields_value = '1.5\" (38mm)') and ptc.categories_id = 95 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 = '143' and ptpef2.products_extra_fields_value = '1.5\" (38mm)') and ptc.categories_id = 95 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 = '143' and ptpef2.products_extra_fields_value = '1.5\" (38mm)') and ptc.categories_id = 95 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 = '143' and ptpef2.products_extra_fields_value = '1.5\" (38mm)') and ptc.categories_id = 95 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 = '143' and ptpef2.products_extra_fields_value = '1.5\" (38mm)') and ptc.categories_id = 95 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 = '143' and ptpef2.products_extra_fields_value = '1.5\" (38mm)') and ptc.categories_id = 95 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 = '143' and ptpef2.products_extra_fields_value = '2 3/4\" (70mm)') and ptc.categories_id = 95 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 = '143' and ptpef2.products_extra_fields_value = '2\" (51mm)') and ptc.categories_id = 95 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 = '143' and ptpef2.products_extra_fields_value = '2\" (51mm)') and ptc.categories_id = 95 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 = '143' and ptpef2.products_extra_fields_value = '3\" (76mm)') and ptc.categories_id = 95 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 = '143' and ptpef2.products_extra_fields_value = '3\" (76mm)') and ptc.categories_id = 95 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 = '143' and ptpef2.products_extra_fields_value = '3\" (76mm)') and ptc.categories_id = 95 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 = '143' and ptpef2.products_extra_fields_value = '3\" (76mm)') and ptc.categories_id = 95 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 = '143' and ptpef2.products_extra_fields_value = '3\" (76mm)') and ptc.categories_id = 95 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 = '143' and ptpef2.products_extra_fields_value = '3/4\" (19mm)') and ptc.categories_id = 95 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 = '143' and ptpef2.products_extra_fields_value = '3/4\" (19mm)') and ptc.categories_id = 95 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 = '143' and ptpef2.products_extra_fields_value = '3/4\" (19mm)') and ptc.categories_id = 95 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 = '143' and ptpef2.products_extra_fields_value = '3/4\" (19mm)') and ptc.categories_id = 95 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 = '143' and ptpef2.products_extra_fields_value = '3/4\" (19mm)') and ptc.categories_id = 95 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 = '143' and ptpef2.products_extra_fields_value = '3/4\" (19mm)') and ptc.categories_id = 95 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 = '143' and ptpef2.products_extra_fields_value = '3/4″ (19mm)') and ptc.categories_id = 95 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 = '143' and ptpef2.products_extra_fields_value = '3/4″ (19mm)') and ptc.categories_id = 95 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 = '143' and ptpef2.products_extra_fields_value = '3/4″ (19mm)') and ptc.categories_id = 95 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 = '143' and ptpef2.products_extra_fields_value = '3/4″ (19mm)') and ptc.categories_id = 95 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 = '143' and ptpef2.products_extra_fields_value = '3/5\" (15.24mm)') and ptc.categories_id = 95 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 = '143' and ptpef2.products_extra_fields_value = '5/8\" (15mm)') and ptc.categories_id = 95 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 = '143' and ptpef2.products_extra_fields_value = '7/8\" (22.25mm)') and ptc.categories_id = 95 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 = '142' and ptpef2.products_extra_fields_value = 'Pesado') and ptc.categories_id = 95 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 = '142' and ptpef2.products_extra_fields_value = 'Pesado') and ptc.categories_id = 95 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 = '142' and ptpef2.products_extra_fields_value = 'Pesado') and ptc.categories_id = 95 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 = '142' and ptpef2.products_extra_fields_value = 'Pesado') and ptc.categories_id = 95 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 = '142' and ptpef2.products_extra_fields_value = 'Pesado') and ptc.categories_id = 95 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 = '142' and ptpef2.products_extra_fields_value = 'Pesado') and ptc.categories_id = 95 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 = '142' and ptpef2.products_extra_fields_value = 'Pesado') and ptc.categories_id = 95 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 = '142' and ptpef2.products_extra_fields_value = 'Pesado') and ptc.categories_id = 95 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 = '142' and ptpef2.products_extra_fields_value = 'Regular') and ptc.categories_id = 95 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 = '142' and ptpef2.products_extra_fields_value = 'Regular') and ptc.categories_id = 95 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 = '142' and ptpef2.products_extra_fields_value = 'Regular') and ptc.categories_id = 95 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 = '142' and ptpef2.products_extra_fields_value = 'Regular') and ptc.categories_id = 95 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 = '142' and ptpef2.products_extra_fields_value = 'Regular') and ptc.categories_id = 95 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 = '142' and ptpef2.products_extra_fields_value = 'Regular') and ptc.categories_id = 95 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 = '142' and ptpef2.products_extra_fields_value = 'Regular') and ptc.categories_id = 95 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 = '142' and ptpef2.products_extra_fields_value = 'Regular') and ptc.categories_id = 95 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 = '142' and ptpef2.products_extra_fields_value = 'Regular') and ptc.categories_id = 95 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 = '142' and ptpef2.products_extra_fields_value = 'Regular') and ptc.categories_id = 95 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 = '142' and ptpef2.products_extra_fields_value = 'Regular') and ptc.categories_id = 95 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 = '142' and ptpef2.products_extra_fields_value = 'Regular') and ptc.categories_id = 95 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 = '142' and ptpef2.products_extra_fields_value = 'Regular') and ptc.categories_id = 95 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 = '142' and ptpef2.products_extra_fields_value = 'Regular') and ptc.categories_id = 95 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 = '142' and ptpef2.products_extra_fields_value = 'Regular') and ptc.categories_id = 95 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 = '142' and ptpef2.products_extra_fields_value = 'Regular') and ptc.categories_id = 95 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 = '142' and ptpef2.products_extra_fields_value = 'Regular') and ptc.categories_id = 95 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 = '142' and ptpef2.products_extra_fields_value = 'Regular') and ptc.categories_id = 95 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 = '142' and ptpef2.products_extra_fields_value = 'Regular') and ptc.categories_id = 95 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 = '142' and ptpef2.products_extra_fields_value = 'Regular') and ptc.categories_id = 95 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 = '142' and ptpef2.products_extra_fields_value = 'Regular') and ptc.categories_id = 95 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 = '142' and ptpef2.products_extra_fields_value = 'Regular') and ptc.categories_id = 95 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 = '142' and ptpef2.products_extra_fields_value = 'Regular') and ptc.categories_id = 95 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 = '106' and ptpef2.products_extra_fields_value = 'Batería') and ptc.categories_id = 95 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 = '106' and ptpef2.products_extra_fields_value = 'Batería') and ptc.categories_id = 95 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 = '106' and ptpef2.products_extra_fields_value = 'Batería') and ptc.categories_id = 95 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 = '106' and ptpef2.products_extra_fields_value = 'Batería') and ptc.categories_id = 95 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 = '106' and ptpef2.products_extra_fields_value = '30 VDC') and ptc.categories_id = 95 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 = '106' and ptpef2.products_extra_fields_value = '30 VDC') and ptc.categories_id = 95 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 = '106' and ptpef2.products_extra_fields_value = '130 VDC') and ptc.categories_id = 95 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
DSC
Ecolink
Flair Electronics
Gri - George Risk Industries
Linear
Magnasphere
Potter
Resideo
Rokonet | Risco Group
Seco-Larm
Tane Alarm Products
Acabado
Aluminio
Ambiente
Exterior
Interior
Banda de Transmisión
345 MHz
433 MHz
915 MHz
Calibre de Alambre (Awg)
22
Circuito
cerrado
DPDT
N/C
N/O
NO/NC
SPDT
Clasificación
160 VDC
175 VDC
Color
Blanco
Gris
Marrón
Negro
Plata
Conectividad
Cableado
Inalámbrico
Corriente (A)
3
Diámetro (In)
0.4
0.75
1
Familia
Aml
Power Series
Powerg
Instalación
Superficial
Superficie
Separación (In)
1
1" (25mm)
1/2" (12.5mm)
1.5" (38mm)
2 3/4" (70mm)
2" (51mm)
3" (76mm)
3/4" (19mm)
3/4″ (19mm)
3/5" (15.24mm)
5/8" (15mm)
7/8" (22.25mm)
Tipo de Trabajo
Pesado
Regular
Voltaje de Operación
Batería
30 VDC
130 VDC
Pixel Trans
Pixel Trans
 Cuadrícula  List      100 artículos    
 1  2  3  4  5  ▶ ▶ 
1-1/2″ Contacto Magnético de Montaje en Superficie - Blanco
1-1/2″ Contacto Magnético de Montaje en Superficie - Blanco
# VIP100-1WH
Flair Electronics
Inicie sesión para ver precios
 
1-1/2″ Contacto Magnético de Montaje en Superficie - Marrón
1-1/2″ Contacto Magnético de Montaje en Superficie -...
# VIP100-1BR
Flair Electronics
Inicie sesión para ver precios
 
1000-65L-36 (Interlogix 2505A-L) Contacto Magnético de Montaje en Superficie de 3 1/2″ - 36" Cable con Proteccic162n Metálica
1000-65L-36 (Interlogix 2505A-L) Contacto Magnético de Mon...
# VIP1000-65L-36
Flair Electronics
Inicie sesión para ver precios
 
2" Contacto Magnético de Montaje en Superficie - Blanco
2" Contacto Magnético de Montaje en Superficie - Blanco
# VIP100WH
Flair Electronics
Inicie sesión para ver precios
 
2" Contacto Magnético de Montaje en Superficie - Marrón
2" Contacto Magnético de Montaje en Superficie - Marrón
# VIP100BR
Flair Electronics
Inicie sesión para ver precios
 
4 1/2" Contacto de Alta Seguridad BMS de Montaje Superficial, Nivel II del Estándar 634 de la UL
4 1/2" Contacto de Alta Seguridad BMS de Montaje Superficial, Niv...
# FL2-100
Flair Electronics
Inicie sesión para ver precios
 
4704A con Cable Blindado Recubierto de 3' - Conector Macho
4704A con Cable Blindado Recubierto de 3' - Conector Macho
# 8307-3
Gri - George Risk Industries
Inicie sesión para ver precios
 
Conjunto de Interruptores de Montaje en Riel Industrial - Tamaño de Riel de 2.5" a 4"
Conjunto de Interruptores de Montaje en Riel Industrial - Tama&nt...
# 4700-AXL
Gri - George Risk Industries
Inicie sesión para ver precios
 
Contacto de Alta Seguridad
Contacto de Alta Seguridad
# HSC-M
Potter
Inicie sesión para ver precios
 
Contacto de Montaje en Superficie - Blanco
Contacto de Montaje en Superficie - Blanco
# 7939-2WH
Resideo
Inicie sesión para ver precios
 
Contacto de Montaje en Superficie de 2 1/2″
Contacto de Montaje en Superficie de 2 1/2″
# 1000-34SWY
Flair Electronics
Inicie sesión para ver precios
 
Contacto de Montaje en Superficie Direccionable V-Plex® - Blanco
Contacto de Montaje en Superficie Direccionable V-Plex® - Blanco
# 4939SN-WH
Resideo
Inicie sesión para ver precios
 
Contacto de Montaje Superficial con Desplazamiento de Aislamiento - Blanco
Contacto de Montaje Superficial con Desplazamiento de Aislamiento - Blanco
# AMS-51CV
Potter
Inicie sesión para ver precios
 
Contacto de puerta / ventana direccionable
Contacto de puerta / ventana direccionable
# AMP-701
DSC
Inicie sesión para ver precios
 
Contacto Magnético Balanceado de Montaje en Superficie de Alta Seguridad con Separación de 1/2"
Contacto Magnético Balanceado de Montaje en Superficie de ...
# 1010-64X
Flair Electronics
Inicie sesión para ver precios
 
Contacto Magnético de 3" para Montaje en Superficie
Contacto Magnético de 3" para Montaje en Superficie
# VIP1000-50
Flair Electronics
Inicie sesión para ver precios
 
Contacto Magnético de Alta Resistencia Extraíble
Contacto Magnético de Alta Resistencia Extraíble
# PA1000-80
Flair Electronics
Inicie sesión para ver precios
 
Contacto magnético de montaje en superficie
Contacto magnético de montaje en superficie
# VIP88WH
Flair Electronics
Inicie sesión para ver precios
 
Contacto magnético de montaje en superficie
Contacto magnético de montaje en superficie
# 7939WG-WH
Resideo
Inicie sesión para ver precios
 
Contacto magnético de montaje en superficie
Contacto magnético de montaje en superficie
# VIP39WH
Flair Electronics
Inicie sesión para ver precios
 
Contacto Magnético de Montaje en Superficie con Terminal de Tornillo - Blanco, Espacio de 3/4″ (19 mm)
Contacto Magnético de Montaje en Superficie con Terminal d...
# SM-200Q/W
Seco-Larm
Inicie sesión para ver precios
 
Contacto Magnético de Montaje en Superficie de Alta Potencia
Contacto Magnético de Montaje en Superficie de Alta Potencia
# 1000-26S-834
Flair Electronics
Inicie sesión para ver precios
 
Contacto Magnético de Montaje en Superficie de Alta Potencia
Contacto Magnético de Montaje en Superficie de Alta Potencia
# 1000-66-634
Flair Electronics
Inicie sesión para ver precios
 
Contacto Magnético de Montaje en Superficie de Alta Potencia - SPDT
Contacto Magnético de Montaje en Superficie de Alta Potencia - SPDT
# 1000-26S-634
Flair Electronics
Inicie sesión para ver precios
 
100 artículos  1  2  3  4  5  ▶ ▶