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>'2024-04-16 16:00:00' and a.holdnum>0 and a.badseller='N' and a.visible='Y' and (a.brand like 'HarryNAbrams%' or a.brand in ('Harry N Abrams','Harry N Abrams Inc','Harry N. Abrams','Hampton-Brown Books','Han's English School, Australia','HANA','hanaE&B(구 다우미디어)','HANCHIC(한시크)','Hand Print','HandC','Handprint Books Inc','HANDS ON ENGLISH','Hanford Mead Publishers, Incorporated','HANKOOK','hanl(하늘)','HANMI EDUCATION','HANS MEDIA','HANSHOUSE','Hansol(아이웰니스)','HAPPER COLLINS','Harcourt Brace & Company','Harcourt Brace and Company','Harcourt Brace Jovanovich','Harcourt Children's Books','Harcourt Childrens Books','HARCOURT EDUCATION COMPANY','Harcourt School Publishers Trophies: On Level Individual Reader Grade 2 Sam's Chase','HarcourtBraceandCompany','HARMONIE','Harmony Books','Harmony Hearth LLC','Harper Business','Harper Collins','Harper Collins Promotion','Harper Collins U.K','Harper Collins UK','Harper Collins USA','Harper Design |','Harper Design Intl','Harper Entertainment','Harper Perennial','Harper Perennial Modern Classics','Harper Teen','HarperBusiness','HarperCollins','HarperCollins (UK)','Harpercollins Children','HarperCollins Children's','Harpercollins Children's Books','Harpercollins Childrens','HarperCollins Childrens Book','Harpercollins Childrens Books','Harpercollins College Div','Harpercollins Juvenile','Harpercollins Pub Ltd','HarperCollins Publisher','HarperCollins Publishers','HarperCollins Publishers Limited','HarperCollins Publishers Ltd','HarperCollins Publishers, London','HarperCollinsChildren'sBooks','HarperEntertainment','HarperOne','HarperTeen','Harvard Business Review Press','Harvard Business School Pr','Harvard Univ David Rockefeller','Harvard Univ Pr','Harvard University Press','Hatje Cantz Pub','HAVEFUNCOCO(해브펀코코)')) and (a.allbuy='n' or (a.allbuy='y' and a.rid<1)) order by a.sell_price asc limit 0,30]
