ＹＬ　が　現在　０　となっているデータ １２４件

ＹＬが０に現在なっているデータです。
これらのほとんどが　データ移行時のミスと思われます。

----------------------------------------------------

select dt_isbn,dt_syuppan, nm_yle,nm_yls,nm_yl_a from m_syuppan
where nm_yl_a between 0.0 and 0.0
and nm_yle is not null
order by dt_syuppan;

4896843088 AESOP'S FABLES 0 0 0
0789466821 ATLANTIS THE LOST CITY 0 0 0
0435286196 AXLE TOM 0 0 0
0789473755 Abraham Lincoln 0 0 0
0751331929 Alien Invaders 0 0 0
0751331635 Amazing Horses 0 0 0
0751329398 Amazon Terror 0 0 0
0751329282 Amelia Earhart 0 0 0
0751329215 Animal Senses 0 0 0
0751329207 Animals Look 0 0 0
0751329363 Animals in Winter 0 0 0
0448420953 Baby ALLIGATOR 0 0 0
044841645 Baby Wolf 0 0 0
0448425238 Bear Cub 0 0 0
0751329290 Beastly Tales 0 0 0
0751329266 Bermuda Triangle, The 0 0 0
1869610199 Biggest Fish, The 0 0 0
0751331627 Bugs! 0 0 0
0618238093 Busy beach 0 0 0
0435286188 Button Soup 0 0 0
0194219690 CITY OF LIGHTS 0 0 0
04352721881 Claws 0 0 0
0582343674 Collected Classics 1 0 0 0
058234364x Collected Classics 2 0 0 0
0582454352 Collected Classics 7 0 0 0
0435286129 Crazy Sandwich, The 0 0 0
0789473852 DANGER on the Mountain 0 0 0
0435288326 Danger at Sea 0 0 0
0751329258 Dangerous Plants 0 0 0
4896843614 Death Be Not Proud 0 0 0
1869610210 Dinosaur Chase, The 0 0 0
0448420937 Dinosaur Egg 0 0 0
078947381X Disasters at sea 0 0 0
0448401827 Doll Party 0 0 0
043271997 Escape and Other Stories, The 0 0 0
0789454351 FLYING ACE 0 0 0
0789457172 FREE AT LAST 0 0 0
0435286161 Fastest Trolley in the world, The 0 0 0
0435288261 First to Fly 0 0 0
0448412608 Great-Grandpa's in the Litter Box 0 0 0
4896843673 HOW TO BE A LEADER 0 0 0
0747569401 Harry Potter and the Order of the Phoenix (UK) 0 0 0
0435286153 Hatman's Holiday 0 0 0
0618238069 Hermit crabs 0 0 0
0194219461 Hitch-hiker,The 0 0 0
0448417367 How to Speak Dolphin in Three Easy Lessons 0 0 0
0618238158 I don't like candy 0 0 0
0789457199 JOAN of ARC 0 0 0
1869610180 Jack and Chug 0 0 0
0435286137 Jack and his Computer 0 0 0
0618238131 Jane's drawing 0 0 0
0435286102 Jasper 0 0 0
075132941X Joan of Arc 0 0 0
044841130 Johnny Appleseed 0 0 0
0763619310 Judy Moody Gets Famous! 0 0 0
0751331988 Knights and Castles 0 0 0
0435271601 L.A.Detective 0 0 0
0618238034 Let's paint 0 0 0
0553159194 Lila's Haunted House Party 0 0 0
0582421276X MEMOIRS OF A GEISHA 0 0 0
0431072884 MGR2- Guided Readers Beginners Pack 0 0 0
0435288210 Magnificent Mango, The 0 0 0
0751329428 Martin Luther King 0 0 0
1869611365 Maths Around Us 0 0 0
0618238182 Messy room. The 0 0 0
0582829933 Moonfleet 0 0 0
0194230414X Morbid Taste For Bones, A 0 0 0
075133197X Movie Magic 0 0 0
0751329274 Moving Machines 0 0 0
0751331937 Mummy Mysteries 0 0 0
0582344034 Musicians of Bremen, The 0 0 0
0618238042 My Dog 0 0 0
0618238107 My own kite 0 0 0
0743437438 Mystery of the Mother Wolf, The 0 0 0
0618238174 Neil's fib 0 0 0
061823814x Old train, The 0 0 0
0618238123 On the frog trail 0 0 0
058241537X PGR level 3 Library Set 0 0 0
0618238166 Parade day 0 0 0
058245140X Penguin Readers level 6 Library Set 0 0 0
4887358199 Penguin Starter Kit 0 0 0
0751331686 Pirate Tales 0 0 0
0435286110 Present for Ann, A 0 0 0
0194224805 Prisoner in the Jungle 0 0 0
043528827X Race Against Time 0 0 0
0618238115 Robots 0 0 0
4896843517 SHANE 0 0 0
0582402913 SIMON and the SPY 0 0 0
0789483734 SPIDERS' SECRETS 0 0 0
078946523X SPOOKY SPINECHILLERS 0 0 0
043528617X Salty to the Rescue 0 0 0
0751331775 Shark! 0 0 0
0618238050 Sink or swim 0 0 0
0618238077 Skunk lesson ,A 0 0 0
0448424185 Snail City 0 0 0
0751329231 Space Mission 0 0 0
0435286234 Speedy the Flying Camel 0 0 0
0751329401 Spies and Spying 0 0 0
0789485176 Story of Muhammad Ali,The 0 0 0
075133183X Story of Troy, The 0 0 0
0435288334 Summer in the City 0 0 0
4896843010 TWELVE ANGRY MEN 0 0 0
019433547X The Fox and the Stork, The Bird and the Glass 0 0 0
0751331880 The Olympics 0 0 0
019916066-X The Play -- Oxford Readint Tree stage 4 -- 0 0 0
0789473798 The Story of Anne Frank 0 0 0
0723284075 The World of Peter Rabbit 0 0 0
0789454238 Tiger Tales AND BIG CAT STORYS 0 0 0
0751329223 Tigers and Big Cats 0 0 0
0751331872 Titanic Story, The 0 0 0
1869610164 Toby and BJ 0 0 0
1869610172 Toby and the Big Tree 0 0 0
1869610221 Toy Farm, The 0 0 0
0618238085 Tricky Spider 0 0 0
0751331473 Truck Driver 0 0 0
0333999703 Umbrella, The 0 0 0
075132924X Under the Microscope 0 0 0
0435286145 Unhappy Ghost, The 0 0 0
0751331732 Volcanoes 0 0 0
4896843584 WIZARD OF OZ, THE 0 0 0
0435286226 Where's Rose 0 0 0
0199197628 Wonders of the world 0 0 0
0618238026 Wrong Bus,The 0 0 0
0789457156 ZEPPERIN The age of the airship 0 0 0

　ども、ふ〜んです。

078946523X
0789454351
078947381X
0553159194
0789466821
0789483734
0789473755
0789454238
0789473852
0789457172
0582454352
0789485176
0789457199
4896843673
0743437438
0751329231
0751331473
0789457156
044841645

なんか9桁もありますが(^^;
これらは、旧書評でもYL、レベルともに記載無しでした。
（ダウンロードデータでのみ調べました）

他のものは、更新用に編集しますか？

こころ強いですね。おねがいできますか？

"ふ〜ん"さんは[url:kb:414]で書きました:
〉　ども、ふ〜んです。

〉078946523X
〉0789454351
〉078947381X
〉0553159194
〉0789466821
〉0789483734
〉0789473755
〉0789454238
〉0789473852
〉0789457172
〉0582454352
〉0789485176
〉0789457199
〉4896843673
〉0743437438
〉0751329231
〉0751331473
〉0789457156
〉044841645

〉なんか9桁もありますが(^^;
〉これらは、旧書評でもYL、レベルともに記載無しでした。
〉（ダウンロードデータでのみ調べました）

〉他のものは、更新用に編集しますか？

出来ました。

20件の枠を外してます。
桁数チェックはしていません。
YLとレベルに差があるものが数件＜レベル優先にしました
レベル７は該当無しです。

0
'1869610180','0435286153','0435286145','0199197628','1869611365','0435286226','019433547X','0435288210','0582402913','0582402913','0435286137','1869610199','0435286234','0618238158','0618238034','0618238042','0618238026','0618238093','0618238069','0618238131','0618238107','0618238123','0618238115','0618238050','1869610164','0618238085','1869610221','0582344034','061823814X','0618238182','0618238174','0618238166','0435286102','0435286129','0435286110','019916066X','1869610210','1869610172','0618238077','4887358199');

1
'0194224805','0435286196','0448401827','0448424185','0435286161','044841130','0435288326','0333999703','0435271601','0435286188','0435288261','043528827X','0435288334','043528617X');

2
'0751331929','0751329258','0751329223','0751331872','0448417367','075133197X','0751329274','0751331775','4896843614','0431072884','0751331627','0751329207','0751329398','0751329363','0751329215','0448425238','0751329290','0448412608','0448420937','0448420953','0582829933','075132941X');

3
'4896843088','0763619310','0751331686','043271997','075132924X','0751329401','0194219690','0751331635','058241537X','0723284075','0751329282','4896843584','0751331732','0751329266','0194219461','0789473798','4896843517');

4
'0194230414','0194230414','0751329428','075133183X','0751331880','0751331988','0751331937');

5
'4896843010','058234364X');

6
'0582421276','0582421276','0582343674','058245140X');

8
'0747569401');

今日はもう寝ます。

明日の夜　つづきをやります。