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 » Gri - George Risk Industries

Gri - George Risk Industries

   
select count(distinct(p.products_id)) as total from products p left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id left join products_models_to_products p2m on p2m.products_id = p.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 = 'Sounder') and p.manufacturers_id = 5017 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G") select count(distinct(p.products_id)) as total from products p left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id left join products_models_to_products p2m on p2m.products_id = p.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 = 'Sounder') and p.manufacturers_id = 5017 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G") select count(distinct(p.products_id)) as total from products p left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id left join products_models_to_products p2m on p2m.products_id = p.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 = 'Sounder') and p.manufacturers_id = 5017 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G") select count(distinct(p.products_id)) as total from products p left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id left join products_models_to_products p2m on p2m.products_id = p.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 = 'Almond') and p.manufacturers_id = 5017 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G") select count(distinct(p.products_id)) as total from products p left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id left join products_models_to_products p2m on p2m.products_id = p.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 = 'Almond') and p.manufacturers_id = 5017 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G") select count(distinct(p.products_id)) as total from products p left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id left join products_models_to_products p2m on p2m.products_id = p.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 = 5017 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G") select count(distinct(p.products_id)) as total from products p left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id left join products_models_to_products p2m on p2m.products_id = p.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 = 5017 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G") select count(distinct(p.products_id)) as total from products p left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id left join products_models_to_products p2m on p2m.products_id = p.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 = 5017 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G") select count(distinct(p.products_id)) as total from products p left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id left join products_models_to_products p2m on p2m.products_id = p.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 = 5017 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G") select count(distinct(p.products_id)) as total from products p left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id left join products_models_to_products p2m on p2m.products_id = p.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 = 5017 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G") select count(distinct(p.products_id)) as total from products p left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id left join products_models_to_products p2m on p2m.products_id = p.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 = 5017 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G") select count(distinct(p.products_id)) as total from products p left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id left join products_models_to_products p2m on p2m.products_id = p.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 = 'Brown') and p.manufacturers_id = 5017 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G") select count(distinct(p.products_id)) as total from products p left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id left join products_models_to_products p2m on p2m.products_id = p.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 = 'Brown') and p.manufacturers_id = 5017 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G") select count(distinct(p.products_id)) as total from products p left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id left join products_models_to_products p2m on p2m.products_id = p.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 = 'Brown') and p.manufacturers_id = 5017 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G") select count(distinct(p.products_id)) as total from products p left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id left join products_models_to_products p2m on p2m.products_id = p.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 = 'Brown') and p.manufacturers_id = 5017 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G") select count(distinct(p.products_id)) as total from products p left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id left join products_models_to_products p2m on p2m.products_id = p.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 = 'Brown') and p.manufacturers_id = 5017 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G") select count(distinct(p.products_id)) as total from products p left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id left join products_models_to_products p2m on p2m.products_id = p.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 = 'Brown') and p.manufacturers_id = 5017 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G") select count(distinct(p.products_id)) as total from products p left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id left join products_models_to_products p2m on p2m.products_id = p.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 = 'Brown') and p.manufacturers_id = 5017 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G") select count(distinct(p.products_id)) as total from products p left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id left join products_models_to_products p2m on p2m.products_id = p.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 = 'Brown') and p.manufacturers_id = 5017 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G") select count(distinct(p.products_id)) as total from products p left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id left join products_models_to_products p2m on p2m.products_id = p.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 = 'Brown') and p.manufacturers_id = 5017 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G") select count(distinct(p.products_id)) as total from products p left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id left join products_models_to_products p2m on p2m.products_id = p.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 = 'Brown') and p.manufacturers_id = 5017 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G") select count(distinct(p.products_id)) as total from products p left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id left join products_models_to_products p2m on p2m.products_id = p.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 = 'Brown') and p.manufacturers_id = 5017 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G") select count(distinct(p.products_id)) as total from products p left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id left join products_models_to_products p2m on p2m.products_id = p.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 = 'Gray') and p.manufacturers_id = 5017 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G") select count(distinct(p.products_id)) as total from products p left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id left join products_models_to_products p2m on p2m.products_id = p.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 = 'Gray') and p.manufacturers_id = 5017 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G") select count(distinct(p.products_id)) as total from products p left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id left join products_models_to_products p2m on p2m.products_id = p.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 = 'Gray') and p.manufacturers_id = 5017 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G") select count(distinct(p.products_id)) as total from products p left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id left join products_models_to_products p2m on p2m.products_id = p.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 = 'Grey') and p.manufacturers_id = 5017 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G") select count(distinct(p.products_id)) as total from products p left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id left join products_models_to_products p2m on p2m.products_id = p.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 = 'Light Almond') and p.manufacturers_id = 5017 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G") select count(distinct(p.products_id)) as total from products p left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id left join products_models_to_products p2m on p2m.products_id = p.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 = 'Silver') and p.manufacturers_id = 5017 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G") select count(distinct(p.products_id)) as total from products p left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id left join products_models_to_products p2m on p2m.products_id = p.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 = 5017 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G") select count(distinct(p.products_id)) as total from products p left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id left join products_models_to_products p2m on p2m.products_id = p.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 = 5017 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G") select count(distinct(p.products_id)) as total from products p left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id left join products_models_to_products p2m on p2m.products_id = p.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 = 5017 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G") select count(distinct(p.products_id)) as total from products p left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id left join products_models_to_products p2m on p2m.products_id = p.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 = 5017 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G") select count(distinct(p.products_id)) as total from products p left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id left join products_models_to_products p2m on p2m.products_id = p.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 = 5017 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G") select count(distinct(p.products_id)) as total from products p left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id left join products_models_to_products p2m on p2m.products_id = p.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 = 5017 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G") select count(distinct(p.products_id)) as total from products p left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id left join products_models_to_products p2m on p2m.products_id = p.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 = 5017 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G") select count(distinct(p.products_id)) as total from products p left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id left join products_models_to_products p2m on p2m.products_id = p.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 = 5017 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G") select count(distinct(p.products_id)) as total from products p left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id left join products_models_to_products p2m on p2m.products_id = p.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 = 5017 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G") select count(distinct(p.products_id)) as total from products p left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id left join products_models_to_products p2m on p2m.products_id = p.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 = 5017 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G") select count(distinct(p.products_id)) as total from products p left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id left join products_models_to_products p2m on p2m.products_id = p.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 = 5017 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G") select count(distinct(p.products_id)) as total from products p left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id left join products_models_to_products p2m on p2m.products_id = p.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 = 5017 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G") select count(distinct(p.products_id)) as total from products p left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id left join products_models_to_products p2m on p2m.products_id = p.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 = 5017 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G") select count(distinct(p.products_id)) as total from products p left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id left join products_models_to_products p2m on p2m.products_id = p.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 = 5017 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G") select count(distinct(p.products_id)) as total from products p left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id left join products_models_to_products p2m on p2m.products_id = p.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 = 5017 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G") select count(distinct(p.products_id)) as total from products p left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id left join products_models_to_products p2m on p2m.products_id = p.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 = 5017 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G") select count(distinct(p.products_id)) as total from products p left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id left join products_models_to_products p2m on p2m.products_id = p.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 = 5017 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G") select count(distinct(p.products_id)) as total from products p left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id left join products_models_to_products p2m on p2m.products_id = p.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 = 5017 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G") select count(distinct(p.products_id)) as total from products p left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id left join products_models_to_products p2m on p2m.products_id = p.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 = 5017 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G") select count(distinct(p.products_id)) as total from products p left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id left join products_models_to_products p2m on p2m.products_id = p.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 = 5017 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G") select count(distinct(p.products_id)) as total from products p left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id left join products_models_to_products p2m on p2m.products_id = p.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 = 5017 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G") select count(distinct(p.products_id)) as total from products p left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id left join products_models_to_products p2m on p2m.products_id = p.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 = 5017 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G") select count(distinct(p.products_id)) as total from products p left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id left join products_models_to_products p2m on p2m.products_id = p.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 = 5017 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G") select count(distinct(p.products_id)) as total from products p left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id left join products_models_to_products p2m on p2m.products_id = p.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 = 5017 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G") select count(distinct(p.products_id)) as total from products p left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id left join products_models_to_products p2m on p2m.products_id = p.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 = 5017 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G") select count(distinct(p.products_id)) as total from products p left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id left join products_models_to_products p2m on p2m.products_id = p.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 = 5017 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G") select count(distinct(p.products_id)) as total from products p left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id left join products_models_to_products p2m on p2m.products_id = p.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 = 5017 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G") select count(distinct(p.products_id)) as total from products p left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id left join products_models_to_products p2m on p2m.products_id = p.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 = 5017 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G") select count(distinct(p.products_id)) as total from products p left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id left join products_models_to_products p2m on p2m.products_id = p.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 = 5017 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G") select count(distinct(p.products_id)) as total from products p left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id left join products_models_to_products p2m on p2m.products_id = p.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 = 5017 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G") select count(distinct(p.products_id)) as total from products p left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id left join products_models_to_products p2m on p2m.products_id = p.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 = 5017 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G") select count(distinct(p.products_id)) as total from products p left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id left join products_models_to_products p2m on p2m.products_id = p.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 = 5017 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G") select count(distinct(p.products_id)) as total from products p left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id left join products_models_to_products p2m on p2m.products_id = p.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 = 5017 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G") select count(distinct(p.products_id)) as total from products p left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id left join products_models_to_products p2m on p2m.products_id = p.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 = 5017 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G") select count(distinct(p.products_id)) as total from products p left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id left join products_models_to_products p2m on p2m.products_id = p.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 = 5017 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G") select count(distinct(p.products_id)) as total from products p left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id left join products_models_to_products p2m on p2m.products_id = p.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 = 5017 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G") select count(distinct(p.products_id)) as total from products p left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id left join products_models_to_products p2m on p2m.products_id = p.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 = 5017 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G") select count(distinct(p.products_id)) as total from products p left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id left join products_models_to_products p2m on p2m.products_id = p.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 = 5017 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G") select count(distinct(p.products_id)) as total from products p left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id left join products_models_to_products p2m on p2m.products_id = p.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 = 5017 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G") select count(distinct(p.products_id)) as total from products p left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id left join products_models_to_products p2m on p2m.products_id = p.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 = 5017 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G") select count(distinct(p.products_id)) as total from products p left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id left join products_models_to_products p2m on p2m.products_id = p.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 = 5017 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G") select count(distinct(p.products_id)) as total from products p left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id left join products_models_to_products p2m on p2m.products_id = p.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 = 5017 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G") select count(distinct(p.products_id)) as total from products p left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id left join products_models_to_products p2m on p2m.products_id = p.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 = 5017 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G") select count(distinct(p.products_id)) as total from products p left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id left join products_models_to_products p2m on p2m.products_id = p.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 = 5017 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G") select count(distinct(p.products_id)) as total from products p left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id left join products_models_to_products p2m on p2m.products_id = p.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 = 5017 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G") select count(distinct(p.products_id)) as total from products p left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id left join products_models_to_products p2m on p2m.products_id = p.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 = 5017 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G") select count(distinct(p.products_id)) as total from products p left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id left join products_models_to_products p2m on p2m.products_id = p.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 = 5017 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G") select count(distinct(p.products_id)) as total from products p left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id left join products_models_to_products p2m on p2m.products_id = p.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 = 5017 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G") select count(distinct(p.products_id)) as total from products p left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id left join products_models_to_products p2m on p2m.products_id = p.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 = 5017 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G") select count(distinct(p.products_id)) as total from products p left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id left join products_models_to_products p2m on p2m.products_id = p.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 = 5017 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G") select count(distinct(p.products_id)) as total from products p left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id left join products_models_to_products p2m on p2m.products_id = p.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 = 5017 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G") select count(distinct(p.products_id)) as total from products p left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id left join products_models_to_products p2m on p2m.products_id = p.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 = 5017 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G") select count(distinct(p.products_id)) as total from products p left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id left join products_models_to_products p2m on p2m.products_id = p.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 = 5017 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G") select count(distinct(p.products_id)) as total from products p left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id left join products_models_to_products p2m on p2m.products_id = p.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 = 5017 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G") select count(distinct(p.products_id)) as total from products p left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id left join products_models_to_products p2m on p2m.products_id = p.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 = 5017 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G") select count(distinct(p.products_id)) as total from products p left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id left join products_models_to_products p2m on p2m.products_id = p.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 = 5017 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G") select count(distinct(p.products_id)) as total from products p left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id left join products_models_to_products p2m on p2m.products_id = p.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 = 5017 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G") select count(distinct(p.products_id)) as total from products p left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id left join products_models_to_products p2m on p2m.products_id = p.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 = 5017 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G") select count(distinct(p.products_id)) as total from products p left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id left join products_models_to_products p2m on p2m.products_id = p.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 = 5017 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G") select count(distinct(p.products_id)) as total from products p left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id left join products_models_to_products p2m on p2m.products_id = p.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 = 5017 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G") select count(distinct(p.products_id)) as total from products p left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id left join products_models_to_products p2m on p2m.products_id = p.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 = 5017 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G") select count(distinct(p.products_id)) as total from products p left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id left join products_models_to_products p2m on p2m.products_id = p.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 = 5017 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G") select count(distinct(p.products_id)) as total from products p left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id left join products_models_to_products p2m on p2m.products_id = p.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 = 5017 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G") select count(distinct(p.products_id)) as total from products p left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id left join products_models_to_products p2m on p2m.products_id = p.products_id left join products_models pm on pm.ID = p2m.model_id where (p.products_status = 1) and (ptpef2.products_extra_fields_id = '30' and ptpef2.products_extra_fields_value = '500 m') and p.manufacturers_id = 5017 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G") select count(distinct(p.products_id)) as total from products p left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id left join products_models_to_products p2m on p2m.products_id = p.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 = '0.375') and p.manufacturers_id = 5017 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G") select count(distinct(p.products_id)) as total from products p left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id left join products_models_to_products p2m on p2m.products_id = p.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 = '0.375') and p.manufacturers_id = 5017 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G") select count(distinct(p.products_id)) as total from products p left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id left join products_models_to_products p2m on p2m.products_id = p.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 = '0.375') and p.manufacturers_id = 5017 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G") select count(distinct(p.products_id)) as total from products p left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id left join products_models_to_products p2m on p2m.products_id = p.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 = '0.375') and p.manufacturers_id = 5017 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G") select count(distinct(p.products_id)) as total from products p left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id left join products_models_to_products p2m on p2m.products_id = p.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 = '0.4') and p.manufacturers_id = 5017 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G") select count(distinct(p.products_id)) as total from products p left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id left join products_models_to_products p2m on p2m.products_id = p.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 = '0.4') and p.manufacturers_id = 5017 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G") select count(distinct(p.products_id)) as total from products p left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id left join products_models_to_products p2m on p2m.products_id = p.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 = '0.44') and p.manufacturers_id = 5017 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G") select count(distinct(p.products_id)) as total from products p left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id left join products_models_to_products p2m on p2m.products_id = p.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 = '0.5') and p.manufacturers_id = 5017 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G") select count(distinct(p.products_id)) as total from products p left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id left join products_models_to_products p2m on p2m.products_id = p.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 = '0.5') and p.manufacturers_id = 5017 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G") select count(distinct(p.products_id)) as total from products p left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id left join products_models_to_products p2m on p2m.products_id = p.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 = '0.75') and p.manufacturers_id = 5017 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G") select count(distinct(p.products_id)) as total from products p left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id left join products_models_to_products p2m on p2m.products_id = p.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 = '0.75') and p.manufacturers_id = 5017 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G") select count(distinct(p.products_id)) as total from products p left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id left join products_models_to_products p2m on p2m.products_id = p.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 = '0.75') and p.manufacturers_id = 5017 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G") select count(distinct(p.products_id)) as total from products p left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id left join products_models_to_products p2m on p2m.products_id = p.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 = '0.75') and p.manufacturers_id = 5017 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G") select count(distinct(p.products_id)) as total from products p left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id left join products_models_to_products p2m on p2m.products_id = p.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 = '0.75') and p.manufacturers_id = 5017 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G") select count(distinct(p.products_id)) as total from products p left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id left join products_models_to_products p2m on p2m.products_id = p.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 = '0.75') and p.manufacturers_id = 5017 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G") select count(distinct(p.products_id)) as total from products p left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id left join products_models_to_products p2m on p2m.products_id = p.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 = '0.75') and p.manufacturers_id = 5017 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G") select count(distinct(p.products_id)) as total from products p left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id left join products_models_to_products p2m on p2m.products_id = p.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 = '0.75') and p.manufacturers_id = 5017 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G") select count(distinct(p.products_id)) as total from products p left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id left join products_models_to_products p2m on p2m.products_id = p.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 = '0.75') and p.manufacturers_id = 5017 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G") select count(distinct(p.products_id)) as total from products p left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id left join products_models_to_products p2m on p2m.products_id = p.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 = '0.75') and p.manufacturers_id = 5017 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G") select count(distinct(p.products_id)) as total from products p left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id left join products_models_to_products p2m on p2m.products_id = p.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 = '1') and p.manufacturers_id = 5017 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G") select count(distinct(p.products_id)) as total from products p left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id left join products_models_to_products p2m on p2m.products_id = p.products_id left join products_models pm on pm.ID = p2m.model_id where (p.products_status = 1) and (ptpef2.products_extra_fields_id = '54' and ptpef2.products_extra_fields_value = 'Heavy') and p.manufacturers_id = 5017 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G") select count(distinct(p.products_id)) as total from products p left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id left join products_models_to_products p2m on p2m.products_id = p.products_id left join products_models pm on pm.ID = p2m.model_id where (p.products_status = 1) and (ptpef2.products_extra_fields_id = '54' and ptpef2.products_extra_fields_value = 'Heavy') and p.manufacturers_id = 5017 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G") select count(distinct(p.products_id)) as total from products p left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id left join products_models_to_products p2m on p2m.products_id = p.products_id left join products_models pm on pm.ID = p2m.model_id where (p.products_status = 1) and (ptpef2.products_extra_fields_id = '54' and ptpef2.products_extra_fields_value = 'Heavy') and p.manufacturers_id = 5017 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G") select count(distinct(p.products_id)) as total from products p left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id left join products_models_to_products p2m on p2m.products_id = p.products_id left join products_models pm on pm.ID = p2m.model_id where (p.products_status = 1) and (ptpef2.products_extra_fields_id = '54' and ptpef2.products_extra_fields_value = 'Heavy') and p.manufacturers_id = 5017 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G") select count(distinct(p.products_id)) as total from products p left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id left join products_models_to_products p2m on p2m.products_id = p.products_id left join products_models pm on pm.ID = p2m.model_id where (p.products_status = 1) and (ptpef2.products_extra_fields_id = '54' and ptpef2.products_extra_fields_value = 'Heavy') and p.manufacturers_id = 5017 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G") select count(distinct(p.products_id)) as total from products p left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id left join products_models_to_products p2m on p2m.products_id = p.products_id left join products_models pm on pm.ID = p2m.model_id where (p.products_status = 1) and (ptpef2.products_extra_fields_id = '54' and ptpef2.products_extra_fields_value = 'Heavy') and p.manufacturers_id = 5017 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G") select count(distinct(p.products_id)) as total from products p left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id left join products_models_to_products p2m on p2m.products_id = p.products_id left join products_models pm on pm.ID = p2m.model_id where (p.products_status = 1) and (ptpef2.products_extra_fields_id = '54' and ptpef2.products_extra_fields_value = 'Regular') and p.manufacturers_id = 5017 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G") select count(distinct(p.products_id)) as total from products p left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id left join products_models_to_products p2m on p2m.products_id = p.products_id left join products_models pm on pm.ID = p2m.model_id where (p.products_status = 1) and (ptpef2.products_extra_fields_id = '54' and ptpef2.products_extra_fields_value = 'Regular') and p.manufacturers_id = 5017 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G") select count(distinct(p.products_id)) as total from products p left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id left join products_models_to_products p2m on p2m.products_id = p.products_id left join products_models pm on pm.ID = p2m.model_id where (p.products_status = 1) and (ptpef2.products_extra_fields_id = '54' and ptpef2.products_extra_fields_value = 'Regular') and p.manufacturers_id = 5017 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G") select count(distinct(p.products_id)) as total from products p left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id left join products_models_to_products p2m on p2m.products_id = p.products_id left join products_models pm on pm.ID = p2m.model_id where (p.products_status = 1) and (ptpef2.products_extra_fields_id = '20' and ptpef2.products_extra_fields_value = 'Indoor') and p.manufacturers_id = 5017 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G") select count(distinct(p.products_id)) as total from products p left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id left join products_models_to_products p2m on p2m.products_id = p.products_id left join products_models pm on pm.ID = p2m.model_id where (p.products_status = 1) and (ptpef2.products_extra_fields_id = '20' and ptpef2.products_extra_fields_value = 'Indoor') and p.manufacturers_id = 5017 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G") select count(distinct(p.products_id)) as total from products p left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id left join products_models_to_products p2m on p2m.products_id = p.products_id left join products_models pm on pm.ID = p2m.model_id where (p.products_status = 1) and (ptpef2.products_extra_fields_id = '20' and ptpef2.products_extra_fields_value = 'Indoor') and p.manufacturers_id = 5017 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G") select count(distinct(p.products_id)) as total from products p left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id left join products_models_to_products p2m on p2m.products_id = p.products_id left join products_models pm on pm.ID = p2m.model_id where (p.products_status = 1) and (ptpef2.products_extra_fields_id = '20' and ptpef2.products_extra_fields_value = 'Indoor') and p.manufacturers_id = 5017 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G") select count(distinct(p.products_id)) as total from products p left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id left join products_models_to_products p2m on p2m.products_id = p.products_id left join products_models pm on pm.ID = p2m.model_id where (p.products_status = 1) and (ptpef2.products_extra_fields_id = '20' and ptpef2.products_extra_fields_value = 'Indoor') and p.manufacturers_id = 5017 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G") select count(distinct(p.products_id)) as total from products p left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id left join products_models_to_products p2m on p2m.products_id = p.products_id left join products_models pm on pm.ID = p2m.model_id where (p.products_status = 1) and (ptpef2.products_extra_fields_id = '20' and ptpef2.products_extra_fields_value = 'Indoor') and p.manufacturers_id = 5017 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G") select count(distinct(p.products_id)) as total from products p left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id left join products_models_to_products p2m on p2m.products_id = p.products_id left join products_models pm on pm.ID = p2m.model_id where (p.products_status = 1) and (ptpef2.products_extra_fields_id = '20' and ptpef2.products_extra_fields_value = 'Indoor') and p.manufacturers_id = 5017 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G") select count(distinct(p.products_id)) as total from products p left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id left join products_models_to_products p2m on p2m.products_id = p.products_id left join products_models pm on pm.ID = p2m.model_id where (p.products_status = 1) and (ptpef2.products_extra_fields_id = '20' and ptpef2.products_extra_fields_value = 'Indoor') and p.manufacturers_id = 5017 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G") select count(distinct(p.products_id)) as total from products p left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id left join products_models_to_products p2m on p2m.products_id = p.products_id left join products_models pm on pm.ID = p2m.model_id where (p.products_status = 1) and (ptpef2.products_extra_fields_id = '20' and ptpef2.products_extra_fields_value = 'Indoor') and p.manufacturers_id = 5017 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G") select count(distinct(p.products_id)) as total from products p left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id left join products_models_to_products p2m on p2m.products_id = p.products_id left join products_models pm on pm.ID = p2m.model_id where (p.products_status = 1) and (ptpef2.products_extra_fields_id = '20' and ptpef2.products_extra_fields_value = 'Indoor') and p.manufacturers_id = 5017 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G") select count(distinct(p.products_id)) as total from products p left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id left join products_models_to_products p2m on p2m.products_id = p.products_id left join products_models pm on pm.ID = p2m.model_id where (p.products_status = 1) and (ptpef2.products_extra_fields_id = '20' and ptpef2.products_extra_fields_value = 'Indoor') and p.manufacturers_id = 5017 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G") select count(distinct(p.products_id)) as total from products p left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id left join products_models_to_products p2m on p2m.products_id = p.products_id left join products_models pm on pm.ID = p2m.model_id where (p.products_status = 1) and (ptpef2.products_extra_fields_id = '20' and ptpef2.products_extra_fields_value = 'Indoor') and p.manufacturers_id = 5017 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G") select count(distinct(p.products_id)) as total from products p left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id left join products_models_to_products p2m on p2m.products_id = p.products_id left join products_models pm on pm.ID = p2m.model_id where (p.products_status = 1) and (ptpef2.products_extra_fields_id = '20' and ptpef2.products_extra_fields_value = 'Indoor') and p.manufacturers_id = 5017 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G") select count(distinct(p.products_id)) as total from products p left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id left join products_models_to_products p2m on p2m.products_id = p.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 = 5017 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G") select count(distinct(p.products_id)) as total from products p left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id left join products_models_to_products p2m on p2m.products_id = p.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 = 5017 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G") select count(distinct(p.products_id)) as total from products p left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id left join products_models_to_products p2m on p2m.products_id = p.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 = 5017 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G") select count(distinct(p.products_id)) as total from products p left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id left join products_models_to_products p2m on p2m.products_id = p.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 = 5017 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G") select count(distinct(p.products_id)) as total from products p left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id left join products_models_to_products p2m on p2m.products_id = p.products_id left join products_models pm on pm.ID = p2m.model_id where (p.products_status = 1) and (ptpef2.products_extra_fields_id = '25' and ptpef2.products_extra_fields_value = 'Aluminum') and p.manufacturers_id = 5017 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G") select count(distinct(p.products_id)) as total from products p left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id left join products_models_to_products p2m on p2m.products_id = p.products_id left join products_models pm on pm.ID = p2m.model_id where (p.products_status = 1) and (ptpef2.products_extra_fields_id = '25' and ptpef2.products_extra_fields_value = 'Aluminum') and p.manufacturers_id = 5017 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G") select count(distinct(p.products_id)) as total from products p left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id left join products_models_to_products p2m on p2m.products_id = p.products_id left join products_models pm on pm.ID = p2m.model_id where (p.products_status = 1) and (ptpef2.products_extra_fields_id = '25' and ptpef2.products_extra_fields_value = 'Aluminum') and p.manufacturers_id = 5017 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G") select count(distinct(p.products_id)) as total from products p left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id left join products_models_to_products p2m on p2m.products_id = p.products_id left join products_models pm on pm.ID = p2m.model_id where (p.products_status = 1) and (ptpef2.products_extra_fields_id = '25' and ptpef2.products_extra_fields_value = 'Stainless Steel') and p.manufacturers_id = 5017 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G") select count(distinct(p.products_id)) as total from products p left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id left join products_models_to_products p2m on p2m.products_id = p.products_id left join products_models pm on pm.ID = p2m.model_id where (p.products_status = 1) and (ptpef2.products_extra_fields_id = '55' and ptpef2.products_extra_fields_value = '1\" (25mm)') and p.manufacturers_id = 5017 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G") select count(distinct(p.products_id)) as total from products p left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id left join products_models_to_products p2m on p2m.products_id = p.products_id left join products_models pm on pm.ID = p2m.model_id where (p.products_status = 1) and (ptpef2.products_extra_fields_id = '55' and ptpef2.products_extra_fields_value = '1\" (25mm)') and p.manufacturers_id = 5017 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G") select count(distinct(p.products_id)) as total from products p left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id left join products_models_to_products p2m on p2m.products_id = p.products_id left join products_models pm on pm.ID = p2m.model_id where (p.products_status = 1) and (ptpef2.products_extra_fields_id = '55' and ptpef2.products_extra_fields_value = '1\" (25mm)') and p.manufacturers_id = 5017 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G") select count(distinct(p.products_id)) as total from products p left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id left join products_models_to_products p2m on p2m.products_id = p.products_id left join products_models pm on pm.ID = p2m.model_id where (p.products_status = 1) and (ptpef2.products_extra_fields_id = '55' and ptpef2.products_extra_fields_value = '1\" (25mm)') and p.manufacturers_id = 5017 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G") select count(distinct(p.products_id)) as total from products p left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id left join products_models_to_products p2m on p2m.products_id = p.products_id left join products_models pm on pm.ID = p2m.model_id where (p.products_status = 1) and (ptpef2.products_extra_fields_id = '55' and ptpef2.products_extra_fields_value = '1\" (25mm)') and p.manufacturers_id = 5017 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G") select count(distinct(p.products_id)) as total from products p left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id left join products_models_to_products p2m on p2m.products_id = p.products_id left join products_models pm on pm.ID = p2m.model_id where (p.products_status = 1) and (ptpef2.products_extra_fields_id = '55' and ptpef2.products_extra_fields_value = '1\" (25mm)') and p.manufacturers_id = 5017 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G") select count(distinct(p.products_id)) as total from products p left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id left join products_models_to_products p2m on p2m.products_id = p.products_id left join products_models pm on pm.ID = p2m.model_id where (p.products_status = 1) and (ptpef2.products_extra_fields_id = '55' and ptpef2.products_extra_fields_value = '1\" (25mm)') and p.manufacturers_id = 5017 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G") select count(distinct(p.products_id)) as total from products p left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id left join products_models_to_products p2m on p2m.products_id = p.products_id left join products_models pm on pm.ID = p2m.model_id where (p.products_status = 1) and (ptpef2.products_extra_fields_id = '55' and ptpef2.products_extra_fields_value = '1\" (25mm)') and p.manufacturers_id = 5017 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G") select count(distinct(p.products_id)) as total from products p left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id left join products_models_to_products p2m on p2m.products_id = p.products_id left join products_models pm on pm.ID = p2m.model_id where (p.products_status = 1) and (ptpef2.products_extra_fields_id = '55' and ptpef2.products_extra_fields_value = '1\" (25mm)') and p.manufacturers_id = 5017 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G") select count(distinct(p.products_id)) as total from products p left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id left join products_models_to_products p2m on p2m.products_id = p.products_id left join products_models pm on pm.ID = p2m.model_id where (p.products_status = 1) and (ptpef2.products_extra_fields_id = '55' and ptpef2.products_extra_fields_value = '1\" (25mm)') and p.manufacturers_id = 5017 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G") select count(distinct(p.products_id)) as total from products p left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id left join products_models_to_products p2m on p2m.products_id = p.products_id left join products_models pm on pm.ID = p2m.model_id where (p.products_status = 1) and (ptpef2.products_extra_fields_id = '55' and ptpef2.products_extra_fields_value = '1/2\" (12.5mm)') and p.manufacturers_id = 5017 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G") select count(distinct(p.products_id)) as total from products p left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id left join products_models_to_products p2m on p2m.products_id = p.products_id left join products_models pm on pm.ID = p2m.model_id where (p.products_status = 1) and (ptpef2.products_extra_fields_id = '55' and ptpef2.products_extra_fields_value = '1/2\" (12.5mm)') and p.manufacturers_id = 5017 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G") select count(distinct(p.products_id)) as total from products p left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id left join products_models_to_products p2m on p2m.products_id = p.products_id left join products_models pm on pm.ID = p2m.model_id where (p.products_status = 1) and (ptpef2.products_extra_fields_id = '55' and ptpef2.products_extra_fields_value = '1/2\" (12.5mm)') and p.manufacturers_id = 5017 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G") select count(distinct(p.products_id)) as total from products p left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id left join products_models_to_products p2m on p2m.products_id = p.products_id left join products_models pm on pm.ID = p2m.model_id where (p.products_status = 1) and (ptpef2.products_extra_fields_id = '55' and ptpef2.products_extra_fields_value = '1.5\" (38mm)') and p.manufacturers_id = 5017 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G") select count(distinct(p.products_id)) as total from products p left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id left join products_models_to_products p2m on p2m.products_id = p.products_id left join products_models pm on pm.ID = p2m.model_id where (p.products_status = 1) and (ptpef2.products_extra_fields_id = '55' and ptpef2.products_extra_fields_value = '2\" (51mm)') and p.manufacturers_id = 5017 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G") select count(distinct(p.products_id)) as total from products p left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id left join products_models_to_products p2m on p2m.products_id = p.products_id left join products_models pm on pm.ID = p2m.model_id where (p.products_status = 1) and (ptpef2.products_extra_fields_id = '55' and ptpef2.products_extra_fields_value = '2.5\" (63.5mm)') and p.manufacturers_id = 5017 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G") select count(distinct(p.products_id)) as total from products p left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id left join products_models_to_products p2m on p2m.products_id = p.products_id left join products_models pm on pm.ID = p2m.model_id where (p.products_status = 1) and (ptpef2.products_extra_fields_id = '55' and ptpef2.products_extra_fields_value = '3/4\" (19mm)') and p.manufacturers_id = 5017 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G") select count(distinct(p.products_id)) as total from products p left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id left join products_models_to_products p2m on p2m.products_id = p.products_id left join products_models pm on pm.ID = p2m.model_id where (p.products_status = 1) and (ptpef2.products_extra_fields_id = '55' and ptpef2.products_extra_fields_value = '3/4\" (19mm)') and p.manufacturers_id = 5017 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G") select count(distinct(p.products_id)) as total from products p left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id left join products_models_to_products p2m on p2m.products_id = p.products_id left join products_models pm on pm.ID = p2m.model_id where (p.products_status = 1) and (ptpef2.products_extra_fields_id = '55' and ptpef2.products_extra_fields_value = '3/4\" (19mm)') and p.manufacturers_id = 5017 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G") select count(distinct(p.products_id)) as total from products p left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id left join products_models_to_products p2m on p2m.products_id = p.products_id left join products_models pm on pm.ID = p2m.model_id where (p.products_status = 1) and (ptpef2.products_extra_fields_id = '55' and ptpef2.products_extra_fields_value = '3/4\" (19mm)') and p.manufacturers_id = 5017 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G") select count(distinct(p.products_id)) as total from products p left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id left join products_models_to_products p2m on p2m.products_id = p.products_id left join products_models pm on pm.ID = p2m.model_id where (p.products_status = 1) and (ptpef2.products_extra_fields_id = '55' and ptpef2.products_extra_fields_value = '3/4\" (19mm)') and p.manufacturers_id = 5017 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G") select count(distinct(p.products_id)) as total from products p left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id left join products_models_to_products p2m on p2m.products_id = p.products_id left join products_models pm on pm.ID = p2m.model_id where (p.products_status = 1) and (ptpef2.products_extra_fields_id = '55' and ptpef2.products_extra_fields_value = '3/8″ (9.7mm)') and p.manufacturers_id = 5017 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G") select count(distinct(p.products_id)) as total from products p left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id left join products_models_to_products p2m on p2m.products_id = p.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 = 'Recessed') and p.manufacturers_id = 5017 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G") select count(distinct(p.products_id)) as total from products p left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id left join products_models_to_products p2m on p2m.products_id = p.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 = 'Recessed') and p.manufacturers_id = 5017 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G") select count(distinct(p.products_id)) as total from products p left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id left join products_models_to_products p2m on p2m.products_id = p.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 = 'Recessed') and p.manufacturers_id = 5017 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G") select count(distinct(p.products_id)) as total from products p left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id left join products_models_to_products p2m on p2m.products_id = p.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 = 'Recessed') and p.manufacturers_id = 5017 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G") select count(distinct(p.products_id)) as total from products p left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id left join products_models_to_products p2m on p2m.products_id = p.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 = 'Recessed') and p.manufacturers_id = 5017 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G") select count(distinct(p.products_id)) as total from products p left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id left join products_models_to_products p2m on p2m.products_id = p.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 = 'Recessed') and p.manufacturers_id = 5017 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G") select count(distinct(p.products_id)) as total from products p left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id left join products_models_to_products p2m on p2m.products_id = p.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 = 'Recessed') and p.manufacturers_id = 5017 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G") select count(distinct(p.products_id)) as total from products p left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id left join products_models_to_products p2m on p2m.products_id = p.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 = 'Recessed') and p.manufacturers_id = 5017 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G") select count(distinct(p.products_id)) as total from products p left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id left join products_models_to_products p2m on p2m.products_id = p.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 = 'Recessed') and p.manufacturers_id = 5017 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G") select count(distinct(p.products_id)) as total from products p left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id left join products_models_to_products p2m on p2m.products_id = p.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 = 'Recessed') and p.manufacturers_id = 5017 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G") select count(distinct(p.products_id)) as total from products p left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id left join products_models_to_products p2m on p2m.products_id = p.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 = 'Recessed') and p.manufacturers_id = 5017 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G") select count(distinct(p.products_id)) as total from products p left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id left join products_models_to_products p2m on p2m.products_id = p.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 = 'Recessed') and p.manufacturers_id = 5017 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G") select count(distinct(p.products_id)) as total from products p left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id left join products_models_to_products p2m on p2m.products_id = p.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 = 'Recessed') and p.manufacturers_id = 5017 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G") select count(distinct(p.products_id)) as total from products p left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id left join products_models_to_products p2m on p2m.products_id = p.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 = 'Recessed') and p.manufacturers_id = 5017 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G") select count(distinct(p.products_id)) as total from products p left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id left join products_models_to_products p2m on p2m.products_id = p.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 = 'Surface') and p.manufacturers_id = 5017 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G") select count(distinct(p.products_id)) as total from products p left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id left join products_models_to_products p2m on p2m.products_id = p.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 = 'Surface') and p.manufacturers_id = 5017 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G") select count(distinct(p.products_id)) as total from products p left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id left join products_models_to_products p2m on p2m.products_id = p.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 = 'Surface') and p.manufacturers_id = 5017 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G") select count(distinct(p.products_id)) as total from products p left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id left join products_models_to_products p2m on p2m.products_id = p.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 = 'Surface') and p.manufacturers_id = 5017 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G") select count(distinct(p.products_id)) as total from products p left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id left join products_models_to_products p2m on p2m.products_id = p.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 = 'Surface') and p.manufacturers_id = 5017 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G") select count(distinct(p.products_id)) as total from products p left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id left join products_models_to_products p2m on p2m.products_id = p.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 = 'Surface') and p.manufacturers_id = 5017 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G") select count(distinct(p.products_id)) as total from products p left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id left join products_models_to_products p2m on p2m.products_id = p.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 = 'Surface') and p.manufacturers_id = 5017 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G") select count(distinct(p.products_id)) as total from products p left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id left join products_models_to_products p2m on p2m.products_id = p.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 = 'Surface') and p.manufacturers_id = 5017 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G") select count(distinct(p.products_id)) as total from products p left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id left join products_models_to_products p2m on p2m.products_id = p.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 = 'Surface') and p.manufacturers_id = 5017 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G") select count(distinct(p.products_id)) as total from products p left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id left join products_models_to_products p2m on p2m.products_id = p.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 = 'Surface') and p.manufacturers_id = 5017 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G") select count(distinct(p.products_id)) as total from products p left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id left join products_models_to_products p2m on p2m.products_id = p.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 = 'Surface') and p.manufacturers_id = 5017 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G") select count(distinct(p.products_id)) as total from products p left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id left join products_models_to_products p2m on p2m.products_id = p.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 = 'Surface') and p.manufacturers_id = 5017 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G") select count(distinct(p.products_id)) as total from products p left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id left join products_models_to_products p2m on p2m.products_id = p.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 = 'Surface') and p.manufacturers_id = 5017 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G") select count(distinct(p.products_id)) as total from products p left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id left join products_models_to_products p2m on p2m.products_id = p.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 = 'Surface') and p.manufacturers_id = 5017 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G") select count(distinct(p.products_id)) as total from products p left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id left join products_models_to_products p2m on p2m.products_id = p.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 = 'Surface') and p.manufacturers_id = 5017 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G") select count(distinct(p.products_id)) as total from products p left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id left join products_models_to_products p2m on p2m.products_id = p.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 = 'Surface') and p.manufacturers_id = 5017 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G") select count(distinct(p.products_id)) as total from products p left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id left join products_models_to_products p2m on p2m.products_id = p.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 = 'Surface') and p.manufacturers_id = 5017 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G") select count(distinct(p.products_id)) as total from products p left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id left join products_models_to_products p2m on p2m.products_id = p.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 = 'Surface') and p.manufacturers_id = 5017 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G") select count(distinct(p.products_id)) as total from products p left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id left join products_models_to_products p2m on p2m.products_id = p.products_id left join products_models pm on pm.ID = p2m.model_id where (p.products_status = 1) and (ptpef2.products_extra_fields_id = '56' and ptpef2.products_extra_fields_value = 'DPDT') and p.manufacturers_id = 5017 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G") select count(distinct(p.products_id)) as total from products p left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id left join products_models_to_products p2m on p2m.products_id = p.products_id left join products_models pm on pm.ID = p2m.model_id where (p.products_status = 1) and (ptpef2.products_extra_fields_id = '56' and ptpef2.products_extra_fields_value = 'DPDT') and p.manufacturers_id = 5017 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G") select count(distinct(p.products_id)) as total from products p left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id left join products_models_to_products p2m on p2m.products_id = p.products_id left join products_models pm on pm.ID = p2m.model_id where (p.products_status = 1) and (ptpef2.products_extra_fields_id = '56' and ptpef2.products_extra_fields_value = 'DPDT') and p.manufacturers_id = 5017 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G") select count(distinct(p.products_id)) as total from products p left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id left join products_models_to_products p2m on p2m.products_id = p.products_id left join products_models pm on pm.ID = p2m.model_id where (p.products_status = 1) and (ptpef2.products_extra_fields_id = '56' and ptpef2.products_extra_fields_value = 'N/C') and p.manufacturers_id = 5017 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G") select count(distinct(p.products_id)) as total from products p left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id left join products_models_to_products p2m on p2m.products_id = p.products_id left join products_models pm on pm.ID = p2m.model_id where (p.products_status = 1) and (ptpef2.products_extra_fields_id = '56' and ptpef2.products_extra_fields_value = 'N/C') and p.manufacturers_id = 5017 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G") select count(distinct(p.products_id)) as total from products p left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id left join products_models_to_products p2m on p2m.products_id = p.products_id left join products_models pm on pm.ID = p2m.model_id where (p.products_status = 1) and (ptpef2.products_extra_fields_id = '56' and ptpef2.products_extra_fields_value = 'N/C') and p.manufacturers_id = 5017 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G") select count(distinct(p.products_id)) as total from products p left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id left join products_models_to_products p2m on p2m.products_id = p.products_id left join products_models pm on pm.ID = p2m.model_id where (p.products_status = 1) and (ptpef2.products_extra_fields_id = '56' and ptpef2.products_extra_fields_value = 'N/C') and p.manufacturers_id = 5017 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G") select count(distinct(p.products_id)) as total from products p left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id left join products_models_to_products p2m on p2m.products_id = p.products_id left join products_models pm on pm.ID = p2m.model_id where (p.products_status = 1) and (ptpef2.products_extra_fields_id = '56' and ptpef2.products_extra_fields_value = 'N/C') and p.manufacturers_id = 5017 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G") select count(distinct(p.products_id)) as total from products p left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id left join products_models_to_products p2m on p2m.products_id = p.products_id left join products_models pm on pm.ID = p2m.model_id where (p.products_status = 1) and (ptpef2.products_extra_fields_id = '56' and ptpef2.products_extra_fields_value = 'N/C') and p.manufacturers_id = 5017 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G") select count(distinct(p.products_id)) as total from products p left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id left join products_models_to_products p2m on p2m.products_id = p.products_id left join products_models pm on pm.ID = p2m.model_id where (p.products_status = 1) and (ptpef2.products_extra_fields_id = '56' and ptpef2.products_extra_fields_value = 'N/C') and p.manufacturers_id = 5017 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G") select count(distinct(p.products_id)) as total from products p left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id left join products_models_to_products p2m on p2m.products_id = p.products_id left join products_models pm on pm.ID = p2m.model_id where (p.products_status = 1) and (ptpef2.products_extra_fields_id = '56' and ptpef2.products_extra_fields_value = 'N/C') and p.manufacturers_id = 5017 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G") select count(distinct(p.products_id)) as total from products p left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id left join products_models_to_products p2m on p2m.products_id = p.products_id left join products_models pm on pm.ID = p2m.model_id where (p.products_status = 1) and (ptpef2.products_extra_fields_id = '56' and ptpef2.products_extra_fields_value = 'N/C') and p.manufacturers_id = 5017 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G") select count(distinct(p.products_id)) as total from products p left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id left join products_models_to_products p2m on p2m.products_id = p.products_id left join products_models pm on pm.ID = p2m.model_id where (p.products_status = 1) and (ptpef2.products_extra_fields_id = '56' and ptpef2.products_extra_fields_value = 'N/C') and p.manufacturers_id = 5017 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G") select count(distinct(p.products_id)) as total from products p left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id left join products_models_to_products p2m on p2m.products_id = p.products_id left join products_models pm on pm.ID = p2m.model_id where (p.products_status = 1) and (ptpef2.products_extra_fields_id = '56' and ptpef2.products_extra_fields_value = 'N/C') and p.manufacturers_id = 5017 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G") select count(distinct(p.products_id)) as total from products p left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id left join products_models_to_products p2m on p2m.products_id = p.products_id left join products_models pm on pm.ID = p2m.model_id where (p.products_status = 1) and (ptpef2.products_extra_fields_id = '56' and ptpef2.products_extra_fields_value = 'N/C') and p.manufacturers_id = 5017 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G") select count(distinct(p.products_id)) as total from products p left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id left join products_models_to_products p2m on p2m.products_id = p.products_id left join products_models pm on pm.ID = p2m.model_id where (p.products_status = 1) and (ptpef2.products_extra_fields_id = '56' and ptpef2.products_extra_fields_value = 'N/C') and p.manufacturers_id = 5017 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G") select count(distinct(p.products_id)) as total from products p left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id left join products_models_to_products p2m on p2m.products_id = p.products_id left join products_models pm on pm.ID = p2m.model_id where (p.products_status = 1) and (ptpef2.products_extra_fields_id = '56' and ptpef2.products_extra_fields_value = 'N/C') and p.manufacturers_id = 5017 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G") select count(distinct(p.products_id)) as total from products p left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id left join products_models_to_products p2m on p2m.products_id = p.products_id left join products_models pm on pm.ID = p2m.model_id where (p.products_status = 1) and (ptpef2.products_extra_fields_id = '56' and ptpef2.products_extra_fields_value = 'N/C') and p.manufacturers_id = 5017 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G") select count(distinct(p.products_id)) as total from products p left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id left join products_models_to_products p2m on p2m.products_id = p.products_id left join products_models pm on pm.ID = p2m.model_id where (p.products_status = 1) and (ptpef2.products_extra_fields_id = '56' and ptpef2.products_extra_fields_value = 'N/C') and p.manufacturers_id = 5017 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G") select count(distinct(p.products_id)) as total from products p left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id left join products_models_to_products p2m on p2m.products_id = p.products_id left join products_models pm on pm.ID = p2m.model_id where (p.products_status = 1) and (ptpef2.products_extra_fields_id = '56' and ptpef2.products_extra_fields_value = 'N/C') and p.manufacturers_id = 5017 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G") select count(distinct(p.products_id)) as total from products p left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id left join products_models_to_products p2m on p2m.products_id = p.products_id left join products_models pm on pm.ID = p2m.model_id where (p.products_status = 1) and (ptpef2.products_extra_fields_id = '56' and ptpef2.products_extra_fields_value = 'N/C') and p.manufacturers_id = 5017 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G") select count(distinct(p.products_id)) as total from products p left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id left join products_models_to_products p2m on p2m.products_id = p.products_id left join products_models pm on pm.ID = p2m.model_id where (p.products_status = 1) and (ptpef2.products_extra_fields_id = '56' and ptpef2.products_extra_fields_value = 'N/C') and p.manufacturers_id = 5017 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G") select count(distinct(p.products_id)) as total from products p left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id left join products_models_to_products p2m on p2m.products_id = p.products_id left join products_models pm on pm.ID = p2m.model_id where (p.products_status = 1) and (ptpef2.products_extra_fields_id = '56' and ptpef2.products_extra_fields_value = 'N/C') and p.manufacturers_id = 5017 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G") select count(distinct(p.products_id)) as total from products p left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id left join products_models_to_products p2m on p2m.products_id = p.products_id left join products_models pm on pm.ID = p2m.model_id where (p.products_status = 1) and (ptpef2.products_extra_fields_id = '56' and ptpef2.products_extra_fields_value = 'N/C') and p.manufacturers_id = 5017 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G") select count(distinct(p.products_id)) as total from products p left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id left join products_models_to_products p2m on p2m.products_id = p.products_id left join products_models pm on pm.ID = p2m.model_id where (p.products_status = 1) and (ptpef2.products_extra_fields_id = '56' and ptpef2.products_extra_fields_value = 'N/C') and p.manufacturers_id = 5017 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G") select count(distinct(p.products_id)) as total from products p left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id left join products_models_to_products p2m on p2m.products_id = p.products_id left join products_models pm on pm.ID = p2m.model_id where (p.products_status = 1) and (ptpef2.products_extra_fields_id = '56' and ptpef2.products_extra_fields_value = 'N/C') and p.manufacturers_id = 5017 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G") select count(distinct(p.products_id)) as total from products p left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id left join products_models_to_products p2m on p2m.products_id = p.products_id left join products_models pm on pm.ID = p2m.model_id where (p.products_status = 1) and (ptpef2.products_extra_fields_id = '56' and ptpef2.products_extra_fields_value = 'N/C') and p.manufacturers_id = 5017 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G") select count(distinct(p.products_id)) as total from products p left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id left join products_models_to_products p2m on p2m.products_id = p.products_id left join products_models pm on pm.ID = p2m.model_id where (p.products_status = 1) and (ptpef2.products_extra_fields_id = '56' and ptpef2.products_extra_fields_value = 'N/C') and p.manufacturers_id = 5017 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G") select count(distinct(p.products_id)) as total from products p left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id left join products_models_to_products p2m on p2m.products_id = p.products_id left join products_models pm on pm.ID = p2m.model_id where (p.products_status = 1) and (ptpef2.products_extra_fields_id = '56' and ptpef2.products_extra_fields_value = 'N/C') and p.manufacturers_id = 5017 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G") select count(distinct(p.products_id)) as total from products p left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id left join products_models_to_products p2m on p2m.products_id = p.products_id left join products_models pm on pm.ID = p2m.model_id where (p.products_status = 1) and (ptpef2.products_extra_fields_id = '56' and ptpef2.products_extra_fields_value = 'N/C') and p.manufacturers_id = 5017 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G") select count(distinct(p.products_id)) as total from products p left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id left join products_models_to_products p2m on p2m.products_id = p.products_id left join products_models pm on pm.ID = p2m.model_id where (p.products_status = 1) and (ptpef2.products_extra_fields_id = '56' and ptpef2.products_extra_fields_value = 'N/C') and p.manufacturers_id = 5017 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G") select count(distinct(p.products_id)) as total from products p left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id left join products_models_to_products p2m on p2m.products_id = p.products_id left join products_models pm on pm.ID = p2m.model_id where (p.products_status = 1) and (ptpef2.products_extra_fields_id = '56' and ptpef2.products_extra_fields_value = 'N/C') and p.manufacturers_id = 5017 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G") select count(distinct(p.products_id)) as total from products p left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id left join products_models_to_products p2m on p2m.products_id = p.products_id left join products_models pm on pm.ID = p2m.model_id where (p.products_status = 1) and (ptpef2.products_extra_fields_id = '56' and ptpef2.products_extra_fields_value = 'N/O') and p.manufacturers_id = 5017 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G") select count(distinct(p.products_id)) as total from products p left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id left join products_models_to_products p2m on p2m.products_id = p.products_id left join products_models pm on pm.ID = p2m.model_id where (p.products_status = 1) and (ptpef2.products_extra_fields_id = '56' and ptpef2.products_extra_fields_value = 'N/O') and p.manufacturers_id = 5017 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G") select count(distinct(p.products_id)) as total from products p left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id left join products_models_to_products p2m on p2m.products_id = p.products_id left join products_models pm on pm.ID = p2m.model_id where (p.products_status = 1) and (ptpef2.products_extra_fields_id = '56' and ptpef2.products_extra_fields_value = 'NO/NC') and p.manufacturers_id = 5017 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G") select count(distinct(p.products_id)) as total from products p left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id left join products_models_to_products p2m on p2m.products_id = p.products_id left join products_models pm on pm.ID = p2m.model_id where (p.products_status = 1) and (ptpef2.products_extra_fields_id = '56' and ptpef2.products_extra_fields_value = 'SPDT') and p.manufacturers_id = 5017 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G") select count(distinct(p.products_id)) as total from products p left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id left join products_models_to_products p2m on p2m.products_id = p.products_id left join products_models pm on pm.ID = p2m.model_id where (p.products_status = 1) and (ptpef2.products_extra_fields_id = '56' and ptpef2.products_extra_fields_value = 'SPDT') and p.manufacturers_id = 5017 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G") select count(distinct(p.products_id)) as total from products p left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id left join products_models_to_products p2m on p2m.products_id = p.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 = 5017 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G") select count(distinct(p.products_id)) as total from products p left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id left join products_models_to_products p2m on p2m.products_id = p.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 = 5017 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G") select count(distinct(p.products_id)) as total from products p left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id left join products_models_to_products p2m on p2m.products_id = p.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 = 5017 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G") select count(distinct(p.products_id)) as total from products p left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id left join products_models_to_products p2m on p2m.products_id = p.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 = 5017 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G") select count(distinct(p.products_id)) as total from products p left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id left join products_models_to_products p2m on p2m.products_id = p.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 = 5017 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G") select count(distinct(p.products_id)) as total from products p left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id left join products_models_to_products p2m on p2m.products_id = p.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 = 5017 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G") select count(distinct(p.products_id)) as total from products p left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id left join products_models_to_products p2m on p2m.products_id = p.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 = 5017 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G") select count(distinct(p.products_id)) as total from products p left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id left join products_models_to_products p2m on p2m.products_id = p.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 = 5017 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G") select count(distinct(p.products_id)) as total from products p left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id left join products_models_to_products p2m on p2m.products_id = p.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 = 5017 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G") select count(distinct(p.products_id)) as total from products p left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id left join products_models_to_products p2m on p2m.products_id = p.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 = 5017 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G") select count(distinct(p.products_id)) as total from products p left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id left join products_models_to_products p2m on p2m.products_id = p.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 = 5017 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G") select count(distinct(p.products_id)) as total from products p left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id left join products_models_to_products p2m on p2m.products_id = p.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 = 5017 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G") select count(distinct(p.products_id)) as total from products p left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id left join products_models_to_products p2m on p2m.products_id = p.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 / BATTERY') and p.manufacturers_id = 5017 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G") select count(distinct(p.products_id)) as total from products p left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id left join products_models_to_products p2m on p2m.products_id = p.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 / BATTERY') and p.manufacturers_id = 5017 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G") select count(distinct(p.products_id)) as total from products p left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id left join products_models_to_products p2m on p2m.products_id = p.products_id left join products_models pm on pm.ID = p2m.model_id where (p.products_status = 1) and (ptpef2.products_extra_fields_id = '8' and ptpef2.products_extra_fields_value = '48 VDC') and p.manufacturers_id = 5017 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G") select count(distinct(p.products_id)) as total from products p left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id left join products_models_to_products p2m on p2m.products_id = p.products_id left join products_models pm on pm.ID = p2m.model_id where (p.products_status = 1) and (ptpef2.products_extra_fields_id = '29' and ptpef2.products_extra_fields_value = '12 VDC') and p.manufacturers_id = 5017 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G") select count(distinct(p.products_id)) as total from products p left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id left join products_models_to_products p2m on p2m.products_id = p.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 = '160 VDC') and p.manufacturers_id = 5017 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G") select count(distinct(p.products_id)) as total from products p left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id left join products_models_to_products p2m on p2m.products_id = p.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 = '175 VDC') and p.manufacturers_id = 5017 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G") select count(distinct(p.products_id)) as total from products p left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id left join products_models_to_products p2m on p2m.products_id = p.products_id left join products_models pm on pm.ID = p2m.model_id where (p.products_status = 1) and (ptpef2.products_extra_fields_id = '41' and ptpef2.products_extra_fields_value = '22') and p.manufacturers_id = 5017 and (p.products_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
Sounder
Color
Almond
Black
Brown
Gray
Grey
Light Almond
Silver
White
Connectivity
Wired
Current (A)
500 m
Diameter (In)
0.375
0.4
0.44
0.5
0.75
1
Duty
Heavy
Regular
Environment
Indoor
Outdoor
Finish
Aluminum
Stainless Steel
Gap (In)
1" (25mm)
1/2" (12.5mm)
1.5" (38mm)
2" (51mm)
2.5" (63.5mm)
3/4" (19mm)
3/8″ (9.7mm)
Installation
Recessed
Surface
Loop
DPDT
N/C
N/O
NO/NC
SPDT
Operating Voltage
12 VDC
12 VDC / BATTERY
48 VDC
Output Voltage
12 VDC
Rating
160 VDC
175 VDC
Wire (Awg)
22
Pixel Trans
Pixel Trans
 Grid  List      127 items    
   1  2  3  4  5  6   
Recessed Remote Button - All Weather Stainless Steel
Recessed Remote Button - All Weather Stainless Steel
# 084-1
Gri - George Risk Industries
Log In To View
Prices
 
Recessed Remote Sounder and Shunt Button
Recessed Remote Sounder and Shunt Button
# PAAR-RSB
Gri - George Risk Industries
Log In To View
Prices
 
Recessed Sounder Only / Pool Alarm Remotes
Recessed Sounder Only / Pool Alarm Remotes
# 184-2
Gri - George Risk Industries
Log In To View
Prices
 
Replacement Blades for 10" Hole Cutter
Replacement Blades for 10" Hole Cutter
# LS-56-017
Gri - George Risk Industries
Log In To View
Prices
 
Short Roller Ball with 12" Wire Leads - White
Short Roller Ball with 12" Wire Leads - White
# DS-01-W
Gri - George Risk Industries
Log In To View
Prices
 
Special Purpose Pull Apart Switch Set - 20' Armored Cable
Special Purpose Pull Apart Switch Set - 20' Armored Cable
# 4704-A-240
Gri - George Risk Industries
Log In To View
Prices
 
Special Purpose Pull Apart Switch Set - 25' Armored Cable
Special Purpose Pull Apart Switch Set - 25' Armored Cable
# 4704-A-300
Gri - George Risk Industries
Log In To View
Prices
 
Special Purpose Pull Apart Switch Set - 5' Armored Cable
Special Purpose Pull Apart Switch Set - 5' Armored Cable
# 4704-A-60
Gri - George Risk Industries
Log In To View
Prices
 
Stainless Steel Armored Cable 25 FT
Stainless Steel Armored Cable 25 FT
# 5702-25
Gri - George Risk Industries
Log In To View
Prices
 
Standard Surface Mount Reed Switch Set
Standard Surface Mount Reed Switch Set
# 29A-W
Gri - George Risk Industries
Log In To View
Prices
 
Standard Surface Mount Switch Set
Standard Surface Mount Switch Set
# 29C-W
Gri - George Risk Industries
Log In To View
Prices
 
Surface Mount Button Only
Surface Mount Button Only
# 184-6
Gri - George Risk Industries
Log In To View
Prices
 
Surface Mount Door Alarm 12VDC - Almond
Surface Mount Door Alarm 12VDC - Almond
# 289-4-AL
Gri - George Risk Industries
Log In To View
Prices
 
Surface Mount Pool Access Alarm
Surface Mount Pool Access Alarm
# PAA-S
Gri - George Risk Industries
Log In To View
Prices
 
Surface Mount Pool Access Alarm with Included box - Almond
Surface Mount Pool Access Alarm with Included box - Almond
# PAA-S-AL
Gri - George Risk Industries
Log In To View
Prices
 
Surface Mount Pull Apart Switch Set - SPDT
Surface Mount Pull Apart Switch Set - SPDT
# 4704-A-360
Gri - George Risk Industries
Log In To View
Prices
 
Surface Mount Sounder and Button
Surface Mount Sounder and Button
# PAAR-SSB
Gri - George Risk Industries
Log In To View
Prices
 
Surface Mount Switch Set with Magnasphere Technology - Gray
Surface Mount Switch Set with Magnasphere Technology - Gray
# MS29A-G
Gri - George Risk Industries
Log In To View
Prices
 
Surface Mount Water Sensor
Surface Mount Water Sensor
# 2800-W
Gri - George Risk Industries
Log In To View
Prices
 
Switch Set - Brown
Switch Set - Brown
# 4834-T-B-GEN
Gri - George Risk Industries
Log In To View
Prices
 
Switch Set - White
Switch Set - White
# 4834-T-W-GEN
Gri - George Risk Industries
Log In To View
Prices
 
Switch Set, 190-12WG with 2-1K Resistor
Switch Set, 190-12WG with 2-1K Resistor
# 11492-W
Gri - George Risk Industries
Log In To View
Prices
 
Switch Set, S20RS-T-W with MM-400
Switch Set, S20RS-T-W with MM-400
# N20RS-T-W
Gri - George Risk Industries
Log In To View
Prices
 
TS-01S Box Tamper Shunted with Terminals
TS-01S Box Tamper Shunted with Terminals
# TS-01S
Gri - George Risk Industries
Log In To View
Prices
 
127 items    1  2  3  4  5  6