select s.service_id s.abstract_service_id a.abstract_service CONCAT_WS(' - ', a.abstract_service, m.modifier) as service g.analytic_code g.area g.area_code a.code as abstract_service_code m.code as modifier_code c.modifier_class c.modifier_class_id m.modifier m.modifier_id s.manager_id u.login u.firstname u.middlename u.lastname u.email s.descr s.commercial_note s.is_internal a.status_id st.status s.measure_id n.measure s.vat_perc s.vat_free (select count(*) from service_param sp where sp.service_id=s.service_id) as param_count (select count(*) from abstract_service_param_class ac where ac.abstract_service_id=a.abstract_service_id) as abstract_param_count from service s join abstract_service a on (s.abstract_service_id=a.abstract_service_id) left outer join modifier m on (s.modifier_id=m.modifier_id) left outer join modifier_class c on (a.modifier_class_id=c.modifier_class_id) left outer join area g on (a.area_id=g.area_id) left outer join status st on (s.status_id=st.status_id) left outer join measure n on (s.measure_id=n.measure_id) left outer join usr u on (s.manager_id=u.usr_id) where 1=1 order by select count(*) as cnt from service where 1=1 Варианты услуг (список конкретных услуг с характеристиками)

	#analytic_code# #area#	#request.skuCode(area_code,abstract_service_code,modifier_code)#	#service#	#abstract_service#	#modifier_class#	#modifier#	#abstract_param_count#	#param_count#	#lastname# #firstname# #middlename#	#status#	#measure#	Не облагается	#vat_perc#

#gridFooter#