MYSQL QUERY ERROR REPORT - 23/04/2025 07:04:03 --------------------------------------- 1064 - 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 p.products_status = '1' and p.products_image!='' ...' at line 21 select distinct p.products_id, p.products_image, p.products_quantity, p.products_model, p.lable_1, p.manufacturers_id, p.lable_2, p.lable_3, p.amazone_rating,count(r.rating) as products_rating,p.amazone_reviews, p.products_price as products_price, s.specials_new_products_price, p.products_tax_class_id, pd.products_url, pd.products_name from products p left join products_to_categories p2c on p.products_id = p2c.products_id left join road r on r.product_id = p.products_id left join specials s on p.products_id = s.products_id and s.status = '1' and (s.expires_date >= CURDATE() or s.expires_date = '0000-00-00 00:00:00') , products_description pd where p.products_id in() and p.products_status = '1' and p.products_image!='' and p.products_id = pd.products_id and pd.language_id = 1 and p2c.categories_id in(146,26,125,157,174,160,161,158,138,50,128,98,97,99,61,107,155,106,103,118,85,57,132,76,72,100,75,74,73,56,111,200,22,67,68,69,66,163,166,164,20,108,177,25,52,127,104,51,134,62,23,17,28,29,192,84,30,70,32,33,172,194,171,170,139,185,168,36,37,198,176,129,38,181,124,39,123,136,156,86,197,173,80,40,195,41,137,42,43,153,154,179,44,141,199,81,196,45,113,46,47,78,82,193,60,19,182,21,184,102,117,110,116,101,140,114,105,122,18,178,191,189,190,145,95,55,165,162,58,53,188,143,144,48,159,71,87,90,91,88,115,89,92,93,94,130,65,133,59,49,54,109,112,167,187,180) group by p.products_id order by FIND_IN_SET(p.products_id,'') limit 50 --------------------------------------- Server Name : www.hollandindustry.com Remote Address: 108.162.242.98 Referer : https://www.hollandindustry.com/propagation-jiffy-7-peat-pellets-1000-box-42mm-p-159.html Requested : /jiffy-7-peat-pellets-1000-box-42mm-p-159.html