English
SpanishLanguage:
EnglishEspañol
Need help? Reach us at 1800.325.9708
Live Support
Elk Products
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '37' and ptpef2.products_extra_fields_value = '5') and p.manufacturers_id = 11 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '37' and ptpef2.products_extra_fields_value = '8') and p.manufacturers_id = 11 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '37' and ptpef2.products_extra_fields_value = '12') and p.manufacturers_id = 11 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '37' and ptpef2.products_extra_fields_value = '18') and p.manufacturers_id = 11 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '52' and ptpef2.products_extra_fields_value = '1') and p.manufacturers_id = 11 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '2' and ptpef2.products_extra_fields_value = 'Verizon') and p.manufacturers_id = 11 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '13' and ptpef2.products_extra_fields_value = 'Black') and p.manufacturers_id = 11 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '13' and ptpef2.products_extra_fields_value = 'Black') and p.manufacturers_id = 11 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '13' and ptpef2.products_extra_fields_value = 'Blue') and p.manufacturers_id = 11 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '13' and ptpef2.products_extra_fields_value = 'Brown') and p.manufacturers_id = 11 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '13' and ptpef2.products_extra_fields_value = 'Brown') and p.manufacturers_id = 11 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '13' and ptpef2.products_extra_fields_value = 'Brown') and p.manufacturers_id = 11 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '13' and ptpef2.products_extra_fields_value = 'White') and p.manufacturers_id = 11 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '13' and ptpef2.products_extra_fields_value = 'White') and p.manufacturers_id = 11 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '13' and ptpef2.products_extra_fields_value = 'White') and p.manufacturers_id = 11 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '13' and ptpef2.products_extra_fields_value = 'White') and p.manufacturers_id = 11 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '13' and ptpef2.products_extra_fields_value = 'White') and p.manufacturers_id = 11 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '13' and ptpef2.products_extra_fields_value = 'White') and p.manufacturers_id = 11 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '13' and ptpef2.products_extra_fields_value = 'White') and p.manufacturers_id = 11 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '13' and ptpef2.products_extra_fields_value = 'White') and p.manufacturers_id = 11 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '13' and ptpef2.products_extra_fields_value = 'White') and p.manufacturers_id = 11 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '13' and ptpef2.products_extra_fields_value = 'White') and p.manufacturers_id = 11 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '13' and ptpef2.products_extra_fields_value = 'White') and p.manufacturers_id = 11 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '13' and ptpef2.products_extra_fields_value = 'White') and p.manufacturers_id = 11 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '13' and ptpef2.products_extra_fields_value = 'White') and p.manufacturers_id = 11 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '13' and ptpef2.products_extra_fields_value = 'White') and p.manufacturers_id = 11 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '13' and ptpef2.products_extra_fields_value = 'White') and p.manufacturers_id = 11 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '13' and ptpef2.products_extra_fields_value = 'White') and p.manufacturers_id = 11 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '13' and ptpef2.products_extra_fields_value = 'White') and p.manufacturers_id = 11 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '13' and ptpef2.products_extra_fields_value = 'White') and p.manufacturers_id = 11 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '13' and ptpef2.products_extra_fields_value = 'White') and p.manufacturers_id = 11 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '13' and ptpef2.products_extra_fields_value = 'White') and p.manufacturers_id = 11 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '13' and ptpef2.products_extra_fields_value = 'White') and p.manufacturers_id = 11 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '13' and ptpef2.products_extra_fields_value = 'White') and p.manufacturers_id = 11 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '13' and ptpef2.products_extra_fields_value = 'White') and p.manufacturers_id = 11 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '13' and ptpef2.products_extra_fields_value = 'White') and p.manufacturers_id = 11 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '13' and ptpef2.products_extra_fields_value = 'White') and p.manufacturers_id = 11 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '13' and ptpef2.products_extra_fields_value = 'White') and p.manufacturers_id = 11 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '13' and ptpef2.products_extra_fields_value = 'White') and p.manufacturers_id = 11 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '13' and ptpef2.products_extra_fields_value = 'White') and p.manufacturers_id = 11 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '13' and ptpef2.products_extra_fields_value = 'White') and p.manufacturers_id = 11 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '13' and ptpef2.products_extra_fields_value = 'White') and p.manufacturers_id = 11 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '13' and ptpef2.products_extra_fields_value = 'White') and p.manufacturers_id = 11 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '13' and ptpef2.products_extra_fields_value = 'White') and p.manufacturers_id = 11 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '13' and ptpef2.products_extra_fields_value = 'Yellow') and p.manufacturers_id = 11 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '1' and ptpef2.products_extra_fields_value = 'Ethernet / WiFi / Z-Wave') and p.manufacturers_id = 11 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '1' and ptpef2.products_extra_fields_value = 'LTE / IP') and p.manufacturers_id = 11 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '1' and ptpef2.products_extra_fields_value = 'Wired') and p.manufacturers_id = 11 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '1' and ptpef2.products_extra_fields_value = 'Wired') and p.manufacturers_id = 11 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '1' and ptpef2.products_extra_fields_value = 'Wired') and p.manufacturers_id = 11 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '1' and ptpef2.products_extra_fields_value = 'Wired') and p.manufacturers_id = 11 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '1' and ptpef2.products_extra_fields_value = 'Wired') and p.manufacturers_id = 11 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '1' and ptpef2.products_extra_fields_value = 'Wired') and p.manufacturers_id = 11 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '1' and ptpef2.products_extra_fields_value = 'Wired') and p.manufacturers_id = 11 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '1' and ptpef2.products_extra_fields_value = 'Wired') and p.manufacturers_id = 11 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '1' and ptpef2.products_extra_fields_value = 'Wired') and p.manufacturers_id = 11 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '1' and ptpef2.products_extra_fields_value = 'Wired') and p.manufacturers_id = 11 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '1' and ptpef2.products_extra_fields_value = 'Wired') and p.manufacturers_id = 11 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '1' and ptpef2.products_extra_fields_value = 'Wired') and p.manufacturers_id = 11 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '1' and ptpef2.products_extra_fields_value = 'Wired') and p.manufacturers_id = 11 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '1' and ptpef2.products_extra_fields_value = 'Wired') and p.manufacturers_id = 11 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '1' and ptpef2.products_extra_fields_value = 'Wired') and p.manufacturers_id = 11 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '1' and ptpef2.products_extra_fields_value = 'Wired') and p.manufacturers_id = 11 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '1' and ptpef2.products_extra_fields_value = 'Wired') and p.manufacturers_id = 11 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '1' and ptpef2.products_extra_fields_value = 'Wired') and p.manufacturers_id = 11 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '1' and ptpef2.products_extra_fields_value = 'Wired') and p.manufacturers_id = 11 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '1' and ptpef2.products_extra_fields_value = 'Wireless') and p.manufacturers_id = 11 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '1' and ptpef2.products_extra_fields_value = 'Wireless') and p.manufacturers_id = 11 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '1' and ptpef2.products_extra_fields_value = 'Wireless') and p.manufacturers_id = 11 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '1' and ptpef2.products_extra_fields_value = 'Wireless') and p.manufacturers_id = 11 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '1' and ptpef2.products_extra_fields_value = 'Wireless') and p.manufacturers_id = 11 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '30' and ptpef2.products_extra_fields_value = '1') and p.manufacturers_id = 11 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '30' and ptpef2.products_extra_fields_value = '1.2') and p.manufacturers_id = 11 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '30' and ptpef2.products_extra_fields_value = '1.66') and p.manufacturers_id = 11 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '30' and ptpef2.products_extra_fields_value = '1.7') and p.manufacturers_id = 11 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '30' and ptpef2.products_extra_fields_value = '2') and p.manufacturers_id = 11 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '30' and ptpef2.products_extra_fields_value = '2.6') and p.manufacturers_id = 11 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '30' and ptpef2.products_extra_fields_value = '2.7') and p.manufacturers_id = 11 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '30' and ptpef2.products_extra_fields_value = '4') and p.manufacturers_id = 11 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '30' and ptpef2.products_extra_fields_value = '800 mA') and p.manufacturers_id = 11 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '22' and ptpef2.products_extra_fields_value = '0.75') and p.manufacturers_id = 11 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '22' and ptpef2.products_extra_fields_value = '0.75') and p.manufacturers_id = 11 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '22' and ptpef2.products_extra_fields_value = '2.29') and p.manufacturers_id = 11 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '22' and ptpef2.products_extra_fields_value = '2.95') and p.manufacturers_id = 11 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '22' and ptpef2.products_extra_fields_value = '4.63') and p.manufacturers_id = 11 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '22' and ptpef2.products_extra_fields_value = '5.25') and p.manufacturers_id = 11 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '22' and ptpef2.products_extra_fields_value = '5.6') and p.manufacturers_id = 11 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '20' and ptpef2.products_extra_fields_value = 'Indoor') and p.manufacturers_id = 11 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '20' and ptpef2.products_extra_fields_value = 'Indoor') and p.manufacturers_id = 11 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '20' and ptpef2.products_extra_fields_value = 'Indoor') and p.manufacturers_id = 11 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '20' and ptpef2.products_extra_fields_value = 'Indoor') and p.manufacturers_id = 11 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '20' and ptpef2.products_extra_fields_value = 'Indoor') and p.manufacturers_id = 11 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '20' and ptpef2.products_extra_fields_value = 'Indoor') and p.manufacturers_id = 11 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '20' and ptpef2.products_extra_fields_value = 'Indoor') and p.manufacturers_id = 11 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '20' and ptpef2.products_extra_fields_value = 'Indoor') and p.manufacturers_id = 11 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '20' and ptpef2.products_extra_fields_value = 'Indoor') and p.manufacturers_id = 11 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '20' and ptpef2.products_extra_fields_value = 'Indoor') and p.manufacturers_id = 11 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '20' and ptpef2.products_extra_fields_value = 'Indoor') and p.manufacturers_id = 11 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '20' and ptpef2.products_extra_fields_value = 'Indoor') and p.manufacturers_id = 11 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '20' and ptpef2.products_extra_fields_value = 'Indoor') and p.manufacturers_id = 11 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '20' and ptpef2.products_extra_fields_value = 'Indoor') and p.manufacturers_id = 11 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '20' and ptpef2.products_extra_fields_value = 'Indoor') and p.manufacturers_id = 11 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '20' and ptpef2.products_extra_fields_value = 'Indoor') and p.manufacturers_id = 11 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '20' and ptpef2.products_extra_fields_value = 'Indoor') and p.manufacturers_id = 11 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '20' and ptpef2.products_extra_fields_value = 'Indoor') and p.manufacturers_id = 11 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '20' and ptpef2.products_extra_fields_value = 'Indoor') and p.manufacturers_id = 11 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '20' and ptpef2.products_extra_fields_value = 'Outdoor') and p.manufacturers_id = 11 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '20' and ptpef2.products_extra_fields_value = 'Outdoor') and p.manufacturers_id = 11 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '20' and ptpef2.products_extra_fields_value = 'Outdoor') and p.manufacturers_id = 11 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '20' and ptpef2.products_extra_fields_value = 'Outdoor') and p.manufacturers_id = 11 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '20' and ptpef2.products_extra_fields_value = 'Outdoor') and p.manufacturers_id = 11 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '3' and ptpef2.products_extra_fields_value = 'CCTV') and p.manufacturers_id = 11 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '3' and ptpef2.products_extra_fields_value = 'Elk Echo') and p.manufacturers_id = 11 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '3' and ptpef2.products_extra_fields_value = 'Universal') and p.manufacturers_id = 11 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '3' and ptpef2.products_extra_fields_value = 'Universal') and p.manufacturers_id = 11 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '25' and ptpef2.products_extra_fields_value = 'Stainless Steel') and p.manufacturers_id = 11 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '55' and ptpef2.products_extra_fields_value = '1/2\" (12.5mm)') and p.manufacturers_id = 11 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '55' and ptpef2.products_extra_fields_value = '3/4\" (19mm)') and p.manufacturers_id = 11 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '57' and ptpef2.products_extra_fields_value = 'RoR 135 °F (57 °C)') and p.manufacturers_id = 11 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '57' and ptpef2.products_extra_fields_value = 'RoR 135 °F (57 °C)') and p.manufacturers_id = 11 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '45' and ptpef2.products_extra_fields_value = '8') and p.manufacturers_id = 11 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '45' and ptpef2.products_extra_fields_value = '8') and p.manufacturers_id = 11 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '45' and ptpef2.products_extra_fields_value = '8') and p.manufacturers_id = 11 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '51' and ptpef2.products_extra_fields_value = '1') and p.manufacturers_id = 11 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '51' and ptpef2.products_extra_fields_value = '3') and p.manufacturers_id = 11 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '51' and ptpef2.products_extra_fields_value = '3') and p.manufacturers_id = 11 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '51' and ptpef2.products_extra_fields_value = '16') and p.manufacturers_id = 11 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '11' and ptpef2.products_extra_fields_value = 'Ceiling') and p.manufacturers_id = 11 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '11' and ptpef2.products_extra_fields_value = 'Flush') and p.manufacturers_id = 11 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '11' and ptpef2.products_extra_fields_value = 'Recessed') and p.manufacturers_id = 11 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '11' and ptpef2.products_extra_fields_value = 'Surface Mount') and p.manufacturers_id = 11 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '11' and ptpef2.products_extra_fields_value = 'Wall') and p.manufacturers_id = 11 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '11' and ptpef2.products_extra_fields_value = 'Wall') and p.manufacturers_id = 11 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '49' and ptpef2.products_extra_fields_value = 'LCD') and p.manufacturers_id = 11 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '49' and ptpef2.products_extra_fields_value = 'LCD') and p.manufacturers_id = 11 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '49' and ptpef2.products_extra_fields_value = 'LCD') and p.manufacturers_id = 11 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '49' and ptpef2.products_extra_fields_value = 'LCD') and p.manufacturers_id = 11 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '49' and ptpef2.products_extra_fields_value = 'LCD') and p.manufacturers_id = 11 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '49' and ptpef2.products_extra_fields_value = 'Touch') and p.manufacturers_id = 11 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '49' and ptpef2.products_extra_fields_value = 'Touch') and p.manufacturers_id = 11 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '32' and ptpef2.products_extra_fields_value = '10 W') and p.manufacturers_id = 11 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '32' and ptpef2.products_extra_fields_value = '40 VA') and p.manufacturers_id = 11 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '32' and ptpef2.products_extra_fields_value = '45 VA') and p.manufacturers_id = 11 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '70' and ptpef2.products_extra_fields_value = '18') and p.manufacturers_id = 11 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '8' and ptpef2.products_extra_fields_value = 'Battery') and p.manufacturers_id = 11 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '8' and ptpef2.products_extra_fields_value = 'Battery') and p.manufacturers_id = 11 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '8' and ptpef2.products_extra_fields_value = 'Battery') and p.manufacturers_id = 11 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '8' and ptpef2.products_extra_fields_value = 'Battery') and p.manufacturers_id = 11 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '8' and ptpef2.products_extra_fields_value = 'Battery') and p.manufacturers_id = 11 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '8' and ptpef2.products_extra_fields_value = 'Battery') and p.manufacturers_id = 11 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '8' and ptpef2.products_extra_fields_value = 'Battery') and p.manufacturers_id = 11 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '8' and ptpef2.products_extra_fields_value = 'Battery') and p.manufacturers_id = 11 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '8' and ptpef2.products_extra_fields_value = 'Battery') and p.manufacturers_id = 11 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '8' and ptpef2.products_extra_fields_value = 'Battery') and p.manufacturers_id = 11 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '8' and ptpef2.products_extra_fields_value = 'Battery') and p.manufacturers_id = 11 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '8' and ptpef2.products_extra_fields_value = 'Battery') and p.manufacturers_id = 11 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '8' and ptpef2.products_extra_fields_value = 'Battery') and p.manufacturers_id = 11 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '8' and ptpef2.products_extra_fields_value = 'Battery') and p.manufacturers_id = 11 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '8' and ptpef2.products_extra_fields_value = 'Battery') and p.manufacturers_id = 11 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '8' and ptpef2.products_extra_fields_value = 'Bus') and p.manufacturers_id = 11 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '8' and ptpef2.products_extra_fields_value = 'Bus') and p.manufacturers_id = 11 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '8' and ptpef2.products_extra_fields_value = 'Bus') and p.manufacturers_id = 11 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '8' and ptpef2.products_extra_fields_value = '3 VDC') and p.manufacturers_id = 11 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '8' and ptpef2.products_extra_fields_value = '6 - 14 VDC') and p.manufacturers_id = 11 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '8' and ptpef2.products_extra_fields_value = '6 - 14 VDC') and p.manufacturers_id = 11 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '8' and ptpef2.products_extra_fields_value = '6 / 12 VDC') and p.manufacturers_id = 11 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '8' and ptpef2.products_extra_fields_value = '10 - 14 VDC') and p.manufacturers_id = 11 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '8' and ptpef2.products_extra_fields_value = '10 - 14 VDC') and p.manufacturers_id = 11 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '8' and ptpef2.products_extra_fields_value = '11 -14 VDC') and p.manufacturers_id = 11 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '8' and ptpef2.products_extra_fields_value = '11 -14 VDC') and p.manufacturers_id = 11 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '8' and ptpef2.products_extra_fields_value = '12 - 18 VAC / VDC') and p.manufacturers_id = 11 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '8' and ptpef2.products_extra_fields_value = '12 / 16.5 / 24 VAC') and p.manufacturers_id = 11 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '8' and ptpef2.products_extra_fields_value = '12 / 24 VDC') and p.manufacturers_id = 11 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '8' and ptpef2.products_extra_fields_value = '12 / 24 VDC') and p.manufacturers_id = 11 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '8' and ptpef2.products_extra_fields_value = '12 / 24 VDC') and p.manufacturers_id = 11 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '8' and ptpef2.products_extra_fields_value = '12 / 24 VDC') and p.manufacturers_id = 11 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '8' and ptpef2.products_extra_fields_value = '12 VDC') and p.manufacturers_id = 11 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '8' and ptpef2.products_extra_fields_value = '12 VDC') and p.manufacturers_id = 11 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '8' and ptpef2.products_extra_fields_value = '12 VDC') and p.manufacturers_id = 11 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '8' and ptpef2.products_extra_fields_value = '12 VDC') and p.manufacturers_id = 11 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '8' and ptpef2.products_extra_fields_value = '12 VDC') and p.manufacturers_id = 11 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '8' and ptpef2.products_extra_fields_value = '12 VDC') and p.manufacturers_id = 11 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '8' and ptpef2.products_extra_fields_value = '12 VDC') and p.manufacturers_id = 11 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '8' and ptpef2.products_extra_fields_value = '12 VDC') and p.manufacturers_id = 11 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '8' and ptpef2.products_extra_fields_value = '13.8 VDC') and p.manufacturers_id = 11 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '8' and ptpef2.products_extra_fields_value = '13.8 VDC') and p.manufacturers_id = 11 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '8' and ptpef2.products_extra_fields_value = '13.8 VDC') and p.manufacturers_id = 11 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '8' and ptpef2.products_extra_fields_value = '13.8 VDC') and p.manufacturers_id = 11 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '8' and ptpef2.products_extra_fields_value = '14 VDC') and p.manufacturers_id = 11 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '8' and ptpef2.products_extra_fields_value = '14 VDC') and p.manufacturers_id = 11 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '8' and ptpef2.products_extra_fields_value = '16.5 VAC') and p.manufacturers_id = 11 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '8' and ptpef2.products_extra_fields_value = '16.5 VAC') and p.manufacturers_id = 11 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '8' and ptpef2.products_extra_fields_value = '85 - 264 VAC') and p.manufacturers_id = 11 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '8' and ptpef2.products_extra_fields_value = '100 - 240 VAC') and p.manufacturers_id = 11 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '8' and ptpef2.products_extra_fields_value = '120 VAC') and p.manufacturers_id = 11 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '8' and ptpef2.products_extra_fields_value = '120 VAC') and p.manufacturers_id = 11 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '29' and ptpef2.products_extra_fields_value = '6 / 12 / 24 VDC') and p.manufacturers_id = 11 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '29' and ptpef2.products_extra_fields_value = '12 VDC') and p.manufacturers_id = 11 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '29' and ptpef2.products_extra_fields_value = '12 VDC') and p.manufacturers_id = 11 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '29' and ptpef2.products_extra_fields_value = '12 VDC') and p.manufacturers_id = 11 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '29' and ptpef2.products_extra_fields_value = '12 VDC') and p.manufacturers_id = 11 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '29' and ptpef2.products_extra_fields_value = '12 VDC') and p.manufacturers_id = 11 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '29' and ptpef2.products_extra_fields_value = '12 VDC') and p.manufacturers_id = 11 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '29' and ptpef2.products_extra_fields_value = '13.8 VDC') and p.manufacturers_id = 11 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '29' and ptpef2.products_extra_fields_value = '13.8 VDC') and p.manufacturers_id = 11 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '29' and ptpef2.products_extra_fields_value = '14 VDC') and p.manufacturers_id = 11 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '29' and ptpef2.products_extra_fields_value = '16.5 VAC') and p.manufacturers_id = 11 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '29' and ptpef2.products_extra_fields_value = '24 VAC') and p.manufacturers_id = 11 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '28' and ptpef2.products_extra_fields_value = '1') and p.manufacturers_id = 11 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '28' and ptpef2.products_extra_fields_value = '3') and p.manufacturers_id = 11 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '46' and ptpef2.products_extra_fields_value = 'Yes') and p.manufacturers_id = 11 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '31' and ptpef2.products_extra_fields_value = 'PTC') and p.manufacturers_id = 11 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '33' and ptpef2.products_extra_fields_value = '85 dBA') and p.manufacturers_id = 11 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '33' and ptpef2.products_extra_fields_value = '100') and p.manufacturers_id = 11 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '33' and ptpef2.products_extra_fields_value = '108') and p.manufacturers_id = 11 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '33' and ptpef2.products_extra_fields_value = '115') and p.manufacturers_id = 11 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '33' and ptpef2.products_extra_fields_value = '118') and p.manufacturers_id = 11 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '33' and ptpef2.products_extra_fields_value = '120') and p.manufacturers_id = 11 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '33' and ptpef2.products_extra_fields_value = '122') and p.manufacturers_id = 11 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '33' and ptpef2.products_extra_fields_value = '122') and p.manufacturers_id = 11 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '4' and ptpef2.products_extra_fields_value = 'SLA') and p.manufacturers_id = 11 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '4' and ptpef2.products_extra_fields_value = 'SLA') and p.manufacturers_id = 11 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '4' and ptpef2.products_extra_fields_value = 'SLA') and p.manufacturers_id = 11 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '14' and ptpef2.products_extra_fields_value = '2.4 GHz') and p.manufacturers_id = 11 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '14' and ptpef2.products_extra_fields_value = '319.5 MHz') and p.manufacturers_id = 11 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '14' and ptpef2.products_extra_fields_value = '319.5 MHz') and p.manufacturers_id = 11 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '14' and ptpef2.products_extra_fields_value = '319.5 MHz') and p.manufacturers_id = 11 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '14' and ptpef2.products_extra_fields_value = '319.5 MHz') and p.manufacturers_id = 11 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '14' and ptpef2.products_extra_fields_value = '319.5 MHz') and p.manufacturers_id = 11 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '14' and ptpef2.products_extra_fields_value = '319.5 MHz') and p.manufacturers_id = 11 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '14' and ptpef2.products_extra_fields_value = '319.5 MHz') and p.manufacturers_id = 11 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '14' and ptpef2.products_extra_fields_value = '319.5 MHz') and p.manufacturers_id = 11 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '14' and ptpef2.products_extra_fields_value = '319.5 MHz') and p.manufacturers_id = 11 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '14' and ptpef2.products_extra_fields_value = '319.5 MHz') and p.manufacturers_id = 11 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '14' and ptpef2.products_extra_fields_value = '319.5 MHz') and p.manufacturers_id = 11 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '14' and ptpef2.products_extra_fields_value = '319.5 MHz') and p.manufacturers_id = 11 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '14' and ptpef2.products_extra_fields_value = '319.5 MHz') and p.manufacturers_id = 11 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '14' and ptpef2.products_extra_fields_value = '345 MHz') and p.manufacturers_id = 11 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '14' and ptpef2.products_extra_fields_value = '800 / 1900 MHz') and p.manufacturers_id = 11 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '14' and ptpef2.products_extra_fields_value = '902 - 928 MHz') and p.manufacturers_id = 11 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '14' and ptpef2.products_extra_fields_value = '902 - 928 MHz') and p.manufacturers_id = 11 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '14' and ptpef2.products_extra_fields_value = '902 - 928 MHz') and p.manufacturers_id = 11 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '14' and ptpef2.products_extra_fields_value = '902 - 928 MHz') and p.manufacturers_id = 11 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '14' and ptpef2.products_extra_fields_value = '902 - 928 MHz') and p.manufacturers_id = 11 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '14' and ptpef2.products_extra_fields_value = '902 - 928 MHz') and p.manufacturers_id = 11 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '72' and ptpef2.products_extra_fields_value = '199') and p.manufacturers_id = 11 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '72' and ptpef2.products_extra_fields_value = '199') and p.manufacturers_id = 11 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '41' and ptpef2.products_extra_fields_value = '22 - 26') and p.manufacturers_id = 11 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '41' and ptpef2.products_extra_fields_value = '22 - 26') and p.manufacturers_id = 11 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '48' and ptpef2.products_extra_fields_value = '16') and p.manufacturers_id = 11 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '48' and ptpef2.products_extra_fields_value = '16') and p.manufacturers_id = 11 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '48' and ptpef2.products_extra_fields_value = '16') and p.manufacturers_id = 11 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '48' and ptpef2.products_extra_fields_value = '16') and p.manufacturers_id = 11 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '48' and ptpef2.products_extra_fields_value = '16') and p.manufacturers_id = 11 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '48' and ptpef2.products_extra_fields_value = '16') and p.manufacturers_id = 11 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '48' and ptpef2.products_extra_fields_value = '144') and p.manufacturers_id = 11 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '48' and ptpef2.products_extra_fields_value = '144') and p.manufacturers_id = 11 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '48' and ptpef2.products_extra_fields_value = '208') and p.manufacturers_id = 11 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
Category
Brand
Elk Products
Price
Battery Capacity (Ah)
5
8
12
18
Buttons
1
Cellular Provider
Verizon
Color
Black
Blue
Brown
White
Yellow
Connectivity
Ethernet / WiFi / Z-Wave
LTE / IP
Wired
Wireless
Current (A)
1
1.2
1.66
1.7
2
2.6
2.7
4
800 mA
Diameter (In)
0.75
2.29
2.95
4.63
5.25
5.6
Environment
Indoor
Outdoor
Family
CCTV
Elk Echo
Universal
Finish
Stainless Steel
Gap (In)
1/2" (12.5mm)
3/4" (19mm)
Heat Detection Type
RoR 135 °F (57 °C)
Impedance (Ohms)
8
Inputs
1
3
16
Installation
Ceiling
Flush
Recessed
Surface Mount
Wall
Keypad
LCD
Touch
Max Output Power (VA / W)
10 W
40 VA
45 VA
Maximum Power Per Port (W)
18
Operating Voltage
Battery
Bus
3 VDC
6 - 14 VDC
6 / 12 VDC
10 - 14 VDC
11 -14 VDC
12 - 18 VAC / VDC
12 / 16.5 / 24 VAC
12 / 24 VDC
12 VDC
13.8 VDC
14 VDC
16.5 VAC
85 - 264 VAC
100 - 240 VAC
120 VAC
Output Voltage
6 / 12 / 24 VDC
12 VDC
13.8 VDC
14 VDC
16.5 VAC
24 VAC
Outputs
1
3
Pet Immune
Yes
Protection
PTC
Sound Output (dB)
85 dBA
100
108
115
118
120
122
Technology
SLA
Transmission Band
2.4 GHz
319.5 MHz
345 MHz
800 / 1900 MHz
902 - 928 MHz
User Capacity
199
Wire (Awg)
22 - 26
Zones
16
144
208
from ( products p left join specials s on (s.products_id = p.products_id and s.status = 1)) left join manufacturers m on p.manufacturers_id = m.manufacturers_id left join products_to_products_extra_fields p2pef on p.products_id = p2pef.products_id , products_description pd, categories c, products_to_categories p2c
where (p.products_status = 1) and p.products_id = pd.products_id and pd.language_id = '1' and p.products_id = p2c.products_id and p2c.categories_id = c.categories_id and m.manufacturers_id = '11' and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
group by p.products_id order by p.products_sort_order, p.products_date_available desc, p.products_last_views desc, pd.products_name
Kewords:
Plural keywords:
  129 items |
◀ 1 2 3 4 5 6 |
| 129 items | ◀ 1 2 3 4 5 6 |