リクエスト&メッセージ radiko
Array
(
    [title] => クマガイタツロウ
    [keywords] => クマガイタツロウ,サウンドクルー,DJ
    [description] => 
    [soundcrews] => Array
        (
            [0] => Array
                (
                    [id] => 35
                    [name] => クマガイタツロウ
                    [name_kana] => くまがいたつろう
                    [message] => 神戸市在住。ロックバンド「ワタナベフラワー」のボーカル。自称、誰よりも神戸のことを知り尽くしたい男。多くの地元企業・自治体とのコラボ実績あり。
                    [history] => 
                    [favorites] => ハンモック/土鍋ごはん
                    [url] => 
                    [blog] => 
                    [twitter] => https://twitter.com/kumagaitatsurou
                    [birthday] => 06/08
                    [zodiac] => ふたご座
                    [blood] => AB
                    [Program] => Array
                        (
                            [0] => Array
                                (
                                    [id] => 414
                                    [name] => 4 SEASONS
                                    [same_information] => 4 SEASONS
                                    [catch_copy] => 
                                    [notice] => 自然・歴史・グルメ…魅力に溢れた神戸の街で何よりも輝いているのが、この街を誇り、愛する「人」。神戸にはまだまだ知られていないこと、素敵な場所が隠されています。そんな神戸の街を紐とき、地元の方々にもご満足いただける情報をお伝えしていくのが、この「4 SEASONS」。皆様のライフスタイルを豊かに彩る番組を提供いたします。私たちが何より大切にしているのは、この街の知られざる魅力をふんだんにお届けし、その素晴らしさを改めて知っていただくこと。日々の生活を彩る心地よいサウンドと、神戸に精通したサウンドクルーが番組をナビゲート。神戸の美しい四季を、ラジオを通して受け止めてください。

@kiss_4seasons
[url] => http://www.kiss-fm.co.jp/4seasons/ [request_mail] => 4_season_s@kiss-fm.co.jp [mail_type] => 1 [image_data] => Array ( [path] => /assets/img/common/ [name] => noimage_B-gray.png [src] => /assets/img/common/noimage_B-gray.png ) [week] => Array ( [0] => Array ( [week] => 水・木 [week_time] => 7:30~11:00 ) ) [week_cnt] => 2 ) ) [image] => Array ( [illust] => /img/src/soundcrew/35/illust.jpg [icon] => /img/src/soundcrew/35/icon.jpg ) ) ) )

サウンドクルー紹介

SOUND CREW

くまがいたつろう

クマガイタツロウ

血液型
AB型
誕生日
06/08
趣味
ハンモック/土鍋ごはん

神戸市在住。ロックバンド「ワタナベフラワー」のボーカル。自称、誰よりも神戸のことを知り尽くしたい男。多くの地元企業・自治体とのコラボ実績あり。

担当番組

(default) 5 queries took 678 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 1111
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-04 19:26:43' AND ((`GuestEvent`.`release_end` >= '2021-12-04 19:26:43') 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` = '04') AND (LPAD(`BroadcastTime`.`broadcast_end`, 5, '0') > '19:26'))) OR (((`BroadcastDay`.`year` = 2021) AND (`BroadcastDay`.`month` = 12) AND (`BroadcastDay`.`day` = 5)))) ORDER BY `BroadcastDay`.`year` ASC, `BroadcastDay`.`month` ASC, `BroadcastDay`.`day` ASC, LPAD(`BroadcastTime`.`broadcast_start`, 5, '0') ASC LIMIT 111673
3SELECT `ProgramPresent`.`id` FROM `program_presents` AS `ProgramPresent` WHERE `ProgramPresent`.`program_id` = 2565 AND `ProgramPresent`.`release_start` <= '2021-12-04 14:26:43' AND `ProgramPresent`.`release_end` >= '2021-12-04 14:26:43' 002
4SELECT `Program`.*, `BroadcastTime`.* FROM `broadcast_times` AS `BroadcastTime` INNER JOIN programs AS `Program` ON (`Program`.`id` = `BroadcastTime`.`program_id` AND `Program`.`program_id` = '2565' AND `Program`.`corner` = 1) WHERE `BroadcastTime`.`broadcast_day_id` = 4121 AND LPAD(`BroadcastTime`.`broadcast_start`, 5, '0') <= '19:26' ORDER BY LPAD(`BroadcastTime`.`broadcast_start`, 5, '0') DESC LIMIT 1000
5SELECT `Soundcrew`.`id`, `Soundcrew`.`name`, `Soundcrew`.`name_kana`, `Soundcrew`.`message`, `Soundcrew`.`history`, `Soundcrew`.`favorites`, `Soundcrew`.`url`, `Soundcrew`.`blog`, `Soundcrew`.`twitter`, `Soundcrew`.`birthday`, `Zodiac`.`name`, `Blood`.`name`, `DefBroadcastTime`.`week`, `DefBroadcastTime`.`broadcast_start`, `DefBroadcastTime`.`broadcast_end`, `Program`.`id`, `Program`.`name`, `Program`.`same_information`, `Program`.`catch_copy`, `Program`.`notice`, `Program`.`url`, `Program`.`request_mail`, `Program`.`mail_type` FROM `soundcrews` AS `Soundcrew` LEFT JOIN zodiacs AS `Zodiac` ON (`Zodiac`.`id` = `Soundcrew`.`zodiac_id`) LEFT JOIN bloods AS `Blood` ON (`Blood`.`id` = `Soundcrew`.`blood_id`) INNER JOIN def_program_soundcrews AS `DefProgramSoundcrew` ON (`Soundcrew`.`id` = `DefProgramSoundcrew`.`soundcrew_id`) LEFT JOIN def_broadcast_times AS `DefBroadcastTime` ON (`DefBroadcastTime`.`id` = `DefProgramSoundcrew`.`broadcast_time_id`) INNER JOIN programs AS `Program` ON (`Program`.`id` = `DefBroadcastTime`.`program_id`) WHERE ((`Soundcrew`.`radio_station` = 1) AND (`Soundcrew`.`id` != 42) AND (`Soundcrew`.`release_start` <= CURDATE()) AND (((`Soundcrew`.`release_end` is null) OR (((`Soundcrew`.`release_end` is not null) AND (`Soundcrew`.`release_end` >= CURDATE())))))) ORDER BY `Soundcrew`.`sort` ASC, `Program`.`sort` ASC, `DefBroadcastTime`.`week` ASC, `DefBroadcastTime`.`broadcast_start` ASC 28282