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 14:40:00' and a.holdnum>0 and a.badseller='N' and a.visible='Y' and (a.brand like 'BookStudio%' or a.brand in ('ABC Books','AbeBooks','ABIABOOKS(도서출판아비아)','aboubooks','Abrams Books','AC BOOK','Accounting Books','Ace Books','Advantage Books','Agota books','AI-Books','AK HOBBY BOOK','AK TRVIA BOOK','Alaska Northwest Books','Alfred A. Knopf Books for Young Readers','Algonquin Books','Alison Green Books','a-studio','ART BOOK PRESS','Arthur A. Levine Books','ASTEROID BOOK','Atheneum Books','Atheneum Books for Young Readers','Atlantic Books','Atria Books','AVON BOOKS','AWB(AW Books 애니월드북스)','Back Pack Books','Backpack Books','Ballantine Books','Bantam Books','AT studio','Bison Books','BIZ TALK BOOK(비즈토크북)','BK Books Ltd','Black Rabbit Books','Bloomsbury Childrens Books','Blue Apple Books','BLUEPRINT BOOK','Bluewood Books','BMBOOKS','Book Around','book by PUBLY(북 바이 퍼블리)','Book Company Publishing','Book House','Book Insight','BOOK STUDIO','BOOK&BOOK','Book-Studio','BookaBooka','Bookcraft','Bookcraft Pubs','bookdod(오이팜)','BOOKER(부커)','BOOKK(부크크)','Booklines Hawaii Ltd','Bookman Pub','Bookmark','BOOKPOINT','Books Are Fun','BOOKS KOREA(북스코리아)','BOOKS 마니아(북스마니아)','Books&Illusts','BooksMan','Chambooks','Chartwell Books','Checkmark Books','Childrens Book Pr','Chronicle Books','Chronicle Books Llc','CK Books(시케이북스)','CKBOOKS','CKbooks(시케이북스)','Clarion Books','Chart Studio','Edge Books','Eerdmans Books for Young Readers','Egmont Books','Egmont Books Ltd','Egmont Childrens Books','EL BOOK(이엘북)','ELLYBOOK(도서출판엘리)','EGO DESIGN STUDIO(잡지)','Eric VelasquezYearling Books','esbook','euneunBooks(은은북스)','Evans Brothers - Books for Child','EWAY books(이웨이)','EWAYBOOKS','FAMILYBOOKCLUB(패밀리북클럽)','Fast fact book','Fawcett Books','Fernleigh Books','F STUDIO(에프 스튜디오)','IMAGETALKBOOK(이미지토크북)','Ink Books(잉크북스)','Intervisual Books Inc','ISLAND BOOKS','It Books','IVP Books','iwbook','Imagination Studio','Jan BerenstainRandom House Childrens Books','Jbooks','Jester Books','JJbooks','Joanna Cotler Books','Jonathan S. AdelsteinKingfisher Books','Joy st Books','JD DRUM STUDIO MUSIC ACADEMY','JHS STUDIO','Lucasbooks','LucasBooks for Young Readers','Lucent Books','Macmillan Children's Books','Macmillan Childrens Books','MADEBOOK','Magni Books','Margaret K. McElderry Books','Mariner Books','Lyrick Studios','Stone Arch Books','Storybook Meadow Pub','STT Books','SueHwaBooks(수화북스)','sunburst book','Suntal Books (썬탈북스)','SWEET BOOK','Tan Books & Pub','TANGO BOOKS','Tchaikovsky Family Books','Studio i(스튜디오아이)','Studio Mouse','Studio Mouse Llc','Studio VECSE','TEM book (템북)','Terrace Book','THE BOOK COMPANY','THE BOOK(더북)','Thomas Dunne Books','The Chart Studio','The Toon Studio','스카이미디어(book)','스타일스튜디오(style STUDIO)','스토리북(STORYBOOK)','스튜디오 크로스컬쳐(Studio Crossculture)','스튜디오11(studio11am)','스튜디오구(Studio Gu)','씨제이북스코리아(CJBooksKorea)','씨코북스(CKoBooks)','씽크북스(Think Books)','씨피티스튜디오(cpt studio)')) and (a.allbuy='n' or (a.allbuy='y' and a.rid<1)) order by a.sell_price asc limit 0,30]
