Самые активные пользователи за последние 180 дней [Июль 2020]
#
Имя
Сообщения
Процент
График
Самые активные пользователи месяца [Январь 2021]
#
Имя
Сообщения
Процент
График
Самые активные пользователи недели [Пн - Вс]
#
Имя
Сообщения
Процент
График
Общая ошибка
Couldn't retrieve posts data
DEBUG MODE
SQL Error : 1055 Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column 'vr.phpbb_posts.post_time' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
SELECT YEAR(FROM_UNIXTIME(post_time)) as aar, MONTH(FROM_UNIXTIME(post_time)) as mnd, COUNT(*) AS ant
FROM phpbb_posts
GROUP BY YEAR(FROM_UNIXTIME(post_time)),MONTH(FROM_UNIXTIME(post_time))
ORDER BY post_time Line : 48 File : module.php