Error [select HIGH_PRIORITY a.oan,a.fid,a.rid,a.allbuy,a.itemID,a.sritemID,a.searchid,a.item_name,a.addit_name,a.brand,a.b_price,a.sell_price,a.sell_price_super,a.sell_price_rent,a.section,a.btype,a.time_price,a.dis_price,a.mileage_price,a.titem_write_rate,a.oyear,a.byear,a.holdnum,a.pid,a.pno,a.pnick,a.inum,a.giftID,a.item_age,a.sellnum,a.rdirname,a.lrfile1,a.sfile,u.d_cost,u.d_cost_limit,u.credit,s.sopen_fid,s.hcode,s.b_auth,s.compare_cnt from nlkb_itemDB a left join nlkb_sritemDB_isbn_avg s on a.sritemID=s.sritemID left join users_addinfo u on a.pno=u.num where a.edate>'2026-06-17 21:00:00' and a.holdnum>0 and a.badseller='N' and a.visible='Y' and (a.brand like 'Macmillan%' or a.brand in ('MACMILLAN','Macmillan','MacMillan Audio','Macmillan Children','Macmillan Children's','Macmillan Children's Books','Macmillan Childrens Books','Macmillan Company','Macmillan Education Ltd','Macmillan ELT','MacMillan Kids','Macmillan McGraw-Hill','Macmillan Pub Ltd','Macmillan Uk','Macmillan US','Macmillan Young Listeners','MACMILLAN/ McGRAW-HILL','MacMillan/McGraw-Hill','Macmillan/McGraw-Hill School','Macmillan/McGraw-Hill School Div','Macmillan/McGraw-Hill School Division','Palgrave Macmillan','Pan MacMillan','Pan MacMillan Childrens','SRA Macmillan/McGraw-Hill','U.S.A.: Macmillan/McGraw-Hill')) and (a.allbuy='n' or (a.allbuy='y' and a.rid<1)) order by a.sell_price asc limit 0,30]