MariaDB [thetvdb]> SELECT (@rn := @rn + 1) Num, sea.season Season, ep.EpisodeNumber Episode, ep.EpisodeName Title FROM tvseasons sea INNER JOIN tvepisodes ep ON ep.seasonid = sea.id INNER JOIN tvseries ser ON ser.id = ep.seriesid CROSS JOIN (select @rn := 0) params WHERE ser.id = '78857' and season != 0 ORDER BY Season,Episode ASC; +------+--------+---------+-------------------------------------------------------------------------------+ | Num | Season | Episode | Title | +------+--------+---------+-------------------------------------------------------------------------------+ | 1 | 1 | 1 | Enter: Naruto Uzumaki! | | 2 | 1 | 2 | My Name is Konohamaru | | 3 | 1 | 3 | Sasuke and Sakura: Friends or Foes? | | 4 | 1 | 4 | Pass or Fail: Survival Test | | 5 | 1 | 5 | You Failed! Kakashis Final Decision | | 6 | 1 | 6 | A Dangerous Mission! Journey to the Land of Waves! | | 7 | 1 | 7 | The Assassin of the Mist! | | 8 | 1 | 8 | The Oath of Pain | | 9 | 1 | 9 | Kakashi: Sharingan Warrior! | | 10 | 1 | 10 | The Forest of Chakra | | 11 | 1 | 11 | The Land Where a Hero Once Lived | | 12 | 1 | 12 | Battle on the Bridge! Zabuza Returns! | | 13 | 1 | 13 | Hakus Secret Jutsu: Crystal Ice Mirrors | | 14 | 1 | 14 | The Number One Hyperactive, Knucklehead Ninja Joins the Fight! | | 15 | 1 | 15 | Zero Visibility: The Sharingan Shatters | | 16 | 1 | 16 | The Broken Seal | | 17 | 1 | 17 | White Past: Hidden Ambition | | 18 | 1 | 18 | The Weapons Known as Shinobi | | 19 | 1 | 19 | The Demon in the Snow | | 20 | 1 | 20 | A New Chapter Begins: The Chūnin Exam! | | 21 | 1 | 21 | Identify Yourself: Powerful New Rivals | | 22 | 1 | 22 | Chūnin Challenge: Rock Lee vs. Sasuke! | | 23 | 1 | 23 | Genin Takedown! All Nine Rookies Face Off! | | 24 | 1 | 24 | Start Your Engines: The Chūnin Exam Begins! | | 25 | 1 | 25 | The Tenth Question: All or Nothing | | 27 | 1 | 26 | Special Report: Live from the Forest of Death! | | 28 | 1 | 27 | The Chunin Exam Stage 2: The Forest of Death | | 26 | 1 | 28 | Eat or Be Eaten: Panic In the Forest | | 29 | 1 | 29 | Narutos Counterattack: Never Give In! | | 30 | 1 | 30 | The Sharingan Revived: Dragon Flame Jutsu! | | 31 | 1 | 31 | Bushy Brows Pledge: Undying Love and Protection | | 32 | 1 | 32 | Sakura Blossoms! | | 33 | 1 | 33 | Battle Formation: Ino-Shika-Cho! | | 34 | 1 | 34 | Akamaru Trembles: Gaaras Cruel Strength! | | 35 | 1 | 35 | The Scrolls Secret: No Peeking Allowed | | 36 | 2 | 1 | Clone vs. Clone: Mine are Better than Yours! | | 37 | 2 | 2 | Surviving the Cut! The Rookie Nine Together Again! | | 38 | 2 | 3 | Narrowing the Field: Sudden Death Elimination! | | 39 | 2 | 4 | Bushy Brows Jealousy - Lions Barrage Unleashed! | | 40 | 2 | 5 | Kakashi and Orochimaru: Face-to-Face! | | 41 | 2 | 6 | Kunoichi Rumble: The Rivals Get Serious! | | 42 | 2 | 7 | The Ultimate Battle: Cha! | | 43 | 2 | 8 | Killer Kunoichi and a Shaky Shikamaru | | 44 | 2 | 9 | Akamaru Unleashed! Whos Top Dog Now? | | 45 | 2 | 10 | Surprise Attack! Narutos Secret Weapon! | | 46 | 2 | 11 | Byakugan Battle: Hinata Grows Bold! | | 47 | 2 | 12 | A Failure Stands Tall! | | 48 | 2 | 13 | Gaara vs. Rock Lee: The Power of Youth Explodes! | | 49 | 2 | 14 | Lees Hidden Strength: Forbidden Secret Jutsu! | | 50 | 2 | 15 | The Fifth Gate: A Splendid Ninja is Born | | 51 | 2 | 16 | A Shadow in the Darkness: Danger Approaches Sasuke | | 52 | 2 | 17 | Ebisu Returns: Narutos Toughest Training Yet! | | 206 | 2 | 18 | Long Time No See: Jiraiya Returns! | | 54 | 2 | 19 | Summoning Jutsu; Wisdom of the Toad Sage! | | 55 | 2 | 20 | A Feeling of Yearning, A Flower Full of Hope | | 56 | 2 | 21 | Live or Die: Risk It All to Win It All! | | 57 | 2 | 22 | He Flies! He Jumps! He Lurks! Chief Toad Appears! | | 58 | 2 | 23 | Hospital Besieged: The Evil Hand Revealed! | | 59 | 2 | 24 | The Final Rounds: Rush to the Battle Arena! | | 60 | 2 | 25 | Byakugan vs. Shadow Clone Jutsu! | | 61 | 2 | 26 | Ultimate Defense: Zero Blind Spot! | | 62 | 2 | 27 | A Failures True Power | | 63 | 2 | 28 | Hit It or Quit It: The Final Rounds Get Complicated! | | 64 | 2 | 29 | Zero Motivation: The Guy with Cloud Envy! | | 65 | 2 | 30 | Dancing Leaf, Squirming Sand | | 66 | 2 | 31 | Bushy Brows Jutsu: Sasuke Style! | | 67 | 2 | 32 | I Wasnt Late for Nothing! Ultimate Move - Chidori Revealed!! | | 68 | 2 | 33 | Zero Hour! Destruction of Konoha Commenced! | | 69 | 2 | 34 | Village in Distress: A New A-Ranked Mission! | | 70 | 2 | 35 | A Shirkers Call to Action: Layabout No More! | | 71 | 2 | 36 | Absolutely Incomparable! A Hokage-Level Battle! | | 72 | 2 | 37 | A Mistake from the Past: A Face Revealed! | | 73 | 2 | 38 | Forbidden Secret Jutsu! Shiki-Fujin | | 74 | 2 | 39 | Astonishment! Gaaras True Identity! | | 75 | 2 | 40 | Over the Limit! Sasukes Decision | | 76 | 2 | 41 | An Assassin in the Moonlight! | | 77 | 2 | 42 | Light and Shadow: The Name of Gaara! | | 53 | 2 | 43 | Narutos Ninja Handbook | | 78 | 2 | 44 | Beyond the Limit of Darkness and Light | | 79 | 2 | 45 | The Third Hokage, Forever... | | 80 | 2 | 46 | Coming Home in the Morning Mist | | 81 | 2 | 47 | Sharingan vs. Sharingan! | | 82 | 2 | 48 | Jiraiya: Narutos Potential Disaster! | | 83 | 3 | 1 | Roar, Chidori! Brother vs. Brother! | | 84 | 3 | 2 | Foolish Little Brother: Despise Me, Hate Me! | | 85 | 3 | 3 | The Pursuit of Knowledge! Ill Definately Get Stronger!!! | | 86 | 3 | 4 | Will Power! Break the Water Balloon!!! | | 87 | 3 | 5 | Focal Point: The Symbol of the Hidden Leaf | | 88 | 3 | 6 | Impossible Choice: The Pain in Tsunades Heart | | 89 | 3 | 7 | Angry Explosion! I Wont Forgive You! | | 90 | 3 | 8 | Inheritance: The Necklace of Death | | 91 | 3 | 9 | Yes or No! Tsunades Decision! | | 92 | 3 | 10 | Negotiations Breakdown | | 93 | 3 | 11 | Attack! Fury of the Rasengan! | | 94 | 3 | 12 | The Fifth Hokage! Sacrificing Her Life to Fight! | | 95 | 3 | 13 | Three-way Battle! Tsunade and Jiraiya vs. Orochimaru! | | 96 | 3 | 14 | Narutos Hot Springs Adventure | | 97 | 3 | 15 | Tsunades Warning: Ninja No More | | 98 | 3 | 16 | The One Who Inherits the Will of Fire | | 99 | 3 | 17 | Sensei and Student: The Bond of a Shinobi! | | 100 | 3 | 18 | I Want to See it! Kakashi-senseis True Face | | 101 | 3 | 19 | New Missions! Rescue the Tea Country! | | 102 | 3 | 20 | The Race is On! Trouble on the High Seas! | | 207 | 3 | 21 | Run Idate, Run! Nagi Island Awaits! | | 104 | 3 | 22 | A Fierce Battle of Rolling Thunder! | | 105 | 3 | 23 | The Last Leg: A Final Act of Desperation | | 106 | 3 | 24 | The Battle Begins: Naruto vs. Sasuke | | 107 | 3 | 25 | Bitter Rivals and Broken Bonds | | 108 | 3 | 26 | An Invitation from the Sound | | 109 | 3 | 27 | Formation! The Sasuke Retrieval Squad | | 110 | 3 | 28 | Sound vs. Leaf | | 111 | 3 | 29 | Squad Mutiny: Everything Falls Apart! | | 112 | 3 | 30 | Full Throttle Power! Choji, Ablaze! | | 113 | 3 | 31 | Good-bye Old Friend...! Ill Always Believe in You! | | 114 | 3 | 32 | Your Opponent Is Me! | | 115 | 3 | 33 | 360 Degrees of Vision: The Byakugans Blind Spot | | 116 | 3 | 34 | Losing is Not an Option! | | 117 | 3 | 35 | The Vessel Arrives Too Late | | 118 | 3 | 36 | Miscalculation: A New Enemy Appears! | | 119 | 3 | 37 | Roar and Howl! The Ultimate Tag-Team! | | 120 | 3 | 38 | To Each His Own Battle | | 121 | 3 | 39 | Fakeout: Shikamarus Comeback! | | 122 | 3 | 40 | The Leafs Handsome Devil! | | 123 | 3 | 41 | The Beast Within | | 124 | 3 | 42 | The Sand Shinobi: Allies of the Leaf | | 125 | 3 | 43 | Showdown: Gaara vs. Kimimaro | | 126 | 3 | 44 | Vengeful Strike! The Bracken Dance! | | 127 | 3 | 45 | A Cry on Deaf Ears | | 103 | 3 | 46 | Brothers: Distance Among the Uchihas | | 208 | 3 | 47 | Father and Son, the Broken Crest | | 129 | 3 | 48 | The Secrets of the Mangekyō Sharingan | | 130 | 4 | 1 | For a Friend... | | 131 | 4 | 2 | A Plea from a Friend | | 132 | 4 | 3 | The End of Tears | | 133 | 4 | 4 | The Promise That Could Not Be Kept | | 134 | 4 | 5 | Deep Cover?! A Super S-Ranked Mission! | | 135 | 4 | 6 | A Town of Outlaws, The Shadow of the Fuma Clan | | 136 | 4 | 7 | The Promise Betrayed, The Fleeting Request | | 137 | 4 | 8 | Fear! Orochimarus Castle! | | 138 | 4 | 9 | Two Beats, Kabutos Trap! | | 139 | 4 | 10 | Sakuras Determination | | 140 | 4 | 11 | The Evil Trio of the High Security Installation! | | 141 | 4 | 12 | Run, Ton-ton! Im Depending on Your Nose! | | 142 | 4 | 13 | Newly Formed Three Man Cell! Two People and an Animal! | | 143 | 4 | 14 | Explosion! New Formation! Ino-Shika-Cho | | 144 | 4 | 15 | Leftover Ambitions and Orochimaru | | 145 | 4 | 16 | Fateful Showdown! You Wont Defeat Me | | 146 | 4 | 17 | Super Pursuit Power Even Akamaru is Jealous of! Seek the Mysterious Bikouchuu | | 147 | 4 | 18 | How Are They Different? Dont All Bugs Look the Same? | | 148 | 4 | 19 | Deceive, Confuse, and Be Deceived. The Grand Bug Battle | | 149 | 4 | 20 | Blaze Away, Byakugan! This is My Ninja Way! | | 150 | 4 | 21 | Requiem for the Living | | 151 | 4 | 22 | A Lesson Learned: The Iron Fist of Love! | | 209 | 4 | 23 | The Enemy of the Byakugan | | 210 | 4 | 24 | The Dark Creeping Clouds | | 211 | 4 | 25 | Raigas Counterattack | | 152 | 4 | 26 | Run!!! Curry of Life | | 153 | 4 | 27 | Everyone, Come With Me! Great Sweat and Tears Survival Plan | | 154 | 4 | 28 | Enemy or Ally?! Wilderness Bounty Hunting | | 155 | 4 | 29 | Take or Be Taken?! Showdown at the Okay Temple! | | 156 | 4 | 30 | Meeting the Strange Visitor, Green Beast? Wild Beast?...Animal? | | 157 | 4 | 31 | White Cursed Warrior | | 158 | 4 | 32 | Tactician - Expectation of Koumei | | 159 | 4 | 33 | The Late Supporter | | 160 | 4 | 34 | Naruto Dies | | 161 | 4 | 35 | The Time That is Stopped | | 162 | 4 | 36 | White Herons Flapping Wings of Time | | 163 | 4 | 37 | Burn Zundou! Mix, Stretch, Boil! | | 164 | 4 | 38 | Memory, the Lost Page | | 165 | 4 | 39 | Impact, the Closed Door | | 166 | 4 | 40 | Infiltration, the Devised Trap | | 167 | 4 | 41 | Despair, the Broken Heart | | 168 | 4 | 42 | Sea Battle, the Released Power | | 169 | 4 | 43 | No Waaaay! Celebrity Ninpou: Kinton no Jutsu | | 170 | 4 | 44 | Dig Here! Woof! Woof! Search for Buried Treasure | | 171 | 4 | 45 | Zig Zag Run! Chase, Chased, Mistaken | | 172 | 4 | 46 | OH?! Please, Mister Postman | | 173 | 4 | 47 | Encounter, The Boy Named “Star” | | 128 | 4 | 48 | The Remembered Lullaby | | 212 | 5 | 1 | Hidden Jutsu! The Price of the Ninja Art: Kujaku | | 213 | 5 | 2 | Hoshikage: The Buried Truth | | 214 | 5 | 3 | Reunion: The Remaining Time | | 174 | 5 | 4 | The Stars Radiance | | 175 | 5 | 5 | Kibas Long Day | | 176 | 5 | 6 | A Legend from the Hidden Leaf: The Onbaa! | | 177 | 5 | 7 | Laughing Shino | | 178 | 5 | 8 | Open for Business! The Leaf Moving Service | | 179 | 5 | 9 | The Mystery of the Targeted Merchants | | 180 | 5 | 10 | A Limitless Supply of Ninja Tools | | 181 | 5 | 11 | The Byakugan Sees the Blind Spot! | | 182 | 5 | 12 | Forecast: Death! Cloudy with Chance of Sun! | | 183 | 5 | 13 | Ino Screams! Chubby Paradise! | | 184 | 5 | 14 | Viva Dojo Challenge! Youth is All About Passion! | | 185 | 5 | 15 | The Mysterious Curse of the Haunted Castle | | 186 | 5 | 16 | The Third Super-Beast! | | 187 | 5 | 17 | Hot-Blooded Confrontation: Student vs. Sensei | | 188 | 5 | 18 | Crisis: The Hidden Leaf 11 Gather! | | 189 | 5 | 19 | The Anbu Gives Up? Narutos Recollection | | 190 | 5 | 20 | The Missed Target | | 191 | 5 | 21 | The Powerful Helper | | 192 | 5 | 22 | Multiple Traps! Countdown to Destruction | | 193 | 5 | 23 | The Top 5 Ninja Battles! | | 215 | 5 | 24 | Kurenais Decision: Squad 8 Left Behind | | 216 | 5 | 25 | Yakumos Sealed Power | | 217 | 5 | 26 | Kurenais Top Secret Mission: The Promise with the Third Hokage | | 218 | 5 | 27 | Genjutsu or Reality? | | 219 | 5 | 28 | The Supposed Sealed Ability | | 220 | 5 | 29 | The Weight of the Prized Artifact! | | 194 | 5 | 30 | The Enemy | | 195 | 5 | 31 | Labyrinth Forest | | 196 | 5 | 32 | Memories of Fire | | 197 | 5 | 33 | Everyones Paths | | 198 | 5 | 34 | The Lost Memory | | 199 | 5 | 35 | Take Back Reality | | 200 | 5 | 36 | Erasing the Past | | 201 | 5 | 37 | The Disappearing Craftsman, the Targeted Shukaku | | 202 | 5 | 38 | The Sands Allies - The Leafs Shinobi | | 203 | 5 | 39 | The Sealed Sand Water Tigers Counterattack | | 204 | 5 | 40 | The Resurrected Ultimate Weapon | | 205 | 5 | 41 | Heading Out | +------+--------+---------+-------------------------------------------------------------------------------+ 220 rows in set (0.01 sec)
Comments