SELECT SUM(CASE WHEN p.product_parent_id=0 THEN 1 ELSE 0 END) AS counter,'1' AS id,'Σε απόθεμα' AS name FROM `#__virtuemart_products` AS p WHERE (p.`product_in_stock` - p.`product_ordered` >0)