Сибирский
0
Репутация
0
Рейтинг
Если выбрать категорию новостей, то ошибка на сайте:
503
Ошибка в запросе БД:
Повторяющаяся таблица/псевдоним 'b'
SELECT DISTINCT i.*, c.title as `cat_title`, c.slug as `cat_slug`, u.nickname as `user_nickname`, u.slug as `user_slug`, u.is_deleted as `user_is_deleted`, u.groups as `user_groups`, u.avatar as `user_avatar`, u.privacy_options as `user_privacy_options`, f.title as `folder_title`, cat.title as `cat_title`, cat.slug as `cat_slug`
FROM cms_con_news i
FORCE INDEX (date_pub)
INNER JOIN cms_con_news_cats_bind as b FORCE INDEX (item_id) ON b.item_id = i.id
INNER JOIN cms_con_news_cats as c ON c.id = b.category_id
INNER JOIN cms_con_news_cats_bind as b ON b.item_id = i.id
INNER JOIN cms_con_news_cats as c ON c.id = b.category_id
INNER JOIN cms_users as u ON u.id = i.user_id
LEFT JOIN cms_content_folders as f ON f.id = i.folder_id
LEFT JOIN cms_con_news_cats as cat ON cat.id = i.category_id
WHERE (c.ns_left >= '2') AND (c.ns_right <= '3') AND (c.ns_left >= '2') AND (c.ns_right <= '3') AND (i.is_private = '0') AND (i.is_approved = '1') AND (i.is_deleted IS NULL) AND (i.is_pub = '1')
ORDER BY i.date_pub desc
LIMIT 3
Последние вызовы:
cmsModel->get() @ /system/controllers/content/model.php: 1761
modelContent->getContentItems() @ /system/controllers/fox/widgets/content/widget.php: 77
widgetFoxContent->run() @ /system/core/core.php: 908
cmsCore->runWidget() @ /system/core/core.php: 861
cmsCore->runWidgets() @ /index.php: 51