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

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

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

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