select c.param_class_id c.param_class c.param_class_en m.measure_short (select count(*) from param p where p.param_class_id=c.param_class_id) as param_count (select count(*) from abstract_service_param_class ac where ac.param_class_id=c.param_class_id) as abstract_service_param_class_count from param_class c left outer join measure m on (c.measure_id=m.measure_id) where 1=1 order by select count(*) as cnt from param_class where 1=1 Компоненты (компоненты услуг)

	#param_class#	#param_class_en#	#measure_short#	#param_count#	#abstract_service_param_class_count#

#gridFooter#