Войти|
Видеокопилка Библиотека
Наш медиацентр
Видео ролик "Школьный клуб"
Фильм - информатизации в школе - итог
АТВ Ставрополь 05_05_2008 О КМ-школе
|
НАЧНИ УЧИТЬСЯ СЕЙЧАС!  Курсы Got error 28 from storage engine SELECT O.ID AS ObjID, O.UID AS ObjUID, O.OwnerID AS ObjOwnerID, O.RightID as ObjRightID , RTC.Description AS rtcDescription, RTC.PreviewImageFN AS rtcPreviewImageFN, RTC.Duration AS rtcDuration, RTC.GiveCertificate AS rtcGiveCertificate, RTC.Name AS rtcName, RTC.RootThemeID AS rtcRootThemeID, RTC.IsPublic AS rtcIsPublic, RTC.ShowStructureInDesc AS rtcShowStructureInDesc, RTC.AllowGroupWork AS ctoAllowGroupWork, RTC.GrpWSeVisibilityTypeID AS ctoGrpWSeVisibilityTypeID, RTC.GroupWorkPlanRootThemeID AS ctoGroupWorkPlanRootThemeID FROM objects O INNER JOIN rtcourses RTC ON O.ID = RTC.ID inner join asobjects aso on aso.ObjectID=O.ID inner join attachedstorage ast on ast.ID=aso.AttachedStorageID inner join portfolio pf on pf.ID=ast.OwnerObjectID WHERE (O.available = 1) AND RTC.IsPublic=1 AND NOT EXISTS (SELECT * FROM objects OO INNER JOIN rtcgroups RTCG ON RTCG.ID=OO.ID INNER JOIN rtcrequests RTCR ON RTCG.ID=RTCR.GroupID WHERE OO.available = 1 AND (RTCR.Approved = 1) AND (RTCG.IsActive = 1) AND (RTCR.UserID=100061270) AND RTCG.CourseID = O.ID LIMIT 1) ORDER BY (SELECT SUM(Rating * Count) / SUM(Count) AS Rating FROM objectratings WHERE ObjectID=O.ID) DESC LIMIT 4 |
