SELECT
Visit.StartTime,
CONCAT(Patient.LastName, ' ', Patient.FirstName) AS Pacjent,
Patient.PeselNo AS pesel,
`Procedure`.FullName,
`Procedure`.ProcCode,
VisitProcedure.`Count` * VisitProcedure.ProcedureCost AS Wartosc,
VisitProcedure.Teeth AS Zab
FROM  Visit
INNER JOIN Patient ON Patient.ID = Visit.PatientID
INNER JOIN VisitProcedure ON VisitProcedure.VisitID = Visit.ID
INNER JOIN `Procedure` ON `Procedure`.ID=VisitProcedure.ProcedureID
WHERE (DATE(Visit.StartTime) BETWEEN DATE([DateFrom]) AND DATE([DateTo]))
AND Patient.PatientGroupID ='ad25d042-06de-4e26-a68c-500ccfccd7ee'
AND `Procedure`.FolderID IN(SELECT ProcedureFolder.ID FROM ProcedureFolder WHERE ProcedureFolder.ParentID = '7625b860-2b1a-4c51-975d-7afe3726e34b')
AND VisitProcedure.X_RemoveTime is NULL
ORDER BY Visit.StartTime