select DISTINCT u.strusername, ROW_NUMBER() OVER ( order by Educationstartdate asc ) AS 'RowID', mpp.*, mppt.*, meo.*, mec.nimi as Citynimi,d.deptname from ModulStorage_Education_Educations mpp left join ModulStorage_Education_Educations_Translations mppt on mppt.Educationid=mpp.id LEFT JOIN modulstorage_Education_Optionals meo on meo.educationid=mpp.id left join users u on u.intuserid = mpp.modifier left join ModulStorage_Education_Category_Educations MECE on MECE.Educationid = MPP.id left join ModulStorage_Education_Category MECA on MECA.id = MECE.Categoryid left join modul_education_city mec on mec.id = mpp.EducationCompletionPlace left join depts d on d.deptid = mpp.EducationOrganizer LEFT JOIN Modul_EducationList_Category melc ON melc.LocationID = '725dd2fc-e5d2-4ac9-8713-6d1aa742e6ff' where mpp.deleted = 0 AND melc.deptid = mpp.EducationOrganizer and mppt.languageid=3 and (EducationStartDate between getdate() and (dateadd(d,100,getdate())) ) order by Educationstartdate asc