MySQL Error!
Ошибка MySQL в файле: /home/r/rodich3k/plus71.ru/public_html/app/models/ModelBase.php at line 2553
Описание ошибки: 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 '' at line 19
Номер ошибки: 1064
SQL запрос:
SELECT DISTINCT p.id, p.title, p.url, p.availability, pv.price, pv.compare_price, br.title AS b_title, br.url AS b_url, br.image AS b_image FROM s_products AS p inner join s_products_variants AS pv on p.id = pv.product_id inner join s_products_brands AS pb on p.id = pb.product_id inner join s_brands AS br on br.id = pb.brand_id inner join s_products_properties AS prp on prp.product_id=p.id inner join s_properties_values AS prv on prv.id = prp.property_id inner join s_properties AS pr on pr.id = prv.prop_id inner join s_products_categories AS prcat on p.id = prcat.product_id WHERE p.is_active = 1 AND prcat.category_id = '3' AND p.id in ( select s_products_properties.`product_id` from `s_products_properties`, `s_properties_values` WHERE s_properties_values.`prop_id` = 6 AND ( s_properties_values.`id` = 28) AND s_products_properties.`property_id` = s_properties_values.`id` ) AND p.id in ( select s_products_properties.`product_id` from `s_products_properties`, `s_properties_values` WHERE s_properties_values.`prop_id` = 5 AND ( s_properties_values.title >= 60 AND s_properties_values.title <= 65 ) AND s_products_properties.`property_id` = s_properties_values.`id` ) GROUP BY p.id ORDER BY pv.price ASC LIMIT ,