$kategoriler = mssql_query("select (select count(product_id)from products where products.anakategori=category.category_id) as urunsayisi,
category.category_name, category.link,category.ust, category.category_id from category left join products on (products.category_id=category.category_id)
where category.ust='0' ");
Arkadaşlar gruplama yapmam lazım ama yazdıgım kod çalışmıyor.

$kategoriler = mssql_query("select (select count(product_id)from products where products.anakategori=category.category_id) as urunsayisi,
	category.category_name, category.link,category.ust, category.category_id from category  
	left join products on (products.category_id=category.category_id)
	where category.ust='0'  GROUP BY category_id");
sizce nasıl olmalıdır ?