SELECT 
  usp.product_id, 
  product.company_id, 
  descr.product, 
  COUNT(usp.product_id) AS `count` 
FROM 
  cscart_user_session_products AS usp 
  LEFT JOIN cscart_products AS product ON usp.product_id = product.product_id 
  LEFT JOIN cscart_product_descriptions descr ON product.product_id = descr.product_id 
WHERE 
  usp.type = 'W' 
  AND product.status = 'A' 
GROUP BY 
  usp.product_id 
ORDER BY 
  `count` DESC, 
  usp.product_id ASC 
LIMIT 
  0, 4;