File /data/marcospo/html/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 (pa.value = 2348) AND p.detail_image <> '' AND p.catalog_number <> '' A...' at line 1 (select distinct p.id from products p left join product_variants pv on(pv.id=p.default_variant) left join price_cache pc on(pv.id=pc.variant_id and pc.dealer_id=0 AND pc.broker_id IS NULL and pc.is_default=1) left join product_attributes ps on(p.id = ps.product_id AND ps.attribute_id =1935 ) left join product_attributes pa on(p.id = pa.product_id AND pa.attribute_id =68 ) left join category_products cp on(p.id = cp.product_id) where (cp.category_id = 3275) OR (cp.category_id = 3286) OR (cp.category_id = 3491) OR (cp.category_id = 3371) OR (cp.category_id = 3357) OR (cp.category_id = 3356) OR (cp.category_id = 3347) OR (cp.category_id = 3333) OR (cp.category_id = 3294) OR (cp.category_id = 3283) OR (cp.category_id = 3279) OR (cp.category_id = 3276) OR (cp.category_id = 3492)) AND (pa.value = 2348) AND p.detail_image <> '' AND p.catalog_number <> '' AND pv.availability = '0').

Trace:

File /data/marcospo/html/nshop/dbconnection.php, line 25, class/function dbresult->dbresult, arg0 resource(7) of type (mysql link) , arg1 string(884) "select distinct p.id from products p left join product_variants pv on(pv.id=p.default_variant) left join price_cache pc on(pv.id=pc.varia.

File /data/marcospo/html/nshop/product_listing.php, line 35, class/function dbconnection->query, arg0 string(884) "select distinct p.id from products p left join product_variants pv on(pv.id=p.default_variant) left join price_cache pc on(pv.id=pc.varia.

File /data/marcospo/html/nshop/product_search.php, line 132, class/function product_listing::out, arg0 string(876) "select p.id from products p left join product_variants pv on(pv.id=p.default_variant) left join price_cache pc on(pv.id=pc.variant_id and.

File /data/marcospo/html/nshop/product_search.php, line 21, class/function product_search->out_content.

File /data/marcospo/html/nshop/nshop.php, line 128, class/function product_search->out_body.

File /data/marcospo/html/index.php, line 173, class/function nshop->out_body.