Error [select HIGH_PRIORITY a.oan,a.itemID,a.sritemID,a.fid,a.rid,a.allbuy,a.mdate,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.oyear,a.byear,a.holdnum,a.pid,a.pno,a.pnick,a.inum,a.giftID,a.item_age,a.sellnum,a.mileage_price,a.titem_write_rate,a.rdirname,a.lrfile1,a.sfile,a.item_str,a.item_state,a.item_ext,u.d_cost,u.d_cost_limit,u.credit,timediff(now(),from_unixtime(a.mdate)) as timedff,s.sopen_fid,s.hcode,s.b_auth,s.compare_cnt,s.searchid
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, nlkb_ctoi b ,nlkb_ctoi v0
where a.edate>'2024-04-16 22:20:00' and a.holdnum>0 and a.badseller='N' and a.visible='Y' and b.itemID=a.itemID and a.pno='49886' and v0.classID='272' and v0.itemID=b.itemID and match(a.pnick) against ('*강아지똥**' in boolean mode) group by a.itemID order by a.sell_price asc limit 0,30]
