An Error Was Encountered

Error Number: 1064

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND brand_area = '日本品牌' LIMIT 0,30' at line 4

select uid,cosmetic_uid,title,infobody,class,efficacy,spec1,price1,spec2,price2,ping_img_num, imgurl_s,imgpath_s,imgurl_b,imgpath_b,clicks,ping_num,good_num,soso_num,bad_num, post_time,refresh_time,batch,enabled from ac_cosmetic_product where enabled = 1 and class LIKE '%眼霜%' order by refresh_time DESC, post_time DESC AND brand_area = '日本品牌' LIMIT 0,30