обучение испанскому языку
Родственные отношения
- user warning: Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'aminel_ru_db.qnrs.result_id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by query: SELECT COUNT(*) FROM ( SELECT qnrs.result_id FROM quiz_node_results qnrs LEFT JOIN users u ON u.uid = qnrs.uid LEFT JOIN quiz_node_properties qnp ON qnrs.vid = qnp.vid INNER JOIN ( SELECT qnrs.uid, MAX(qnrs.score) AS top_score FROM quiz_node_results qnrs LEFT JOIN users u ON u.uid = qnrs.uid LEFT JOIN quiz_node_properties qnp ON qnrs.vid = qnp.vid WHERE qnrs.nid = 436 AND time_end != 0 GROUP BY qnrs.uid ) AS qnrc ON qnrs.uid = qnrc.uid AND qnrs.score = qnrc.top_score WHERE qnrs.nid = 436 AND time_end != 0 GROUP BY qnrs.uid LIMIT 0, 500) tbl in /var/www/aminel.ru/data/www/aminel.ru/modules/quiz/quiz.admin.inc on line 2190.
- user warning: Expression #3 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'aminel_ru_db.qnrs.result_id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by query: SELECT u.name, qnrs.uid, qnrs.result_id, qnrs.score, qnrs.is_evaluated AS evaluated, qnrs.time_start as started, qnrs.time_end as finished, qnp.pass_rate, qnrs.time_end - qnrs.time_start as duration FROM quiz_node_results qnrs LEFT JOIN users u ON u.uid = qnrs.uid LEFT JOIN quiz_node_properties qnp ON qnrs.vid = qnp.vid INNER JOIN ( SELECT qnrs.uid, MAX(qnrs.score) AS top_score FROM quiz_node_results qnrs LEFT JOIN users u ON u.uid = qnrs.uid LEFT JOIN quiz_node_properties qnp ON qnrs.vid = qnp.vid WHERE qnrs.nid = 436 AND time_end != 0 GROUP BY qnrs.uid ) AS qnrc ON qnrs.uid = qnrc.uid AND qnrs.score = qnrc.top_score WHERE qnrs.nid = 436 AND time_end != 0 GROUP BY qnrs.uid ORDER BY finished DESC, qnrs.result_id DESC LIMIT 0, 50 in /var/www/aminel.ru/data/www/aminel.ru/modules/quiz/quiz.admin.inc on line 2190.