01.SELECT
02. DISTINCT ipdinfo.hn as codeuser,
03. (
04. SELECT syscon.Name as name
05. FROM prefix
06. LEFT JOIN syscon ON prefix.codeuser = syscon.Code
07. WHERE codeuser = info.Code
08. AND Suffix = patname.Suffix
09. AND syscon.Code = 100
10. ) PrefixName
11.FROM ipdinfo
12.LEFT JOIN codemas ON info.codeuser = codemas.codeuser
13.LEFT JOIN patname ON info.hn = patname.hn
14.LEFT JOIN syscon ON codemas.Code = syscon.Code
15.WHERE info.HDBDateTime is not null
16. AND info.DateTime BETWEEN '".$Datestart."' AND '".$EndDate."'
17. AND syscon.Code = 52615 and codemas.Code is not null
18. AND codemas.Codecxl in ('45','99')
19. AND patname.Suffix='0'
