Language:
EnglishEspañol
Need help? Reach us at 1800.325.9708
Live Support
PoE
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '69' and ptpef2.products_extra_fields_value = 'IEEE 802.3af/at') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '69' and ptpef2.products_extra_fields_value = 'IEEE 802.3at') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '69' and ptpef2.products_extra_fields_value = 'IEEE 802.3at/af') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '69' and ptpef2.products_extra_fields_value = 'IEEE 802.3at/af') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '69' and ptpef2.products_extra_fields_value = 'IEEE 802.3at/af') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '69' and ptpef2.products_extra_fields_value = 'IEEE 802.3at/af') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '69' and ptpef2.products_extra_fields_value = 'IEEE 802.3at/af') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '69' and ptpef2.products_extra_fields_value = 'IEEE 802.3at/af') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '69' and ptpef2.products_extra_fields_value = 'IEEE 802.3at/af') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '69' and ptpef2.products_extra_fields_value = 'IEEE 802.3at/af') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '69' and ptpef2.products_extra_fields_value = 'IEEE 802.3at/af') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '69' and ptpef2.products_extra_fields_value = 'IEEE 802.3at/af') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '69' and ptpef2.products_extra_fields_value = 'IEEE 802.3at/af') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '69' and ptpef2.products_extra_fields_value = 'IEEE 802.3at/af') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '69' and ptpef2.products_extra_fields_value = 'IEEE 802.3at/af') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '69' and ptpef2.products_extra_fields_value = 'IEEE 802.3at/af') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '69' and ptpef2.products_extra_fields_value = 'IEEE 802.3at/af') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '69' and ptpef2.products_extra_fields_value = 'IEEE 802.3at/af') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '69' and ptpef2.products_extra_fields_value = 'IEEE 802.3at/af') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '69' and ptpef2.products_extra_fields_value = 'IEEE 802.3at/af') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '69' and ptpef2.products_extra_fields_value = 'IEEE 802.3at/af') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '69' and ptpef2.products_extra_fields_value = 'IEEE 802.3at/af') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '69' and ptpef2.products_extra_fields_value = 'IEEE 802.3at/af') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '69' and ptpef2.products_extra_fields_value = 'IEEE 802.3at/af') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '69' and ptpef2.products_extra_fields_value = 'IEEE 802.3at/af') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '69' and ptpef2.products_extra_fields_value = 'IEEE 802.3at/af') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '69' and ptpef2.products_extra_fields_value = 'IEEE 802.3at/af') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '69' and ptpef2.products_extra_fields_value = 'IEEE 802.3at/af') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '69' and ptpef2.products_extra_fields_value = 'IEEE 802.3at/af') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '69' and ptpef2.products_extra_fields_value = 'IEEE 802.3at/af') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '13' and ptpef2.products_extra_fields_value = 'Blue') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '13' and ptpef2.products_extra_fields_value = 'Blue') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '13' and ptpef2.products_extra_fields_value = 'Blue') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '12' and ptpef2.products_extra_fields_value = 'RJ45') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '12' and ptpef2.products_extra_fields_value = 'RJ45') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '12' and ptpef2.products_extra_fields_value = 'RJ45') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '12' and ptpef2.products_extra_fields_value = 'RJ45') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '12' and ptpef2.products_extra_fields_value = 'RJ45') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '12' and ptpef2.products_extra_fields_value = 'RJ45') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '12' and ptpef2.products_extra_fields_value = 'RJ45') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '12' and ptpef2.products_extra_fields_value = 'RJ45') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '12' and ptpef2.products_extra_fields_value = 'RJ45') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '12' and ptpef2.products_extra_fields_value = 'RJ45') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '12' and ptpef2.products_extra_fields_value = 'RJ45') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '12' and ptpef2.products_extra_fields_value = 'RJ45') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '12' and ptpef2.products_extra_fields_value = 'RJ45') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '12' and ptpef2.products_extra_fields_value = 'RJ45') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '12' and ptpef2.products_extra_fields_value = 'RJ45') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '12' and ptpef2.products_extra_fields_value = 'RJ45') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '12' and ptpef2.products_extra_fields_value = 'RJ45') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '12' and ptpef2.products_extra_fields_value = 'RJ45') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '12' and ptpef2.products_extra_fields_value = 'RJ45') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '12' and ptpef2.products_extra_fields_value = 'RJ45') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '12' and ptpef2.products_extra_fields_value = 'RJ45 / SFP') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '12' and ptpef2.products_extra_fields_value = 'RJ45 / SFP') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '12' and ptpef2.products_extra_fields_value = 'RJ45 / SFP') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '20' and ptpef2.products_extra_fields_value = 'Indoor') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '20' and ptpef2.products_extra_fields_value = 'Indoor') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '20' and ptpef2.products_extra_fields_value = 'Indoor') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '20' and ptpef2.products_extra_fields_value = 'Indoor') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '20' and ptpef2.products_extra_fields_value = 'Indoor') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '20' and ptpef2.products_extra_fields_value = 'Indoor') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '20' and ptpef2.products_extra_fields_value = 'Indoor') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '20' and ptpef2.products_extra_fields_value = 'Indoor') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '20' and ptpef2.products_extra_fields_value = 'Indoor') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '20' and ptpef2.products_extra_fields_value = 'Indoor') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '20' and ptpef2.products_extra_fields_value = 'Indoor') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '20' and ptpef2.products_extra_fields_value = 'Indoor') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '20' and ptpef2.products_extra_fields_value = 'Indoor') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '20' and ptpef2.products_extra_fields_value = 'Indoor') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '20' and ptpef2.products_extra_fields_value = 'Indoor') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '20' and ptpef2.products_extra_fields_value = 'Indoor') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '20' and ptpef2.products_extra_fields_value = 'Indoor') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '20' and ptpef2.products_extra_fields_value = 'Indoor') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '20' and ptpef2.products_extra_fields_value = 'Indoor') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '20' and ptpef2.products_extra_fields_value = 'Indoor') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '20' and ptpef2.products_extra_fields_value = 'Outdoor') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '11' and ptpef2.products_extra_fields_value = 'Desktop') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '11' and ptpef2.products_extra_fields_value = 'Desktop') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '11' and ptpef2.products_extra_fields_value = 'Desktop') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '11' and ptpef2.products_extra_fields_value = 'Desktop') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '11' and ptpef2.products_extra_fields_value = 'Desktop') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '11' and ptpef2.products_extra_fields_value = 'Desktop') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '11' and ptpef2.products_extra_fields_value = 'Desktop') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '11' and ptpef2.products_extra_fields_value = 'Desktop') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '11' and ptpef2.products_extra_fields_value = 'Desktop') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '11' and ptpef2.products_extra_fields_value = 'Rack') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '11' and ptpef2.products_extra_fields_value = 'Rack Mountable') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '11' and ptpef2.products_extra_fields_value = 'Rack Mountable') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '11' and ptpef2.products_extra_fields_value = 'Rack Mountable') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '11' and ptpef2.products_extra_fields_value = 'Rack Mountable') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '11' and ptpef2.products_extra_fields_value = 'Rack Mountable') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '11' and ptpef2.products_extra_fields_value = 'Rack Mountable') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '11' and ptpef2.products_extra_fields_value = 'Rack Mountable') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '11' and ptpef2.products_extra_fields_value = 'Rack Mountable') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '11' and ptpef2.products_extra_fields_value = 'Rack Mountable') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '11' and ptpef2.products_extra_fields_value = 'Rack Mountable') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '11' and ptpef2.products_extra_fields_value = 'Rack Mountable') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '11' and ptpef2.products_extra_fields_value = 'Rack Mountable') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '11' and ptpef2.products_extra_fields_value = 'Rack Mountable') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '68' and ptpef2.products_extra_fields_value = 'Managed') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '68' and ptpef2.products_extra_fields_value = 'Managed') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '68' and ptpef2.products_extra_fields_value = 'Managed') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '68' and ptpef2.products_extra_fields_value = 'Managed') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '68' and ptpef2.products_extra_fields_value = 'Managed') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '68' and ptpef2.products_extra_fields_value = 'Managed') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '68' and ptpef2.products_extra_fields_value = 'Managed') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '68' and ptpef2.products_extra_fields_value = 'Managed') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '68' and ptpef2.products_extra_fields_value = 'Managed') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '68' and ptpef2.products_extra_fields_value = 'Unmanaged') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '68' and ptpef2.products_extra_fields_value = 'Unmanaged') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '68' and ptpef2.products_extra_fields_value = 'Unmanaged') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '68' and ptpef2.products_extra_fields_value = 'Unmanaged') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '68' and ptpef2.products_extra_fields_value = 'Unmanaged') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '68' and ptpef2.products_extra_fields_value = 'Unmanaged') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '68' and ptpef2.products_extra_fields_value = 'Unmanaged') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '68' and ptpef2.products_extra_fields_value = 'Unmanaged') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '68' and ptpef2.products_extra_fields_value = 'Unmanaged') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '68' and ptpef2.products_extra_fields_value = 'Unmanaged') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '68' and ptpef2.products_extra_fields_value = 'Unmanaged') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '68' and ptpef2.products_extra_fields_value = 'Unmanaged') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '68' and ptpef2.products_extra_fields_value = 'Unmanaged') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '68' and ptpef2.products_extra_fields_value = 'Unmanaged') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '68' and ptpef2.products_extra_fields_value = 'Unmanaged') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '68' and ptpef2.products_extra_fields_value = 'Unmanaged') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '70' and ptpef2.products_extra_fields_value = '30') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '70' and ptpef2.products_extra_fields_value = '30') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '70' and ptpef2.products_extra_fields_value = '30') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '70' and ptpef2.products_extra_fields_value = '30') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '70' and ptpef2.products_extra_fields_value = '30') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '70' and ptpef2.products_extra_fields_value = '30') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '70' and ptpef2.products_extra_fields_value = '30') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '70' and ptpef2.products_extra_fields_value = '30') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '70' and ptpef2.products_extra_fields_value = '30') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '70' and ptpef2.products_extra_fields_value = '30') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '70' and ptpef2.products_extra_fields_value = '30') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '70' and ptpef2.products_extra_fields_value = '30') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '70' and ptpef2.products_extra_fields_value = '30') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '70' and ptpef2.products_extra_fields_value = '30') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '70' and ptpef2.products_extra_fields_value = '30') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '70' and ptpef2.products_extra_fields_value = '30') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '70' and ptpef2.products_extra_fields_value = '30') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '70' and ptpef2.products_extra_fields_value = '30') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '70' and ptpef2.products_extra_fields_value = '30') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '70' and ptpef2.products_extra_fields_value = '30') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '70' and ptpef2.products_extra_fields_value = '30') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '70' and ptpef2.products_extra_fields_value = '30') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '70' and ptpef2.products_extra_fields_value = '30') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '70' and ptpef2.products_extra_fields_value = '30') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '70' and ptpef2.products_extra_fields_value = '30') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '70' and ptpef2.products_extra_fields_value = '30') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '70' and ptpef2.products_extra_fields_value = '34') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '70' and ptpef2.products_extra_fields_value = '60') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 = 'PoE / PoE+') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 = 'PoE / PoE+') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 = '48 - 57 VDC') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 = '48 VDC') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 / POE') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 = '220 VAC') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 = '240 VAC') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 = '240 VAC') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 = '48 VDC') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 = '48 VDC') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 = '48 VDC') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 = '48 VDC') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 = '48 VDC') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 = '48 VDC') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '65' and ptpef2.products_extra_fields_value = '30') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '65' and ptpef2.products_extra_fields_value = '30') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '65' and ptpef2.products_extra_fields_value = '40') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '65' and ptpef2.products_extra_fields_value = '55') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '65' and ptpef2.products_extra_fields_value = '58') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '65' and ptpef2.products_extra_fields_value = '58') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '65' and ptpef2.products_extra_fields_value = '60') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '65' and ptpef2.products_extra_fields_value = '60') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '65' and ptpef2.products_extra_fields_value = '60') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '65' and ptpef2.products_extra_fields_value = '62') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '65' and ptpef2.products_extra_fields_value = '63') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '65' and ptpef2.products_extra_fields_value = '65') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '65' and ptpef2.products_extra_fields_value = '68') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '65' and ptpef2.products_extra_fields_value = '92') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '65' and ptpef2.products_extra_fields_value = '110') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '65' and ptpef2.products_extra_fields_value = '120') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '65' and ptpef2.products_extra_fields_value = '130') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '65' and ptpef2.products_extra_fields_value = '135') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '65' and ptpef2.products_extra_fields_value = '140') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '65' and ptpef2.products_extra_fields_value = '140') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '65' and ptpef2.products_extra_fields_value = '195') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '65' and ptpef2.products_extra_fields_value = '220') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '65' and ptpef2.products_extra_fields_value = '225') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '65' and ptpef2.products_extra_fields_value = '230') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '65' and ptpef2.products_extra_fields_value = '240') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '65' and ptpef2.products_extra_fields_value = '243') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '65' and ptpef2.products_extra_fields_value = '250') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '65' and ptpef2.products_extra_fields_value = '270') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '65' and ptpef2.products_extra_fields_value = '370') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '65' and ptpef2.products_extra_fields_value = '370') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '65' and ptpef2.products_extra_fields_value = '370') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '65' and ptpef2.products_extra_fields_value = '370') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '65' and ptpef2.products_extra_fields_value = '370') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '65' and ptpef2.products_extra_fields_value = '370') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '65' and ptpef2.products_extra_fields_value = '370') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '65' and ptpef2.products_extra_fields_value = '470') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '65' and ptpef2.products_extra_fields_value = '500') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '65' and ptpef2.products_extra_fields_value = '740') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '64' and ptpef2.products_extra_fields_value = '1') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '64' and ptpef2.products_extra_fields_value = '2') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '64' and ptpef2.products_extra_fields_value = '4') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '64' and ptpef2.products_extra_fields_value = '4') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '64' and ptpef2.products_extra_fields_value = '4') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '64' and ptpef2.products_extra_fields_value = '4') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '64' and ptpef2.products_extra_fields_value = '4') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '64' and ptpef2.products_extra_fields_value = '4') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '64' and ptpef2.products_extra_fields_value = '5') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '64' and ptpef2.products_extra_fields_value = '5') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '64' and ptpef2.products_extra_fields_value = '5') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '64' and ptpef2.products_extra_fields_value = '5') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '64' and ptpef2.products_extra_fields_value = '8') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '64' and ptpef2.products_extra_fields_value = '8') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '64' and ptpef2.products_extra_fields_value = '8') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '64' and ptpef2.products_extra_fields_value = '8') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '64' and ptpef2.products_extra_fields_value = '8') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '64' and ptpef2.products_extra_fields_value = '8') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '64' and ptpef2.products_extra_fields_value = '8') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '64' and ptpef2.products_extra_fields_value = '8') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '64' and ptpef2.products_extra_fields_value = '8') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '64' and ptpef2.products_extra_fields_value = '8') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '64' and ptpef2.products_extra_fields_value = '8') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '64' and ptpef2.products_extra_fields_value = '8') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '64' and ptpef2.products_extra_fields_value = '16') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '64' and ptpef2.products_extra_fields_value = '16') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '64' and ptpef2.products_extra_fields_value = '16') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '64' and ptpef2.products_extra_fields_value = '16') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '64' and ptpef2.products_extra_fields_value = '24') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '64' and ptpef2.products_extra_fields_value = '24') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '64' and ptpef2.products_extra_fields_value = '24') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '64' and ptpef2.products_extra_fields_value = '24') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '64' and ptpef2.products_extra_fields_value = '24') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '64' and ptpef2.products_extra_fields_value = '24') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '64' and ptpef2.products_extra_fields_value = '24') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '64' and ptpef2.products_extra_fields_value = '24') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '64' and ptpef2.products_extra_fields_value = '24') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '64' and ptpef2.products_extra_fields_value = '24') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '64' and ptpef2.products_extra_fields_value = '24') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '64' and ptpef2.products_extra_fields_value = '48') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '64' and ptpef2.products_extra_fields_value = '48') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '64' and ptpef2.products_extra_fields_value = '48') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '43' and ptpef2.products_extra_fields_value = '1') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '43' and ptpef2.products_extra_fields_value = '1') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '43' and ptpef2.products_extra_fields_value = '1') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '43' and ptpef2.products_extra_fields_value = '3') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '43' and ptpef2.products_extra_fields_value = '5') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '43' and ptpef2.products_extra_fields_value = '5') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '43' and ptpef2.products_extra_fields_value = '5') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '43' and ptpef2.products_extra_fields_value = '5') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '43' and ptpef2.products_extra_fields_value = '5') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '43' and ptpef2.products_extra_fields_value = '8') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '43' and ptpef2.products_extra_fields_value = '8') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '43' and ptpef2.products_extra_fields_value = '8') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '43' and ptpef2.products_extra_fields_value = '9') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '43' and ptpef2.products_extra_fields_value = '9') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '43' and ptpef2.products_extra_fields_value = '10') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '43' and ptpef2.products_extra_fields_value = '16') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '43' and ptpef2.products_extra_fields_value = '16') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '43' and ptpef2.products_extra_fields_value = '16') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '43' and ptpef2.products_extra_fields_value = '16') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '43' and ptpef2.products_extra_fields_value = '16') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '43' and ptpef2.products_extra_fields_value = '24') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '43' and ptpef2.products_extra_fields_value = '24') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '43' and ptpef2.products_extra_fields_value = '24') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '43' and ptpef2.products_extra_fields_value = '24') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '43' and ptpef2.products_extra_fields_value = '24') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '43' and ptpef2.products_extra_fields_value = '24') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '43' and ptpef2.products_extra_fields_value = '24') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '43' and ptpef2.products_extra_fields_value = '24') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '43' and ptpef2.products_extra_fields_value = '24') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '43' and ptpef2.products_extra_fields_value = '26') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '23' and ptpef2.products_extra_fields_value = '120') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '23' and ptpef2.products_extra_fields_value = '163.2') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '23' and ptpef2.products_extra_fields_value = '260') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '23' and ptpef2.products_extra_fields_value = '337') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '23' and ptpef2.products_extra_fields_value = '374') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '23' and ptpef2.products_extra_fields_value = '400') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '23' and ptpef2.products_extra_fields_value = '400') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '23' and ptpef2.products_extra_fields_value = '899') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '82' and ptpef2.products_extra_fields_value = '1') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '82' and ptpef2.products_extra_fields_value = '1U') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '82' and ptpef2.products_extra_fields_value = '1U') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '82' and ptpef2.products_extra_fields_value = '1U') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '82' and ptpef2.products_extra_fields_value = '1U') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '87' and ptpef2.products_extra_fields_value = '1') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '87' and ptpef2.products_extra_fields_value = '1') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '87' and ptpef2.products_extra_fields_value = '1') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '87' and ptpef2.products_extra_fields_value = '2') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '87' and ptpef2.products_extra_fields_value = '2') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '87' and ptpef2.products_extra_fields_value = '2') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '87' and ptpef2.products_extra_fields_value = '2') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '87' and ptpef2.products_extra_fields_value = '2') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '87' and ptpef2.products_extra_fields_value = '2') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '87' and ptpef2.products_extra_fields_value = '2') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '87' and ptpef2.products_extra_fields_value = '2') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '87' and ptpef2.products_extra_fields_value = '2') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '87' and ptpef2.products_extra_fields_value = '2') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '87' and ptpef2.products_extra_fields_value = '2') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '87' and ptpef2.products_extra_fields_value = '2') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '87' and ptpef2.products_extra_fields_value = '2') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '87' and ptpef2.products_extra_fields_value = '4') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '87' and ptpef2.products_extra_fields_value = '4') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '87' and ptpef2.products_extra_fields_value = '4') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '67' and ptpef2.products_extra_fields_value = '10/100') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '67' and ptpef2.products_extra_fields_value = '10/100/1000') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '67' and ptpef2.products_extra_fields_value = '10/100/1000') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '67' and ptpef2.products_extra_fields_value = '10/100/1000') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '67' and ptpef2.products_extra_fields_value = '10/100/1000') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '67' and ptpef2.products_extra_fields_value = '10/100/1000') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '67' and ptpef2.products_extra_fields_value = '10/100/1000') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '67' and ptpef2.products_extra_fields_value = '10/100/1000') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '67' and ptpef2.products_extra_fields_value = '10/100/1000') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '67' and ptpef2.products_extra_fields_value = '10/100/1000') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '67' and ptpef2.products_extra_fields_value = '10/100/1000') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '67' and ptpef2.products_extra_fields_value = '10/100/1000') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '67' and ptpef2.products_extra_fields_value = '10/100/1000') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '67' and ptpef2.products_extra_fields_value = '10/100/1000') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '67' and ptpef2.products_extra_fields_value = '10/100/1000') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '67' and ptpef2.products_extra_fields_value = '10/100/1000') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '67' and ptpef2.products_extra_fields_value = '10/100/1000') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '67' and ptpef2.products_extra_fields_value = '10/100/1000') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '67' and ptpef2.products_extra_fields_value = '10/100/1000') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '67' and ptpef2.products_extra_fields_value = '10/100/1000') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '67' and ptpef2.products_extra_fields_value = '10/100/1000') and ptc.categories_id = 132 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
PoE
Category
Brand
Aruba by HP
Avycon
Hikvision
Intellinet
KBC Networks
Luxul
Speco Technologies
TP-Link
Ubiquiti Networks
Veracity
Vigitron
Price
Class
IEEE 802.3af/at
IEEE 802.3at
IEEE 802.3at/af
Color
Black
Blue
Connectivity
Ethernet
Wired
Connector
RJ45
RJ45 / SFP
Environment
Indoor
Outdoor
Installation
Desktop
Rack
Rack Mountable
Management
Managed
Unmanaged
Maximum Power Per Port (W)
30
34
60
Operating Voltage
PoE / PoE+
48 - 57 VDC
48 VDC
100 - 240 VAC
120 VAC / POE
220 VAC
240 VAC
Output Voltage
48 VDC
PoE Budget (W)
30
40
55
58
60
62
63
65
68
92
110
120
130
135
140
195
220
225
230
240
243
250
270
370
470
500
740
PoE Ports
1
2
4
5
8
16
24
48
Ports
1
3
5
8
9
10
16
24
26
Power Consumption (W)
120
163.2
260
337
374
400
899
Rack Units
1
1U
SFP Ports
1
2
4
Speed
10/100
10/100/1000


![]() ![]() |
1 2 ▶ |
66 items | 1 2 ▶ |