English
SpanishLanguage:
EnglishEspañol
Need help? Reach us at 1800.325.9708
Live Support
Panels
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '26' and ptpef2.products_extra_fields_value = '2-Way') and ptc.categories_id = 62 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '26' and ptpef2.products_extra_fields_value = '2-Way') and ptc.categories_id = 62 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '26' and ptpef2.products_extra_fields_value = '2-Way') and ptc.categories_id = 62 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 = 'AT&T') and ptc.categories_id = 62 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 = 'AT&T') and ptc.categories_id = 62 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 = 'AT&T') and ptc.categories_id = 62 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 = 'AT&T') and ptc.categories_id = 62 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 = 'AT&T') and ptc.categories_id = 62 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 = 'AT&T') and ptc.categories_id = 62 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 = 'AT&T') and ptc.categories_id = 62 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 = 'AT&T') and ptc.categories_id = 62 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 ptc.categories_id = 62 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 ptc.categories_id = 62 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 ptc.categories_id = 62 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 ptc.categories_id = 62 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 ptc.categories_id = 62 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 ptc.categories_id = 62 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 ptc.categories_id = 62 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 ptc.categories_id = 62 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 ptc.categories_id = 62 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 ptc.categories_id = 62 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 ptc.categories_id = 62 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 ptc.categories_id = 62 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 ptc.categories_id = 62 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 ptc.categories_id = 62 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 ptc.categories_id = 62 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 ptc.categories_id = 62 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 ptc.categories_id = 62 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 ptc.categories_id = 62 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 ptc.categories_id = 62 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 ptc.categories_id = 62 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 ptc.categories_id = 62 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 ptc.categories_id = 62 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 ptc.categories_id = 62 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 ptc.categories_id = 62 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 ptc.categories_id = 62 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 ptc.categories_id = 62 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 ptc.categories_id = 62 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 ptc.categories_id = 62 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 ptc.categories_id = 62 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 ptc.categories_id = 62 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 ptc.categories_id = 62 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 ptc.categories_id = 62 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 ptc.categories_id = 62 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 = 'Bluetooth® / WiFi / Z-Wave') and ptc.categories_id = 62 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 ptc.categories_id = 62 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 = 'Hybrid') and ptc.categories_id = 62 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 = 'Hybrid') and ptc.categories_id = 62 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 = 'Hybrid') and ptc.categories_id = 62 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 = 'Hybrid') and ptc.categories_id = 62 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 = 'Hybrid') and ptc.categories_id = 62 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 = 'Hybrid') and ptc.categories_id = 62 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 = 'Hybrid') and ptc.categories_id = 62 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 = 'Hybrid') and ptc.categories_id = 62 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 = 'Hybrid') and ptc.categories_id = 62 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 = 'Hybrid') and ptc.categories_id = 62 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 = 'Hybrid') and ptc.categories_id = 62 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 = 'Hybrid') and ptc.categories_id = 62 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 = 'Hybrid') and ptc.categories_id = 62 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 = 'Hybrid') and ptc.categories_id = 62 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 = 'Hybrid') and ptc.categories_id = 62 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 = 'Hybrid') and ptc.categories_id = 62 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 = 'Hybrid') and ptc.categories_id = 62 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 = 'Hybrid') and ptc.categories_id = 62 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 = 'Hybrid') and ptc.categories_id = 62 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 = 'Hybrid') and ptc.categories_id = 62 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 = 'Hybrid') and ptc.categories_id = 62 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 = 'Hybrid') and ptc.categories_id = 62 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 = 'Hybrid') and ptc.categories_id = 62 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 = 'Hybrid') and ptc.categories_id = 62 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 = 'Hybrid') and ptc.categories_id = 62 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 = 'Hybrid') and ptc.categories_id = 62 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 = 'Hybrid') and ptc.categories_id = 62 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 = 'Hybrid') and ptc.categories_id = 62 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 = 'Hybrid') and ptc.categories_id = 62 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 = 'Hybrid') and ptc.categories_id = 62 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 = 'Hybrid') and ptc.categories_id = 62 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 = 'Hybrid') and ptc.categories_id = 62 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 = 'Hybrid') and ptc.categories_id = 62 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 = 'Hybrid') and ptc.categories_id = 62 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 = 'Hybrid') and ptc.categories_id = 62 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 = 'Hybrid') and ptc.categories_id = 62 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 = 'Hybrid') and ptc.categories_id = 62 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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') and ptc.categories_id = 62 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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') and ptc.categories_id = 62 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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') and ptc.categories_id = 62 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 / WiFi') and ptc.categories_id = 62 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 / WiFi') and ptc.categories_id = 62 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 / WiFi') and ptc.categories_id = 62 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 / WiFi') and ptc.categories_id = 62 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 / WiFi') and ptc.categories_id = 62 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 / WiFi') and ptc.categories_id = 62 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 ptc.categories_id = 62 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 ptc.categories_id = 62 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 ptc.categories_id = 62 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 ptc.categories_id = 62 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 ptc.categories_id = 62 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 ptc.categories_id = 62 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 ptc.categories_id = 62 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 ptc.categories_id = 62 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 = 'Connect+') and ptc.categories_id = 62 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 = 'Connect+') and ptc.categories_id = 62 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 = 'Connect+') and ptc.categories_id = 62 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 = 'Edge') and ptc.categories_id = 62 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 = 'Edge') and ptc.categories_id = 62 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 = 'IQ Pro') and ptc.categories_id = 62 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 = 'IQ4') and ptc.categories_id = 62 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 = 'IQ4') and ptc.categories_id = 62 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 = 'IQ4 Hub') and ptc.categories_id = 62 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 = 'IQ4 Hub') and ptc.categories_id = 62 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 = 'Maxsys') and ptc.categories_id = 62 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 = 'Maxsys') and ptc.categories_id = 62 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 = 'Maxsys') and ptc.categories_id = 62 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 = 'Neo') and ptc.categories_id = 62 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 = 'Neo') and ptc.categories_id = 62 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 = 'Neo') and ptc.categories_id = 62 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 = 'Neo') and ptc.categories_id = 62 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 = 'Neo') and ptc.categories_id = 62 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 = 'Neo') and ptc.categories_id = 62 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 = 'Neo') and ptc.categories_id = 62 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 = 'Neo') and ptc.categories_id = 62 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 = 'Neo') and ptc.categories_id = 62 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 = 'Neo') and ptc.categories_id = 62 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 = 'Neo') and ptc.categories_id = 62 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 = 'Neo') and ptc.categories_id = 62 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 = 'Neo') and ptc.categories_id = 62 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 = 'Neo') and ptc.categories_id = 62 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 = 'Neo Pro') and ptc.categories_id = 62 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 = 'Power Series') and ptc.categories_id = 62 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 = 'Power Series') and ptc.categories_id = 62 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 = 'Power Series') and ptc.categories_id = 62 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 = 'Power Series') and ptc.categories_id = 62 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 = 'Power Series') and ptc.categories_id = 62 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 = 'Power Series') and ptc.categories_id = 62 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 = 'Power Series') and ptc.categories_id = 62 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 = 'Power Series') and ptc.categories_id = 62 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 = 'Power Series') and ptc.categories_id = 62 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 = 'Power Series') and ptc.categories_id = 62 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 = 'Power Series') and ptc.categories_id = 62 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 = 'Power Series') and ptc.categories_id = 62 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 = 'Power Series') and ptc.categories_id = 62 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 = 'Power Series') and ptc.categories_id = 62 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 = 'PowerSeries Pro') and ptc.categories_id = 62 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 = 'Vista') and ptc.categories_id = 62 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 = 'Vista') and ptc.categories_id = 62 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 = 'Vista') and ptc.categories_id = 62 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 = 'Vista') and ptc.categories_id = 62 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 = 'Vista') and ptc.categories_id = 62 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 = '7 VDC') and ptc.categories_id = 62 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 = '7 VDC') and ptc.categories_id = 62 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 = '7 VDC') and ptc.categories_id = 62 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 = '7 VDC') and ptc.categories_id = 62 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 = '7 VDC') and ptc.categories_id = 62 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 = '7 VDC') and ptc.categories_id = 62 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 = '7 VDC') and ptc.categories_id = 62 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 = '7 VDC') and ptc.categories_id = 62 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 ptc.categories_id = 62 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 ptc.categories_id = 62 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 VDC') and ptc.categories_id = 62 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 ptc.categories_id = 62 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 VDC') and ptc.categories_id = 62 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 VDC') and ptc.categories_id = 62 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 VDC') and ptc.categories_id = 62 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 VDC') and ptc.categories_id = 62 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 VDC') and ptc.categories_id = 62 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 VDC') and ptc.categories_id = 62 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 VDC') and ptc.categories_id = 62 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 VDC') and ptc.categories_id = 62 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 VDC') and ptc.categories_id = 62 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 VDC') and ptc.categories_id = 62 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 VDC') and ptc.categories_id = 62 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 VDC') and ptc.categories_id = 62 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 VDC') and ptc.categories_id = 62 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 VDC') and ptc.categories_id = 62 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 VDC') and ptc.categories_id = 62 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 VDC') and ptc.categories_id = 62 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 VDC') and ptc.categories_id = 62 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 VDC') and ptc.categories_id = 62 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 VDC') and ptc.categories_id = 62 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 VDC') and ptc.categories_id = 62 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 VDC') and ptc.categories_id = 62 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 VDC') and ptc.categories_id = 62 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 VDC') and ptc.categories_id = 62 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 VDC') and ptc.categories_id = 62 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 VDC') and ptc.categories_id = 62 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 VDC') and ptc.categories_id = 62 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 VDC') and ptc.categories_id = 62 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 VDC') and ptc.categories_id = 62 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 VDC') and ptc.categories_id = 62 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 ptc.categories_id = 62 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 ptc.categories_id = 62 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 ptc.categories_id = 62 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 ptc.categories_id = 62 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 ptc.categories_id = 62 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 ptc.categories_id = 62 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 ptc.categories_id = 62 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 VDC') and ptc.categories_id = 62 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 = '18 VDC') and ptc.categories_id = 62 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 ptc.categories_id = 62 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 ptc.categories_id = 62 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 ptc.categories_id = 62 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 ptc.categories_id = 62 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 ptc.categories_id = 62 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 ptc.categories_id = 62 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 / 240 VAC / BATTERY') and ptc.categories_id = 62 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 ptc.categories_id = 62 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 = '9 VDC') and ptc.categories_id = 62 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 ptc.categories_id = 62 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 ptc.categories_id = 62 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '15' and ptpef2.products_extra_fields_value = '1280 X 800') and ptc.categories_id = 62 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '15' and ptpef2.products_extra_fields_value = '1280 X 800') and ptc.categories_id = 62 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '15' and ptpef2.products_extra_fields_value = '1280 X 800') and ptc.categories_id = 62 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 = 'Z-Wave') and ptc.categories_id = 62 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 = 'Z-Wave') and ptc.categories_id = 62 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 = 'Z-Wave') and ptc.categories_id = 62 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 = 'Z-Wave') and ptc.categories_id = 62 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 = 'Z-Wave') and ptc.categories_id = 62 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 = 'Z-Wave Plus') and ptc.categories_id = 62 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 = 'Z-Wave Plus') and ptc.categories_id = 62 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 / Z Wave') and ptc.categories_id = 62 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 / Z Wave') and ptc.categories_id = 62 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 ptc.categories_id = 62 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 / 2.4 GHz / 5 GHz / Z Wave') and ptc.categories_id = 62 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 ptc.categories_id = 62 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 ptc.categories_id = 62 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 ptc.categories_id = 62 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 / 2.4 GHz / 5 GHz / Z Wave') and ptc.categories_id = 62 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 = '433 / 915 MHz') and ptc.categories_id = 62 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 = '433 MHz') and ptc.categories_id = 62 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 = '433 MHz') and ptc.categories_id = 62 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 = '433 MHz') and ptc.categories_id = 62 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 = '433 MHz') and ptc.categories_id = 62 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 = '433.92 MHz / 2.4 GHz') and ptc.categories_id = 62 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 = '433.92 MHz / 2.4 GHz') and ptc.categories_id = 62 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 = '433.92 MHz / 2.4 GHz') and ptc.categories_id = 62 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 = '912 - 919 MHz') and ptc.categories_id = 62 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 = '915 / 319 MHz') and ptc.categories_id = 62 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 = '915 / 319 MHz') and ptc.categories_id = 62 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 = '915 / 319 MHz') and ptc.categories_id = 62 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 = '915 MHz') and ptc.categories_id = 62 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 = '50') and ptc.categories_id = 62 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 ptc.categories_id = 62 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 ptc.categories_id = 62 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 = '6') and ptc.categories_id = 62 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 = '8') and ptc.categories_id = 62 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 = '8') and ptc.categories_id = 62 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 = '8') and ptc.categories_id = 62 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 = '8') and ptc.categories_id = 62 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 = '12') and ptc.categories_id = 62 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 ptc.categories_id = 62 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 ptc.categories_id = 62 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 ptc.categories_id = 62 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 ptc.categories_id = 62 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 ptc.categories_id = 62 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 ptc.categories_id = 62 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 = '32') and ptc.categories_id = 62 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 = '32') and ptc.categories_id = 62 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 = '32') and ptc.categories_id = 62 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 = '32') and ptc.categories_id = 62 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 = '32') and ptc.categories_id = 62 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 = '32') and ptc.categories_id = 62 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 = '32') and ptc.categories_id = 62 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 = '32') and ptc.categories_id = 62 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 = '32') and ptc.categories_id = 62 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 = '32') and ptc.categories_id = 62 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 = '32') and ptc.categories_id = 62 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 = '48') and ptc.categories_id = 62 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 = '48') and ptc.categories_id = 62 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 = '60') and ptc.categories_id = 62 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 = '64') and ptc.categories_id = 62 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 = '64') and ptc.categories_id = 62 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 = '64') and ptc.categories_id = 62 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 = '64') and ptc.categories_id = 62 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 = '64') and ptc.categories_id = 62 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 = '64') and ptc.categories_id = 62 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 = '64') and ptc.categories_id = 62 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 = '64') and ptc.categories_id = 62 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 = '96') and ptc.categories_id = 62 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 = '96') and ptc.categories_id = 62 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 = '96') and ptc.categories_id = 62 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 = '102') and ptc.categories_id = 62 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 = '102') and ptc.categories_id = 62 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 = '127') and ptc.categories_id = 62 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 = '128') and ptc.categories_id = 62 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 = '128') and ptc.categories_id = 62 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 = '128') and ptc.categories_id = 62 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 = '128') and ptc.categories_id = 62 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 = '128') and ptc.categories_id = 62 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 = '128') and ptc.categories_id = 62 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 = '128') and ptc.categories_id = 62 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 = '128') and ptc.categories_id = 62 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 = '128') and ptc.categories_id = 62 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 = '128') and ptc.categories_id = 62 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 = '248') and ptc.categories_id = 62 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 = '248') and ptc.categories_id = 62 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 = '250') and ptc.categories_id = 62 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 = '255') and ptc.categories_id = 62 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
Panels
Category
Brand
2gig
Alarm.com
Alula
CDVI
DSC
Elk Products
Honeywell Commercial Security
Napco
Qolsys
Resideo
Rokonet | Risco Group
Price
Audio
2-Way
Cellular Provider
AT&T
Verizon
Color
Black
White
Connectivity
Bluetooth® / WiFi / Z-Wave
Ethernet / WiFi / Z-Wave
Hybrid
LTE
LTE / WiFi
Wired
Wireless
Family
Connect+
Edge
IQ Pro
IQ4
IQ4 Hub
Maxsys
Neo
Neo Pro
Power Series
PowerSeries Pro
Vista
Operating Voltage
7 VDC
12 VDC
13 VDC
14 VDC
16 VDC
16.5 VAC
16.5 VDC
18 VDC
100 - 240 VAC
120 / 240 VAC / BATTERY
120 VAC
Output Voltage
9 VDC
12 VDC
Pet Immune
Yes
Resolution
1280 X 800
Technology
Z-Wave
Z-Wave Plus
Transmission Band
2.4 GHz / Z Wave
319.5 MHz
319.5 MHz / 2.4 GHz / 5 GHz / Z Wave
345 MHz
345 MHz / 2.4 GHz / 5 GHz / Z Wave
433 / 915 MHz
433 MHz
433.92 MHz / 2.4 GHz
912 - 919 MHz
915 / 319 MHz
915 MHz
User Capacity
50
199
Zones
6
8
12
16
32
48
60
64
96
102
127
128
248
250
255
