Error on file /var/www/catalog/www/includes/database_mysql.php at line 280
Message [1]: Ошибка в запросе к базе данных!
Call stack:
CSiteBase->Main - [/var/www/catalog/www/index.php], 35
CSiteBase->Main_NonCLI - [/var/www/catalog/www/includes/site.php], 567
CSiteBase->Translate - [/var/www/catalog/www/includes/site.php], 950
CSiteBase->ExecuteModule - [/var/www/catalog/www/includes/site.php], 1585
CModule->main - [/var/www/catalog/www/includes/site.php], 1355
CModule->translate - [/var/www/catalog/www/includes/module.php], 338
CModule->execute_function - [/var/www/catalog/www/includes/module.php], 309
MODULE_shop->modf_index - [/var/www/catalog/www/includes/module.php], 269
MODULE_shop->append_similar_links - [/var/www/catalog/www/modules/shop.php], 525
CDatabaseAbstract->query_struct - [/var/www/catalog/www/modules/shop.php], 196
CDatabaseAbstract->query - [/var/www/catalog/www/includes/database.php], 428
CDatabase_mysql->_query - [/var/www/catalog/www/includes/database.php], 177
CBase->Error - [/var/www/catalog/www/includes/database_mysql.php], 280
URI: /shop/6083/
IP: 207.241.237.235
HOST: www.mos-catalog.ru
Array
(
[sql] => SELECT * FROM (
SELECT shop.*, count(comments.id) AS comments_cnt,
(
SELECT count(*)
FROM site_shops_physical physical
WHERE physical.shop_id = shop.id
) AS phys_cnt
FROM site_shops shop
LEFT JOIN site_shops_comments comments
ON comments.shop_id = shop.id
LEFT JOIN site_shops_rubrics AS rubrics
ON rubrics.shop_id = shop.id
WHERE rubrics.rubric_id =
AND shop.city_id = 1
AND shop.descr IS NOT NULL
AND shop.id <> 6083
GROUP BY shop.id
) AS res
WHERE res.phys_cnt <> 0
ORDER BY res.comments_cnt DESC
LIMIT 30
[mysql_error] => You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND shop.city_id = 1
AND shop.descr IS NOT NULL
' at line 15
[mysql_errno] => 1064
[_backtrace_size_first] => 12
[_backtrace_line] => 280
[_backtrace_file] => /var/www/catalog/www/includes/database_mysql.php
)