Kissner's club radiko
Array
(
    [0] => Array
        (
            [week] => Array
                (
                    [0] => Array
                        (
                            [week] => 6
                            [week_time] => 11:00~12:55
                        )

                )

            [soundcrews] => Array
                (
                    [0] => Array
                        (
                            [id] => 4
                            [week] => 6
                            [name] => 藤原 岬
                            [name_kana] => ふじわら みさき
                        )

                )

            [id] => 2628
            [name] => Saturday Junction
            [same_information] => Saturday Junction
            [catch_copy] => 
            [notice] => 京阪神FM3局共同制作・生放送!ドライブのお供に、リラックスタイムに、京阪神エリアの魅力を再発見。週末がもっと楽しくなる番組を目指します。DJは川原ちかよ(α-STATION)・遠藤淳(FM大阪)・藤原岬(Kiss FM KOBE)が週替わりで出演。キー局も京都・大阪・神戸が週替わりで担当。その街ならではの雰囲気・選曲でお送りします。

DJ/Sound Crew:川原ちかよ(α-STATION)・遠藤淳(FM大阪)・藤原岬(Kiss FM KOBE)
@SaturdayJCT
[soundcrew] => [url] => https://kiss-fm.co.jp/junction/ [twitter] => [program_week] => Array ( [0] => Array ( [week] => 土 [week_time] => 11:00~12:55 ) ) [program_week_cnt] => 1 [program_soundcrew] => 藤原 岬 [image] => Array ( [thumbnail] => /img/src/program/2628/thumbnail.jpg ) ) )

番組

PROGRAM

Saturday Junction

SHARE

放送時間

毎週 土曜 11:00~12:55

番組内容
京阪神FM3局共同制作・生放送!ドライブのお供に、リラックスタイムに、京阪神エリアの魅力を再発見。週末がもっと楽しくなる番組を目指します。DJは川原ちかよ(α-STATION)・遠藤淳(FM大阪)・藤原岬(Kiss FM KOBE)が週替わりで出演。キー局も京都・大阪・神戸が週替わりで担当。その街ならではの雰囲気・選曲でお送りします。

DJ/Sound Crew:川原ちかよ(α-STATION)・遠藤淳(FM大阪)・藤原岬(Kiss FM KOBE)
公式サイト
https://kiss-fm.co.jp/junction/

SOUND CREW

  • 藤原 岬

    ふじわら みさき

番組一覧ページに戻る

(default) 5 queries took 419 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-10-21 14:45:17' AND ((`GuestEvent`.`release_end` >= '2021-10-21 14:45:17') 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` = 10) AND (`BroadcastDay`.`day` = 21) AND (LPAD(`BroadcastTime`.`broadcast_end`, 5, '0') > '14:45'))) OR (((`BroadcastDay`.`year` = 2021) AND (`BroadcastDay`.`month` = 10) AND (`BroadcastDay`.`day` = 22)))) ORDER BY `BroadcastDay`.`year` ASC, `BroadcastDay`.`month` ASC, `BroadcastDay`.`day` ASC, LPAD(`BroadcastTime`.`broadcast_start`, 5, '0') ASC LIMIT 111415
3SELECT `ProgramPresent`.`id` FROM `program_presents` AS `ProgramPresent` WHERE `ProgramPresent`.`program_id` = 2626 AND `ProgramPresent`.`release_start` <= '2021-10-21 09:45:17' AND `ProgramPresent`.`release_end` >= '2021-10-21 09:45:17' 000
4SELECT `Program`.*, `BroadcastTime`.* FROM `broadcast_times` AS `BroadcastTime` INNER JOIN programs AS `Program` ON (`Program`.`id` = `BroadcastTime`.`program_id` AND `Program`.`program_id` = '2626' AND `Program`.`corner` = 1) WHERE `BroadcastTime`.`broadcast_day_id` = 4077 AND LPAD(`BroadcastTime`.`broadcast_start`, 5, '0') <= '14:45' ORDER BY LPAD(`BroadcastTime`.`broadcast_start`, 5, '0') DESC LIMIT 1110
5SELECT `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`) 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