Ошибка приложения
Ошибка: Произошла ошибка при обращении к базе данных.
You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'AND R.RESULT>0 AND R.COUNT>0 AND R.FINISHED
ORDER BY C.COMP_ID, T.TEST_ID, ' at line 13
Запрос:
SELECT
T.TEST_ID as testId,
(R.RESULT * 100 / R.COUNT) AS rate,
C.COMP_ID as id,
T.STEP as step,
C.SHORTREALNAME as name,
O.PUBLICNAME as company
FROM
CHAMP_RESULT R
LEFT JOIN CHAMP_COMPETITOR C ON(R.COMP_ID = C.COMP_ID AND R.CHAMP_ID=C.CHAMP_ID)
LEFT JOIN CHAMP_ORGANIZATION O ON(R.ORG_ID = O.ORG_ID AND R.CHAMP_ID=O.CHAMP_ID)
LEFT JOIN CHAMP_TEST T ON (T.TEST_ID=R.TEST_ID AND R.CHAMP_ID=T.CHAMP_ID)
WHERE R.CHAMP_ID=2 AND T.CHAIN= AND R.RESULT>0 AND R.COUNT>0 AND R.FINISHED
ORDER BY C.COMP_ID, T.TEST_ID, R.RESULT DESC
Стек:, line: . Function: ""
trapper.inc, line: 75. Function: ""
dbconnect.inc, line: 122. Class "DB", function: ""
read-chain.php, line: 33. Class "DB", function: ""
chainrating.php, line: 22. Function: ""
chainrating.php, line: 27. Class "PageResponse", function: ""
champapp.inc, line: 600. Class "PageResponse", function: ""
chainrating.php, line: 48. Class "ChampApp", function: ""
index.php, line: 96. Function: ""