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 variant_id in (695)) order by (case when spbkrovli_catalogue_list.price_redu' at line 1 at /home/u305130/nevastroy.com/www/_modules/spbkrovli_catalogue/spbkrovli_catalogue.module.php line 950
Array
(
    [code] => 1064
    [message] => 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 variant_id in (695)) order by (case when spbkrovli_catalogue_list.price_redu' at line 1
    [query] => select SQL_CALC_FOUND_ROWS spbkrovli_catalogue_list.*,spbkrovli_catalogue_categories.name as category_name,spbkrovli_catalogue_categories.measure as category_measure,spbkrovli_catalogue_marks.name as mark_name,spbkrovli_catalogue_collections.name as collection_name,spbkrovli_images.filename from spbkrovli_catalogue_list inner join spbkrovli_catalogue_categories on spbkrovli_catalogue_categories.id=spbkrovli_catalogue_list.category_id and spbkrovli_catalogue_categories.publish inner join spbkrovli_catalogue_marks on spbkrovli_catalogue_marks.id=spbkrovli_catalogue_list.mark_id and spbkrovli_catalogue_marks.publish left join spbkrovli_catalogue_collections on spbkrovli_catalogue_collections.id=spbkrovli_catalogue_list.collection_id and spbkrovli_catalogue_collections.publish left join spbkrovli_images on spbkrovli_catalogue_list.photo_id=spbkrovli_images.id where spbkrovli_catalogue_list.publish and (case when spbkrovli_catalogue_list.collection_id!=0 and spbkrovli_catalogue_collections.id is null then false else true end) and spbkrovli_catalogue_marks.is_compl!=1 and spbkrovli_catalogue_list.category_id=8 and spbkrovli_catalogue_list.collection_id not in (select collection_id from spbkrovli_catalogue_list_link_compl where category_id=8) and spbkrovli_catalogue_list.id in (select object_id from spbkrovli_catalogue_chars_one_from_values where char_id= and variant_id in (695)) order by (case when spbkrovli_catalogue_list.price_reduced is not null then spbkrovli_catalogue_list.price_reduced else spbkrovli_catalogue_list.price end),spbkrovli_catalogue_list.taborder limit 0,20
    [context] => /home/u305130/nevastroy.com/www/_modules/spbkrovli_catalogue/spbkrovli_catalogue.module.php line 950
)