Sorted SQL Query Results

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)