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 use index (pno)
left join nlkb_sritemDB_isbn_avg s on a.sritemID=s.sritemID
left join users_addinfo u on a.pno=u.num , nlkb_ctoi b
where a.edate>'2024-10-04 18:20:00' and a.holdnum>0 and a.badseller='N' and a.visible='Y' and b.itemID=a.itemID and a.pno='245188' and b.classID in () and (a.allbuy='n' or (a.allbuy='y' and a.rid<1)) and a.oan in ('11','21') group by a.itemID order by a.sell_price asc limit 0,30]
