|
|
|
|
|
|
|
|
 |
 |
 |
 |
 |
|
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 04:10:00' and a.holdnum>0 and a.badseller='N' and a.visible='Y' and (a.brand like 'A&CBlackPublishersLtd%' or a.brand in ('?다(ITTA)','A & C Black','A & C Black (Publishers) Ltd','A & C Black Publishers Ltd','A K Peters Ltd','A List','A to Z Pub','A&CB','A&A컨설팅','A&C Black','A&C Black Childrens','A&C Black Publishers','A&D미디어','A&D컨설턴트(에이앤디컨설턴트)','A*List','A+중앙교육(성전에듀앤컬처)','A-LIST PUBLISHING','A-Note(에이노트)','a-studio','A-Works','A-북스','A.TRACT(어트랙트)','A.U.S','A9Press','AATNB','AB-ROAD(에이비로드)','Abacus','ABA부모회','ABBA Communication','Abbeville Kids','Abbeville Pr','ABC Books','ABC혁신학교 명상센터(도서출판서원)','AbeBooks','ABIABOOKS(도서출판아비아)','Abingdon Pr','Abingdon Press','able','aboubooks','abou북스','ABRAMS','Abrams Appleseed','Abrams Books','Abrams, N','AB출판사','AC BOOK','Academic','Academic Internet Pub Inc','Academic Press','Academy of Korean Studies The Fast Free Shipping','ACC(국립아시아문화전당)','Accord Pub Ltd','Accord Publishing','Accord Publishing Ltd.','Accounting Books','Ace Books','ACE ENGLISH','ACE English(에이스잉글리시)','ACG school','ACG 에듀','ACLA','ACP Publishing Pty Ltd','Acts1001','AD Publishing','ADAMS MEDIA','Adams Media Corp','Adams Printing Press','ADC International','ADDISON WESLEY','Addison Wesley Publishing Comp','Addison-Wesley','Addison-Wesley Professional','Addison-Wesley Pub (Sd)','Addison-Wesley Publishing','Advantage Books','Advantage Pub Group','Adventure Publications','Aegis Consulting Group','AETP(에이이티피)','African Amer Images','after(애프터)','AG 타이포그라피연구소','Agate Bolden','Age of Learning','Agnetha','Agota books','AHOPE','Ai friend(에이아이프렌드)','AI-Books','AIN','AINO','AJ(에이제이)','AJBEE(에이제이비)','AK','AK COMICS','AK HOBBY BOOK','AK IT','Berryland','Best Graphics International','BetaLab(베타랩)','Bethany House','Bethany House Pub','Better Than Broccoli Books','Better Way of Learning','BEULAH25','BH balance & harmony','BH balance & harmony','BH(balance harmony)','BH(balance harmoy)','Bibliographisches Institut & F.A. Brockhaus A','Big and Small Publishing','Birch Lane Pr','Birkhauser Architecture','BIZ TALK BOOK(비즈토크북)','Black','Black Cat','Black Dog & Leventhal','Black Dog & Leventhal Pub','Black Rabbit Books','Black Swan','Blackbirch Pr Inc','Blackbirch Press','Blackbirch Press |','BlackD','BlackD(블랙디)','BLACKSHEEP(블랙쉽)','Blackwell','Blackwell Pub','Blackwell Publishers','Blake Publishing','Bloomsbury Pub Plc USA','Bloomsbury USA','Bloomsbury USA Childrens','Blue Apple Books','Blue Sky Press (AZ)','BMCompany(BM컴퍼니)','Bess Pr Inc','Best Friends Rock','bestcite(베스트사이트)','Beyond Words Pub Co','BIC','BIC 미디어북스','BICbooks','BIC미디어북스','Big Brown Box, Inc.','Big Picture Pr','Big Picture Press','BIGHIT MUSIC','BLC교육연구원','BLOCKBUSTERENGLISH(블록버스터잉글리시 )','Bloomsbury Childrens','Bloomsbury Childrens Books','Bloomsbury Publishing PLC','Blue Pencil Books','BK Books Ltd','Bloomsbury Pub Ltd','RC-KOREA(알씨코리아)','rchard Books','RCP KOREA','Read','READ&CHANGE','Reader s Digest','Reader's Digest Children's Boo','Reader's Digest','Reader's Digest Association','Reader's Digest Children's Books','Reader's Digest Childrens Books','READER'S DIGEST YOUNG FAMILIES','Reader's Digest Young Families, Inc.','Readers Digest','Readers Digest Association','Readers Digest Childrens Book','Readers Digest Young Families','Readers World','Reading's Fun Ltd.','REAL PIANO','REAL SOUP','Red Chair Press','Red Wagon','Red Wagon Books','REDBLACK PRODUCTIONS(레드블랙프로덕션스)','Regal Books','Regan Books','Review & Herald Pub Assn','Review & Herald Publishing','REX MEDIA','RIC Publications','Rick Riordan Presents','Rigby Education','Rikuyosha','Ripley Entertainment Inc','Riverhead Books','Roaring Brook','Roaring Brook Press','Roaring Brook Press/A Neal Porter Book','roast','Rock N Learn','Rodale Pr','Rodale Press','Rosen Central','Rowman & Littlefield Publishers, Incorporated','Rowman & Littlefield Publishing Group','REBORN MUSIC','Red Bricks','Red Fox Picture Book','Red Fox Picture Books','REFERENCE BY B','REFERENCE BY B(JOH.)','Regnery Publishing, Inc.','Richmond','RICON(대한건설정책연구원)','Ricordi','RN CENTER','ROBERT FREDERICK','Robert Frederick, Ltd','Robin Corey Books','Rockport','Rockport Pub','Rockport Publishers','Rockridge Press','Roli Books Pvt Ltd','Roundhouse Publishing Ltd')) and (a.allbuy='n' or (a.allbuy='y' and a.rid<1)) order by a.sell_price asc limit 0,30] | |
