English
SpanishIdioma:
EnglishEspañol
Necesitas ayuda? Contáctanos en 1800.325.9708
Soporte vital
Flair Electronics
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 = 'Acero Inoxidable') and p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '171' and ptpef2.products_extra_fields_value = '177') and p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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') and p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 = 'Natural') and p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 = 'Natural') and p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 = 'Natural') and p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 = 'Wired') and p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 = '0.05') and p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 = '0.5') and p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 = '0.5') and p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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.375') and p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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.375') and p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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.375') and p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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.375') and p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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.375') and p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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.375') and p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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.375') and p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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.375') and p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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.38') and p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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.38') and p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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.38') and p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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.38') and p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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.38') and p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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.38') and p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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.38') and p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 = '.43') and p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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.6') and p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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.925') and p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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.925') and p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 = 'Empotrado') and p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 = 'Empotrado') and p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 = 'Empotrado') and p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 = 'Empotrado') and p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 = 'Empotrado') and p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 = 'Empotrado') and p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 = 'Empotrado') and p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 = 'Empotrado') and p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 = 'Empotrado') and p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 = 'Empotrado') and p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 = 'Empotrado') and p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 = 'Recesado') and p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '109' and ptpef2.products_extra_fields_value = '10') and p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '109' and ptpef2.products_extra_fields_value = '10') and p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '109' and ptpef2.products_extra_fields_value = '10') and p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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\" (88.9mm)') and p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 = '8\" (203mm)') and p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '123' and ptpef2.products_extra_fields_value = 'L') and p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '123' and ptpef2.products_extra_fields_value = 'L') and p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '123' and ptpef2.products_extra_fields_value = 'Z') and p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 = '5 - 24 VDC') and p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 = '100 VDC') and p.manufacturers_id = 4947 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 p.manufacturers_id = 4947 and (p.products_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
Flair Electronics
Precio
Acabado
Acero Inoxidable
Aluminio
Ambiente
Exterior
Interior
Calibre de Alambre (Awg)
22
Candela
177
Circuito
cerrado
DPDT
N/C
N/O
NO
NO/NC
SPDT
Color
Blanco
Gris
Marrón
Natural
Negro
Conectividad
Cableado
Inalámbrico
Wired
Corriente (A)
0.05
0.5
3
Diámetro (In)
0.375
0.38
0.4
.43
0.6
0.75
0.925
1
Instalación
Empotrado
Recesado
Superficial
Superficie
Potencia de Consumo (W)
10
Separación (In)
1" (25mm)
1/2" (12.5mm)
1.5" (38mm)
2" (51mm)
3" (76mm)
3/4" (19mm)
3/4″ (19mm)
3/5" (15.24mm)
3.5" (88.9mm)
8" (203mm)
Soporte
L
Z
Tipo de Trabajo
Pesado
Regular
Voltaje de Operación
5 - 24 VDC
30 VDC
100 VDC
130 VDC
  103 artículos |
◀ 1 2 3 4 5 ▶ ▶ |
| 103 artículos | ◀ 1 2 3 4 5 ▶ ▶ |