<!--


<br><br>SELECT * FROM sites  WHERE Site_Name IN ('clarybusinessmachines', 'clarybusinessmachines')  <br><br>--><!--


<br><br>SELECT Category,COUNT(Product_id) AS prod_cat_cnt FROM products  WHERE Status<>'Discontinued' AND Status<>'Hide in List' GROUP BY Category  <br><br>--><!--


<br><br>SELECT category_criteria.Category, Criteria_Name, Criteria_Value, Is_Multiple FROM category_criteria,criteria  WHERE category_criteria.Category=criteria.Category AND Criteria_Name=Criteria AND category_criteria.CATEGORY in ('Conferencing Equipment','Office Products','Audio Conferencing Equipment','Network Equipment','Video Conferencing Equipment','')  AND ( (Parent_Criteria_Name= 'Resolution' AND Parent_Criteria_Value= 'Standard Definition' ) OR  ( Parent_Criteria_Name IS  NULL  AND Parent_Criteria_Value IS NULL )) and Hide_In_Menu = 0 ORDER BY Sort_Order,Sort <br><br>--><!--


<br><br>SELECT Criteria_Name,Criteria_Value,COUNT(Criteria_Value) AS prod_cnt FROM product_criteria,products  WHERE product_criteria.Product_id=products.Product_id AND  category IN ('Audio Conferencing Equipment','Network Equipment','Video Conferencing Equipment','','Conferencing Equipment')  AND (products.Product_id IN (SELECT product_criteria.Product_id FROM product_criteria WHERE (product_criteria.Criteria_Name='Resolution' AND product_criteria.Criteria_Value='Standard Definition' ))  ) AND Status<>'Hide in List' AND Status<>'Discontinued' AND products.Category  in ('Conferencing Equipment','Audio Conferencing Equipment','Network Equipment','Video Conferencing Equipment','')  GROUP BY Criteria_Value,Criteria_Name ORDER BY Criteria_Name <br><br>--><!--


<br><br>SELECT DISTINCT products.* FROM products , product_criteria  WHERE  category IN ('Audio Conferencing Equipment','Network Equipment','Video Conferencing Equipment','','Conferencing Equipment')  AND (products.Product_id IN (SELECT product_criteria.Product_id FROM product_criteria WHERE (product_criteria.Criteria_Name='Resolution' AND product_criteria.Criteria_Value='Standard Definition' ))  ) AND Status<>'Hide in List' AND Status<>'Discontinued' AND products.Category  in ('Conferencing Equipment','Audio Conferencing Equipment','Network Equipment','Video Conferencing Equipment','')  ORDER BY Is_Accessory, Top_Seller DESC , Category, Our_Price, Name LIMIT 0,50<br><br>-->products_list