Klaida SQL: 			SELECT * 
			FROM
				(
					SELECT 
						mn.MenuId as id,
						mn.ParentId as parent,
						mn.PointerId,
						mn.Name as text,
						mn.Alias,
						mn.LineAge,
						(SELECT count(p.ProductId) FROM Products p WHERE p.MenuId = mn.PointerId AND p.IsVisible = 1) AS Total
					FROM cms_menu mn
						JOIN cms_menu mn2 ON mn.PointerId = mn2.MenuId
					WHERE 
						mn.TreeId = '2' 
					AND 
						mn.IsVisible = 1 
					AND 
						mn.lang = 'ru'
					ORDER BY 
						mn2.ParentId, 
						mn2.SortOrder
				) tbl;klaidos tekstas: 

Server shutdown in progress