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/3103/
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 <> 3103
                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
)