Список писем относящихся к СП 7.13130.2013 Изм.2 test: различия между версиями

Версия от 17:34, 29 декабря 2025

Error 1055: Expression #5 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'mediawiki.L.date__precision' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

Function: CargoSQLQuery::run Query: SELECT `L`.`num` AS `Номер`,`L`.`date` AS `Дата`,`L`.`topic` AS `Тема`,GROUP_CONCAT(`T`.`tag`, ", ") AS `Теги`,`L`.`date__precision` AS `Дата__precision` FROM `cargo__sp7_letters` `L` LEFT OUTER JOIN `cargo__sp7_letter_tags` `T` ON ((`L`.`num`=`T`.`num`)) GROUP BY `L`.`num`, `L`.`date`, `L`.`topic` ORDER BY `L`.`date` DESC LIMIT 100

@@ Строка 13: / Строка 13: @@
 |join on=L.num=T.num
 |fields=L.num=Номер, L.date=Дата, L.topic=Тема, GROUP_CONCAT(T.tag, ", ")=Теги
-|group by=L.num
+|group by=L.num, L.date, L.topic
 |order by=L.date DESC
 |format=table
 }}