Kissner's club radiko

特別番組

SPECIAL PROGRAM

2021.10.29 - Fri

SHE'S with Kiss

Array
(
    [id] => 6763
    [kind] => special_pr
    [event_date] => 2021-10-29
    [article_title] => SHE'S with Kiss
    [description] => 
    [article_name] => 
    [text] => 2021年10月のwith Kissは今年バンド結成10周年、メジャーデビュー5周年というアニバーサリーイヤーを迎えるSHE’Sとコラボレート!
特別番組『SHE’S with Kiss』10月29日(金)『Kiss Music Presenter スパシャン FRIDAY』内18時台に放送!
インタビューをたっぷりお届けします。
    [artist_info] => 『SHE'S with Kiss』
放送日時:2021年10月29日(金)18時台
Kiss Music Presenter スパシャン FRIDAY 内
ゲスト:SHE'S
サウンドクルー:川田一輝

SHE'S公式サイト http://she-s.info/

    [article_info] => 
    [override_url] => 
    [url] => 
    [image0] => image06155a5e68e684.jpg
    [image0_caption] => 
    [image1] => 
    [image1_caption] => 
    [image2] => 
    [image2_caption] => 
    [movie_youtube] => 
    [sort_number] => 1
    [toppage_disp_flg_id] => 1
    [visible_flg_id] => 1
    [release_start] => 2021-10-01 00:00:00
    [release_end] => 2021-11-01 00:00:00
    [period_flg] => 0
    [modified] => 2021-09-30 20:57:14
    [created] => 2021-09-30 20:57:14
    [program_id] => 
    [guest_name] => 
    [image] => Array
        (
            [0] => /img/src/guest_event/image06155a5e68e684.jpg
            [1] => 
            [2] => 
        )

    [image_data] => Array
        (
            [path] => /home/kiss-fm.co.jp/public_html/www.kiss-fm.co.jp/img/src/information
            [name] => image06155a5e68e684.jpg
            [src] => https://www.kiss-fm.co.jp/img/src/information/image06155a5e68e684.jpg
        )

    [event_date_array] => Array
        (
            [0] => Array
                (
                    [y] => 2021
                    [m] => 10
                    [d] => 29
                    [day] => Fri
                )

        )

)

SHARE

2021年10月のwith Kissは今年バンド結成10周年、メジャーデビュー5周年というアニバーサリーイヤーを迎えるSHE’Sとコラボレート!
特別番組『SHE’S with Kiss』10月29日(金)『Kiss Music Presenter スパシャン FRIDAY』内18時台に放送!
インタビューをたっぷりお届けします。

『SHE'S with Kiss』
放送日時:2021年10月29日(金)18時台
Kiss Music Presenter スパシャン FRIDAY 内
ゲスト:SHE'S
サウンドクルー:川田一輝

SHE'S公式サイト http://she-s.info/

イベント一覧ページに戻る

(reg_db) 1 query took 0 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT `Information`.`id`, `Information`.`kind`, `Information`.`event_date`, `Information`.`article_title`, `Information`.`description`, `Information`.`article_name`, `Information`.`text`, `Information`.`artist_info`, `Information`.`article_info`, `Information`.`override_url`, `Information`.`url`, `Information`.`image0`, `Information`.`image0_caption`, `Information`.`image1`, `Information`.`image1_caption`, `Information`.`image2`, `Information`.`image2_caption`, `Information`.`movie_youtube`, `Information`.`sort_number`, `Information`.`toppage_disp_flg_id`, `Information`.`visible_flg_id`, `Information`.`release_start`, `Information`.`release_end`, `Information`.`period_flg`, `Information`.`modified`, `Information`.`created`, `Information`.`program_id`, `Information`.`guest_name` FROM `informations` AS `Information` WHERE `visible_flg_id` = 1 AND `id` = 6763 ORDER BY `Information`.`sort_number` ASC 110
(default) 7 queries took 389 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
2SHOW FULL COLUMNS FROM `soundcrews`19191
3SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'utf8_general_ci';110
4SHOW FULL COLUMNS FROM `broadcast_days`660
5SELECT `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 15:17:50' AND ((`GuestEvent`.`release_end` >= '2021-10-21 15:17:50') 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') > '15:17'))) 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 111387
6SELECT `ProgramPresent`.`id` FROM `program_presents` AS `ProgramPresent` WHERE `ProgramPresent`.`program_id` = 3 AND `ProgramPresent`.`release_start` <= '2021-10-21 10:17:50' AND `ProgramPresent`.`release_end` >= '2021-10-21 10:17:50' 771
7SELECT `Program`.*, `BroadcastTime`.* FROM `broadcast_times` AS `BroadcastTime` INNER JOIN programs AS `Program` ON (`Program`.`id` = `BroadcastTime`.`program_id` AND `Program`.`program_id` = '3' AND `Program`.`corner` = 1) WHERE `BroadcastTime`.`broadcast_day_id` = 4077 AND LPAD(`BroadcastTime`.`broadcast_start`, 5, '0') <= '15:17' ORDER BY LPAD(`BroadcastTime`.`broadcast_start`, 5, '0') DESC LIMIT 1110