Цитата |
---|
sql error: 2007-10-12 11:23:41 /home/go.php 1064 syntax error near 'vtvpmc' ORDER BY I.Step' at line 20 SELECT I.Theme, I.Item, LEFT(I.Item, POSITION('.' IN I.Item)-1) AS Media, round((Factor * Points - Late)*SubPoints/100, 1) AS Points, S.Status, I.Status as IStatus, I.MinPoints, NULL, P.Login, CONCAT(P.LastName, ' ', P.FirstName, ' ', P.FatherName) AS Name, P.LastName AS FIO, P.SchoolName As Nr, NOW() < ADDDATE(StatDate, INTERVAL 16 HOUR) AS NowStat FROM Item I LEFT JOIN Stat S ON S.Course = I.Course AND S.Theme = I.Theme AND S.Item = I.Item JOIN Person P ON P.Login = S.Login JOIN Login L ON L.Login = S.Login WHERE I.Course = 'pascal' AND LEFT(I.Item, 5) IN ('test.', 'pasca', 'olimp', 'gtest', 'strik') AND I.Step > 0 AND I.Status = 'next' AND P.Sector = 'ikt4'' AND L.School = 'vtvpmc' ORDER BY I.Step |