SELECT 
  pc.category_id, 
  COUNT(pc.product_id) AS products_count 
FROM 
  cscart_products_categories AS pc 
  LEFT JOIN cscart_products AS p ON p.product_id = pc.product_id 
  LEFT JOIN cscart_companies AS c ON p.company_id = c.company_id 
WHERE 
  p.status = 'A' 
  AND p.paused = 'N' 
  AND c.status = 'A' 
  AND (
    p.amount >= p.min_qty 
    OR (
      p.min_qty IS NULL 
      AND p.amount > 0
    )
  ) 
  AND pc.category_id IN (
    34, 43, 60, 61, 69, 160, 85, 95, 96, 101, 
    104, 113, 119, 120, 124, 131, 78
  ) 
GROUP BY 
  pc.category_id