Тезисы Конгресса. Просмотр по регионам    



Просмотр по секциям       |      Просмотр по алфавиту     |      Расширенный поиск тезисов

SQL Error: Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'ssa_rss.c.region_ru' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by at /home/shef/ssa-rss.ru/html/site_template/cmpl_tmp/abstract_view_region_vsk.html.php line 52
Array
(
    [code] => 1055
    [message] => Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'ssa_rss.c.region_ru' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
    [query] => SELECT c.region_ru AS region,INTERVAL(191,ASCII(a.region)) as lang, count(*) as count FROM abstract_vsk AS a
INNER JOIN abstract_region AS c ON c.region=a.region
GROUP BY a.region ORDER BY lang,count,c.region_ru 
    [context] => /home/shef/ssa-rss.ru/html/site_template/cmpl_tmp/abstract_view_region_vsk.html.php line 52
)