MySQL error in file: /engine/modules/news_in_period.php at line 167

Error Number: 1055

The Error returned was:
Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'shnyagi_sh.p.id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

SQL query:

SELECT p.id as id, p.approve as approve, count(p.autor) as autor, SUM( CASE WHEN p.comm_num <= 1 THEN p.comm_num WHEN p.comm_num > 1 and p.comm_num < 11 THEN p.comm_num*2 WHEN p.comm_num > 10 and p.comm_num < 21 THEN p.comm_num*3 WHEN p.comm_num > 20 and p.comm_num < 31 THEN p.comm_num*4 WHEN p.comm_num > 30 and p.comm_num < 41 THEN p.comm_num*5 WHEN p.comm_num > 40 and p.comm_num < 51 THEN p.comm_num*6 WHEN p.comm_num > 50 and p.comm_num < 101 THEN p.comm_num*7 WHEN p.comm_num > 100 and p.comm_num < 201 THEN p.comm_num*8 WHEN p.comm_num > 200 and p.comm_num < 251 THEN p.comm_num*9 WHEN p.comm_num > 250 and p.comm_num < 301 THEN p.comm_num*10 ELSE p.comm_num*20 END) as comm_num, SUM( CASE WHEN e.news_read <= 100 THEN e.news_read WHEN e.news_read > 100 and e.news_read < 201 THEN e.news_read*2 WHEN e.news_read > 200 and e.news_read < 501 THEN e.news_read*3 WHEN e.news_read > 500 and e.news_read < 1001 THEN e.news_read*4 WHEN e.news_read > 1000 and e.news_read < 2001 THEN e.news_read*5 WHEN e.news_read > 2000 and e.news_read < 5001 THEN e.news_read*6 WHEN e.news_read > 5000 and e.news_read < 10001 THEN e.news_read*7 WHEN e.news_read > 10000 and e.news_read < 20001 THEN e.news_read*8 WHEN e.news_read > 20000 and e.news_read < 25001 THEN e.news_read*9 WHEN e.news_read > 25000 and e.news_read < 30001 THEN e.news_read*10 ELSE e.news_read*100 END) as news_read, SUM( CASE WHEN e.rating <= 1 THEN e.rating WHEN e.rating > 1 and e.rating < 11 THEN e.rating*2 WHEN e.rating > 10 and e.rating < 21 THEN e.rating*3 WHEN e.rating > 20 and e.rating < 31 THEN e.rating*4 WHEN e.rating > 30 and e.rating < 41 THEN e.rating*5 WHEN e.rating > 40 and e.rating < 51 THEN e.rating*6 WHEN e.rating > 50 and e.rating < 101 THEN e.rating*7 WHEN e.rating > 100 and e.rating < 201 THEN e.rating*8 WHEN e.rating > 200 and e.rating < 251 THEN e.rating*9 WHEN e.rating > 250 and e.rating < 301 THEN e.rating*10 ELSE e.rating*20 END) as rating, SUM( CASE WHEN e.vote_num <= 1 THEN e.vote_num WHEN e.vote_num > 1 and e.vote_num < 11 THEN e.vote_num*2 WHEN e.vote_num > 10 and e.vote_num < 21 THEN e.vote_num*3 WHEN e.vote_num > 20 and e.vote_num < 31 THEN e.vote_num*4 WHEN e.vote_num > 30 and e.vote_num < 41 THEN e.vote_num*5 WHEN e.vote_num > 40 and e.vote_num < 51 THEN e.vote_num*6 WHEN e.vote_num > 50 and e.vote_num < 101 THEN e.vote_num*7 WHEN e.vote_num > 100 and e.vote_num < 201 THEN e.vote_num*8 WHEN e.vote_num > 200 and e.vote_num < 251 THEN e.vote_num*9 WHEN e.vote_num > 250 and e.vote_num < 301 THEN e.vote_num*10 ELSE e.vote_num*20 END) as vote_num, u.name as name, u.foto as foto FROM dle_post p, dle_post_extras e, dle_users u WHERE p.autor=u.name AND p.id=e.news_id AND p.date between '2026-01-01 00:00:00' and '2026-01-16 12:43:06' AND p.approve=1 AND autor not in (SELECT name FROM dle_users where user_group in (1,2,3,8,14,16)) group by p.autor order by count(p.autor)+SUM( CASE WHEN p.comm_num <= 1 THEN p.comm_num WHEN p.comm_num > 1 and p.comm_num < 11 THEN p.comm_num*2 WHEN p.comm_num > 10 and p.comm_num < 21 THEN p.comm_num*3 WHEN p.comm_num > 20 and p.comm_num < 31 THEN p.comm_num*4 WHEN p.comm_num > 30 and p.comm_num < 41 THEN p.comm_num*5 WHEN p.comm_num > 40 and p.comm_num < 51 THEN p.comm_num*6 WHEN p.comm_num > 50 and p.comm_num < 101 THEN p.comm_num*7 WHEN p.comm_num > 100 and p.comm_num < 201 THEN p.comm_num*8 WHEN p.comm_num > 200 and p.comm_num < 251 THEN p.comm_num*9 WHEN p.comm_num > 250 and p.comm_num < 301 THEN p.comm_num*10 ELSE p.comm_num*20 END) + SUM( CASE WHEN e.news_read <= 100 THEN e.news_read WHEN e.news_read > 100 and e.news_read < 201 THEN e.news_read*2 WHEN e.news_read > 200 and e.news_read < 501 THEN e.news_read*3 WHEN e.news_read > 500 and e.news_read < 1001 THEN e.news_read*4 WHEN e.news_read > 1000 and e.news_read < 2001 THEN e.news_read*5 WHEN e.news_read > 2000 and e.news_read < 5001 THEN e.news_read*6 WHEN e.news_read > 5000 and e.news_read < 10001 THEN e.news_read*7 WHEN e.news_read > 10000 and e.news_read < 20001 THEN e.news_read*8 WHEN e.news_read > 20000 and e.news_read < 25001 THEN e.news_read*9 WHEN e.news_read > 25000 and e.news_read < 30001 THEN e.news_read*10 ELSE e.news_read*100 END) + SUM( CASE WHEN e.rating <= 1 THEN e.rating WHEN e.rating > 1 and e.rating < 11 THEN e.rating*2 WHEN e.rating > 10 and e.rating < 21 THEN e.rating*3 WHEN e.rating > 20 and e.rating < 31 THEN e.rating*4 WHEN e.rating > 30 and e.rating < 41 THEN e.rating*5 WHEN e.rating > 40 and e.rating < 51 THEN e.rating*6 WHEN e.rating > 50 and e.rating < 101 THEN e.rating*7 WHEN e.rating > 100 and e.rating < 201 THEN e.rating*8 WHEN e.rating > 200 and e.rating < 251 THEN e.rating*9 WHEN e.rating > 250 and e.rating < 301 THEN e.rating*10 ELSE e.rating*20 END) + SUM( CASE WHEN e.vote_num <= 1 THEN e.vote_num WHEN e.vote_num > 1 and e.vote_num < 11 THEN e.vote_num*2 WHEN e.vote_num > 10 and e.vote_num < 21 THEN e.vote_num*3 WHEN e.vote_num > 20 and e.vote_num < 31 THEN e.vote_num*4 WHEN e.vote_num > 30 and e.vote_num < 41 THEN e.vote_num*5 WHEN e.vote_num > 40 and e.vote_num < 51 THEN e.vote_num*6 WHEN e.vote_num > 50 and e.vote_num < 101 THEN e.vote_num*7 WHEN e.vote_num > 100 and e.vote_num < 201 THEN e.vote_num*8 WHEN e.vote_num > 200 and e.vote_num < 251 THEN e.vote_num*9 WHEN e.vote_num > 250 and e.vote_num < 301 THEN e.vote_num*10 ELSE e.vote_num*20 END) DESC limit 12