PER NAME		Score	MD
Jan Juza		10.5	4
Jiri Drabek		19.5	4
Martin Abrman		60.8	4
Martin Pisar		10.85	4
Matej Horacek		41.8	4
Mirwais Alizada		9.45	4
Richard Holy		6.45	4
Robert Jost		15.4	4
Roman Kapitan		0.75	4
Sascha Gräber		19.65	4
Slavomir Matousek	34.25	4
Vojtech Rozsival	6.1	4

SELECT     PER.PER_NAME, COUNT(SER.SER_OID) AS Number
FROM         OVSD_PERSONS AS PER 
			 INNER JOIN OVSD_SERVICECALLS AS SER ON PER.PER_OID = SER.SER_ASS_PER_TO_OID
			 INNER JOIN OVSD_PER_CUSTOM_FIELDS AS PCF ON PER.PER_OID = PCF.PEC_PER_OID 
			 INNER JOIN OVSD_REP_CODES_TEXT AS RCT ON SER.SER_CAT_OID = RCT.RCT_RCD_OID
WHERE     (LOWER(PCF.PEC_PERSHORTTEXT9) LIKE @l) AND (PER.PER_NOTSELECTABLE =  0 ) AND (SER.SER_ACTUALFINISH BETWEEN @d1 and @d2)
GROUP BY PER.PER_NAME, SER.SER_CAT_OID