SELECT dbo.TBLsite_calender.CalenderGuid,TBLsite_calender.CalenderTicketCount,dbo.TBLsite_calender.logicalName, dbo.TBLsite_calender.CalenderName, dbo.TBLsite_calender.CalenderText, dbo.TBLsite_calender.CalenderTime, dbo.TBLsite_calender.CalenderDate, dbo.TBLsite_calender.pictureName, dbo.TBLsite_calender.picturePath, dbo.TBLsite_calender.SiteGuid, dbo.TBLSite_relation.relationName, dbo.TBLSite_relation.relationDescription FROM dbo.TBLSite_relation INNER JOIN dbo.TBLsite_calender ON dbo.TBLSite_relation.toEntityGuid = dbo.TBLsite_calender.CalenderGuid WHERE (dbo.TBLsite_calender.SiteGuid IN (11072,11073,11074,11075,11228,12244,11869)) AND (dbo.TBLsite_calender.CalendarFreeText = '') AND (dbo.TBLSite_relation.fromModuleGuid = 0) AND (dbo.TBLSite_relation.fromSubModuleGuid = 0) AND (dbo.TBLSite_relation.fromSiteGuid IN (11072,11073,11074,11075,11228,12244,11869)) AND (dbo.TBLSite_relation.toSiteGuid IN (11072,11073,11074,11075,11228,12244,11869)) AND (dbo.TBLSite_relation.toModuleGuid = 28) AND (dbo.TBLSite_relation.toSubModuleGuid = 0) AND (dbo.TBLSite_relation.relationStartDate <= GETDATE() OR dbo.TBLSite_relation.relationStartDate IS NULL) AND (dbo.TBLSite_relation.relationEndDate >= GETDATE() OR dbo.TBLSite_relation.relationEndDate IS NULL) AND (dbo.TBLSite_relation.fromEntityGuid = 0) AND (dbo.TBLsite_calender.CalenderDate >= CONVERT(datetime,'2017-6-23', 102)) ORDER BY dbo.TBLSite_relation.relationSortInt, dbo.TBLsite_calender.CalenderDate, dbo.TBLsite_calender.CalenderTime