select p.param_id c.param_class_id p.param p.param_short c.param_class m.measure_short p.code p.sort p.precision (select count(*) from service_param sp where sp.param_id=p.param_id) as svc_count from param p left outer join param_class c on (p.param_class_id=c.param_class_id) left outer join measure m on (p.measure_id=m.measure_id) where 1=1 order by select count(*) as cnt from param where 1=1 Варианты компонентов

	#param_class#	#param#	#param_short#	#code#	#measure_short#	#precision#	#sort#	#svc_count#

#gridFooter#