File nshop/dbresult.php, line 14], message Query failed: 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 'AND `cvp`.`product_id` IS NULL) t ON(t.product_id=pa.product_id) WHERE cf.catego' at line 8 (SELECT DISTINCT pa.attribute_id, av.id value_id, av.value FROM product_attributes pa JOIN attribute_values av ON(pa.value=av.id) JOIN category_filters cf ON (cf.attribute_id=pa.attribute_id) JOIN ( SELECT `cp`.`product_id` FROM `category_products` `cp` JOIN `price_cache` `price` ON (`cp`.`product_id`=`price`.`product_id` AND price.dealer_id=0 AND price.broker_id IS NULL AND `price`.`is_default`=1) JOIN `products` `p` ON (`cp`.`product_id`=`p`.`id` AND `p`.`in_sale`=1) LEFT JOIN `c_visibility_products` `cvp` ON (`cp`.`product_id`=`cvp`.`product_id` AND `cvp`.`dealer_id`=0) WHERE `cp`.`category_id`= AND `cvp`.`product_id` IS NULL) t ON(t.product_id=pa.product_id) WHERE cf.category_id=594 order by coalesce(0+av.value, av.id), av.value).

Trace:

File nshop/dbconnection.php, line 25, class/function dbresult->dbresult, arg0 resource(5) of type (mysql link) , arg1 string(780) "SELECT DISTINCT pa.attribute_id, av.id value_id, av.value FROM product_attributes pa JOIN attribute_values av ON(pa.value=av.id) JOIN cat.

File nshop/dbconnection.php, line 105, class/function dbconnection->query, arg0 string(780) "SELECT DISTINCT pa.attribute_id, av.id value_id, av.value FROM product_attributes pa JOIN attribute_values av ON(pa.value=av.id) JOIN cat.

File nshop/category_listing.php, line 82, class/function dbconnection->fetch_assocs, arg0 string(780) "SELECT DISTINCT pa.attribute_id, av.id value_id, av.value FROM product_attributes pa JOIN attribute_values av ON(pa.value=av.id) JOIN cat.

File nshop/nshop.php, line 120, class/function category_listing->out_body.

File index.php, line 71, class/function nshop->out_body.