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 = 2351) 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 = 3296) OR (cp.category_id = 3321) OR (cp.category_id = 3396) OR (cp.category_id = 3417) OR (cp.category_id = 3422) OR (cp.category_id = 3438) OR (cp.category_id = 3439) OR (cp.category_id = 3440) OR (cp.category_id = 3443) OR (cp.category_id = 3444) OR (cp.category_id = 3395) OR (cp.category_id = 3381) OR (cp.category_id = 3322) OR (cp.category_id = 3335) OR (cp.category_id = 3361) OR (cp.category_id = 3362) OR (cp.category_id = 3363) OR (cp.category_id = 3374) OR (cp.category_id = 3378) OR (cp.category_id = 3379) OR (cp.category_id = 3487) OR (cp.category_id = 3418) OR (cp.category_id = 3474) OR (cp.category_id = 3485) OR (cp.category_id = 3441) OR (cp.category_id = 3448) OR (cp.category_id = 3479) OR (cp.category_id = 3482) OR (cp.category_id = 3442) OR (cp.category_id = 3483) OR (cp.category_id = 3484) OR (cp.category_id = 3445) OR (cp.category_id = 3446) OR (cp.category_id = 3447) OR (cp.category_id = 3486) OR (cp.category_id = 3489) OR (cp.category_id = 3488)) AND (pa.value = 2351) 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(1532) "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.vari.

File /data/marcospo/html/nshop/product_listing.php, line 35, class/function dbconnection->query, arg0 string(1532) "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.vari.

File /data/marcospo/html/nshop/product_search.php, line 132, class/function product_listing::out, arg0 string(1524) "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 an.

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.