|
|
|
|
|
På skolen kan du finde flere hyggehjørner, hvor du kan sidde sammen med dine kammerater i pauser. I kan også spille bordfodbold, Nintendo Wii eller pool, eller I kan dyste i fodbold eller basket udendørs.
|
|
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 (11073,11228,11869,11075,12244,11074,11072)) AND (dbo.TBLsite_calender.CalendarFreeText = '') AND (dbo.TBLSite_relation.fromModuleGuid = 25) AND (dbo.TBLSite_relation.fromSubModuleGuid = 0) AND (dbo.TBLSite_relation.fromSiteGuid IN (11073,11228,11869,11075,12244,11074,11072)) AND (dbo.TBLSite_relation.toSiteGuid IN (11073,11228,11869,11075,12244,11074,11072)) 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 = 90363) AND (dbo.TBLsite_calender.CalenderDate >= CONVERT(datetime,'2017-7-21', 102)) ORDER BY dbo.TBLSite_relation.relationSortInt, dbo.TBLsite_calender.CalenderDate, dbo.TBLsite_calender.CalenderTime
|
