Log Out Log Out Log Out Log Outopen invoices
Language:
EnglishEspaƱol
Shopping Cart Icon
Arror Down Icon
My Shopping Cart
alt"Ajax close button images"
Your shopping cart is empty
Need help? Reach us at 1800.325.9708 Live Support
Home » Brands » Digital Watchdog

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")
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
Pixel Trans
Pixel Trans
 Grid  List      27 items    
 1  2   
2.1MP Indoor Dome 2.8-12MM Camera
2.1MP Indoor Dome 2.8-12MM Camera
# DWC-D3263WTIR
Digital Watchdog
Log In To View
Prices
 
2.1MP Indoor/Outdoor Vandal Dome 2.8-12MM Camera
2.1MP Indoor/Outdoor Vandal Dome 2.8-12MM Camera
# DWC-V6263WTIR
Digital Watchdog
Log In To View
Prices
 
2.1MP Pinhole IP Camera with 2.8mm Fixed Lens
2.1MP Pinhole IP Camera with 2.8mm Fixed Lens
# DWC-MPH2W28TW
Digital Watchdog
Log In To View
Prices
 
2.1MP Star-Light HD-TVI Indoor Box Camera
2.1MP Star-Light HD-TVI Indoor Box Camera
# DWC-C223W
Digital Watchdog
Log In To View
Prices
 
2.1MP Vandal Dome 2.8-12MM Camera
2.1MP Vandal Dome 2.8-12MM Camera
# DWC-V4283WTIR
Digital Watchdog
Log In To View
Prices
 
4MP H.265 IP Bullet 2.8MM Camera
4MP H.265 IP Bullet 2.8MM Camera
# DWC-MB94WI28T
Digital Watchdog
Log In To View
Prices
 
4MP Turret IP Camera 2.8mm
4MP Turret IP Camera 2.8mm
# DWC-MT94WI28T
Digital Watchdog
Log In To View
Prices
 
5MP Color in Near-Total Darkness Vandal Ball Turret IP Camera
5MP Color in Near-Total Darkness Vandal Ball Turret IP Camera
# DWC-MVA5WI28T
Digital Watchdog
Log In To View
Prices
 
5MP H.265 IP Turret Camera 2.8 mm
5MP H.265 IP Turret Camera 2.8 mm
# DWC-MT95WI28TW
Digital Watchdog
Log In To View
Prices
 
5MP H.265 IP Turret Camera 3.6 mm
5MP H.265 IP Turret Camera 3.6 mm
# DWC-MT95WI36TW
Digital Watchdog
Log In To View
Prices
 
5MP H.265 MEGApix IP Turret Camera 2.8 - 12 mm
5MP H.265 MEGApix IP Turret Camera 2.8 - 12 mm
# DWC-MT95WIATW
Digital Watchdog
Log In To View
Prices
 
5MP H.265 MEGApix IVA IP Bullet Camera 4.0mm
5MP H.265 MEGApix IVA IP Bullet Camera 4.0mm
# DWC-MB75Wi4T
Digital Watchdog
Log In To View
Prices
 
5MP MEGApix Vandal Dome IP Camera with a Varifocal Lens
5MP MEGApix Vandal Dome IP Camera with a Varifocal Lens
# DWC-MV45WIATW
Digital Watchdog
Log In To View
Prices
 
8MP H.265 MEGApix IVA Vandal dome IP Camera 2.8MM
8MP H.265 MEGApix IVA Vandal dome IP Camera 2.8MM
# DWC-MVC8WI28TW
Digital Watchdog
Log In To View
Prices
 
MEGApix 4K Bullet IP Camera with a Varifocal Lens
MEGApix 4K Bullet IP Camera with a Varifocal Lens
# DWC-MPB48WIATW
Digital Watchdog
Log In To View
Prices
 
MEGApix 4K Bullet IP Camera with a Varifocal Lens
MEGApix 4K Bullet IP Camera with a Varifocal Lens
# DWC-MB48WIATW
Digital Watchdog
Log In To View
Prices
 
MEGApix 4MP Bullet IP Camera with 2.8mm Fixed Lens
MEGApix 4MP Bullet IP Camera with 2.8mm Fixed Lens
# DWC-VSBD04BI
Digital Watchdog
Log In To View
Prices
 
MEGApix 4MP Turret IP Camera with 2.8mm Fixed Lens
MEGApix 4MP Turret IP Camera with 2.8mm Fixed Lens
# DWC-VSTB04BI
Digital Watchdog
Log In To View
Prices
 
MEGApix 4MP Vandal Dome IP Camera with 2.8mm Fixed Lens
MEGApix 4MP Vandal Dome IP Camera with 2.8mm Fixed Lens
# DWC-VSDG04BI
Digital Watchdog
Log In To View
Prices
 
MEGApix 5MP Ultra Low-Profile Vandal Dome IP Camera with 4mm Fixed Lens
MEGApix 5MP Ultra Low-Profile Vandal Dome IP Camera with 4mm Fixed Lens
# DWC-MV75WI4TW
Digital Watchdog
Log In To View
Prices
 
MEGApix 5MP Ultra Low-Profile Vandal Dome IP Camera with 6mm Fixed Lens
MEGApix 5MP Ultra Low-Profile Vandal Dome IP Camera with 6mm Fixed Lens
# DWC-MV75WI6TW
Digital Watchdog
Log In To View
Prices
 
MEGApix Ai 10MP Dual-Sensor Vandal Dome IP Camera with Fixed Lenses 
MEGApix Ai 10MP Dual-Sensor Vandal Dome IP Camera with Fixed Lenses 
# DWC-PDS10WI28A
Digital Watchdog
Log In To View
Prices
 
MEGApix Ai 5MP Indoor/Outdoor Vandal Turret Camera with 2.7-12mm Varifocal Lens
MEGApix Ai 5MP Indoor/Outdoor Vandal Turret Camera with 2.7-12mm ...
# DWC-XSTD05MF
Digital Watchdog
Log In To View
Prices
 
MEGApix IVA 4K Indoor/Outdoor Vandal Turret Camera with 2.7-13.5 Varifocal Lens
MEGApix IVA 4K Indoor/Outdoor Vandal Turret Camera with 2.7-13.5 ...
# DWC-MVD8WIATW
Digital Watchdog
Log In To View
Prices
 
27 items  1  2