リクエスト&メッセージ radiko

Kiss FM KOBE 2021年11月のオススメ楽曲

HOTRAXX

Kiss FM KOBE 2021年11月の邦楽推薦曲

YONA YONA WEEKENDERS

光の中

ARTIST
YONA YONA WEEKENDERS
OFFICIAL SITE
https://www.yonayonaweekenders.com/

メロコア・パンクシーンで活動してきた4人が集まり、耳馴染みの良いシティポップサウンドを奏でるYONA YONA WEEKENDERS。メンバー全員が平日昼間は会社員として働き、夜な夜なスタジオやライブハウスに集って奏でる音楽はどこか哀愁を帯びながらもほっと一息つける”ツマミになるグッドミュージック”。そんな彼らの待望の1st Full Album「YONA YONA WEEKENDERS」を締めくくるリードソング「光の中」は、”どんな世界にだって必ずある光”を唄う、今の彼らそのものを送り届ける1曲。

YouTubeチャンネル

YONA YONA WEEKENDERS

YONA YONA WEEKENDERS

ARTIST
YONA YONA WEEKENDERS
PRICE
Album: ¥3300

SPEEDSTAR RECORDS(VICL-65586)
2021.11.3 ON SALE

01. 思い出in the sky
02. 終電で帰ります
03. Open your eyes
04. リルバズ
05. Good bye
06. 泡沫の夢
07. いい夢
08. Night Rider feat. 荒井岳史(the band apart)
09. Tick Tack
10. 光の中"

(default) 13 queries took 488 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT `NowPlaying`.`id`, `NowPlaying`.`on_air_time`, `NowPlaying`.`artist`, `NowPlaying`.`song`, `NowPlaying`.`created`, `NowPlaying`.`modified` FROM `now_playings` AS `NowPlaying` WHERE `NowPlaying`.`id` = 1 LIMIT 1110
2SELECT `BroadcastDay`.*, `BroadcastTime`.*, `Program`.*, `subSoundcrew`.*, `subGuestEvent`.* FROM `broadcast_days` AS `BroadcastDay` INNER JOIN broadcast_times AS `BroadcastTime` ON (`BroadcastTime`.`broadcast_day_id` = `BroadcastDay`.`id`) INNER JOIN programs AS `Program` ON (`Program`.`id` = `BroadcastTime`.`program_id` AND `Program`.`corner` = 0) LEFT JOIN (SELECT `ProgramSoundcrew`.`broadcast_time_id`, group_concat(distinct `Soundcrew`.`name` SEPARATOR ",") AS soundcrew_name, group_concat(distinct `Soundcrew`.`id` SEPARATOR ",") AS soundcrew_id, group_concat(distinct `Soundcrew`.`sort` SEPARATOR ",") AS soundcrew_sort FROM soundcrews AS `Soundcrew` INNER JOIN program_soundcrews AS `ProgramSoundcrew` ON (`ProgramSoundcrew`.`soundcrew_id` = `Soundcrew`.`id`) WHERE 1 = 1 GROUP BY `ProgramSoundcrew`.`broadcast_time_id` ORDER BY `Soundcrew`.`sort` ASC ) AS `subSoundcrew` ON (`subSoundcrew`.`broadcast_time_id` = `BroadcastTime`.`id`) LEFT JOIN (SELECT `GuestEvent`.`program_id`, `GuestEvent`.`event_date`, group_concat(distinct `GuestEvent`.`guest_name` SEPARATOR ",") AS guest_event_name, group_concat(distinct `GuestEvent`.`id` SEPARATOR ",") AS guest_event_id FROM guest_events AS `GuestEvent` WHERE `GuestEvent`.`kind` = 'guest' AND `GuestEvent`.`visible_flg_id` = 1 AND `GuestEvent`.`release_start` <= '2021-12-06 08:45:06' AND ((`GuestEvent`.`release_end` >= '2021-12-06 08:45:06') OR (`GuestEvent`.`release_end` IS NULL)) GROUP BY `GuestEvent`.`program_id`, `GuestEvent`.`event_date` ORDER BY `GuestEvent`.`sort_number` ASC ) AS `subGuestEvent` ON (`subGuestEvent`.`program_id` = `Program`.`id` AND `subGuestEvent`.`event_date` Like CONCAT('%', date_format(CONCAT(`BroadcastDay`.`year`,'-',`BroadcastDay`.`month`,'-',`BroadcastDay`.`day`), '%Y-%m-%d'), '%')) WHERE ((((`BroadcastDay`.`year` = 2021) AND (`BroadcastDay`.`month` = 12) AND (`BroadcastDay`.`day` = '06') AND (LPAD(`BroadcastTime`.`broadcast_end`, 5, '0') > '08:45'))) OR (((`BroadcastDay`.`year` = 2021) AND (`BroadcastDay`.`month` = 12) AND (`BroadcastDay`.`day` = 7)))) ORDER BY `BroadcastDay`.`year` ASC, `BroadcastDay`.`month` ASC, `BroadcastDay`.`day` ASC, LPAD(`BroadcastTime`.`broadcast_start`, 5, '0') ASC LIMIT 111477
3SELECT `ProgramPresent`.`id` FROM `program_presents` AS `ProgramPresent` WHERE `ProgramPresent`.`program_id` = 414 AND `ProgramPresent`.`release_start` <= '2021-12-06 03:45:06' AND `ProgramPresent`.`release_end` >= '2021-12-06 03:45:06' 440
4SELECT `Program`.*, `BroadcastTime`.* FROM `broadcast_times` AS `BroadcastTime` INNER JOIN programs AS `Program` ON (`Program`.`id` = `BroadcastTime`.`program_id` AND `Program`.`program_id` = '414' AND `Program`.`corner` = 1) WHERE `BroadcastTime`.`broadcast_day_id` = 4123 AND LPAD(`BroadcastTime`.`broadcast_start`, 5, '0') <= '08:45' ORDER BY LPAD(`BroadcastTime`.`broadcast_start`, 5, '0') DESC LIMIT 1110
5SELECT `Hotraxx`.`id`, `Hotraxx`.`kind`, `Hotraxx`.`release_yearmonth`, `Hotraxx`.`monthly_title`, `Hotraxx`.`track_title`, `Hotraxx`.`track_text`, `Hotraxx`.`artist_name`, `Hotraxx`.`artist_comment`, `Hotraxx`.`artist_info`, `Hotraxx`.`image_top`, `Hotraxx`.`image_main`, `Hotraxx`.`image_album`, `Hotraxx`.`artist_url`, `Hotraxx`.`cd_is_album`, `Hotraxx`.`cd_type`, `Hotraxx`.`cd_price`, `Hotraxx`.`cd_title`, `Hotraxx`.`cd_tracks`, `Hotraxx`.`amazon_url`, `Hotraxx`.`itunes_url`, `Hotraxx`.`movie_youtube`, `Hotraxx`.`sort_number`, `Hotraxx`.`visible_flg_id`, `Hotraxx`.`modified`, `Hotraxx`.`created` FROM `hotraxxes` AS `Hotraxx` WHERE `id` = 286 AND `visible_flg_id` = 1 LIMIT 1110
6SELECT `Banner`.`id`, `Banner`.`banner_type`, `Banner`.`word`, `Banner`.`url`, `Banner`.`image`, `Banner`.`image_l`, `Banner`.`popup_flg`, `Banner`.`release_start`, `Banner`.`release_end`, `Banner`.`visible_flg_id`, `Banner`.`sort_number`, `Banner`.`career_flg`, `Banner`.`modified`, `Banner`.`created` FROM `banners` AS `Banner` WHERE `visible_flg_id` = 1 AND `banner_type` = 5 AND `career_flg` = 0 AND `release_start` <= '2021-12-06 08:45:07' AND `release_end` >= '2021-12-06 08:45:07' ORDER BY `Banner`.`sort_number` asc, `Banner`.`created` desc 551
7SELECT `Banner`.`id`, `Banner`.`banner_type`, `Banner`.`word`, `Banner`.`url`, `Banner`.`image`, `Banner`.`image_l`, `Banner`.`popup_flg`, `Banner`.`release_start`, `Banner`.`release_end`, `Banner`.`visible_flg_id`, `Banner`.`sort_number`, `Banner`.`career_flg`, `Banner`.`modified`, `Banner`.`created` FROM `banners` AS `Banner` WHERE `visible_flg_id` = 1 AND `banner_type` = 4 AND `career_flg` = 0 AND `release_start` <= '2021-12-06 08:45:07' AND `release_end` >= '2021-12-06 08:45:07' ORDER BY `Banner`.`sort_number` asc, `Banner`.`created` desc 111
8SELECT `Banner`.`id`, `Banner`.`banner_type`, `Banner`.`word`, `Banner`.`url`, `Banner`.`image`, `Banner`.`image_l`, `Banner`.`popup_flg`, `Banner`.`release_start`, `Banner`.`release_end`, `Banner`.`visible_flg_id`, `Banner`.`sort_number`, `Banner`.`career_flg`, `Banner`.`modified`, `Banner`.`created` FROM `banners` AS `Banner` WHERE `visible_flg_id` = 1 AND `banner_type` = 2 AND `career_flg` = 0 AND `release_start` <= '2021-12-06 08:45:07' AND `release_end` >= '2021-12-06 08:45:07' ORDER BY `Banner`.`sort_number` asc, `Banner`.`created` desc 17171
9SELECT `Banner`.`id`, `Banner`.`banner_type`, `Banner`.`word`, `Banner`.`url`, `Banner`.`image`, `Banner`.`image_l`, `Banner`.`popup_flg`, `Banner`.`release_start`, `Banner`.`release_end`, `Banner`.`visible_flg_id`, `Banner`.`sort_number`, `Banner`.`career_flg`, `Banner`.`modified`, `Banner`.`created` FROM `banners` AS `Banner` WHERE `visible_flg_id` = 1 AND `banner_type` = 3 AND `career_flg` = 0 AND `release_start` <= '2021-12-06 08:45:07' AND `release_end` >= '2021-12-06 08:45:07' ORDER BY `Banner`.`sort_number` asc, `Banner`.`created` desc 001
10SELECT `Banner`.`id`, `Banner`.`banner_type`, `Banner`.`word`, `Banner`.`url`, `Banner`.`image`, `Banner`.`image_l`, `Banner`.`popup_flg`, `Banner`.`release_start`, `Banner`.`release_end`, `Banner`.`visible_flg_id`, `Banner`.`sort_number`, `Banner`.`career_flg`, `Banner`.`modified`, `Banner`.`created` FROM `banners` AS `Banner` WHERE `visible_flg_id` = 1 AND `banner_type` = 1 AND `career_flg` = 0 AND `release_start` <= '2021-12-06 08:45:07' AND `release_end` >= '2021-12-06 08:45:07' ORDER BY `Banner`.`sort_number` asc, `Banner`.`created` desc 001
11SELECT `Present`.`id`, `Present`.`title`, `Present`.`capacity`, `Present`.`description`, `Present`.`text`, `Present`.`override_url`, `Present`.`client_name`, `Present`.`client_url`, `Present`.`img_main1`, `Present`.`img_main2`, `Present`.`img_main3`, `Present`.`img_main4`, `Present`.`img_main5`, `Present`.`img_main6`, `Present`.`img_main7`, `Present`.`img_main8`, `Present`.`img_main9`, `Present`.`img_main10`, `Present`.`img_caption1`, `Present`.`img_caption2`, `Present`.`img_caption3`, `Present`.`img_caption4`, `Present`.`img_caption5`, `Present`.`img_caption6`, `Present`.`img_caption7`, `Present`.`img_caption8`, `Present`.`img_caption9`, `Present`.`img_caption10`, `Present`.`img_thmb`, `Present`.`img_mobile`, `Present`.`start_datetime`, `Present`.`end_datetime`, `Present`.`require_member_flg_id`, `Present`.`popup_id`, `Present`.`visible_flg_id`, `Present`.`sort_number`, `Present`.`status_code`, `Present`.`modified`, `Present`.`created`, `require_member_flg`.`id`, `require_member_flg`.`name`, `visible_flg`.`id`, `visible_flg`.`name` FROM `presents` AS `Present` LEFT JOIN `require_member_flgs` AS `require_member_flg` ON (`Present`.`require_member_flg_id` = `require_member_flg`.`id`) LEFT JOIN `visible_flgs` AS `visible_flg` ON (`Present`.`visible_flg_id` = `visible_flg`.`id`) WHERE `visible_flg_id` = 1 AND `status_code` = 0 AND `start_datetime` <= '2021-12-06 08:45:07' AND `end_datetime` >= '2021-12-06 08:45:07' ORDER BY `Present`.`sort_number` ASC 882
12SELECT `NewsFlashCategoryWhere`.`id`, `NewsFlashCategoryWhere`.`category`, `NewsFlashCategoryWhere`.`gi_category`, `NewsFlashCategoryWhere`.`gi_subcategory`, `NewsFlashCategoryWhere`.`open_flg`, `NewsFlashCategoryWhere`.`sort` FROM `news_flash_category_where` AS `NewsFlashCategoryWhere` WHERE `open_flg` = 1 440
13SELECT `Program`.`id`, `Program`.`name`, `Program`.`same_information`, `Program`.`catch_copy`, `Program`.`notice`, `Program`.`soundcrew`, `Program`.`url`, `Program`.`twitter`, `DefBroadcastTime`.`broadcast_start`, `DefBroadcastTime`.`broadcast_end`, `DefBroadcastTime`.`week`, `Soundcrew`.`id`, `Soundcrew`.`name`, `Soundcrew`.`name_kana` FROM `programs` AS `Program` INNER JOIN def_broadcast_times AS `DefBroadcastTime` ON (`Program`.`id` = `DefBroadcastTime`.`program_id` AND `DefBroadcastTime`.`release_start` <= CURDATE() AND ((`DefBroadcastTime`.`release_end` is null) OR (((`DefBroadcastTime`.`release_end` is not null) AND (`DefBroadcastTime`.`release_end` >= CURDATE()))))) LEFT JOIN def_program_soundcrews AS `DefProgramSoundcrew` ON (`DefBroadcastTime`.`id` = `DefProgramSoundcrew`.`broadcast_time_id`) LEFT JOIN soundcrews AS `Soundcrew` ON (`DefProgramSoundcrew`.`soundcrew_id` = `Soundcrew`.`id` AND `Soundcrew`.`release_start` <= CURDATE() AND ((`Soundcrew`.`release_end` is null) OR (((`Soundcrew`.`release_end` is not null) AND (`Soundcrew`.`release_end` >= CURDATE()))))) WHERE ((`Program`.`corner` = 0) AND (`Program`.`program_info` > 0) AND (`Program`.`radio_station` = 1) AND (`Program`.`release_start` <= CURDATE()) AND (((`Program`.`release_end` is null) OR (((`Program`.`release_end` is not null) AND (`Program`.`release_end` >= CURDATE())))))) ORDER BY `Program`.`sort` ASC, `DefBroadcastTime`.`week` ASC, `Program`.`same_information` ASC, `Program`.`id` ASC 42424