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-21 00:20:00' and a.holdnum>0 and a.badseller='N' and a.visible='Y' and (a.brand like 'DkPub%' or a.brand in ('CDK미디어','Cardinal Pub Group','Carson Dellosa Pub Co Inc','Carson Dellosa Publishing','Carson-Dellosa Pub Llc','Catholic Book Pub Co','Catholic Book Publishing Company','CENGAGE Learning Custom Publishing','Chariot Family Pub','Chariot Victor Pub','Charlesbridge Pub Inc','Charlesbridge Publishing','Chelsea House Pub','Chelsea House Publications','Cherry Lake Pub','Child's World / Grolier Publishing Co. Inc.','ddk','Dandak Publishing','Dandak Publishing, LLC','Darby Creek Pub','Darby Creek Publishing','David R. Godine Publisher','Dawn Publications (CA)','Dawn Publications (CA) |','Dawn Pubns','Dell Pub Co','Delta Publishing Company','Delta Publishing Company(CA)','Design Eye Publishing','Design Media Publishing','Destiny Image Pub','DK','DK Children','DK ELT/Schools','DK Ink','DK Juvenile Low','DK Preschool','Dk Pub','DK Publishin','DK Publishing','DK Publishing (Dorling Kindersley)','DKBOOK','DKJS(지식플러스)','DKPublishing,Inc.','DK로드','DK로드북스','DK출판사','Dorling Kindersley Publishing(DK)','Disney Publications International','Dogwise Pub','Dorling Kindersley Publishing','Dorling Kindersley Publishing, Incorporated','Dover Publications','Dover Pubns','Drawn & Quarterly Pubns','Fabien CousteauDk Pub','Excel Publishing','Express Publishing','F & W Pubns Inc','Fairchild Publications','Federal Publications','Ferguson Pub','Flame Tree Publishing Co Ltd','Flying Frog Publishing','KODKOD','Kingfisher Publications','Knopf Doubleday Publishing Gro','KP Publisher','SDKOREA','SCHOOL SPECIALTY PUBLISHING','SCHOOL SPECIAYTY PUBLISHING','School Zone Pub Co','SEJIN EDUCATIONAL PUBLICATION','Severn House Pub Ltd','Shamrock Publishing, Incorporated','Simon & Schuster Children's Publ')) and (a.allbuy='n' or (a.allbuy='y' and a.rid<1)) order by a.sell_price asc limit 0,30]
