SQL QUERY:
SELECT Q.*, Q.QuizId as QuizIdSort, Q.StatusExpert as Expert,QC.CategoryName,QC.CategoryId,QOC.CategoryName as OblCategoryName,QOC.CategoryId as OblCategoryId,src.cstat, src.cuser, place1.place1, place2.place2, place3.place3, place4.place4
FROM #__ariquiz Q
LEFT JOIN #__ariquizquizcategory QQC ON Q.QuizId = QQC.QuizId
LEFT JOIN #__ariquizcategory QC ON QQC.CategoryId = QC.CategoryId
LEFT JOIN #__ariquizquizoblcategory QQOC ON Q.QuizId = QQOC.QuizId
LEFT JOIN #__ariquizoblcategory QOC ON QQOC.CategoryId = QOC.CategoryId
LEFT JOIN (SELECT td.quiz_id, count(td.id) as cstat, SUM(td.state_user) as cuser FROM #__testres_diplom as td GROUP BY td.quiz_id ORDER BY cstat DESC) as src ON src.quiz_id=Q.QuizId
LEFT JOIN (SELECT td.quiz_id, count(td.id) as place1 FROM #__testres_diplom as td WHERE td.place_name="1" GROUP BY td.quiz_id) as place1 ON place1.quiz_id=Q.QuizId
LEFT JOIN (SELECT td.quiz_id, count(td.id) as place2 FROM #__testres_diplom as td WHERE td.place_name="2" GROUP BY td.quiz_id) as place2 ON place2.quiz_id=Q.QuizId
LEFT JOIN (SELECT td.quiz_id, count(td.id) as place3 FROM #__testres_diplom as td WHERE td.place_name="3" GROUP BY td.quiz_id) as place3 ON place3.quiz_id=Q.QuizId
LEFT JOIN (SELECT td.quiz_id, count(td.id) as place4 FROM #__testres_diplom as td WHERE td.place_type="Лауреат" GROUP BY td.quiz_id) as place4 ON place4.quiz_id=Q.QuizId
WHERE (QQC.CategoryId IN (SELECT CC.CategoryId FROM #__ariquizcategory PC,#__ariquizcategory CC WHERE PC.CategoryId = 2 AND CC.lft >= PC.lft AND CC.rgt <= PC.rgt)) AND Q.Status=1
ORDER BY QC.CategoryId asc,QOC.CategoryName asc
FILTER OBJECT:
AriDataFilter Object
(
[_config] => Array
(
[sortField] => QC.CategoryId
[sortDirection] => asc
[secondarySorting] => Array
(
[0] => Array
(
[sortField] => QOC.CategoryName
[sortDirection] => asc
)
)
[startOffset] => 0
[limit] =>
[filter] => Array
(
[Status] => 1
[CategoryId] => 2
[IncludeSubcategories] => 1
)
)
[_allowSortFields] =>
[_persistanceKey] =>
[_errors:protected] => Array
(
)
)
GET PARAMETERS:
Array
(
[lang] => ru
)
POST PARAMETERS:
Array
(
)