English
SpanishLanguage:
EnglishEspañol
Need help? Reach us at 1800.325.9708
Live Support
Digital Watchdog
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '26' and ptpef2.products_extra_fields_value = 'Built-In Mic') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '26' and ptpef2.products_extra_fields_value = 'Mic In') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '26' and ptpef2.products_extra_fields_value = '2-Way') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '13' and ptpef2.products_extra_fields_value = 'Black') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '13' and ptpef2.products_extra_fields_value = 'White') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '13' and ptpef2.products_extra_fields_value = 'White') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '13' and ptpef2.products_extra_fields_value = 'White') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '13' and ptpef2.products_extra_fields_value = 'White') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '13' and ptpef2.products_extra_fields_value = 'White') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '13' and ptpef2.products_extra_fields_value = 'White') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '13' and ptpef2.products_extra_fields_value = 'White') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '13' and ptpef2.products_extra_fields_value = 'White') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '13' and ptpef2.products_extra_fields_value = 'White') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '13' and ptpef2.products_extra_fields_value = 'White') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '13' and ptpef2.products_extra_fields_value = 'White') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '13' and ptpef2.products_extra_fields_value = 'White') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '13' and ptpef2.products_extra_fields_value = 'White') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '13' and ptpef2.products_extra_fields_value = 'White') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '13' and ptpef2.products_extra_fields_value = 'White') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '13' and ptpef2.products_extra_fields_value = 'White') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '13' and ptpef2.products_extra_fields_value = 'White') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '13' and ptpef2.products_extra_fields_value = 'White') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '5' and ptpef2.products_extra_fields_value = 'H.265') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '5' and ptpef2.products_extra_fields_value = 'H.265 / H.264 / MJPEG') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '5' and ptpef2.products_extra_fields_value = 'H.265 / H.264 / MJPEG') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '5' and ptpef2.products_extra_fields_value = 'H.265 / H.264 / MJPEG') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '5' and ptpef2.products_extra_fields_value = 'H.265 / H.264 / MJPEG') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '5' and ptpef2.products_extra_fields_value = 'H.265 / H.264 / MJPEG') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '5' and ptpef2.products_extra_fields_value = 'H.265 / H.264 / MJPEG') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '5' and ptpef2.products_extra_fields_value = 'H.265 / H.264 / MJPEG') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '5' and ptpef2.products_extra_fields_value = 'H.265 / H.264 / MJPEG') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '5' and ptpef2.products_extra_fields_value = 'H.265 / H.264 / MJPEG') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '5' and ptpef2.products_extra_fields_value = 'H.265 / H.264 / MJPEG') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '5' and ptpef2.products_extra_fields_value = 'H.265 / H.264 / MJPEG') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '5' and ptpef2.products_extra_fields_value = 'H.265 / H.264 / MJPEG') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '5' and ptpef2.products_extra_fields_value = 'H.265 / H.264 / MJPEG') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '5' and ptpef2.products_extra_fields_value = 'H.265 / H.264 / MJPEG') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '5' and ptpef2.products_extra_fields_value = 'H.265 / H.264 / MJPEG') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '5' and ptpef2.products_extra_fields_value = 'H.265 / H.264 / MJPEG') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '5' and ptpef2.products_extra_fields_value = 'H.265 / H.264 / MJPEG') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '5' and ptpef2.products_extra_fields_value = 'H.265 / H.264 / MJPEG') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '5' and ptpef2.products_extra_fields_value = 'H.265 / H.264 / MJPEG') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '1' and ptpef2.products_extra_fields_value = 'Ethernet') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '1' and ptpef2.products_extra_fields_value = 'Ethernet') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '1' and ptpef2.products_extra_fields_value = 'Ethernet') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '1' and ptpef2.products_extra_fields_value = 'Ethernet') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '1' and ptpef2.products_extra_fields_value = 'Ethernet') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '1' and ptpef2.products_extra_fields_value = 'Ethernet') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '1' and ptpef2.products_extra_fields_value = 'Ethernet') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '1' and ptpef2.products_extra_fields_value = 'Wired') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '1' and ptpef2.products_extra_fields_value = 'Wired') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '1' and ptpef2.products_extra_fields_value = 'Wired') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '1' and ptpef2.products_extra_fields_value = 'Wired') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '22' and ptpef2.products_extra_fields_value = '2.65') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '22' and ptpef2.products_extra_fields_value = '3.15') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '22' and ptpef2.products_extra_fields_value = '4.1') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '22' and ptpef2.products_extra_fields_value = '4.13') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '22' and ptpef2.products_extra_fields_value = '4.66') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '22' and ptpef2.products_extra_fields_value = '4.66') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '22' and ptpef2.products_extra_fields_value = '4.66') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '22' and ptpef2.products_extra_fields_value = '4.72') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '22' and ptpef2.products_extra_fields_value = '4.9') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '22' and ptpef2.products_extra_fields_value = '4.92') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '22' and ptpef2.products_extra_fields_value = '4.92') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '22' and ptpef2.products_extra_fields_value = '5.16') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '22' and ptpef2.products_extra_fields_value = '5.47') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '22' and ptpef2.products_extra_fields_value = '5.47') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '22' and ptpef2.products_extra_fields_value = '5.47') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '22' and ptpef2.products_extra_fields_value = '5.7') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '20' and ptpef2.products_extra_fields_value = 'Outdoor') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '20' and ptpef2.products_extra_fields_value = 'Outdoor') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '20' and ptpef2.products_extra_fields_value = 'Outdoor') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '20' and ptpef2.products_extra_fields_value = 'Outdoor') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '20' and ptpef2.products_extra_fields_value = 'Outdoor') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '20' and ptpef2.products_extra_fields_value = 'Outdoor') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '20' and ptpef2.products_extra_fields_value = 'Outdoor') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '20' and ptpef2.products_extra_fields_value = 'Outdoor') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '20' and ptpef2.products_extra_fields_value = 'Outdoor') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '20' and ptpef2.products_extra_fields_value = 'Outdoor') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '20' and ptpef2.products_extra_fields_value = 'Outdoor') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '20' and ptpef2.products_extra_fields_value = 'Outdoor') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '20' and ptpef2.products_extra_fields_value = 'Outdoor') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '20' and ptpef2.products_extra_fields_value = 'Outdoor') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '20' and ptpef2.products_extra_fields_value = 'Outdoor') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '20' and ptpef2.products_extra_fields_value = 'Outdoor') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '20' and ptpef2.products_extra_fields_value = 'Outdoor') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '20' and ptpef2.products_extra_fields_value = 'Outdoor') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '20' and ptpef2.products_extra_fields_value = 'Outdoor') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '20' and ptpef2.products_extra_fields_value = 'Outdoor') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '20' and ptpef2.products_extra_fields_value = 'Outdoor') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '20' and ptpef2.products_extra_fields_value = 'Outdoor') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '20' and ptpef2.products_extra_fields_value = 'Outdoor') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '20' and ptpef2.products_extra_fields_value = 'Outdoor') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '20' and ptpef2.products_extra_fields_value = 'Outdoor') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '3' and ptpef2.products_extra_fields_value = 'MegaPix') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '3' and ptpef2.products_extra_fields_value = 'MegaPix') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '3' and ptpef2.products_extra_fields_value = 'MegaPix') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '3' and ptpef2.products_extra_fields_value = 'MegaPix') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '11' and ptpef2.products_extra_fields_value = 'Ceiling') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '11' and ptpef2.products_extra_fields_value = 'Ceiling') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '11' and ptpef2.products_extra_fields_value = 'Ceiling') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '11' and ptpef2.products_extra_fields_value = 'Wall / Ceiling') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '11' and ptpef2.products_extra_fields_value = 'Wall / Ceiling') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '19' and ptpef2.products_extra_fields_value = '100') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '19' and ptpef2.products_extra_fields_value = '100') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '19' and ptpef2.products_extra_fields_value = '100') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '19' and ptpef2.products_extra_fields_value = '100') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '19' and ptpef2.products_extra_fields_value = '100') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '19' and ptpef2.products_extra_fields_value = '100') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '19' and ptpef2.products_extra_fields_value = '100') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '19' and ptpef2.products_extra_fields_value = '100') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '19' and ptpef2.products_extra_fields_value = '100') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '19' and ptpef2.products_extra_fields_value = '100') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '19' and ptpef2.products_extra_fields_value = '100') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '19' and ptpef2.products_extra_fields_value = '164') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '19' and ptpef2.products_extra_fields_value = '164') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '19' and ptpef2.products_extra_fields_value = '164') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '19' and ptpef2.products_extra_fields_value = '1148') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '18' and ptpef2.products_extra_fields_value = '30') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '18' and ptpef2.products_extra_fields_value = '30') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '18' and ptpef2.products_extra_fields_value = '30') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '18' and ptpef2.products_extra_fields_value = '30') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '18' and ptpef2.products_extra_fields_value = '30') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '18' and ptpef2.products_extra_fields_value = '30') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '18' and ptpef2.products_extra_fields_value = '30') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '18' and ptpef2.products_extra_fields_value = '30') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '18' and ptpef2.products_extra_fields_value = '30.48') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '18' and ptpef2.products_extra_fields_value = '30.48') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '18' and ptpef2.products_extra_fields_value = '30.48') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '18' and ptpef2.products_extra_fields_value = '49') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '18' and ptpef2.products_extra_fields_value = '50') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '18' and ptpef2.products_extra_fields_value = '50') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '18' and ptpef2.products_extra_fields_value = '350') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '17' and ptpef2.products_extra_fields_value = '2.7 - 12') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '17' and ptpef2.products_extra_fields_value = '2.7 - 13.5') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '17' and ptpef2.products_extra_fields_value = '2.7 - 13.5') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '17' and ptpef2.products_extra_fields_value = '2.7 - 13.5') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '17' and ptpef2.products_extra_fields_value = '2.7 - 13.5') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '17' and ptpef2.products_extra_fields_value = '2.7 - 13.5') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '17' and ptpef2.products_extra_fields_value = '2.8') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '17' and ptpef2.products_extra_fields_value = '2.8') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '17' and ptpef2.products_extra_fields_value = '2.8') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '17' and ptpef2.products_extra_fields_value = '2.8') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '17' and ptpef2.products_extra_fields_value = '2.8') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '17' and ptpef2.products_extra_fields_value = '2.8') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '17' and ptpef2.products_extra_fields_value = '2.8') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '17' and ptpef2.products_extra_fields_value = '2.8') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '17' and ptpef2.products_extra_fields_value = '2.8') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '17' and ptpef2.products_extra_fields_value = '2.8') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '17' and ptpef2.products_extra_fields_value = '2.8 - 12') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '17' and ptpef2.products_extra_fields_value = '2.8 - 12') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '17' and ptpef2.products_extra_fields_value = '2.8 - 12') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '17' and ptpef2.products_extra_fields_value = '2.8 - 12') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '17' and ptpef2.products_extra_fields_value = '3.6') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '17' and ptpef2.products_extra_fields_value = '4') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '17' and ptpef2.products_extra_fields_value = '4') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '17' and ptpef2.products_extra_fields_value = '6') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '17' and ptpef2.products_extra_fields_value = '6.5 - 260') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '16' and ptpef2.products_extra_fields_value = 'Fix') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '16' and ptpef2.products_extra_fields_value = 'Fix') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '16' and ptpef2.products_extra_fields_value = 'Fix') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '16' and ptpef2.products_extra_fields_value = 'Fix') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '16' and ptpef2.products_extra_fields_value = 'Fix') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '16' and ptpef2.products_extra_fields_value = 'Fix') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '16' and ptpef2.products_extra_fields_value = 'Fix') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '16' and ptpef2.products_extra_fields_value = 'Fix') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '16' and ptpef2.products_extra_fields_value = 'Fix') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '16' and ptpef2.products_extra_fields_value = 'Fix') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '16' and ptpef2.products_extra_fields_value = 'Fix') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '16' and ptpef2.products_extra_fields_value = 'Fix') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '16' and ptpef2.products_extra_fields_value = 'Fix') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '16' and ptpef2.products_extra_fields_value = 'Fix') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '16' and ptpef2.products_extra_fields_value = 'Fix') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '16' and ptpef2.products_extra_fields_value = 'Motorized') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '16' and ptpef2.products_extra_fields_value = 'Varifocal') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '16' and ptpef2.products_extra_fields_value = 'Varifocal') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '16' and ptpef2.products_extra_fields_value = 'Varifocal') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '16' and ptpef2.products_extra_fields_value = 'Varifocal') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '16' and ptpef2.products_extra_fields_value = 'Varifocal') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '16' and ptpef2.products_extra_fields_value = 'Varifocal') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '16' and ptpef2.products_extra_fields_value = 'Varifocal') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '16' and ptpef2.products_extra_fields_value = 'Varifocal') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '16' and ptpef2.products_extra_fields_value = 'Varifocal') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '16' and ptpef2.products_extra_fields_value = 'Varifocal') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '8' and ptpef2.products_extra_fields_value = '12 VDC') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '8' and ptpef2.products_extra_fields_value = '12 VDC') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '8' and ptpef2.products_extra_fields_value = '12 VDC') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '8' and ptpef2.products_extra_fields_value = '12 VDC / 24 VAC') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '8' and ptpef2.products_extra_fields_value = '12 VDC / 24 VAC') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '8' and ptpef2.products_extra_fields_value = '12 VDC / 24 VAC') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '8' and ptpef2.products_extra_fields_value = '12 VDC / POE') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '8' and ptpef2.products_extra_fields_value = '12 VDC / POE') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '8' and ptpef2.products_extra_fields_value = '12 VDC / POE') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '8' and ptpef2.products_extra_fields_value = '12 VDC / POE') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '8' and ptpef2.products_extra_fields_value = '12 VDC / POE') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '8' and ptpef2.products_extra_fields_value = '12 VDC / POE') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '8' and ptpef2.products_extra_fields_value = '12 VDC / POE') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '8' and ptpef2.products_extra_fields_value = '12 VDC / POE') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '8' and ptpef2.products_extra_fields_value = '12 VDC / POE') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '8' and ptpef2.products_extra_fields_value = '12 VDC / POE') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '8' and ptpef2.products_extra_fields_value = '12 VDC / POE') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '8' and ptpef2.products_extra_fields_value = '12 VDC / POE') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '8' and ptpef2.products_extra_fields_value = '12 VDC / POE') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '8' and ptpef2.products_extra_fields_value = '12 VDC / POE') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '8' and ptpef2.products_extra_fields_value = '12 VDC / POE') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '8' and ptpef2.products_extra_fields_value = '12 VDC / POE') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '8' and ptpef2.products_extra_fields_value = '12 VDC / POE') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '8' and ptpef2.products_extra_fields_value = '24 VAC / POE') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '85' and ptpef2.products_extra_fields_value = '40') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '29' and ptpef2.products_extra_fields_value = '12 VDC / POE') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '29' and ptpef2.products_extra_fields_value = '12 VDC / POE') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '23' and ptpef2.products_extra_fields_value = '1.7') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '23' and ptpef2.products_extra_fields_value = '5.5') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '23' and ptpef2.products_extra_fields_value = '6.5') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '23' and ptpef2.products_extra_fields_value = '7') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '23' and ptpef2.products_extra_fields_value = '7') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '23' and ptpef2.products_extra_fields_value = '7.5') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '23' and ptpef2.products_extra_fields_value = '9') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '23' and ptpef2.products_extra_fields_value = '9.5') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '21' and ptpef2.products_extra_fields_value = 'IP66') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '21' and ptpef2.products_extra_fields_value = 'IP66') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '21' and ptpef2.products_extra_fields_value = 'IP66') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '21' and ptpef2.products_extra_fields_value = 'IP66') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '21' and ptpef2.products_extra_fields_value = 'IP66') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '21' and ptpef2.products_extra_fields_value = 'IP66') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '21' and ptpef2.products_extra_fields_value = 'IP67') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '21' and ptpef2.products_extra_fields_value = 'IP67') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '21' and ptpef2.products_extra_fields_value = 'IP67') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '21' and ptpef2.products_extra_fields_value = 'IP67') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '21' and ptpef2.products_extra_fields_value = 'IP67') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '21' and ptpef2.products_extra_fields_value = 'IP67') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '21' and ptpef2.products_extra_fields_value = 'IP67') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '21' and ptpef2.products_extra_fields_value = 'IP67') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '21' and ptpef2.products_extra_fields_value = 'IP67') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '21' and ptpef2.products_extra_fields_value = 'IP67') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '21' and ptpef2.products_extra_fields_value = 'IP67') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '21' and ptpef2.products_extra_fields_value = 'IP67') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '21' and ptpef2.products_extra_fields_value = 'IP67') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '21' and ptpef2.products_extra_fields_value = 'IP67') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '21' and ptpef2.products_extra_fields_value = 'IP67') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '21' and ptpef2.products_extra_fields_value = 'IP67') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '21' and ptpef2.products_extra_fields_value = 'IP67') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '21' and ptpef2.products_extra_fields_value = 'IP68') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '21' and ptpef2.products_extra_fields_value = 'IP68') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '15' and ptpef2.products_extra_fields_value = '2 MP') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '15' and ptpef2.products_extra_fields_value = '2.1 MP') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '15' and ptpef2.products_extra_fields_value = '2.1 MP') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '15' and ptpef2.products_extra_fields_value = '2.1 MP') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '15' and ptpef2.products_extra_fields_value = '2.1 MP') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '15' and ptpef2.products_extra_fields_value = '2.1 MP') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '15' and ptpef2.products_extra_fields_value = '4 MP') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '15' and ptpef2.products_extra_fields_value = '4 MP') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '15' and ptpef2.products_extra_fields_value = '4 MP') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '15' and ptpef2.products_extra_fields_value = '4 MP') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '15' and ptpef2.products_extra_fields_value = '4 MP') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '15' and ptpef2.products_extra_fields_value = '5 MP') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '15' and ptpef2.products_extra_fields_value = '5 MP') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '15' and ptpef2.products_extra_fields_value = '5 MP') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '15' and ptpef2.products_extra_fields_value = '5 MP') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '15' and ptpef2.products_extra_fields_value = '5 MP') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '15' and ptpef2.products_extra_fields_value = '5 MP') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '15' and ptpef2.products_extra_fields_value = '5 MP') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '15' and ptpef2.products_extra_fields_value = '5 MP') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '15' and ptpef2.products_extra_fields_value = '5 MP') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '15' and ptpef2.products_extra_fields_value = '5 MP') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '15' and ptpef2.products_extra_fields_value = '5 MP') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '24' and ptpef2.products_extra_fields_value = 'IK09') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '24' and ptpef2.products_extra_fields_value = 'IK10') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '24' and ptpef2.products_extra_fields_value = 'IK10') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '24' and ptpef2.products_extra_fields_value = 'IK10') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '24' and ptpef2.products_extra_fields_value = 'IK10') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '24' and ptpef2.products_extra_fields_value = 'IK10') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '24' and ptpef2.products_extra_fields_value = 'IK10') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '24' and ptpef2.products_extra_fields_value = 'IK10') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '24' and ptpef2.products_extra_fields_value = 'IK10') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '24' and ptpef2.products_extra_fields_value = 'IK10') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '24' and ptpef2.products_extra_fields_value = 'IK10') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '24' and ptpef2.products_extra_fields_value = 'IK10') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '24' and ptpef2.products_extra_fields_value = 'IK10') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '24' and ptpef2.products_extra_fields_value = 'IK10') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '24' and ptpef2.products_extra_fields_value = 'IK10') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '24' and ptpef2.products_extra_fields_value = 'IK10') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '24' and ptpef2.products_extra_fields_value = 'IK10') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '24' and ptpef2.products_extra_fields_value = 'IK10') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '24' and ptpef2.products_extra_fields_value = 'IK10') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '24' and ptpef2.products_extra_fields_value = 'IK10') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '24' and ptpef2.products_extra_fields_value = 'IK10') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '24' and ptpef2.products_extra_fields_value = 'IK10') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '36' and ptpef2.products_extra_fields_value = '1080P') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '10' and ptpef2.products_extra_fields_value = 'CVI, CVBS') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '10' and ptpef2.products_extra_fields_value = 'IP') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '10' and ptpef2.products_extra_fields_value = 'IP') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '10' and ptpef2.products_extra_fields_value = 'IP') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '10' and ptpef2.products_extra_fields_value = 'IP') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '10' and ptpef2.products_extra_fields_value = 'IP') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '10' and ptpef2.products_extra_fields_value = 'IP') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '10' and ptpef2.products_extra_fields_value = 'IP') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '10' and ptpef2.products_extra_fields_value = 'TVI, CVI, AHD, CVBS') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '10' and ptpef2.products_extra_fields_value = 'TVI, CVI, AHD, CVBS') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '10' and ptpef2.products_extra_fields_value = 'TVI, CVI, CVBS') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '34' and ptpef2.products_extra_fields_value = 'TRUE') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '34' and ptpef2.products_extra_fields_value = 'TRUE') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '34' and ptpef2.products_extra_fields_value = 'TRUE') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '34' and ptpef2.products_extra_fields_value = 'TRUE') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '34' and ptpef2.products_extra_fields_value = 'TRUE') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '34' and ptpef2.products_extra_fields_value = 'TRUE') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '34' and ptpef2.products_extra_fields_value = 'TRUE') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '34' and ptpef2.products_extra_fields_value = 'TRUE') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '34' and ptpef2.products_extra_fields_value = 'TRUE') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '34' and ptpef2.products_extra_fields_value = 'TRUE') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '34' and ptpef2.products_extra_fields_value = 'TRUE') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '34' and ptpef2.products_extra_fields_value = 'TRUE') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '34' and ptpef2.products_extra_fields_value = 'TRUE') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '34' and ptpef2.products_extra_fields_value = 'TRUE') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '34' and ptpef2.products_extra_fields_value = 'TRUE') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '34' and ptpef2.products_extra_fields_value = 'TRUE') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '34' and ptpef2.products_extra_fields_value = 'TRUE') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '34' and ptpef2.products_extra_fields_value = 'TRUE') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '34' and ptpef2.products_extra_fields_value = 'TRUE') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '34' and ptpef2.products_extra_fields_value = 'TRUE') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '34' and ptpef2.products_extra_fields_value = 'TRUE') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '34' and ptpef2.products_extra_fields_value = 'TRUE') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '34' and ptpef2.products_extra_fields_value = 'TRUE') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '34' and ptpef2.products_extra_fields_value = 'TRUE') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '34' and ptpef2.products_extra_fields_value = 'TRUE') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '34' and ptpef2.products_extra_fields_value = 'TRUE') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
select count(distinct(p.products_id)) as total
from products p
left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id
left join products_models_to_products p2m on p2m.products_id = p.products_id
left join products_models pm on pm.ID = p2m.model_id
where
(p.products_status = 1)
and (ptpef2.products_extra_fields_id = '34' and ptpef2.products_extra_fields_value = 'TRUE') and p.manufacturers_id = 4838 and p.products_id in (10604,11518,11531,130859,140385,140460,141919,142315,143982,143983,144703,144704,145480,145481,145785,146006,146008,146010,146293,146294,146295,146374,146375,146921,149442,151665,152164) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
Brand
Digital Watchdog
Price
Audio
Built-In Mic
Mic In
2-Way
Color
Black
White
Compression
H.265
H.265 / H.264 / MJPEG
Connectivity
Ethernet
Wired
Diameter (In)
2.65
3.15
4.1
4.13
4.66
4.72
4.9
4.92
5.16
5.47
5.7
Environment
Outdoor
Family
MegaPix
Installation
Ceiling
Wall / Ceiling
IR (Ft)
100
164
1148
IR (M)
30
30.48
49
50
350
Lens Size (mm)
2.7 - 12
2.7 - 13.5
2.8
2.8 - 12
3.6
4
6
6.5 - 260
Lens Type
Fix
Motorized
Varifocal
Operating Voltage
12 VDC
12 VDC / 24 VAC
12 VDC / POE
24 VAC / POE
Optical Zoom X
40
Output Voltage
12 VDC / POE
Power Consumption (W)
1.7
5.5
6.5
7
7.5
9
9.5
Rating
IP66
IP67
IP68
Resolution
2 MP
2.1 MP
4 MP
5 MP
Vandal
IK09
IK10
Video Output Resolution
1080P
Video Technology
CVI, CVBS
IP
TVI, CVI, AHD, CVBS
TVI, CVI, CVBS
WDR (Db)
TRUE
  27 items |
1 2 ▶ |
| 27 items | 1 2 ▶ |