English
SpanishLanguage:
EnglishEspañol
Need help? Reach us at 1800.325.9708
Live Support
Fire
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '38' and ptpef2.products_extra_fields_value = 'Direct Burial') and ptc.categories_id = 48 and p.products_id in (10066,10067,10068,10069,10070,10071,10512,10514,10516,10517,10519,11027,114349,121231,129505,135518,135519,135521,140504,142585,142586,142587,142588,142589,142594,144009,144333,152073,152208,152209,152445) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '38' and ptpef2.products_extra_fields_value = 'Plenum') and ptc.categories_id = 48 and p.products_id in (10066,10067,10068,10069,10070,10071,10512,10514,10516,10517,10519,11027,114349,121231,129505,135518,135519,135521,140504,142585,142586,142587,142588,142589,142594,144009,144333,152073,152208,152209,152445) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '38' and ptpef2.products_extra_fields_value = 'Plenum') and ptc.categories_id = 48 and p.products_id in (10066,10067,10068,10069,10070,10071,10512,10514,10516,10517,10519,11027,114349,121231,129505,135518,135519,135521,140504,142585,142586,142587,142588,142589,142594,144009,144333,152073,152208,152209,152445) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '38' and ptpef2.products_extra_fields_value = 'Plenum') and ptc.categories_id = 48 and p.products_id in (10066,10067,10068,10069,10070,10071,10512,10514,10516,10517,10519,11027,114349,121231,129505,135518,135519,135521,140504,142585,142586,142587,142588,142589,142594,144009,144333,152073,152208,152209,152445) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '38' and ptpef2.products_extra_fields_value = 'Plenum') and ptc.categories_id = 48 and p.products_id in (10066,10067,10068,10069,10070,10071,10512,10514,10516,10517,10519,11027,114349,121231,129505,135518,135519,135521,140504,142585,142586,142587,142588,142589,142594,144009,144333,152073,152208,152209,152445) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '38' and ptpef2.products_extra_fields_value = 'Plenum') and ptc.categories_id = 48 and p.products_id in (10066,10067,10068,10069,10070,10071,10512,10514,10516,10517,10519,11027,114349,121231,129505,135518,135519,135521,140504,142585,142586,142587,142588,142589,142594,144009,144333,152073,152208,152209,152445) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '38' and ptpef2.products_extra_fields_value = 'Plenum') and ptc.categories_id = 48 and p.products_id in (10066,10067,10068,10069,10070,10071,10512,10514,10516,10517,10519,11027,114349,121231,129505,135518,135519,135521,140504,142585,142586,142587,142588,142589,142594,144009,144333,152073,152208,152209,152445) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '38' and ptpef2.products_extra_fields_value = 'Plenum') and ptc.categories_id = 48 and p.products_id in (10066,10067,10068,10069,10070,10071,10512,10514,10516,10517,10519,11027,114349,121231,129505,135518,135519,135521,140504,142585,142586,142587,142588,142589,142594,144009,144333,152073,152208,152209,152445) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '38' and ptpef2.products_extra_fields_value = 'Plenum') and ptc.categories_id = 48 and p.products_id in (10066,10067,10068,10069,10070,10071,10512,10514,10516,10517,10519,11027,114349,121231,129505,135518,135519,135521,140504,142585,142586,142587,142588,142589,142594,144009,144333,152073,152208,152209,152445) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '38' and ptpef2.products_extra_fields_value = 'Plenum') and ptc.categories_id = 48 and p.products_id in (10066,10067,10068,10069,10070,10071,10512,10514,10516,10517,10519,11027,114349,121231,129505,135518,135519,135521,140504,142585,142586,142587,142588,142589,142594,144009,144333,152073,152208,152209,152445) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '38' and ptpef2.products_extra_fields_value = 'Plenum') and ptc.categories_id = 48 and p.products_id in (10066,10067,10068,10069,10070,10071,10512,10514,10516,10517,10519,11027,114349,121231,129505,135518,135519,135521,140504,142585,142586,142587,142588,142589,142594,144009,144333,152073,152208,152209,152445) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '38' and ptpef2.products_extra_fields_value = 'Plenum') and ptc.categories_id = 48 and p.products_id in (10066,10067,10068,10069,10070,10071,10512,10514,10516,10517,10519,11027,114349,121231,129505,135518,135519,135521,140504,142585,142586,142587,142588,142589,142594,144009,144333,152073,152208,152209,152445) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '38' and ptpef2.products_extra_fields_value = 'Riser') and ptc.categories_id = 48 and p.products_id in (10066,10067,10068,10069,10070,10071,10512,10514,10516,10517,10519,11027,114349,121231,129505,135518,135519,135521,140504,142585,142586,142587,142588,142589,142594,144009,144333,152073,152208,152209,152445) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '38' and ptpef2.products_extra_fields_value = 'Riser') and ptc.categories_id = 48 and p.products_id in (10066,10067,10068,10069,10070,10071,10512,10514,10516,10517,10519,11027,114349,121231,129505,135518,135519,135521,140504,142585,142586,142587,142588,142589,142594,144009,144333,152073,152208,152209,152445) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '38' and ptpef2.products_extra_fields_value = 'Riser') and ptc.categories_id = 48 and p.products_id in (10066,10067,10068,10069,10070,10071,10512,10514,10516,10517,10519,11027,114349,121231,129505,135518,135519,135521,140504,142585,142586,142587,142588,142589,142594,144009,144333,152073,152208,152209,152445) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '38' and ptpef2.products_extra_fields_value = 'Riser') and ptc.categories_id = 48 and p.products_id in (10066,10067,10068,10069,10070,10071,10512,10514,10516,10517,10519,11027,114349,121231,129505,135518,135519,135521,140504,142585,142586,142587,142588,142589,142594,144009,144333,152073,152208,152209,152445) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '38' and ptpef2.products_extra_fields_value = 'Riser') and ptc.categories_id = 48 and p.products_id in (10066,10067,10068,10069,10070,10071,10512,10514,10516,10517,10519,11027,114349,121231,129505,135518,135519,135521,140504,142585,142586,142587,142588,142589,142594,144009,144333,152073,152208,152209,152445) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '38' and ptpef2.products_extra_fields_value = 'Riser') and ptc.categories_id = 48 and p.products_id in (10066,10067,10068,10069,10070,10071,10512,10514,10516,10517,10519,11027,114349,121231,129505,135518,135519,135521,140504,142585,142586,142587,142588,142589,142594,144009,144333,152073,152208,152209,152445) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '38' and ptpef2.products_extra_fields_value = 'Riser') and ptc.categories_id = 48 and p.products_id in (10066,10067,10068,10069,10070,10071,10512,10514,10516,10517,10519,11027,114349,121231,129505,135518,135519,135521,140504,142585,142586,142587,142588,142589,142594,144009,144333,152073,152208,152209,152445) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '38' and ptpef2.products_extra_fields_value = 'Riser') and ptc.categories_id = 48 and p.products_id in (10066,10067,10068,10069,10070,10071,10512,10514,10516,10517,10519,11027,114349,121231,129505,135518,135519,135521,140504,142585,142586,142587,142588,142589,142594,144009,144333,152073,152208,152209,152445) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '38' and ptpef2.products_extra_fields_value = 'Riser') and ptc.categories_id = 48 and p.products_id in (10066,10067,10068,10069,10070,10071,10512,10514,10516,10517,10519,11027,114349,121231,129505,135518,135519,135521,140504,142585,142586,142587,142588,142589,142594,144009,144333,152073,152208,152209,152445) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '38' and ptpef2.products_extra_fields_value = 'Riser') and ptc.categories_id = 48 and p.products_id in (10066,10067,10068,10069,10070,10071,10512,10514,10516,10517,10519,11027,114349,121231,129505,135518,135519,135521,140504,142585,142586,142587,142588,142589,142594,144009,144333,152073,152208,152209,152445) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '38' and ptpef2.products_extra_fields_value = 'Riser') and ptc.categories_id = 48 and p.products_id in (10066,10067,10068,10069,10070,10071,10512,10514,10516,10517,10519,11027,114349,121231,129505,135518,135519,135521,140504,142585,142586,142587,142588,142589,142594,144009,144333,152073,152208,152209,152445) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '38' and ptpef2.products_extra_fields_value = 'Riser') and ptc.categories_id = 48 and p.products_id in (10066,10067,10068,10069,10070,10071,10512,10514,10516,10517,10519,11027,114349,121231,129505,135518,135519,135521,140504,142585,142586,142587,142588,142589,142594,144009,144333,152073,152208,152209,152445) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '38' and ptpef2.products_extra_fields_value = 'Riser') and ptc.categories_id = 48 and p.products_id in (10066,10067,10068,10069,10070,10071,10512,10514,10516,10517,10519,11027,114349,121231,129505,135518,135519,135521,140504,142585,142586,142587,142588,142589,142594,144009,144333,152073,152208,152209,152445) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '38' and ptpef2.products_extra_fields_value = 'Riser') and ptc.categories_id = 48 and p.products_id in (10066,10067,10068,10069,10070,10071,10512,10514,10516,10517,10519,11027,114349,121231,129505,135518,135519,135521,140504,142585,142586,142587,142588,142589,142594,144009,144333,152073,152208,152209,152445) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '38' and ptpef2.products_extra_fields_value = 'Riser') and ptc.categories_id = 48 and p.products_id in (10066,10067,10068,10069,10070,10071,10512,10514,10516,10517,10519,11027,114349,121231,129505,135518,135519,135521,140504,142585,142586,142587,142588,142589,142594,144009,144333,152073,152208,152209,152445) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '38' and ptpef2.products_extra_fields_value = 'Riser') and ptc.categories_id = 48 and p.products_id in (10066,10067,10068,10069,10070,10071,10512,10514,10516,10517,10519,11027,114349,121231,129505,135518,135519,135521,140504,142585,142586,142587,142588,142589,142594,144009,144333,152073,152208,152209,152445) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '38' and ptpef2.products_extra_fields_value = 'Riser') and ptc.categories_id = 48 and p.products_id in (10066,10067,10068,10069,10070,10071,10512,10514,10516,10517,10519,11027,114349,121231,129505,135518,135519,135521,140504,142585,142586,142587,142588,142589,142594,144009,144333,152073,152208,152209,152445) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '38' and ptpef2.products_extra_fields_value = 'Riser') and ptc.categories_id = 48 and p.products_id in (10066,10067,10068,10069,10070,10071,10512,10514,10516,10517,10519,11027,114349,121231,129505,135518,135519,135521,140504,142585,142586,142587,142588,142589,142594,144009,144333,152073,152208,152209,152445) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '38' and ptpef2.products_extra_fields_value = 'Riser') and ptc.categories_id = 48 and p.products_id in (10066,10067,10068,10069,10070,10071,10512,10514,10516,10517,10519,11027,114349,121231,129505,135518,135519,135521,140504,142585,142586,142587,142588,142589,142594,144009,144333,152073,152208,152209,152445) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 = 48 and p.products_id in (10066,10067,10068,10069,10070,10071,10512,10514,10516,10517,10519,11027,114349,121231,129505,135518,135519,135521,140504,142585,142586,142587,142588,142589,142594,144009,144333,152073,152208,152209,152445) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 = 'Red') and ptc.categories_id = 48 and p.products_id in (10066,10067,10068,10069,10070,10071,10512,10514,10516,10517,10519,11027,114349,121231,129505,135518,135519,135521,140504,142585,142586,142587,142588,142589,142594,144009,144333,152073,152208,152209,152445) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 = 'Red') and ptc.categories_id = 48 and p.products_id in (10066,10067,10068,10069,10070,10071,10512,10514,10516,10517,10519,11027,114349,121231,129505,135518,135519,135521,140504,142585,142586,142587,142588,142589,142594,144009,144333,152073,152208,152209,152445) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 = 'Red') and ptc.categories_id = 48 and p.products_id in (10066,10067,10068,10069,10070,10071,10512,10514,10516,10517,10519,11027,114349,121231,129505,135518,135519,135521,140504,142585,142586,142587,142588,142589,142594,144009,144333,152073,152208,152209,152445) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 = 'Red') and ptc.categories_id = 48 and p.products_id in (10066,10067,10068,10069,10070,10071,10512,10514,10516,10517,10519,11027,114349,121231,129505,135518,135519,135521,140504,142585,142586,142587,142588,142589,142594,144009,144333,152073,152208,152209,152445) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 = 'Red') and ptc.categories_id = 48 and p.products_id in (10066,10067,10068,10069,10070,10071,10512,10514,10516,10517,10519,11027,114349,121231,129505,135518,135519,135521,140504,142585,142586,142587,142588,142589,142594,144009,144333,152073,152208,152209,152445) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 = 'Red') and ptc.categories_id = 48 and p.products_id in (10066,10067,10068,10069,10070,10071,10512,10514,10516,10517,10519,11027,114349,121231,129505,135518,135519,135521,140504,142585,142586,142587,142588,142589,142594,144009,144333,152073,152208,152209,152445) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 = 'Red') and ptc.categories_id = 48 and p.products_id in (10066,10067,10068,10069,10070,10071,10512,10514,10516,10517,10519,11027,114349,121231,129505,135518,135519,135521,140504,142585,142586,142587,142588,142589,142594,144009,144333,152073,152208,152209,152445) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 = 'Red') and ptc.categories_id = 48 and p.products_id in (10066,10067,10068,10069,10070,10071,10512,10514,10516,10517,10519,11027,114349,121231,129505,135518,135519,135521,140504,142585,142586,142587,142588,142589,142594,144009,144333,152073,152208,152209,152445) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 = 'Red') and ptc.categories_id = 48 and p.products_id in (10066,10067,10068,10069,10070,10071,10512,10514,10516,10517,10519,11027,114349,121231,129505,135518,135519,135521,140504,142585,142586,142587,142588,142589,142594,144009,144333,152073,152208,152209,152445) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 = 'Red') and ptc.categories_id = 48 and p.products_id in (10066,10067,10068,10069,10070,10071,10512,10514,10516,10517,10519,11027,114349,121231,129505,135518,135519,135521,140504,142585,142586,142587,142588,142589,142594,144009,144333,152073,152208,152209,152445) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 = 'Red') and ptc.categories_id = 48 and p.products_id in (10066,10067,10068,10069,10070,10071,10512,10514,10516,10517,10519,11027,114349,121231,129505,135518,135519,135521,140504,142585,142586,142587,142588,142589,142594,144009,144333,152073,152208,152209,152445) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 = 'Red') and ptc.categories_id = 48 and p.products_id in (10066,10067,10068,10069,10070,10071,10512,10514,10516,10517,10519,11027,114349,121231,129505,135518,135519,135521,140504,142585,142586,142587,142588,142589,142594,144009,144333,152073,152208,152209,152445) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 = 'Red') and ptc.categories_id = 48 and p.products_id in (10066,10067,10068,10069,10070,10071,10512,10514,10516,10517,10519,11027,114349,121231,129505,135518,135519,135521,140504,142585,142586,142587,142588,142589,142594,144009,144333,152073,152208,152209,152445) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 = 'Red') and ptc.categories_id = 48 and p.products_id in (10066,10067,10068,10069,10070,10071,10512,10514,10516,10517,10519,11027,114349,121231,129505,135518,135519,135521,140504,142585,142586,142587,142588,142589,142594,144009,144333,152073,152208,152209,152445) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 = 'Red') and ptc.categories_id = 48 and p.products_id in (10066,10067,10068,10069,10070,10071,10512,10514,10516,10517,10519,11027,114349,121231,129505,135518,135519,135521,140504,142585,142586,142587,142588,142589,142594,144009,144333,152073,152208,152209,152445) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 = 'Red') and ptc.categories_id = 48 and p.products_id in (10066,10067,10068,10069,10070,10071,10512,10514,10516,10517,10519,11027,114349,121231,129505,135518,135519,135521,140504,142585,142586,142587,142588,142589,142594,144009,144333,152073,152208,152209,152445) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 = 'Red') and ptc.categories_id = 48 and p.products_id in (10066,10067,10068,10069,10070,10071,10512,10514,10516,10517,10519,11027,114349,121231,129505,135518,135519,135521,140504,142585,142586,142587,142588,142589,142594,144009,144333,152073,152208,152209,152445) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 = 'Red') and ptc.categories_id = 48 and p.products_id in (10066,10067,10068,10069,10070,10071,10512,10514,10516,10517,10519,11027,114349,121231,129505,135518,135519,135521,140504,142585,142586,142587,142588,142589,142594,144009,144333,152073,152208,152209,152445) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 = 'Red') and ptc.categories_id = 48 and p.products_id in (10066,10067,10068,10069,10070,10071,10512,10514,10516,10517,10519,11027,114349,121231,129505,135518,135519,135521,140504,142585,142586,142587,142588,142589,142594,144009,144333,152073,152208,152209,152445) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 = 'Red') and ptc.categories_id = 48 and p.products_id in (10066,10067,10068,10069,10070,10071,10512,10514,10516,10517,10519,11027,114349,121231,129505,135518,135519,135521,140504,142585,142586,142587,142588,142589,142594,144009,144333,152073,152208,152209,152445) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 = 'Red') and ptc.categories_id = 48 and p.products_id in (10066,10067,10068,10069,10070,10071,10512,10514,10516,10517,10519,11027,114349,121231,129505,135518,135519,135521,140504,142585,142586,142587,142588,142589,142594,144009,144333,152073,152208,152209,152445) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 = 'Red') and ptc.categories_id = 48 and p.products_id in (10066,10067,10068,10069,10070,10071,10512,10514,10516,10517,10519,11027,114349,121231,129505,135518,135519,135521,140504,142585,142586,142587,142588,142589,142594,144009,144333,152073,152208,152209,152445) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 = 'Red') and ptc.categories_id = 48 and p.products_id in (10066,10067,10068,10069,10070,10071,10512,10514,10516,10517,10519,11027,114349,121231,129505,135518,135519,135521,140504,142585,142586,142587,142588,142589,142594,144009,144333,152073,152208,152209,152445) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 = 'Red') and ptc.categories_id = 48 and p.products_id in (10066,10067,10068,10069,10070,10071,10512,10514,10516,10517,10519,11027,114349,121231,129505,135518,135519,135521,140504,142585,142586,142587,142588,142589,142594,144009,144333,152073,152208,152209,152445) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 = 'Red') and ptc.categories_id = 48 and p.products_id in (10066,10067,10068,10069,10070,10071,10512,10514,10516,10517,10519,11027,114349,121231,129505,135518,135519,135521,140504,142585,142586,142587,142588,142589,142594,144009,144333,152073,152208,152209,152445) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 = 'Red') and ptc.categories_id = 48 and p.products_id in (10066,10067,10068,10069,10070,10071,10512,10514,10516,10517,10519,11027,114349,121231,129505,135518,135519,135521,140504,142585,142586,142587,142588,142589,142594,144009,144333,152073,152208,152209,152445) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 = 'Red') and ptc.categories_id = 48 and p.products_id in (10066,10067,10068,10069,10070,10071,10512,10514,10516,10517,10519,11027,114349,121231,129505,135518,135519,135521,140504,142585,142586,142587,142588,142589,142594,144009,144333,152073,152208,152209,152445) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 = 'Red') and ptc.categories_id = 48 and p.products_id in (10066,10067,10068,10069,10070,10071,10512,10514,10516,10517,10519,11027,114349,121231,129505,135518,135519,135521,140504,142585,142586,142587,142588,142589,142594,144009,144333,152073,152208,152209,152445) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '13' and ptpef2.products_extra_fields_value = 'White') and ptc.categories_id = 48 and p.products_id in (10066,10067,10068,10069,10070,10071,10512,10514,10516,10517,10519,11027,114349,121231,129505,135518,135519,135521,140504,142585,142586,142587,142588,142589,142594,144009,144333,152073,152208,152209,152445) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '13' and ptpef2.products_extra_fields_value = 'White') and ptc.categories_id = 48 and p.products_id in (10066,10067,10068,10069,10070,10071,10512,10514,10516,10517,10519,11027,114349,121231,129505,135518,135519,135521,140504,142585,142586,142587,142588,142589,142594,144009,144333,152073,152208,152209,152445) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.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 = 'Direct Burial') and ptc.categories_id = 48 and p.products_id in (10066,10067,10068,10069,10070,10071,10512,10514,10516,10517,10519,11027,114349,121231,129505,135518,135519,135521,140504,142585,142586,142587,142588,142589,142594,144009,144333,152073,152208,152209,152445) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '89' and ptpef2.products_extra_fields_value = '500\' (152m)') and ptc.categories_id = 48 and p.products_id in (10066,10067,10068,10069,10070,10071,10512,10514,10516,10517,10519,11027,114349,121231,129505,135518,135519,135521,140504,142585,142586,142587,142588,142589,142594,144009,144333,152073,152208,152209,152445) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '89' and ptpef2.products_extra_fields_value = '500\' (152m)') and ptc.categories_id = 48 and p.products_id in (10066,10067,10068,10069,10070,10071,10512,10514,10516,10517,10519,11027,114349,121231,129505,135518,135519,135521,140504,142585,142586,142587,142588,142589,142594,144009,144333,152073,152208,152209,152445) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '89' and ptpef2.products_extra_fields_value = '500\' (152m)') and ptc.categories_id = 48 and p.products_id in (10066,10067,10068,10069,10070,10071,10512,10514,10516,10517,10519,11027,114349,121231,129505,135518,135519,135521,140504,142585,142586,142587,142588,142589,142594,144009,144333,152073,152208,152209,152445) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '89' and ptpef2.products_extra_fields_value = '500\' (152m)') and ptc.categories_id = 48 and p.products_id in (10066,10067,10068,10069,10070,10071,10512,10514,10516,10517,10519,11027,114349,121231,129505,135518,135519,135521,140504,142585,142586,142587,142588,142589,142594,144009,144333,152073,152208,152209,152445) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '89' and ptpef2.products_extra_fields_value = '500\' (152m)') and ptc.categories_id = 48 and p.products_id in (10066,10067,10068,10069,10070,10071,10512,10514,10516,10517,10519,11027,114349,121231,129505,135518,135519,135521,140504,142585,142586,142587,142588,142589,142594,144009,144333,152073,152208,152209,152445) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '89' and ptpef2.products_extra_fields_value = '500\' (152m)') and ptc.categories_id = 48 and p.products_id in (10066,10067,10068,10069,10070,10071,10512,10514,10516,10517,10519,11027,114349,121231,129505,135518,135519,135521,140504,142585,142586,142587,142588,142589,142594,144009,144333,152073,152208,152209,152445) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '89' and ptpef2.products_extra_fields_value = '500\' (152m)') and ptc.categories_id = 48 and p.products_id in (10066,10067,10068,10069,10070,10071,10512,10514,10516,10517,10519,11027,114349,121231,129505,135518,135519,135521,140504,142585,142586,142587,142588,142589,142594,144009,144333,152073,152208,152209,152445) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '89' and ptpef2.products_extra_fields_value = '500\' (152m)') and ptc.categories_id = 48 and p.products_id in (10066,10067,10068,10069,10070,10071,10512,10514,10516,10517,10519,11027,114349,121231,129505,135518,135519,135521,140504,142585,142586,142587,142588,142589,142594,144009,144333,152073,152208,152209,152445) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '89' and ptpef2.products_extra_fields_value = '500\' (152m)') and ptc.categories_id = 48 and p.products_id in (10066,10067,10068,10069,10070,10071,10512,10514,10516,10517,10519,11027,114349,121231,129505,135518,135519,135521,140504,142585,142586,142587,142588,142589,142594,144009,144333,152073,152208,152209,152445) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '89' and ptpef2.products_extra_fields_value = '500\' (152m)') and ptc.categories_id = 48 and p.products_id in (10066,10067,10068,10069,10070,10071,10512,10514,10516,10517,10519,11027,114349,121231,129505,135518,135519,135521,140504,142585,142586,142587,142588,142589,142594,144009,144333,152073,152208,152209,152445) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '89' and ptpef2.products_extra_fields_value = '500\' (152m)') and ptc.categories_id = 48 and p.products_id in (10066,10067,10068,10069,10070,10071,10512,10514,10516,10517,10519,11027,114349,121231,129505,135518,135519,135521,140504,142585,142586,142587,142588,142589,142594,144009,144333,152073,152208,152209,152445) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '89' and ptpef2.products_extra_fields_value = '500\' (152m)') and ptc.categories_id = 48 and p.products_id in (10066,10067,10068,10069,10070,10071,10512,10514,10516,10517,10519,11027,114349,121231,129505,135518,135519,135521,140504,142585,142586,142587,142588,142589,142594,144009,144333,152073,152208,152209,152445) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '89' and ptpef2.products_extra_fields_value = '500\' (152m)') and ptc.categories_id = 48 and p.products_id in (10066,10067,10068,10069,10070,10071,10512,10514,10516,10517,10519,11027,114349,121231,129505,135518,135519,135521,140504,142585,142586,142587,142588,142589,142594,144009,144333,152073,152208,152209,152445) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '89' and ptpef2.products_extra_fields_value = '500\' (152m)') and ptc.categories_id = 48 and p.products_id in (10066,10067,10068,10069,10070,10071,10512,10514,10516,10517,10519,11027,114349,121231,129505,135518,135519,135521,140504,142585,142586,142587,142588,142589,142594,144009,144333,152073,152208,152209,152445) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '89' and ptpef2.products_extra_fields_value = '500\' (152m)') and ptc.categories_id = 48 and p.products_id in (10066,10067,10068,10069,10070,10071,10512,10514,10516,10517,10519,11027,114349,121231,129505,135518,135519,135521,140504,142585,142586,142587,142588,142589,142594,144009,144333,152073,152208,152209,152445) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '89' and ptpef2.products_extra_fields_value = '500\' (152m)') and ptc.categories_id = 48 and p.products_id in (10066,10067,10068,10069,10070,10071,10512,10514,10516,10517,10519,11027,114349,121231,129505,135518,135519,135521,140504,142585,142586,142587,142588,142589,142594,144009,144333,152073,152208,152209,152445) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '89' and ptpef2.products_extra_fields_value = '500\' (152m)') and ptc.categories_id = 48 and p.products_id in (10066,10067,10068,10069,10070,10071,10512,10514,10516,10517,10519,11027,114349,121231,129505,135518,135519,135521,140504,142585,142586,142587,142588,142589,142594,144009,144333,152073,152208,152209,152445) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '89' and ptpef2.products_extra_fields_value = '1000\' (305m)') and ptc.categories_id = 48 and p.products_id in (10066,10067,10068,10069,10070,10071,10512,10514,10516,10517,10519,11027,114349,121231,129505,135518,135519,135521,140504,142585,142586,142587,142588,142589,142594,144009,144333,152073,152208,152209,152445) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '89' and ptpef2.products_extra_fields_value = '1000\' (305m)') and ptc.categories_id = 48 and p.products_id in (10066,10067,10068,10069,10070,10071,10512,10514,10516,10517,10519,11027,114349,121231,129505,135518,135519,135521,140504,142585,142586,142587,142588,142589,142594,144009,144333,152073,152208,152209,152445) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '89' and ptpef2.products_extra_fields_value = '1000\' (305m)') and ptc.categories_id = 48 and p.products_id in (10066,10067,10068,10069,10070,10071,10512,10514,10516,10517,10519,11027,114349,121231,129505,135518,135519,135521,140504,142585,142586,142587,142588,142589,142594,144009,144333,152073,152208,152209,152445) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '89' and ptpef2.products_extra_fields_value = '1000\' (305m)') and ptc.categories_id = 48 and p.products_id in (10066,10067,10068,10069,10070,10071,10512,10514,10516,10517,10519,11027,114349,121231,129505,135518,135519,135521,140504,142585,142586,142587,142588,142589,142594,144009,144333,152073,152208,152209,152445) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '89' and ptpef2.products_extra_fields_value = '1000\' (305m)') and ptc.categories_id = 48 and p.products_id in (10066,10067,10068,10069,10070,10071,10512,10514,10516,10517,10519,11027,114349,121231,129505,135518,135519,135521,140504,142585,142586,142587,142588,142589,142594,144009,144333,152073,152208,152209,152445) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '89' and ptpef2.products_extra_fields_value = '1000\' (305m)') and ptc.categories_id = 48 and p.products_id in (10066,10067,10068,10069,10070,10071,10512,10514,10516,10517,10519,11027,114349,121231,129505,135518,135519,135521,140504,142585,142586,142587,142588,142589,142594,144009,144333,152073,152208,152209,152445) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '89' and ptpef2.products_extra_fields_value = '1000\' (305m)') and ptc.categories_id = 48 and p.products_id in (10066,10067,10068,10069,10070,10071,10512,10514,10516,10517,10519,11027,114349,121231,129505,135518,135519,135521,140504,142585,142586,142587,142588,142589,142594,144009,144333,152073,152208,152209,152445) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '89' and ptpef2.products_extra_fields_value = '1000\' (305m)') and ptc.categories_id = 48 and p.products_id in (10066,10067,10068,10069,10070,10071,10512,10514,10516,10517,10519,11027,114349,121231,129505,135518,135519,135521,140504,142585,142586,142587,142588,142589,142594,144009,144333,152073,152208,152209,152445) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '89' and ptpef2.products_extra_fields_value = '1000\' (305m)') and ptc.categories_id = 48 and p.products_id in (10066,10067,10068,10069,10070,10071,10512,10514,10516,10517,10519,11027,114349,121231,129505,135518,135519,135521,140504,142585,142586,142587,142588,142589,142594,144009,144333,152073,152208,152209,152445) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '89' and ptpef2.products_extra_fields_value = '1000\' (305m)') and ptc.categories_id = 48 and p.products_id in (10066,10067,10068,10069,10070,10071,10512,10514,10516,10517,10519,11027,114349,121231,129505,135518,135519,135521,140504,142585,142586,142587,142588,142589,142594,144009,144333,152073,152208,152209,152445) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '89' and ptpef2.products_extra_fields_value = '1000\' (305m)') and ptc.categories_id = 48 and p.products_id in (10066,10067,10068,10069,10070,10071,10512,10514,10516,10517,10519,11027,114349,121231,129505,135518,135519,135521,140504,142585,142586,142587,142588,142589,142594,144009,144333,152073,152208,152209,152445) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '27' and ptpef2.products_extra_fields_value = 'Pull Box') and ptc.categories_id = 48 and p.products_id in (10066,10067,10068,10069,10070,10071,10512,10514,10516,10517,10519,11027,114349,121231,129505,135518,135519,135521,140504,142585,142586,142587,142588,142589,142594,144009,144333,152073,152208,152209,152445) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '27' and ptpef2.products_extra_fields_value = 'Pull Box') and ptc.categories_id = 48 and p.products_id in (10066,10067,10068,10069,10070,10071,10512,10514,10516,10517,10519,11027,114349,121231,129505,135518,135519,135521,140504,142585,142586,142587,142588,142589,142594,144009,144333,152073,152208,152209,152445) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '27' and ptpef2.products_extra_fields_value = 'Pull Box') and ptc.categories_id = 48 and p.products_id in (10066,10067,10068,10069,10070,10071,10512,10514,10516,10517,10519,11027,114349,121231,129505,135518,135519,135521,140504,142585,142586,142587,142588,142589,142594,144009,144333,152073,152208,152209,152445) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '27' and ptpef2.products_extra_fields_value = 'Pull Box') and ptc.categories_id = 48 and p.products_id in (10066,10067,10068,10069,10070,10071,10512,10514,10516,10517,10519,11027,114349,121231,129505,135518,135519,135521,140504,142585,142586,142587,142588,142589,142594,144009,144333,152073,152208,152209,152445) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '27' and ptpef2.products_extra_fields_value = 'Pull Box') and ptc.categories_id = 48 and p.products_id in (10066,10067,10068,10069,10070,10071,10512,10514,10516,10517,10519,11027,114349,121231,129505,135518,135519,135521,140504,142585,142586,142587,142588,142589,142594,144009,144333,152073,152208,152209,152445) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '27' and ptpef2.products_extra_fields_value = 'Pull Box') and ptc.categories_id = 48 and p.products_id in (10066,10067,10068,10069,10070,10071,10512,10514,10516,10517,10519,11027,114349,121231,129505,135518,135519,135521,140504,142585,142586,142587,142588,142589,142594,144009,144333,152073,152208,152209,152445) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '27' and ptpef2.products_extra_fields_value = 'Pull Box') and ptc.categories_id = 48 and p.products_id in (10066,10067,10068,10069,10070,10071,10512,10514,10516,10517,10519,11027,114349,121231,129505,135518,135519,135521,140504,142585,142586,142587,142588,142589,142594,144009,144333,152073,152208,152209,152445) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '27' and ptpef2.products_extra_fields_value = 'Pull Box') and ptc.categories_id = 48 and p.products_id in (10066,10067,10068,10069,10070,10071,10512,10514,10516,10517,10519,11027,114349,121231,129505,135518,135519,135521,140504,142585,142586,142587,142588,142589,142594,144009,144333,152073,152208,152209,152445) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '27' and ptpef2.products_extra_fields_value = 'Pull Box') and ptc.categories_id = 48 and p.products_id in (10066,10067,10068,10069,10070,10071,10512,10514,10516,10517,10519,11027,114349,121231,129505,135518,135519,135521,140504,142585,142586,142587,142588,142589,142594,144009,144333,152073,152208,152209,152445) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '27' and ptpef2.products_extra_fields_value = 'Pull Box') and ptc.categories_id = 48 and p.products_id in (10066,10067,10068,10069,10070,10071,10512,10514,10516,10517,10519,11027,114349,121231,129505,135518,135519,135521,140504,142585,142586,142587,142588,142589,142594,144009,144333,152073,152208,152209,152445) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '27' and ptpef2.products_extra_fields_value = 'Pull Box') and ptc.categories_id = 48 and p.products_id in (10066,10067,10068,10069,10070,10071,10512,10514,10516,10517,10519,11027,114349,121231,129505,135518,135519,135521,140504,142585,142586,142587,142588,142589,142594,144009,144333,152073,152208,152209,152445) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '27' and ptpef2.products_extra_fields_value = 'Pull Box') and ptc.categories_id = 48 and p.products_id in (10066,10067,10068,10069,10070,10071,10512,10514,10516,10517,10519,11027,114349,121231,129505,135518,135519,135521,140504,142585,142586,142587,142588,142589,142594,144009,144333,152073,152208,152209,152445) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '27' and ptpef2.products_extra_fields_value = 'Pull Box') and ptc.categories_id = 48 and p.products_id in (10066,10067,10068,10069,10070,10071,10512,10514,10516,10517,10519,11027,114349,121231,129505,135518,135519,135521,140504,142585,142586,142587,142588,142589,142594,144009,144333,152073,152208,152209,152445) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '27' and ptpef2.products_extra_fields_value = 'Pull Box') and ptc.categories_id = 48 and p.products_id in (10066,10067,10068,10069,10070,10071,10512,10514,10516,10517,10519,11027,114349,121231,129505,135518,135519,135521,140504,142585,142586,142587,142588,142589,142594,144009,144333,152073,152208,152209,152445) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '27' and ptpef2.products_extra_fields_value = 'Pull Box') and ptc.categories_id = 48 and p.products_id in (10066,10067,10068,10069,10070,10071,10512,10514,10516,10517,10519,11027,114349,121231,129505,135518,135519,135521,140504,142585,142586,142587,142588,142589,142594,144009,144333,152073,152208,152209,152445) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '27' and ptpef2.products_extra_fields_value = 'Pull Box') and ptc.categories_id = 48 and p.products_id in (10066,10067,10068,10069,10070,10071,10512,10514,10516,10517,10519,11027,114349,121231,129505,135518,135519,135521,140504,142585,142586,142587,142588,142589,142594,144009,144333,152073,152208,152209,152445) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '27' and ptpef2.products_extra_fields_value = 'Pull Box') and ptc.categories_id = 48 and p.products_id in (10066,10067,10068,10069,10070,10071,10512,10514,10516,10517,10519,11027,114349,121231,129505,135518,135519,135521,140504,142585,142586,142587,142588,142589,142594,144009,144333,152073,152208,152209,152445) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '27' and ptpef2.products_extra_fields_value = 'Pull Box') and ptc.categories_id = 48 and p.products_id in (10066,10067,10068,10069,10070,10071,10512,10514,10516,10517,10519,11027,114349,121231,129505,135518,135519,135521,140504,142585,142586,142587,142588,142589,142594,144009,144333,152073,152208,152209,152445) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '27' and ptpef2.products_extra_fields_value = 'Pull Box') and ptc.categories_id = 48 and p.products_id in (10066,10067,10068,10069,10070,10071,10512,10514,10516,10517,10519,11027,114349,121231,129505,135518,135519,135521,140504,142585,142586,142587,142588,142589,142594,144009,144333,152073,152208,152209,152445) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '27' and ptpef2.products_extra_fields_value = 'Pull Box') and ptc.categories_id = 48 and p.products_id in (10066,10067,10068,10069,10070,10071,10512,10514,10516,10517,10519,11027,114349,121231,129505,135518,135519,135521,140504,142585,142586,142587,142588,142589,142594,144009,144333,152073,152208,152209,152445) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '27' and ptpef2.products_extra_fields_value = 'Pull Box') and ptc.categories_id = 48 and p.products_id in (10066,10067,10068,10069,10070,10071,10512,10514,10516,10517,10519,11027,114349,121231,129505,135518,135519,135521,140504,142585,142586,142587,142588,142589,142594,144009,144333,152073,152208,152209,152445) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '27' and ptpef2.products_extra_fields_value = 'Pull Box') and ptc.categories_id = 48 and p.products_id in (10066,10067,10068,10069,10070,10071,10512,10514,10516,10517,10519,11027,114349,121231,129505,135518,135519,135521,140504,142585,142586,142587,142588,142589,142594,144009,144333,152073,152208,152209,152445) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '27' and ptpef2.products_extra_fields_value = 'Pull Box') and ptc.categories_id = 48 and p.products_id in (10066,10067,10068,10069,10070,10071,10512,10514,10516,10517,10519,11027,114349,121231,129505,135518,135519,135521,140504,142585,142586,142587,142588,142589,142594,144009,144333,152073,152208,152209,152445) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '27' and ptpef2.products_extra_fields_value = 'Pull Box') and ptc.categories_id = 48 and p.products_id in (10066,10067,10068,10069,10070,10071,10512,10514,10516,10517,10519,11027,114349,121231,129505,135518,135519,135521,140504,142585,142586,142587,142588,142589,142594,144009,144333,152073,152208,152209,152445) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '27' and ptpef2.products_extra_fields_value = 'Pull Box') and ptc.categories_id = 48 and p.products_id in (10066,10067,10068,10069,10070,10071,10512,10514,10516,10517,10519,11027,114349,121231,129505,135518,135519,135521,140504,142585,142586,142587,142588,142589,142594,144009,144333,152073,152208,152209,152445) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '27' and ptpef2.products_extra_fields_value = 'Pull Box') and ptc.categories_id = 48 and p.products_id in (10066,10067,10068,10069,10070,10071,10512,10514,10516,10517,10519,11027,114349,121231,129505,135518,135519,135521,140504,142585,142586,142587,142588,142589,142594,144009,144333,152073,152208,152209,152445) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '27' and ptpef2.products_extra_fields_value = 'Pull Box') and ptc.categories_id = 48 and p.products_id in (10066,10067,10068,10069,10070,10071,10512,10514,10516,10517,10519,11027,114349,121231,129505,135518,135519,135521,140504,142585,142586,142587,142588,142589,142594,144009,144333,152073,152208,152209,152445) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '27' and ptpef2.products_extra_fields_value = 'Pull Box') and ptc.categories_id = 48 and p.products_id in (10066,10067,10068,10069,10070,10071,10512,10514,10516,10517,10519,11027,114349,121231,129505,135518,135519,135521,140504,142585,142586,142587,142588,142589,142594,144009,144333,152073,152208,152209,152445) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '27' and ptpef2.products_extra_fields_value = 'Pull Box') and ptc.categories_id = 48 and p.products_id in (10066,10067,10068,10069,10070,10071,10512,10514,10516,10517,10519,11027,114349,121231,129505,135518,135519,135521,140504,142585,142586,142587,142588,142589,142594,144009,144333,152073,152208,152209,152445) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '27' and ptpef2.products_extra_fields_value = 'Pull Box') and ptc.categories_id = 48 and p.products_id in (10066,10067,10068,10069,10070,10071,10512,10514,10516,10517,10519,11027,114349,121231,129505,135518,135519,135521,140504,142585,142586,142587,142588,142589,142594,144009,144333,152073,152208,152209,152445) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '27' and ptpef2.products_extra_fields_value = 'Pull Box') and ptc.categories_id = 48 and p.products_id in (10066,10067,10068,10069,10070,10071,10512,10514,10516,10517,10519,11027,114349,121231,129505,135518,135519,135521,140504,142585,142586,142587,142588,142589,142594,144009,144333,152073,152208,152209,152445) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '31' and ptpef2.products_extra_fields_value = 'Shielded') and ptc.categories_id = 48 and p.products_id in (10066,10067,10068,10069,10070,10071,10512,10514,10516,10517,10519,11027,114349,121231,129505,135518,135519,135521,140504,142585,142586,142587,142588,142589,142594,144009,144333,152073,152208,152209,152445) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '31' and ptpef2.products_extra_fields_value = 'Shielded') and ptc.categories_id = 48 and p.products_id in (10066,10067,10068,10069,10070,10071,10512,10514,10516,10517,10519,11027,114349,121231,129505,135518,135519,135521,140504,142585,142586,142587,142588,142589,142594,144009,144333,152073,152208,152209,152445) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '31' and ptpef2.products_extra_fields_value = 'Shielded') and ptc.categories_id = 48 and p.products_id in (10066,10067,10068,10069,10070,10071,10512,10514,10516,10517,10519,11027,114349,121231,129505,135518,135519,135521,140504,142585,142586,142587,142588,142589,142594,144009,144333,152073,152208,152209,152445) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '31' and ptpef2.products_extra_fields_value = 'Unshielded') and ptc.categories_id = 48 and p.products_id in (10066,10067,10068,10069,10070,10071,10512,10514,10516,10517,10519,11027,114349,121231,129505,135518,135519,135521,140504,142585,142586,142587,142588,142589,142594,144009,144333,152073,152208,152209,152445) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '31' and ptpef2.products_extra_fields_value = 'Unshielded') and ptc.categories_id = 48 and p.products_id in (10066,10067,10068,10069,10070,10071,10512,10514,10516,10517,10519,11027,114349,121231,129505,135518,135519,135521,140504,142585,142586,142587,142588,142589,142594,144009,144333,152073,152208,152209,152445) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '31' and ptpef2.products_extra_fields_value = 'Unshielded') and ptc.categories_id = 48 and p.products_id in (10066,10067,10068,10069,10070,10071,10512,10514,10516,10517,10519,11027,114349,121231,129505,135518,135519,135521,140504,142585,142586,142587,142588,142589,142594,144009,144333,152073,152208,152209,152445) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '31' and ptpef2.products_extra_fields_value = 'Unshielded') and ptc.categories_id = 48 and p.products_id in (10066,10067,10068,10069,10070,10071,10512,10514,10516,10517,10519,11027,114349,121231,129505,135518,135519,135521,140504,142585,142586,142587,142588,142589,142594,144009,144333,152073,152208,152209,152445) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '31' and ptpef2.products_extra_fields_value = 'Unshielded') and ptc.categories_id = 48 and p.products_id in (10066,10067,10068,10069,10070,10071,10512,10514,10516,10517,10519,11027,114349,121231,129505,135518,135519,135521,140504,142585,142586,142587,142588,142589,142594,144009,144333,152073,152208,152209,152445) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '31' and ptpef2.products_extra_fields_value = 'Unshielded') and ptc.categories_id = 48 and p.products_id in (10066,10067,10068,10069,10070,10071,10512,10514,10516,10517,10519,11027,114349,121231,129505,135518,135519,135521,140504,142585,142586,142587,142588,142589,142594,144009,144333,152073,152208,152209,152445) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '31' and ptpef2.products_extra_fields_value = 'Unshielded') and ptc.categories_id = 48 and p.products_id in (10066,10067,10068,10069,10070,10071,10512,10514,10516,10517,10519,11027,114349,121231,129505,135518,135519,135521,140504,142585,142586,142587,142588,142589,142594,144009,144333,152073,152208,152209,152445) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '31' and ptpef2.products_extra_fields_value = 'Unshielded') and ptc.categories_id = 48 and p.products_id in (10066,10067,10068,10069,10070,10071,10512,10514,10516,10517,10519,11027,114349,121231,129505,135518,135519,135521,140504,142585,142586,142587,142588,142589,142594,144009,144333,152073,152208,152209,152445) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '31' and ptpef2.products_extra_fields_value = 'Unshielded') and ptc.categories_id = 48 and p.products_id in (10066,10067,10068,10069,10070,10071,10512,10514,10516,10517,10519,11027,114349,121231,129505,135518,135519,135521,140504,142585,142586,142587,142588,142589,142594,144009,144333,152073,152208,152209,152445) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '31' and ptpef2.products_extra_fields_value = 'Unshielded') and ptc.categories_id = 48 and p.products_id in (10066,10067,10068,10069,10070,10071,10512,10514,10516,10517,10519,11027,114349,121231,129505,135518,135519,135521,140504,142585,142586,142587,142588,142589,142594,144009,144333,152073,152208,152209,152445) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '31' and ptpef2.products_extra_fields_value = 'Unshielded') and ptc.categories_id = 48 and p.products_id in (10066,10067,10068,10069,10070,10071,10512,10514,10516,10517,10519,11027,114349,121231,129505,135518,135519,135521,140504,142585,142586,142587,142588,142589,142594,144009,144333,152073,152208,152209,152445) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '31' and ptpef2.products_extra_fields_value = 'Unshielded') and ptc.categories_id = 48 and p.products_id in (10066,10067,10068,10069,10070,10071,10512,10514,10516,10517,10519,11027,114349,121231,129505,135518,135519,135521,140504,142585,142586,142587,142588,142589,142594,144009,144333,152073,152208,152209,152445) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '31' and ptpef2.products_extra_fields_value = 'Unshielded') and ptc.categories_id = 48 and p.products_id in (10066,10067,10068,10069,10070,10071,10512,10514,10516,10517,10519,11027,114349,121231,129505,135518,135519,135521,140504,142585,142586,142587,142588,142589,142594,144009,144333,152073,152208,152209,152445) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '31' and ptpef2.products_extra_fields_value = 'Unshielded') and ptc.categories_id = 48 and p.products_id in (10066,10067,10068,10069,10070,10071,10512,10514,10516,10517,10519,11027,114349,121231,129505,135518,135519,135521,140504,142585,142586,142587,142588,142589,142594,144009,144333,152073,152208,152209,152445) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '31' and ptpef2.products_extra_fields_value = 'Unshielded') and ptc.categories_id = 48 and p.products_id in (10066,10067,10068,10069,10070,10071,10512,10514,10516,10517,10519,11027,114349,121231,129505,135518,135519,135521,140504,142585,142586,142587,142588,142589,142594,144009,144333,152073,152208,152209,152445) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '31' and ptpef2.products_extra_fields_value = 'Unshielded') and ptc.categories_id = 48 and p.products_id in (10066,10067,10068,10069,10070,10071,10512,10514,10516,10517,10519,11027,114349,121231,129505,135518,135519,135521,140504,142585,142586,142587,142588,142589,142594,144009,144333,152073,152208,152209,152445) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '31' and ptpef2.products_extra_fields_value = 'Unshielded') and ptc.categories_id = 48 and p.products_id in (10066,10067,10068,10069,10070,10071,10512,10514,10516,10517,10519,11027,114349,121231,129505,135518,135519,135521,140504,142585,142586,142587,142588,142589,142594,144009,144333,152073,152208,152209,152445) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '31' and ptpef2.products_extra_fields_value = 'Unshielded') and ptc.categories_id = 48 and p.products_id in (10066,10067,10068,10069,10070,10071,10512,10514,10516,10517,10519,11027,114349,121231,129505,135518,135519,135521,140504,142585,142586,142587,142588,142589,142594,144009,144333,152073,152208,152209,152445) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '31' and ptpef2.products_extra_fields_value = 'Unshielded') and ptc.categories_id = 48 and p.products_id in (10066,10067,10068,10069,10070,10071,10512,10514,10516,10517,10519,11027,114349,121231,129505,135518,135519,135521,140504,142585,142586,142587,142588,142589,142594,144009,144333,152073,152208,152209,152445) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '31' and ptpef2.products_extra_fields_value = 'Unshielded') and ptc.categories_id = 48 and p.products_id in (10066,10067,10068,10069,10070,10071,10512,10514,10516,10517,10519,11027,114349,121231,129505,135518,135519,135521,140504,142585,142586,142587,142588,142589,142594,144009,144333,152073,152208,152209,152445) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '31' and ptpef2.products_extra_fields_value = 'Unshielded') and ptc.categories_id = 48 and p.products_id in (10066,10067,10068,10069,10070,10071,10512,10514,10516,10517,10519,11027,114349,121231,129505,135518,135519,135521,140504,142585,142586,142587,142588,142589,142594,144009,144333,152073,152208,152209,152445) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '31' and ptpef2.products_extra_fields_value = 'Unshielded') and ptc.categories_id = 48 and p.products_id in (10066,10067,10068,10069,10070,10071,10512,10514,10516,10517,10519,11027,114349,121231,129505,135518,135519,135521,140504,142585,142586,142587,142588,142589,142594,144009,144333,152073,152208,152209,152445) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '39' and ptpef2.products_extra_fields_value = '2') and ptc.categories_id = 48 and p.products_id in (10066,10067,10068,10069,10070,10071,10512,10514,10516,10517,10519,11027,114349,121231,129505,135518,135519,135521,140504,142585,142586,142587,142588,142589,142594,144009,144333,152073,152208,152209,152445) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '39' and ptpef2.products_extra_fields_value = '2') and ptc.categories_id = 48 and p.products_id in (10066,10067,10068,10069,10070,10071,10512,10514,10516,10517,10519,11027,114349,121231,129505,135518,135519,135521,140504,142585,142586,142587,142588,142589,142594,144009,144333,152073,152208,152209,152445) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '39' and ptpef2.products_extra_fields_value = '2') and ptc.categories_id = 48 and p.products_id in (10066,10067,10068,10069,10070,10071,10512,10514,10516,10517,10519,11027,114349,121231,129505,135518,135519,135521,140504,142585,142586,142587,142588,142589,142594,144009,144333,152073,152208,152209,152445) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '39' and ptpef2.products_extra_fields_value = '2') and ptc.categories_id = 48 and p.products_id in (10066,10067,10068,10069,10070,10071,10512,10514,10516,10517,10519,11027,114349,121231,129505,135518,135519,135521,140504,142585,142586,142587,142588,142589,142594,144009,144333,152073,152208,152209,152445) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '39' and ptpef2.products_extra_fields_value = '2') and ptc.categories_id = 48 and p.products_id in (10066,10067,10068,10069,10070,10071,10512,10514,10516,10517,10519,11027,114349,121231,129505,135518,135519,135521,140504,142585,142586,142587,142588,142589,142594,144009,144333,152073,152208,152209,152445) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '39' and ptpef2.products_extra_fields_value = '2') and ptc.categories_id = 48 and p.products_id in (10066,10067,10068,10069,10070,10071,10512,10514,10516,10517,10519,11027,114349,121231,129505,135518,135519,135521,140504,142585,142586,142587,142588,142589,142594,144009,144333,152073,152208,152209,152445) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '39' and ptpef2.products_extra_fields_value = '2') and ptc.categories_id = 48 and p.products_id in (10066,10067,10068,10069,10070,10071,10512,10514,10516,10517,10519,11027,114349,121231,129505,135518,135519,135521,140504,142585,142586,142587,142588,142589,142594,144009,144333,152073,152208,152209,152445) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '39' and ptpef2.products_extra_fields_value = '2') and ptc.categories_id = 48 and p.products_id in (10066,10067,10068,10069,10070,10071,10512,10514,10516,10517,10519,11027,114349,121231,129505,135518,135519,135521,140504,142585,142586,142587,142588,142589,142594,144009,144333,152073,152208,152209,152445) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '39' and ptpef2.products_extra_fields_value = '2') and ptc.categories_id = 48 and p.products_id in (10066,10067,10068,10069,10070,10071,10512,10514,10516,10517,10519,11027,114349,121231,129505,135518,135519,135521,140504,142585,142586,142587,142588,142589,142594,144009,144333,152073,152208,152209,152445) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '39' and ptpef2.products_extra_fields_value = '2') and ptc.categories_id = 48 and p.products_id in (10066,10067,10068,10069,10070,10071,10512,10514,10516,10517,10519,11027,114349,121231,129505,135518,135519,135521,140504,142585,142586,142587,142588,142589,142594,144009,144333,152073,152208,152209,152445) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '39' and ptpef2.products_extra_fields_value = '2') and ptc.categories_id = 48 and p.products_id in (10066,10067,10068,10069,10070,10071,10512,10514,10516,10517,10519,11027,114349,121231,129505,135518,135519,135521,140504,142585,142586,142587,142588,142589,142594,144009,144333,152073,152208,152209,152445) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '39' and ptpef2.products_extra_fields_value = '2') and ptc.categories_id = 48 and p.products_id in (10066,10067,10068,10069,10070,10071,10512,10514,10516,10517,10519,11027,114349,121231,129505,135518,135519,135521,140504,142585,142586,142587,142588,142589,142594,144009,144333,152073,152208,152209,152445) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '39' and ptpef2.products_extra_fields_value = '2') and ptc.categories_id = 48 and p.products_id in (10066,10067,10068,10069,10070,10071,10512,10514,10516,10517,10519,11027,114349,121231,129505,135518,135519,135521,140504,142585,142586,142587,142588,142589,142594,144009,144333,152073,152208,152209,152445) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '39' and ptpef2.products_extra_fields_value = '2') and ptc.categories_id = 48 and p.products_id in (10066,10067,10068,10069,10070,10071,10512,10514,10516,10517,10519,11027,114349,121231,129505,135518,135519,135521,140504,142585,142586,142587,142588,142589,142594,144009,144333,152073,152208,152209,152445) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '39' and ptpef2.products_extra_fields_value = '2') and ptc.categories_id = 48 and p.products_id in (10066,10067,10068,10069,10070,10071,10512,10514,10516,10517,10519,11027,114349,121231,129505,135518,135519,135521,140504,142585,142586,142587,142588,142589,142594,144009,144333,152073,152208,152209,152445) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '39' and ptpef2.products_extra_fields_value = '4') and ptc.categories_id = 48 and p.products_id in (10066,10067,10068,10069,10070,10071,10512,10514,10516,10517,10519,11027,114349,121231,129505,135518,135519,135521,140504,142585,142586,142587,142588,142589,142594,144009,144333,152073,152208,152209,152445) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '39' and ptpef2.products_extra_fields_value = '4') and ptc.categories_id = 48 and p.products_id in (10066,10067,10068,10069,10070,10071,10512,10514,10516,10517,10519,11027,114349,121231,129505,135518,135519,135521,140504,142585,142586,142587,142588,142589,142594,144009,144333,152073,152208,152209,152445) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '39' and ptpef2.products_extra_fields_value = '4') and ptc.categories_id = 48 and p.products_id in (10066,10067,10068,10069,10070,10071,10512,10514,10516,10517,10519,11027,114349,121231,129505,135518,135519,135521,140504,142585,142586,142587,142588,142589,142594,144009,144333,152073,152208,152209,152445) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '39' and ptpef2.products_extra_fields_value = '4') and ptc.categories_id = 48 and p.products_id in (10066,10067,10068,10069,10070,10071,10512,10514,10516,10517,10519,11027,114349,121231,129505,135518,135519,135521,140504,142585,142586,142587,142588,142589,142594,144009,144333,152073,152208,152209,152445) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '39' and ptpef2.products_extra_fields_value = '4') and ptc.categories_id = 48 and p.products_id in (10066,10067,10068,10069,10070,10071,10512,10514,10516,10517,10519,11027,114349,121231,129505,135518,135519,135521,140504,142585,142586,142587,142588,142589,142594,144009,144333,152073,152208,152209,152445) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '39' and ptpef2.products_extra_fields_value = '4') and ptc.categories_id = 48 and p.products_id in (10066,10067,10068,10069,10070,10071,10512,10514,10516,10517,10519,11027,114349,121231,129505,135518,135519,135521,140504,142585,142586,142587,142588,142589,142594,144009,144333,152073,152208,152209,152445) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '39' and ptpef2.products_extra_fields_value = '4') and ptc.categories_id = 48 and p.products_id in (10066,10067,10068,10069,10070,10071,10512,10514,10516,10517,10519,11027,114349,121231,129505,135518,135519,135521,140504,142585,142586,142587,142588,142589,142594,144009,144333,152073,152208,152209,152445) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '39' and ptpef2.products_extra_fields_value = '4') and ptc.categories_id = 48 and p.products_id in (10066,10067,10068,10069,10070,10071,10512,10514,10516,10517,10519,11027,114349,121231,129505,135518,135519,135521,140504,142585,142586,142587,142588,142589,142594,144009,144333,152073,152208,152209,152445) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '39' and ptpef2.products_extra_fields_value = '4') and ptc.categories_id = 48 and p.products_id in (10066,10067,10068,10069,10070,10071,10512,10514,10516,10517,10519,11027,114349,121231,129505,135518,135519,135521,140504,142585,142586,142587,142588,142589,142594,144009,144333,152073,152208,152209,152445) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '39' and ptpef2.products_extra_fields_value = '4') and ptc.categories_id = 48 and p.products_id in (10066,10067,10068,10069,10070,10071,10512,10514,10516,10517,10519,11027,114349,121231,129505,135518,135519,135521,140504,142585,142586,142587,142588,142589,142594,144009,144333,152073,152208,152209,152445) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '39' and ptpef2.products_extra_fields_value = '4') and ptc.categories_id = 48 and p.products_id in (10066,10067,10068,10069,10070,10071,10512,10514,10516,10517,10519,11027,114349,121231,129505,135518,135519,135521,140504,142585,142586,142587,142588,142589,142594,144009,144333,152073,152208,152209,152445) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '39' and ptpef2.products_extra_fields_value = '4') and ptc.categories_id = 48 and p.products_id in (10066,10067,10068,10069,10070,10071,10512,10514,10516,10517,10519,11027,114349,121231,129505,135518,135519,135521,140504,142585,142586,142587,142588,142589,142594,144009,144333,152073,152208,152209,152445) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '41' and ptpef2.products_extra_fields_value = '14') and ptc.categories_id = 48 and p.products_id in (10066,10067,10068,10069,10070,10071,10512,10514,10516,10517,10519,11027,114349,121231,129505,135518,135519,135521,140504,142585,142586,142587,142588,142589,142594,144009,144333,152073,152208,152209,152445) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '41' and ptpef2.products_extra_fields_value = '14') and ptc.categories_id = 48 and p.products_id in (10066,10067,10068,10069,10070,10071,10512,10514,10516,10517,10519,11027,114349,121231,129505,135518,135519,135521,140504,142585,142586,142587,142588,142589,142594,144009,144333,152073,152208,152209,152445) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '41' and ptpef2.products_extra_fields_value = '14') and ptc.categories_id = 48 and p.products_id in (10066,10067,10068,10069,10070,10071,10512,10514,10516,10517,10519,11027,114349,121231,129505,135518,135519,135521,140504,142585,142586,142587,142588,142589,142594,144009,144333,152073,152208,152209,152445) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '41' and ptpef2.products_extra_fields_value = '16') and ptc.categories_id = 48 and p.products_id in (10066,10067,10068,10069,10070,10071,10512,10514,10516,10517,10519,11027,114349,121231,129505,135518,135519,135521,140504,142585,142586,142587,142588,142589,142594,144009,144333,152073,152208,152209,152445) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '41' and ptpef2.products_extra_fields_value = '16') and ptc.categories_id = 48 and p.products_id in (10066,10067,10068,10069,10070,10071,10512,10514,10516,10517,10519,11027,114349,121231,129505,135518,135519,135521,140504,142585,142586,142587,142588,142589,142594,144009,144333,152073,152208,152209,152445) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '41' and ptpef2.products_extra_fields_value = '16') and ptc.categories_id = 48 and p.products_id in (10066,10067,10068,10069,10070,10071,10512,10514,10516,10517,10519,11027,114349,121231,129505,135518,135519,135521,140504,142585,142586,142587,142588,142589,142594,144009,144333,152073,152208,152209,152445) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '41' and ptpef2.products_extra_fields_value = '16') and ptc.categories_id = 48 and p.products_id in (10066,10067,10068,10069,10070,10071,10512,10514,10516,10517,10519,11027,114349,121231,129505,135518,135519,135521,140504,142585,142586,142587,142588,142589,142594,144009,144333,152073,152208,152209,152445) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '41' and ptpef2.products_extra_fields_value = '16') and ptc.categories_id = 48 and p.products_id in (10066,10067,10068,10069,10070,10071,10512,10514,10516,10517,10519,11027,114349,121231,129505,135518,135519,135521,140504,142585,142586,142587,142588,142589,142594,144009,144333,152073,152208,152209,152445) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '41' and ptpef2.products_extra_fields_value = '16') and ptc.categories_id = 48 and p.products_id in (10066,10067,10068,10069,10070,10071,10512,10514,10516,10517,10519,11027,114349,121231,129505,135518,135519,135521,140504,142585,142586,142587,142588,142589,142594,144009,144333,152073,152208,152209,152445) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '41' and ptpef2.products_extra_fields_value = '16') and ptc.categories_id = 48 and p.products_id in (10066,10067,10068,10069,10070,10071,10512,10514,10516,10517,10519,11027,114349,121231,129505,135518,135519,135521,140504,142585,142586,142587,142588,142589,142594,144009,144333,152073,152208,152209,152445) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '41' and ptpef2.products_extra_fields_value = '16') and ptc.categories_id = 48 and p.products_id in (10066,10067,10068,10069,10070,10071,10512,10514,10516,10517,10519,11027,114349,121231,129505,135518,135519,135521,140504,142585,142586,142587,142588,142589,142594,144009,144333,152073,152208,152209,152445) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '41' and ptpef2.products_extra_fields_value = '16') and ptc.categories_id = 48 and p.products_id in (10066,10067,10068,10069,10070,10071,10512,10514,10516,10517,10519,11027,114349,121231,129505,135518,135519,135521,140504,142585,142586,142587,142588,142589,142594,144009,144333,152073,152208,152209,152445) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '41' and ptpef2.products_extra_fields_value = '18') and ptc.categories_id = 48 and p.products_id in (10066,10067,10068,10069,10070,10071,10512,10514,10516,10517,10519,11027,114349,121231,129505,135518,135519,135521,140504,142585,142586,142587,142588,142589,142594,144009,144333,152073,152208,152209,152445) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '41' and ptpef2.products_extra_fields_value = '18') and ptc.categories_id = 48 and p.products_id in (10066,10067,10068,10069,10070,10071,10512,10514,10516,10517,10519,11027,114349,121231,129505,135518,135519,135521,140504,142585,142586,142587,142588,142589,142594,144009,144333,152073,152208,152209,152445) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '41' and ptpef2.products_extra_fields_value = '18') and ptc.categories_id = 48 and p.products_id in (10066,10067,10068,10069,10070,10071,10512,10514,10516,10517,10519,11027,114349,121231,129505,135518,135519,135521,140504,142585,142586,142587,142588,142589,142594,144009,144333,152073,152208,152209,152445) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '41' and ptpef2.products_extra_fields_value = '18') and ptc.categories_id = 48 and p.products_id in (10066,10067,10068,10069,10070,10071,10512,10514,10516,10517,10519,11027,114349,121231,129505,135518,135519,135521,140504,142585,142586,142587,142588,142589,142594,144009,144333,152073,152208,152209,152445) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '41' and ptpef2.products_extra_fields_value = '18') and ptc.categories_id = 48 and p.products_id in (10066,10067,10068,10069,10070,10071,10512,10514,10516,10517,10519,11027,114349,121231,129505,135518,135519,135521,140504,142585,142586,142587,142588,142589,142594,144009,144333,152073,152208,152209,152445) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '41' and ptpef2.products_extra_fields_value = '18') and ptc.categories_id = 48 and p.products_id in (10066,10067,10068,10069,10070,10071,10512,10514,10516,10517,10519,11027,114349,121231,129505,135518,135519,135521,140504,142585,142586,142587,142588,142589,142594,144009,144333,152073,152208,152209,152445) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '41' and ptpef2.products_extra_fields_value = '18') and ptc.categories_id = 48 and p.products_id in (10066,10067,10068,10069,10070,10071,10512,10514,10516,10517,10519,11027,114349,121231,129505,135518,135519,135521,140504,142585,142586,142587,142588,142589,142594,144009,144333,152073,152208,152209,152445) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '41' and ptpef2.products_extra_fields_value = '18') and ptc.categories_id = 48 and p.products_id in (10066,10067,10068,10069,10070,10071,10512,10514,10516,10517,10519,11027,114349,121231,129505,135518,135519,135521,140504,142585,142586,142587,142588,142589,142594,144009,144333,152073,152208,152209,152445) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '41' and ptpef2.products_extra_fields_value = '18') and ptc.categories_id = 48 and p.products_id in (10066,10067,10068,10069,10070,10071,10512,10514,10516,10517,10519,11027,114349,121231,129505,135518,135519,135521,140504,142585,142586,142587,142588,142589,142594,144009,144333,152073,152208,152209,152445) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '41' and ptpef2.products_extra_fields_value = '18') and ptc.categories_id = 48 and p.products_id in (10066,10067,10068,10069,10070,10071,10512,10514,10516,10517,10519,11027,114349,121231,129505,135518,135519,135521,140504,142585,142586,142587,142588,142589,142594,144009,144333,152073,152208,152209,152445) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '41' and ptpef2.products_extra_fields_value = '18') and ptc.categories_id = 48 and p.products_id in (10066,10067,10068,10069,10070,10071,10512,10514,10516,10517,10519,11027,114349,121231,129505,135518,135519,135521,140504,142585,142586,142587,142588,142589,142594,144009,144333,152073,152208,152209,152445) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '41' and ptpef2.products_extra_fields_value = '18') and ptc.categories_id = 48 and p.products_id in (10066,10067,10068,10069,10070,10071,10512,10514,10516,10517,10519,11027,114349,121231,129505,135518,135519,135521,140504,142585,142586,142587,142588,142589,142594,144009,144333,152073,152208,152209,152445) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '41' and ptpef2.products_extra_fields_value = '18') and ptc.categories_id = 48 and p.products_id in (10066,10067,10068,10069,10070,10071,10512,10514,10516,10517,10519,11027,114349,121231,129505,135518,135519,135521,140504,142585,142586,142587,142588,142589,142594,144009,144333,152073,152208,152209,152445) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '41' and ptpef2.products_extra_fields_value = '18') and ptc.categories_id = 48 and p.products_id in (10066,10067,10068,10069,10070,10071,10512,10514,10516,10517,10519,11027,114349,121231,129505,135518,135519,135521,140504,142585,142586,142587,142588,142589,142594,144009,144333,152073,152208,152209,152445) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '41' and ptpef2.products_extra_fields_value = '18') and ptc.categories_id = 48 and p.products_id in (10066,10067,10068,10069,10070,10071,10512,10514,10516,10517,10519,11027,114349,121231,129505,135518,135519,135521,140504,142585,142586,142587,142588,142589,142594,144009,144333,152073,152208,152209,152445) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '41' and ptpef2.products_extra_fields_value = '22') and ptc.categories_id = 48 and p.products_id in (10066,10067,10068,10069,10070,10071,10512,10514,10516,10517,10519,11027,114349,121231,129505,135518,135519,135521,140504,142585,142586,142587,142588,142589,142594,144009,144333,152073,152208,152209,152445) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '41' and ptpef2.products_extra_fields_value = '22') and ptc.categories_id = 48 and p.products_id in (10066,10067,10068,10069,10070,10071,10512,10514,10516,10517,10519,11027,114349,121231,129505,135518,135519,135521,140504,142585,142586,142587,142588,142589,142594,144009,144333,152073,152208,152209,152445) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '41' and ptpef2.products_extra_fields_value = '22') and ptc.categories_id = 48 and p.products_id in (10066,10067,10068,10069,10070,10071,10512,10514,10516,10517,10519,11027,114349,121231,129505,135518,135519,135521,140504,142585,142586,142587,142588,142589,142594,144009,144333,152073,152208,152209,152445) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '41' and ptpef2.products_extra_fields_value = '22') and ptc.categories_id = 48 and p.products_id in (10066,10067,10068,10069,10070,10071,10512,10514,10516,10517,10519,11027,114349,121231,129505,135518,135519,135521,140504,142585,142586,142587,142588,142589,142594,144009,144333,152073,152208,152209,152445) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '40' and ptpef2.products_extra_fields_value = 'Solid') and ptc.categories_id = 48 and p.products_id in (10066,10067,10068,10069,10070,10071,10512,10514,10516,10517,10519,11027,114349,121231,129505,135518,135519,135521,140504,142585,142586,142587,142588,142589,142594,144009,144333,152073,152208,152209,152445) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '40' and ptpef2.products_extra_fields_value = 'Solid') and ptc.categories_id = 48 and p.products_id in (10066,10067,10068,10069,10070,10071,10512,10514,10516,10517,10519,11027,114349,121231,129505,135518,135519,135521,140504,142585,142586,142587,142588,142589,142594,144009,144333,152073,152208,152209,152445) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '40' and ptpef2.products_extra_fields_value = 'Solid') and ptc.categories_id = 48 and p.products_id in (10066,10067,10068,10069,10070,10071,10512,10514,10516,10517,10519,11027,114349,121231,129505,135518,135519,135521,140504,142585,142586,142587,142588,142589,142594,144009,144333,152073,152208,152209,152445) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '40' and ptpef2.products_extra_fields_value = 'Solid') and ptc.categories_id = 48 and p.products_id in (10066,10067,10068,10069,10070,10071,10512,10514,10516,10517,10519,11027,114349,121231,129505,135518,135519,135521,140504,142585,142586,142587,142588,142589,142594,144009,144333,152073,152208,152209,152445) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '40' and ptpef2.products_extra_fields_value = 'Solid') and ptc.categories_id = 48 and p.products_id in (10066,10067,10068,10069,10070,10071,10512,10514,10516,10517,10519,11027,114349,121231,129505,135518,135519,135521,140504,142585,142586,142587,142588,142589,142594,144009,144333,152073,152208,152209,152445) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '40' and ptpef2.products_extra_fields_value = 'Solid') and ptc.categories_id = 48 and p.products_id in (10066,10067,10068,10069,10070,10071,10512,10514,10516,10517,10519,11027,114349,121231,129505,135518,135519,135521,140504,142585,142586,142587,142588,142589,142594,144009,144333,152073,152208,152209,152445) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '40' and ptpef2.products_extra_fields_value = 'Solid') and ptc.categories_id = 48 and p.products_id in (10066,10067,10068,10069,10070,10071,10512,10514,10516,10517,10519,11027,114349,121231,129505,135518,135519,135521,140504,142585,142586,142587,142588,142589,142594,144009,144333,152073,152208,152209,152445) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '40' and ptpef2.products_extra_fields_value = 'Solid') and ptc.categories_id = 48 and p.products_id in (10066,10067,10068,10069,10070,10071,10512,10514,10516,10517,10519,11027,114349,121231,129505,135518,135519,135521,140504,142585,142586,142587,142588,142589,142594,144009,144333,152073,152208,152209,152445) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '40' and ptpef2.products_extra_fields_value = 'Solid') and ptc.categories_id = 48 and p.products_id in (10066,10067,10068,10069,10070,10071,10512,10514,10516,10517,10519,11027,114349,121231,129505,135518,135519,135521,140504,142585,142586,142587,142588,142589,142594,144009,144333,152073,152208,152209,152445) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '40' and ptpef2.products_extra_fields_value = 'Solid') and ptc.categories_id = 48 and p.products_id in (10066,10067,10068,10069,10070,10071,10512,10514,10516,10517,10519,11027,114349,121231,129505,135518,135519,135521,140504,142585,142586,142587,142588,142589,142594,144009,144333,152073,152208,152209,152445) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '40' and ptpef2.products_extra_fields_value = 'Solid') and ptc.categories_id = 48 and p.products_id in (10066,10067,10068,10069,10070,10071,10512,10514,10516,10517,10519,11027,114349,121231,129505,135518,135519,135521,140504,142585,142586,142587,142588,142589,142594,144009,144333,152073,152208,152209,152445) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '40' and ptpef2.products_extra_fields_value = 'Solid') and ptc.categories_id = 48 and p.products_id in (10066,10067,10068,10069,10070,10071,10512,10514,10516,10517,10519,11027,114349,121231,129505,135518,135519,135521,140504,142585,142586,142587,142588,142589,142594,144009,144333,152073,152208,152209,152445) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '40' and ptpef2.products_extra_fields_value = 'Solid') and ptc.categories_id = 48 and p.products_id in (10066,10067,10068,10069,10070,10071,10512,10514,10516,10517,10519,11027,114349,121231,129505,135518,135519,135521,140504,142585,142586,142587,142588,142589,142594,144009,144333,152073,152208,152209,152445) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '40' and ptpef2.products_extra_fields_value = 'Solid') and ptc.categories_id = 48 and p.products_id in (10066,10067,10068,10069,10070,10071,10512,10514,10516,10517,10519,11027,114349,121231,129505,135518,135519,135521,140504,142585,142586,142587,142588,142589,142594,144009,144333,152073,152208,152209,152445) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '40' and ptpef2.products_extra_fields_value = 'Solid') and ptc.categories_id = 48 and p.products_id in (10066,10067,10068,10069,10070,10071,10512,10514,10516,10517,10519,11027,114349,121231,129505,135518,135519,135521,140504,142585,142586,142587,142588,142589,142594,144009,144333,152073,152208,152209,152445) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '40' and ptpef2.products_extra_fields_value = 'Solid') and ptc.categories_id = 48 and p.products_id in (10066,10067,10068,10069,10070,10071,10512,10514,10516,10517,10519,11027,114349,121231,129505,135518,135519,135521,140504,142585,142586,142587,142588,142589,142594,144009,144333,152073,152208,152209,152445) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '40' and ptpef2.products_extra_fields_value = 'Solid') and ptc.categories_id = 48 and p.products_id in (10066,10067,10068,10069,10070,10071,10512,10514,10516,10517,10519,11027,114349,121231,129505,135518,135519,135521,140504,142585,142586,142587,142588,142589,142594,144009,144333,152073,152208,152209,152445) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '40' and ptpef2.products_extra_fields_value = 'Solid') and ptc.categories_id = 48 and p.products_id in (10066,10067,10068,10069,10070,10071,10512,10514,10516,10517,10519,11027,114349,121231,129505,135518,135519,135521,140504,142585,142586,142587,142588,142589,142594,144009,144333,152073,152208,152209,152445) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '40' and ptpef2.products_extra_fields_value = 'Solid') and ptc.categories_id = 48 and p.products_id in (10066,10067,10068,10069,10070,10071,10512,10514,10516,10517,10519,11027,114349,121231,129505,135518,135519,135521,140504,142585,142586,142587,142588,142589,142594,144009,144333,152073,152208,152209,152445) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '40' and ptpef2.products_extra_fields_value = 'Solid') and ptc.categories_id = 48 and p.products_id in (10066,10067,10068,10069,10070,10071,10512,10514,10516,10517,10519,11027,114349,121231,129505,135518,135519,135521,140504,142585,142586,142587,142588,142589,142594,144009,144333,152073,152208,152209,152445) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '40' and ptpef2.products_extra_fields_value = 'Solid') and ptc.categories_id = 48 and p.products_id in (10066,10067,10068,10069,10070,10071,10512,10514,10516,10517,10519,11027,114349,121231,129505,135518,135519,135521,140504,142585,142586,142587,142588,142589,142594,144009,144333,152073,152208,152209,152445) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '40' and ptpef2.products_extra_fields_value = 'Solid') and ptc.categories_id = 48 and p.products_id in (10066,10067,10068,10069,10070,10071,10512,10514,10516,10517,10519,11027,114349,121231,129505,135518,135519,135521,140504,142585,142586,142587,142588,142589,142594,144009,144333,152073,152208,152209,152445) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '40' and ptpef2.products_extra_fields_value = 'Solid') and ptc.categories_id = 48 and p.products_id in (10066,10067,10068,10069,10070,10071,10512,10514,10516,10517,10519,11027,114349,121231,129505,135518,135519,135521,140504,142585,142586,142587,142588,142589,142594,144009,144333,152073,152208,152209,152445) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '40' and ptpef2.products_extra_fields_value = 'Solid') and ptc.categories_id = 48 and p.products_id in (10066,10067,10068,10069,10070,10071,10512,10514,10516,10517,10519,11027,114349,121231,129505,135518,135519,135521,140504,142585,142586,142587,142588,142589,142594,144009,144333,152073,152208,152209,152445) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '40' and ptpef2.products_extra_fields_value = 'Solid') and ptc.categories_id = 48 and p.products_id in (10066,10067,10068,10069,10070,10071,10512,10514,10516,10517,10519,11027,114349,121231,129505,135518,135519,135521,140504,142585,142586,142587,142588,142589,142594,144009,144333,152073,152208,152209,152445) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '40' and ptpef2.products_extra_fields_value = 'Solid') and ptc.categories_id = 48 and p.products_id in (10066,10067,10068,10069,10070,10071,10512,10514,10516,10517,10519,11027,114349,121231,129505,135518,135519,135521,140504,142585,142586,142587,142588,142589,142594,144009,144333,152073,152208,152209,152445) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '40' and ptpef2.products_extra_fields_value = 'Solid') and ptc.categories_id = 48 and p.products_id in (10066,10067,10068,10069,10070,10071,10512,10514,10516,10517,10519,11027,114349,121231,129505,135518,135519,135521,140504,142585,142586,142587,142588,142589,142594,144009,144333,152073,152208,152209,152445) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '40' and ptpef2.products_extra_fields_value = 'Solid') and ptc.categories_id = 48 and p.products_id in (10066,10067,10068,10069,10070,10071,10512,10514,10516,10517,10519,11027,114349,121231,129505,135518,135519,135521,140504,142585,142586,142587,142588,142589,142594,144009,144333,152073,152208,152209,152445) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '40' and ptpef2.products_extra_fields_value = 'Solid') and ptc.categories_id = 48 and p.products_id in (10066,10067,10068,10069,10070,10071,10512,10514,10516,10517,10519,11027,114349,121231,129505,135518,135519,135521,140504,142585,142586,142587,142588,142589,142594,144009,144333,152073,152208,152209,152445) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_categories ptc on p.products_id = ptc.products_id
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '40' and ptpef2.products_extra_fields_value = 'Stranded') and ptc.categories_id = 48 and p.products_id in (10066,10067,10068,10069,10070,10071,10512,10514,10516,10517,10519,11027,114349,121231,129505,135518,135519,135521,140504,142585,142586,142587,142588,142589,142594,144009,144333,152073,152208,152209,152445) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
Fire
Category
Brand
Condumex Inc
Genesis Cable
Price
Cable Jacket
Direct Burial
Plenum
Riser
Color
Black
Red
White
Installation
Direct Burial
Length
500' (152m)
1000' (305m)
Physical Format
Pull Box
Protection
Shielded
Unshielded
Strands / Conductors
2
4
Wire (Awg)
14
16
18
22
Wire Construction
Solid
Stranded
from ( products p left join specials s on (s.products_id = p.products_id and s.status = 1)) left join manufacturers m on p.manufacturers_id = m.manufacturers_id left join products_to_products_extra_fields p2pef on p.products_id = p2pef.products_id , products_description pd, categories c, products_to_categories p2c
where (p.products_status = 1) and p.products_id = pd.products_id and pd.language_id = '1' and p.products_id = p2c.products_id and p2c.categories_id = c.categories_id and p2c.products_id = p.products_id and p2c.products_id = pd.products_id and (p2c.categories_id = '48') and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
group by p.products_id order by p.products_sort_order, p.products_date_available desc, p.products_last_views desc, pd.products_name
Kewords:
Plural keywords:
  31 items |
1 2 ▶ |
| 31 items | 1 2 ▶ |