Have some troubles: SQL:: prepare() failed. SQL:
SELECT TRIM( TAG ) TAG, COUNT(*) CNT
FROM TAG
WHERE NEWS IN ( SELECT ID FROM CORE_NEWS WHERE `SHOW` = 'Y' AND LANG = 'RU')
GROUP BY UPPER( TRIM( TAG ))
ORDER BY TAG
error:
Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'wakef.TAG.TAG' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
LINE: | 420 |
FILE: | /var/www/www-root/data/www/wakeflot.ru/lib/sql.php |
TRACE: | /var/www/www-root/data/www/wakeflot.ru/lib/core.php | 696 | SQL2A | | /var/www/www-root/data/www/wakeflot.ru/index.php | 226 | __construct | |
|