|
|
|
|
|
|
|
|
 |
 |
 |
 |
 |
|
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-17 00:20:00' and a.holdnum>0 and a.badseller='N' and a.visible='Y' and (a.brand like 'KIDSBOOK%' or a.brand in ('INNOVATIVE KIDS','FUFFIN BOOKS','JYbooks','Walker Books','WISE BOOK',' Creative Kids Publishing','(HUEBOOKS)한국외국어대학교지식출판원','Abbeville Kids','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','Apple Kids','Alligator Books','Alloy Books','Amacom Books','Amulet Books','Anchor Books','andom House Childrens Books','annulet books','ANOTHERBOOK(어나더북)','Applewood Books','APROBOOKS(APRO Books)','Arrow Books','Arrow Books Ltd','Carlton Kids','C&G Books','CABOOKS','Campbell Books','Candle Books','Carlton Books Limited','Carlton Books Ltd','Carolrhoda Books','Cartwheel Books','Cartwheel Books / Scholastic','Cartwheel Books/Scholastic','Cartwheel Books; Scholastic In','Caterpillar Books','CATERPILLAR BOOKS LIMITED','Caterpillar Books Ltd','Catholic Book Pub Co','Catholic Book Publishing Company','CAVES BOOKS','CB BOOK','Creative Kids Publishing','CREATIVITY FOR KIDS','Dalmatian Kids','crazybooks(크레이지북스)','Creston Books','Crossway Books','CTW Books','DADDYBOOK(대디북)','David Fickling Books','Daw Books','DBOOK','Dbooks(천재교육)','DESIGN KIDS','Dearbaby Books','Delacorte Books for Young Readers','Dell Book','dentalbook(덴탈북)','Derrydale Books','Deseret Book Co','Dial Books','Dial Books for Young Readers','Discover Books','Disney Books for Young Readers','DKBOOK','Dmar Books(드마북스)','Flash Kids','FLASHKIDS','Firefly Books','Firefly Books Ltd','First Glance Books','Flatiron Books','FPBooks(에프피북스)','Frances Lincoln Children's Books','Frances Lincoln Children's Books May 2003','Frances Lincoln Childrens Books','Frogillo books','FURSYSBOOKS','G-book','IMAGETALKBOOK(이미지토크북)','Ink Books(잉크북스)','Intervisual Books Inc','ISLAND BOOKS','It Books','IVP Books','iwbook','JCR KIDS','Jan BerenstainRandom House Childrens Books','Jbooks','Jester Books','JJbooks','Joanna Cotler Books','Jonathan S. AdelsteinKingfisher Books','Joy st Books','Just for Kids Pr Llc','JY Books','JYBooks','JYbooks(제이와이북스)','k-Books','K-books(가온미디어)','k-books(경문사)','K-Books(경문사,케이북스)','Kane Miller Book Pub','Kane/Miller Book Pub','Kane/Miller Book Publishers','Katalac Books LLC','Katherine Tegen Books','KIBWORTH BOOKS','KIDS','Kids Brown','Kids Can Pr','Kids Can Press','Kidsbooks','KIDSTALKBOOK(키즈토크북)','Kingfisher Books','Kirimbooks(기림)','Kirk Reeve Books','KMABOOK','KnKBooks','kobook','M&Kids','M&Kids(엠앤키즈)','MacMillan Kids','Lucasbooks','LucasBooks for Young Readers','Lucent Books','Macmillan Children's Books','Macmillan Childrens Books','MADEBOOK','Magni Books','Margaret K. McElderry Books','Mariner Books','mkids(메가스터디)','Midpoint Trade Books Inc','Milly Molly Books','MINBOOKS','Minotaur Books','Mira Books','Miramax Books','MJ BOOKs','MJBOOKs','modoobooks','Monday Morning Books, Ashland, Ohio, U.S.A.','mongsil books (몽실북스)','Moon Books','Mosby-Year Book','MS 북스(MS BOOKS)','Mud Puddle Books','Mud Puddle Books Inc','Mulberry Books','National Geographic Kids','Multnomah Books','MYBOOK','MYPASS BOOKS(마이패스북스)','NABIBooks(나비북스)','Nancy Paulsen Books','NANGMANBOOKS(낭만북스)','National Geographic Children's Books','Natl Book Network','Natl Geographic Soc Childrens books','nchanted Lion Books','Neil Porter Books','New Burlington Books','New Market, England: Brimax Books, Limited','New Monic Books','New York Mud Puddle Books, Inc','New York Review of Books','PI Kids','Powerkids Pr','PowerKids Press','Philomel Books','Photobook&DVD','Picture Window Books','PictureBookFactory(다산글방)','PKM BOOKS','Plan D. Books','PMK BOOKS','Pocket Books','Pomegranate Books','Poppy Books','POPULAR BOOK COMPANY','Popular Book Company Ltd','Running Press Kids','Rising Moon Books','River Books','Riverhead Books','Roaring Brook Press/A Neal Porter Book','Robin Corey Books','Roli Books Pvt Ltd','Running Pr Book Pub','Running Press Book Publishers','Salariya Book Company','Sandcastle Books','Sasquatch Books','SCGBOOKS','Smart Kids','SHBOOKS','Shenanigan Books','Silver Dolphin Books','Silver Whistle Books','Simon & Schuster Books for Young Readers','Simon & Schuster Children's books','Simon & Schuster Childrens Books','Simon & Schuster/Paula Wiseman Books','Simon and Schuster Books for Young Readers','SIMPLY READ BOOKS','Siphano Picture Books','SISOBOOKS(시소북스)','Sixth & Spring Books','Skyview Books','SMbooks(에스엠북스)','SmyrnaBook(서머나북)','Sports Illustrated for Kids','snowman books(스노우맨북스)','SNYBOOK','Sourcebooks Fire','Sourcebooks Inc','Sourcebooks Jabberwocky','SPOKEN BOOKS(스포큰북스)','Spruce Books','SRS BOOKS','SSE BOOK','ST&BOOKS(에스티앤북스)','Stackpole Books','Stagger Lee Books','Stan BerenstainRandom House Childrens Books','Stanford Business Books','Star Bright Books','Watch Me Grow Kids','VITABOOKS(비타북스)','Voyager Books','VS Books','Walker Books Ltd','Walker Books Ltd., London','Walrus Books','Walter Lorraine Books','Warner Books','Warner Juvenile Books','Waverley Books Ltd','WeeBook','Weekly BIZ books','Weinstein Books','Welcome Books','Wendy Lamb Books','White Horse Books','White Stone Books','Wisekids(와이즈키즈)','WorthyKids','William Morrow Cookbooks','Wine Books','Wisebooks(와이즈북스)','WND Books','woman sense books','World Almanac Books','World Book, Incorporated','WORLD OF CHILDRENS BOOK','Worthy Books','Ws Book','xbooks(엑스북스)','XObooks(엑스오북스)','Y&BOOK','Yearling Books','문광Kids','문경Book&Trans','성서원KIDS','성균관대학교(Subook)','엠키즈(mkids)','엠에스북(MSBOOK)','인도어 키즈(indoor kids)','인더북(in the book)','피아이키즈(Pikids)','피씨북(PCBOOK)')) and (a.allbuy='n' or (a.allbuy='y' and a.rid<1)) order by a.sell_price asc limit 0,30] | |
