SafeMySQL: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'ORDER BY `dir` DESC , market=1 desc, market=2 desc LIMIT 0,16' at line 10. Full query: [( SELECT jump_catalog_currency.course AS course, jump_catalog_items.`id`, jump_catalog_items.`sort`, jump_catalog_items.`name`, 0 AS `dir`, MIN(jump_files.`id`) AS `file_id` , jump_catalog_items.`url`, price_1, in_stock, `folder`, `filename`, delivery_date, market, sale, new, leader, spec FROM `jump_catalog_items` INNER JOIN `jump_catalog_items_cat_link` ON jump_catalog_items.`id`=jump_catalog_items_cat_link.`item_id`LEFT JOIN `jump_files` ON (jump_catalog_items.`id`=jump_files.`item_id` AND `type`='item') LEFT JOIN `jump_catalog_currency` ON (jump_catalog_items.`currency_id`=jump_catalog_currency.`id`) LEFT JOIN `jump_catalog_items_params` AS p_501 ON (jump_catalog_items.`id`=p_501.`item_id` AND p_501.`param_id`=501) WHERE `jump_files`.is_image = 1 and jump_catalog_items.`lang`='ru' AND jump_catalog_items.active='1' AND jump_catalog_items.in_stock='1' AND p_501.`value` IN (1454) AND ((jump_catalog_items_cat_link.`cat_id`=127) OR (jump_catalog_items_cat_link.`cat_id` in (SELECT id from jump_catalog_cats where parent_id=127 ) ) ) GROUP BY jump_catalog_items.`id` ORDER BY jump_catalog_items.`sort` ASC, jump_catalog_items.`name` ASC ORDER BY `dir` DESC , market=1 desc, market=2 desc LIMIT 0,16 ]. Error initiated in /home/sadovodu/www/sadovodu.ru/jump/classes/cms/ccatalog_pub.php on line 375, thrown
Fatal error: SafeMySQL: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'ORDER BY `dir` DESC , market=1 desc, market=2 desc LIMIT 0,16' at line 10. Full query: [( SELECT jump_catalog_currency.course AS course, jump_catalog_items.`id`, jump_catalog_items.`sort`, jump_catalog_items.`name`, 0 AS `dir`, MIN(jump_files.`id`) AS `file_id` , jump_catalog_items.`url`, price_1, in_stock, `folder`, `filename`, delivery_date, market, sale, new, leader, spec FROM `jump_catalog_items` INNER JOIN `jump_catalog_items_cat_link` ON jump_catalog_items.`id`=jump_catalog_items_cat_link.`item_id`LEFT JOIN `jump_files` ON (jump_catalog_items.`id`=jump_files.`item_id` AND `type`='item') LEFT JOIN `jump_catalog_currency` ON (jump_catalog_items.`currency_id`=jump_catalog_currency.`id`) LEFT JOIN `jump_catalog_items_params` AS p_501 ON (jump_catalog_items.`id`=p_501.`item_id` AND p_501.`param_id`=501) WHERE `jump_files` in /home/sadovodu/www/sadovodu.ru/jump/classes/ext/safemysql.class.php on line 605