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 = 2352) 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 = 3246) OR (cp.category_id = 3282) OR (cp.category_id = 3389) OR (cp.category_id = 3390) OR (cp.category_id = 3392) OR (cp.category_id = 3394) OR (cp.category_id = 3403) OR (cp.category_id = 3410) OR (cp.category_id = 3412) OR (cp.category_id = 3413) OR (cp.category_id = 3414) OR (cp.category_id = 3432) OR (cp.category_id = 3478) OR (cp.category_id = 3480) OR (cp.category_id = 3490) OR (cp.category_id = 3380) OR (cp.category_id = 3373) OR (cp.category_id = 3365) OR (cp.category_id = 3287) OR (cp.category_id = 3290) OR (cp.category_id = 3291) OR (cp.category_id = 3299) OR (cp.category_id = 3307) OR (cp.category_id = 3314) OR (cp.category_id = 3319) OR (cp.category_id = 3329) OR (cp.category_id = 3331) OR (cp.category_id = 3332) OR (cp.category_id = 3340) OR (cp.category_id = 3341) OR (cp.category_id = 3343) OR (cp.category_id = 3495) OR (cp.category_id = 3393) OR (cp.category_id = 3391) OR (cp.category_id = 3404) OR (cp.category_id = 3415) OR (cp.category_id = 3423) OR (cp.category_id = 3429) OR (cp.category_id = 3481) OR (cp.category_id = 3308) OR (cp.category_id = 3309) OR (cp.category_id = 3384) OR (cp.category_id = 3494) OR (cp.category_id = 3376) OR (cp.category_id = 3411) OR (cp.category_id = 3493)) AND (pa.value = 2352) 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(1775) "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(1775) "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(1767) "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.