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 = 3248) OR (cp.category_id = 3270) OR (cp.category_id = 3280) OR (cp.category_id = 3288) OR (cp.category_id = 3302) OR (cp.category_id = 3372) OR (cp.category_id = 3271) OR (cp.category_id = 3273) OR (cp.category_id = 3277) OR (cp.category_id = 3284) OR (cp.category_id = 3292) OR (cp.category_id = 3272) OR (cp.category_id = 3349) OR (cp.category_id = 3351) OR (cp.category_id = 3364) OR (cp.category_id = 3366) OR (cp.category_id = 3388) OR (cp.category_id = 3405) OR (cp.category_id = 3274) OR (cp.category_id = 3334) OR (cp.category_id = 3339) OR (cp.category_id = 3353) OR (cp.category_id = 3367) OR (cp.category_id = 3375) OR (cp.category_id = 3385) OR (cp.category_id = 3400) OR (cp.category_id = 3421) OR (cp.category_id = 3278) OR (cp.category_id = 3409) OR (cp.category_id = 3401) OR (cp.category_id = 3398) OR (cp.category_id = 3397) OR (cp.category_id = 3386) OR (cp.category_id = 3368) OR (cp.category_id = 3350) OR (cp.category_id = 3346) OR (cp.category_id = 3337) OR (cp.category_id = 3419) OR (cp.category_id = 3285) OR (cp.category_id = 3336) OR (cp.category_id = 3387) OR (cp.category_id = 3408) OR (cp.category_id = 3293) OR (cp.category_id = 3338) OR (cp.category_id = 3348) OR (cp.category_id = 3352) OR (cp.category_id = 3370) OR (cp.category_id = 3407) OR (cp.category_id = 3420) OR (cp.category_id = 3281) OR (cp.category_id = 3428) OR (cp.category_id = 3402) OR (cp.category_id = 3369) OR (cp.category_id = 3358) OR (cp.category_id = 3345) OR (cp.category_id = 3344) OR (cp.category_id = 3342) OR (cp.category_id = 3323) OR (cp.category_id = 3295) OR (cp.category_id = 3459) OR (cp.category_id = 3324) OR (cp.category_id = 3383) OR (cp.category_id = 3289) OR (cp.category_id = 3330) OR (cp.category_id = 3303) OR (cp.category_id = 3305) OR (cp.category_id = 3315) OR (cp.category_id = 3304) OR (cp.category_id = 3325) OR (cp.category_id = 3354) OR (cp.category_id = 3355) OR (cp.category_id = 3306) OR (cp.category_id = 3326) OR (cp.category_id = 3327) OR (cp.category_id = 3316) OR (cp.category_id = 3317) OR (cp.category_id = 3318)) 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(2612) "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(2612) "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(2604) "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.