eggsongs

mysql> select count(i) times, v from np join npm on ti = i where di = 8 group by i order by times desc limit 200;
+-------+----------------------------------------------------------------------------------------------------+
| times | v
+-------+----------------------------------------------------------------------------------------------------+
|    22 | Nujabes - Island (featuring Uyama Hiroto &amp; haruka nakamura)
|    20 | Lynyrd Skynyrd - Tuesday's Gone
|    17 | 澤野弘之 - UNICORN
|    16 | Supercell - Feel so Good
|    14 | Yoko Kanno / Raj Ramayya - Strangers
|    13 | Masuda Toshio - Kaze No Tamakura
|    13 | The Seatbelts - The Real Folk Blues
|    13 | Noriyuki Iwadare - Godot ~ The Fragrance Of Dark Coffee
|    12 | The Delgados - The Light Before We Land
|    12 | Paradise Lunch - Promised Land
|    11 | Tanaka Kouhei - Sunabouzu Tatakai no Theme
|    11 | Yoshimori Makoto - Nagai Nagai Yume no Naka no Utage ~ BACCANO! no Theme
|    11 | Susumu Hirasawa - Bandiria Travellers
|    11 | 【TIGER&amp;BUNNY】 - EDをピアノアレンジ【星のすみか】
|    11 | Art Blakey and The Jazz Messengers - Moanin'
|    11 | Naoki Sato - Ihojin No Yaiba
|    10 | Paradise Lunch - Gun's &amp; Roses
|    10 | The Seatbelts - Space Lion
|    10 | Kanno Youko - ScatCat
|    10 | A～YA - No-PE-No-GE
|    10 | Matsutani Suguru - High High High -piano version-
|     9 |
|     9 | Round Table Featuring Nino - Natsumachi
|     8 | Natural High - バーテンダー
|     8 | Yoshimori Makoto - Abikyoukan no Kurutta Butai
|     8 | Okui Aki - Tsuki no Mayu
|     8 | The Seatbelts - Ask DNA
|     8 | The Seatbelts - Tank
|     8 | Chuck Mangione - Feels So Good
|     8 | Kashiwa Daisuke - My Favorite Things
|     7 | Masayoshi Yamazaki - One more time, One more chance
|     7 | 勝手にしやがれ - グッドバイ・ポーク・パイ・ハット
|     7 | Bôa - Duvet (Acoustic Version)
|     7 | The Seatbelts - Don't Bother None
|     7 | Endou Kenji - Bob Lennon
|     7 | Tosihiko Sahasi - Apologize
|     7 | DJ Sly - いのちの名前～ジブリ・メドレー
|     7 | Nujabes - Far Fowls
|     7 | Kanno Youko - Kuro
|     7 | Mai Yamane - Blue
|     7 | Tokyo Brass Style - 摩訶不思議アドベンチャー！
|     7 | 清水　嶺 - ちょっとフラン…、壊さないでよ？
|     7 | Kaoru Wada - Life of Flowers
|     7 | Masuda Toshio - Umi Sakai (Unasaka) Yori
|     7 | Hajime Mizoguchi - grace ~Jinroh -Main Theme-~ omega
|     7 | Ayur - Another Side Of The Universe
|     6 | Masuda Toshio - Fude no Umi
|     6 | Magic Knight Rayearth - Yuzurenai Negai [Orchestra Version-Remix]
|     6 | Mai Yamane - Gotta Knock a Little Harder
|     6 | Tokyo Brass Style - Sorairo Days
|     6 | Pearl Brothers - Kagerou Ressha
|     6 | 坂本真綾 - おかえりなさい
|     6 | Yoko Kanno / Joyce - Run, Wolf Warrior, Run
|     6 | Ohtake Kaoruko - Hemmingways Daiquiri
|     6 | Mizuyo Komiya - I've Felt Little Autumn (Chiisai Aki Mitsuketa)
|     6 | Ko Otani - Free Bird
|     6 | Elements Garden - 懐かしく滲む空の色
|     6 | Jin Aketagawa - For You - Hourou Musuko edit -
|     6 | Furuido - Nantoka Nare
|     6 | Ishii Yasushi - DARKER THAN BLACK
|     6 | Naoki Sato - Deai...
|     6 | Ohtake Kaoruko - Moscow Mule
|     6 | Mayumi Kojima - Aka to ao no Blues
|     5 | Tokyo Active NEETs - 紅ノ館と紅ノ霧
|     5 | Paradise Lunch - Gun's &amp; Roses - New Ver. (inst)
|     5 | Mountain Mocha Kilimanjaro - WHY AM I STANDING HERE?
|     5 | Saint Seiya - Sayonara Warriors
|     5 | THEATRE BROOK - そこにある受話器
|     5 | Pearl Brothers - Youkoso! Hitori Bocchi
|     5 | まらしぃ - Dear
|     5 | Makino Yui - Undine - Forest Mix
|     5 | boogiepop phantom - Yuudachi
|     5 | Ilaria Graziano - i do
|     5 | Tokyo Brass Style - Theme of Lupin The 3rd
|     5 | Kitagawa Katsutoshi - Rainbow
|     5 | Maaya Sakamoto &amp; Steve Conte - The Garden of Everything
|     5 | Yoko Kanno - Hounds
|     5 | Shihoko Hirata - Heaven
|     5 | Tokyo Brass Style - 宇宙戦艦ヤマト
|     5 | Matsuzaki Shigeru - Katamari on the Swing
|     5 | 9Miles - Feel So Good
|     5 | Votoms - The Theme
|     5 | Tokyo Brass Style - Active Heart
|     5 | demetori - 紅楼 ～ Eastern Dream (Acoustic Demo)
|     5 | bôa - Passport (C.W.B. Always With Me)
|     5 | Yukari Hashimoto - Lost my pieces
|     5 | Tokyo Philharmonic Orchestra - To the Decisive Battle
|     5 | Yusuke Honma - Onizuka's Blues
|     5 | Big Bad Voodoo Daddy - Minnie the Moocher
|     5 | Czech Philharmonic Orchestra - Mononoke Hime ~movement~
|     5 | Kanno Youko - In no Piano
|     5 | まらしぃ - Just Be Friends
|     5 | Persona Music Live Band - Heaven
|     5 | Mayumi Kojima - Poltergeist
|     5 | Otoyakichiemon'Ju - Aoi Kage (Ballad Version)
|     5 | anNina - Taishou a
|     4 | The Seatbelts - Bad Dog No Biscuits
|     4 | All That Jazz feat. Cosmic Home - となりのトトロ
|     4 | Mountain Mocha Kilimanjaro - LOVE SPECTRUM
|     4 | Kotaro Nakagawa - Black Knights
|     4 | NicolArmarfi - Romance in Andante II
|     4 | Makino Yui - Undine
|     4 | Toshihiko Sahashi - Brick Ballades - Houston St
|     4 | Ani-Jazz - あの夏へ
|     4 | A～YA - 花のウィンナーワルツ
|     4 | Sasaki Sayaka - Zzz (Bossa Nova Version)
|     4 | Ohtake Kaoruko - Rusty Nail
|     4 | ALL THAT JAZZ - Moonlight Densetsu
|     4 | Takatori Hideaki - Sunabouzu Ekaki Uta
|     4 | Tatsuro Yamashita - Bokura no Natsu no Yume
|     4 | Kalafina - Kimi ga Hikari ni Kaete yuku
|     4 | Hitomi - Continued Story
|     4 | Nujabes - aruarian dance
|     4 | ひこすけ - 紅の迷路
|     4 | 神前 暁 - 絢爛
|     4 | The Seatbelts - Blue
|     4 | 上松範康 - 父親
|     4 | Kazumi Tateishi Trio - Arrietty's Song
|     4 | Homma Yusuke - Swing
|     4 | Asuka Sakai, Charlie Kosei - Que Sera Sera
|     4 | Choro Club feat. Senoo - Gondola No Yume
|     4 | Hanggai - Beautiful Mongolian Horse
|     4 | ANIME THAT JAZZ - Sousei no Aquarion (Sousei no Aquarion)
|     4 | Persona Music Live Band - The Party for Everyone's Souls
|     4 | dai - Answer
|     4 | Pugsley Buzzard - Cold Wind
|     4 | Pearl Kyoudai - Youkoso! Hitori Bocchi
|     4 | Steve Conte - Heaven's Not Enough
|     4 | Czech Philharmonic Orchestra - The Tale Of Ashitaka
|     4 | Soukichi Narumi - Nobody's Perfect
|     4 | YUKI - Sakamichi no Melody
|     4 | Yuuka Nanri - My Favorite Things
|     4 | Kanno Yuugo - Main Theme -SIDE BIRDY-
|     4 | 結城アイラ - Reine (du) Lace
|     4 | Mitsunori Ikeda Feat. Aimee B - Fallen Angel
|     4 | dai - hope
|     4 | Keiko Matsui - Falcon's Wing
|     4 | Persona Music Live Band - Burn My Dread
|     4 | Ohtake Kaoruko - Old Pal
|     4 | Shinpei Ruike &amp; Masayoshi Furukawa - But not for me
|     4 | ネオ - にとりの大冒険(仮)
|     4 | Graveyard Train - Lonesome Road Coffee Lounge
|     4 | Noriyuki Iwadare - The Steel Samurai
|     4 | ALL THAT JAZZ - GO! GO! MANIAC
|     4 | Masuda Toshio - Suzuri ni Sumu Shiro
|     4 | Rie Fu - Life is Like a Boat
|     4 | Yoshihisa Hirano - Sinfonia on the Battlefield
|     4 | Ooshima Michiru - "Watashi" no Theme (Piano Ver.)
|     4 | Natural High - 始まりの人
|     3 | Tutti Sound - Brightness of The Three Fairie
|     3 | You &amp; The Explosion Band - Lupin III '80
|     3 | Boney M - Daddy Cool
|     3 | dai - my dear
|     3 | NicolArmarfi - Painful History
|     3 | Kanno Youko - No Ones Home
|     3 | Nujabes - Letter From Yokosuka
|     3 | Masuda Toshio - The Sore Feet Song
|     3 | Touyama Nao - Tooku Kimi he
|     3 | Ishii Yasushi - Nyogen's Midnight Town
|     3 | Ikeda Ayako - Sora no Kakera
|     3 | Michiru Oshima - Amazing Grace
|     3 | 清水　嶺 - 紅魔館にピアノなんかあったっけ？
|     3 | supercell - 事実
|     3 | Yoichi Murata - F02_Take02_EWS_Amano &amp; Kosei
|     3 | Pearl Brothers - Kyuukei wa Ama Sugiru Kotoba
|     3 | Kiyoshi Yoshida - The Tree Song
|     3 | Tokyo Active NEETs - 地獄ノ牛鬼
|     3 | Tokyo Brass Style - おどるポンポコリン
|     3 | Kaori Kobayashi - Children's Dream
|     3 | Kaori Kobayashi - Story (AI)
|     3 | 久木田薰 - 人生のメリーゴーランド - 「ハウルの動く城」より
|     3 | Azusa - I Love
|     3 | I's CUBE - 羽
|     3 | Hotarubi Kakeru - Dear You -Hope-
|     3 | Kanako Itō - 沙耶の唄
|     3 | Kenichiro Nishihara - Weather Overtone
|     3 | Ally Kerr - The Sore Feet Song
|     3 | Cafe De Lux - Missing You
|     3 | Otsuki Kenji - Hito to Shite Jiku ga Burete Iru
|     3 | Abo Takeshi - Believe Me
|     3 | Jun Maeda - Onaji Takami he
|     3 | Hazuki Erino &amp; Saito Chiwa &amp; Hirohashi Ryou feat Nishimura Chinami - Dekkai Shiawase Desu.
|     3 | Geinou Yamashirogumi - Kaneda
|     3 | A～YA - L→R KOMACHI
|     3 | Kalafina - I Have a Dream
|     3 | Cafe De Lux - A Night In New York
|     3 | 上松範康 - 親愛
|     3 | 上松範康 - 溢愛
|     3 | Ohtake Kaoruko - Martine
|     3 | Kazumi Tateishi Trio - 君をのせて
|     3 | Big Bad Voodoo Daddy - 2000 Volts
|     3 | Senba Kiyohiko - shunrai
|     3 | Pugsley Buzzard - Aces and Eights
|     3 | 瑞鶴P - マミさんのテーマ - Jazz Mix (Mami's Theme)
|     3 | The Seatbelts - Goodnight Julia
|     3 | Hiroyuki Sawano - Symphonic Suite DEVIL Second Movement i-AM
|     3 | Tanaka Kouhei - Nono
|     3 | 坂本真綾 - gravity
|     3 | Tokyo Active NEETs - 弾幕注意報
|     3 | The Sax Pack - Fallin' For You
+-------+----------------------------------------------------------------------------------------------------+
200 rows in set (0.07 sec)

mysql>