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-20 22:10:00' and a.holdnum>0 and a.badseller='N' and a.visible='Y' and (a.brand like 'PenguinBooks%' or a.brand in ('Penguin','Penguin (edition )','Pacific Books','PAINFREE books(페인프리북스)','Pantheon Books','PAPER BOOKS','PaperBooks(페이퍼북스)','Parragon Books','PASSPORT BOOKS','Pauline Books & Media','Pavilion Books','PCKBOOKS','Pebble Books','Pedigree Books','Pegasus Books','Penguin Books','Penguin Books Ltd','Penguin Books, Limited','Penguin Books, Limited (UK)','Penguin Classic','Penguin Classics','Penguin Group','Penguin Group (USA) Incorporated','Penguin Group USA','Penguin Group(CA)','Penguin Pr','Penguin Publishing Group','Penguin Putnam','PENGUIN PUTNAM * TRADE','Penguin Putnam Books','Penguin Putnam~childrens Hc','Penguin Random House Children','Penguin Random House Children's UK','Penguin Random House Grupo USA','Penguin U.K','Penguin U.S','Penguin UK','Penguin USA','Penguin Workshop','Penguin Young Readers','Penguin Young Readers Group','Penguin(USA)','Peter Bedrick Books','Philomel Books','Phoenix Yard Books','Picture Window Books','PKM BOOKS','Plan D. Books','Portfolio Penguin','PMK BOOKS','Pocket Books','Pomegranate Books','Poppy Books','Priddy Bicknell Books','Priddy Books','PROFILE BOOKS','Profile Books Ltd - Economist books','PROFILER BOOKS','Puffin Books/ Viking Penguin Inc','Puffin Books','Purple Bear Books','pushBUTTON BOOKS(푸시버튼북스)','Quarry Books','Quirk Books','R & S Books','Random House Books for Young Rea','Random House Books for Young Readers','Random House Business Books','Random House Children's Books','Random House Children's Books |','Random House Childrens Books','The Penguin Press','Thomas Dunne Books','Viking An Imprint of Penguin Group','Viking Penguin','Viking Published by Penguin Group','Underwood Books','Uplands Books','UR Books','Usborne Books','Victor Books','Viking Books','Viking Books for Young Readers','Viking Children's Books','Viking Childrens Books','Vintage Books','Vintage Books USA','Virgin Books','VITABOOKS(비타북스)')) and (a.allbuy='n' or (a.allbuy='y' and a.rid<1)) order by a.sell_price asc limit 0,30]
