8 495 921-34-34 Отдел продаж
- Назад
- Телефоны
- 8 495 921-34-34 Отдел продаж
- 8 800 777-34-34 Отдел продаж
- *2134 Отдел продаж
- Заказать звонок
Отдел продаж
zakaz@vodovoz.ru

Для поставщиков
714@vodovoz.ru

Отдел рекламы
reklama@vodovoz.ru
Москва, Волгоградский проспект, д.42
Круглосуточно

Поиск: teabar

Главная Каталог 0 Корзина 0 Избранные Кабинет 0 Сравнение

Приложение Акции Контакты Услуги Бренды Отзывы Блог

Class: CRatings
File: /var/www/www-root/data/www/vodovoz.ru/bitrix/modules/main/classes/mysql/ratings.php
Function: CRatingsComponentsBlog::CalcActivity
Line: 144
MySQL Query Error: INSERT INTO b_rating_component_results (RATING_ID, MODULE_ID, RATING_TYPE, NAME, COMPLEX_NAME, ENTITY_ID, ENTITY_TYPE_ID, CURRENT_VALUE) SELECT '1' as RATING_ID, 'BLOG' as MODULE_ID, 'RATING' as RATING_TYPE, 'ACTIVITY' as NAME, 'USER_BLOG_RATING_ACTIVITY' as COMPLEX_NAME, ENTITY_ID, 'USER' ENTITY_TYPE_ID, SUM(CURRENT_VALUE) CURRENT_VALUE FROM ( SELECT AUTHOR_ID as ENTITY_ID, SUM(IF(TO_DAYS(DATE_PUBLISH) > TO_DAYS(NOW())-1, 1, 0))*0.4 + SUM(IF(TO_DAYS(DATE_PUBLISH) > TO_DAYS(NOW())-7, 1, 0))*0.2+ COUNT(*)*0.1 as CURRENT_VALUE FROM b_blog_post WHERE DATE_PUBLISH > DATE_SUB(NOW(), INTERVAL 30 DAY) AND PUBLISH_STATUS = 'P' GROUP BY AUTHOR_ID UNION ALL SELECT AUTHOR_ID as ENTITY_ID, SUM(IF(TO_DAYS(DATE_CREATE) > TO_DAYS(NOW())-1, 1, 0))*0.2 + SUM(IF(TO_DAYS(DATE_CREATE) > TO_DAYS(NOW())-7, 1, 0))*0.1 + COUNT(*)*0.05 as CURRENT_VALUE FROM b_blog_comment WHERE DATE_CREATE > DATE_SUB(NOW(), INTERVAL 30 DAY) AND PUBLISH_STATUS = 'P' GROUP BY AUTHOR_ID ) q WHERE ENTITY_ID > 0 GROUP BY ENTITY_ID[[167] Out of range value for column 'ID' at row 1]
MySQL Query Error!