Kissner's club radiko
MENU

ゲスト情報

GUEST

    Array
(
    [0_0] => Array
        (
            [GuestEvent] => Array
                (
                    [id] => 6026
                    [kind] => guest
                    [event_date] => 2021-10-21
                    [article_title] => OWV
                    [description] => 放送日:10/21(木) 
    番組:4 SEASONS
                    [text] => 9時台にOWVが登場！

アルバム　「CHASER」
2021.10.13 Release

https://owv.jp/
                    [artist_info] => 
                    [url] => 
                    [image0] => image1615429b16ee9f.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-14 11:00:00
                    [release_end] => 
                    [period_flg] => 0
                    [modified] => 2021-09-29 17:54:26
                    [created] => 2021-09-29 17:54:26
                    [program_id] => 414
                    [guest_name] => OWV
                    [image] => Array
                        (
                            [0] => /kiss_editor/img/guest/7500-7599/7515/image1615429b16ee9f_resize.jpg
                            [1] => 
                            [2] => 
                        )

                    [event_date_array] => Array
                        (
                            [0] => Array
                                (
                                    [y] => 2021
                                    [m] => 10
                                    [d] => 21
                                    [day] => Thu
                                    [holiday] => 
                                )

                        )

                )

            [Program] => Array
                (
                    [id] => 414
                    [program_id] => 0
                    [name] => 4 SEASONS
                    [same_information] => 4 SEASONS
                    [catch_copy] => 
                    [notice] => 自然・歴史・グルメ…魅力に溢れた神戸の街で何よりも輝いているのが、この街を誇り、愛する「人」。神戸にはまだまだ知られていないこと、素敵な場所が隠されています。そんな神戸の街を紐とき、地元の方々にもご満足いただける情報をお伝えしていくのが、この「4 SEASONS」。皆様のライフスタイルを豊かに彩る番組を提供いたします。私たちが何より大切にしているのは、この街の知られざる魅力をふんだんにお届けし、その素晴らしさを改めて知っていただくこと。日々の生活を彩る心地よいサウンドと、神戸に精通したサウンドクルーが番組をナビゲート。神戸の美しい四季を、ラジオを通して受け止めてください。


    @kiss_4seasons
    
                    [tp_title] => Kiss FM KOBE朝のワイドプログラム
                    [tp_description] => ウィークデーの朝はここから始まる♪
7:30～11:00 ON AIR
神戸・兵庫の四季を音楽と情報で彩るKiss FM KOBE朝のワイドプログラム

サウンドクルー：
中野 耕史（月・火・水）、浜平 恭子（木・金）
                    [tp_disp_mon] => 1
                    [tp_disp_tue] => 1
                    [tp_disp_wed] => 1
                    [tp_disp_thu] => 1
                    [tp_disp_fri] => 1
                    [tp_disp_sat] => 0
                    [tp_disp_sun] => 0
                    [url] => http://www.kiss-fm.co.jp/4seasons/
                    [mobile_url] => http://www.kiss-fm.co.jp/4seasons/
                    [corner] => 0
                    [request_mail] => 4_season_s@kiss-fm.co.jp
                    [mail_type] => 1
                    [soundcrew] => 
                    [sort] => 1
                    [program_info] => 1
                    [radio_station] => 1
                    [present_flg] => 1
                    [release_start] => 2012-04-01
                    [release_end] => 2032-03-26
                    [radiko_contents1] => 
                    [radiko_contents2] => 
                    [message_flg] => 0
                    [thumbnail] => 
                    [twitter] => kiss_4seasons
                    [created] => 2012-03-26 21:26:49
                    [modified] => 2021-07-03 17:13:59
                )

            [BroadcastDay] => Array
                (
                    [id] => 4077
                    [year] => 2021
                    [month] => 10
                    [day] => 21
                    [created] => 2021-10-08 00:00:01
                    [modified] => 2021-10-08 00:00:01
                )

            [BroadcastTime] => Array
                (
                    [broadcast_day_id] => 4077
                    [program_id] => 414
                    [broadcast_start] => 7:30
                    [broadcast_end] => 11:00
                )

            [Guest] => Array
                (
                    [id] => 7515
                    [event_guest_id] => 6026
                    [flow] => 1
                    [type] => 101
                    [room] => 0
                    [room_etc] => 
                    [name] => OWV
                    [guest_data] => 
                    [program_id] => 35
                    [user_id] => 
                    [onair_date] => 2021-10-21
                    [onair_date_multi] => 2021-10-21
                    [onair_time] => 09:25
                    [rec_date] => 
                    [rec_time] => 
                    [visit_time] => 
                    [release] => 
                    [msg] => 
                    [image1] => image1615429b16ee9f.jpg
                    [image2] => 
                    [image3] => 
                    [user_id_created] => 5
                    [user_id_modified] => 5
                    [open_flg] => 1
                    [delete_flg] => 0
                    [created] => 2021-09-29 17:54:26
                    [modified] => 2021-09-29 17:54:26
                    [buf_user_id] => 
                    [buf_user_id_created] => 
                    [buf_user_id_modified] => 
                    [buf_program_id] => 
                )

            [sort] => 2021-10-2107:3015:00
        )

    [1_0] => Array
        (
            [GuestEvent] => Array
                (
                    [id] => 6018
                    [kind] => guest
                    [event_date] => 2021-10-21
                    [article_title] => ネルソン・バビンコイ
                    [description] => 放送日:10/21(木) 
    番組:Wave!!!!
                    [text] => シンガー／文化通訳家　ネルソン・バビンコイさんが登場！
 https://www.nellybc.com/
                    [artist_info] => 
                    [url] => 
                    [image0] => 
                    [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-14 15:00:00
                    [release_end] => 
                    [period_flg] => 0
                    [modified] => 2021-09-27 14:07:51
                    [created] => 2021-09-27 14:07:36
                    [program_id] => 2626
                    [guest_name] => ネルソン・バビンコイ
                    [image] => Array
                        (
                            [0] => 
                            [1] => 
                            [2] => 
                        )

                    [event_date_array] => Array
                        (
                            [0] => Array
                                (
                                    [y] => 2021
                                    [m] => 10
                                    [d] => 21
                                    [day] => Thu
                                    [holiday] => 
                                )

                        )

                )

            [Program] => Array
                (
                    [id] => 2626
                    [program_id] => 0
                    [name] => Wave!!!!
                    [same_information] => Wave!!!!
                    [catch_copy] => 
                    [notice] => 海を眺める新スタジオから生放送でお送りするKiss FM KOBEのランドマークプログラム！リモートワークで、車の中で、オフィスで乗り降り自由！あなたの毎日にそっと寄り添う番組です。変化を続ける神戸・兵庫の今、ちょっと得する情報、明るいニュース、今日がちょっと楽しくなる情報を短くお伝えしていきます。


    @kissfmwave
    
                    [tp_title] => 
                    [tp_description] => 
                    [tp_disp_mon] => 0
                    [tp_disp_tue] => 0
                    [tp_disp_wed] => 0
                    [tp_disp_thu] => 0
                    [tp_disp_fri] => 0
                    [tp_disp_sat] => 0
                    [tp_disp_sun] => 0
                    [url] => https://www.kiss-fm.co.jp/wave/
                    [mobile_url] => https://www.kiss-fm.co.jp/wave/
                    [corner] => 0
                    [request_mail] => w_av_e@kiss-fm.co.jp
                    [mail_type] => 1
                    [soundcrew] => 
                    [sort] => 2
                    [program_info] => 1
                    [radio_station] => 1
                    [present_flg] => 1
                    [release_start] => 2021-03-25
                    [release_end] => 2040-03-25
                    [radiko_contents1] => 
                    [radiko_contents2] => 
                    [message_flg] => 1
                    [thumbnail] => 
                    [twitter] => 
                    [created] => 2021-03-25 11:57:54
                    [modified] => 2021-07-03 17:13:59
                )

            [BroadcastDay] => Array
                (
                    [id] => 4077
                    [year] => 2021
                    [month] => 10
                    [day] => 21
                    [created] => 2021-10-08 00:00:01
                    [modified] => 2021-10-08 00:00:01
                )

            [BroadcastTime] => Array
                (
                    [broadcast_day_id] => 4077
                    [program_id] => 2626
                    [broadcast_start] => 12:00
                    [broadcast_end] => 15:00
                )

            [Guest] => Array
                (
                    [id] => 7507
                    [event_guest_id] => 6018
                    [flow] => 1
                    [type] => 102
                    [room] => 0
                    [room_etc] => 
                    [name] => ネルソン・バビンコイ
                    [guest_data] => 
                    [program_id] => 40
                    [user_id] => 
                    [onair_date] => 2021-10-21
                    [onair_date_multi] => 2021-10-21
                    [onair_time] => 
                    [rec_date] => 
                    [rec_time] => 
                    [visit_time] => 
                    [release] => 
                    [msg] => 
                    [image1] => 
                    [image2] => 
                    [image3] => 
                    [user_id_created] => 5
                    [user_id_modified] => 5
                    [open_flg] => 1
                    [delete_flg] => 0
                    [created] => 2021-09-27 14:07:36
                    [modified] => 2021-09-27 14:07:51
                    [buf_user_id] => 
                    [buf_user_id_created] => 
                    [buf_user_id_modified] => 
                    [buf_program_id] => 
                )

            [sort] => 2021-10-2112:0015:00
        )

    [2_0] => Array
        (
            [GuestEvent] => Array
                (
                    [id] => 6074
                    [kind] => guest
                    [event_date] => 2021-10-21
                    [article_title] => 上田正樹
                    [description] => 放送日:10/21(木) 
    番組:Kiss Music Presenter
                    [text] => 
                    [artist_info] => 
                    [url] => 
                    [image0] => image16164e80b12825.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-14 00:00:00
                    [release_end] => 
                    [period_flg] => 0
                    [modified] => 2021-10-14 20:50:31
                    [created] => 2021-10-11 14:19:55
                    [program_id] => 3
                    [guest_name] => 上田正樹
                    [image] => Array
                        (
                            [0] => /kiss_editor/img/guest/7500-7599/7561/image16164e80b12825_resize.jpg
                            [1] => 
                            [2] => 
                        )

                    [event_date_array] => Array
                        (
                            [0] => Array
                                (
                                    [y] => 2021
                                    [m] => 10
                                    [d] => 21
                                    [day] => Thu
                                    [holiday] => 
                                )

                        )

                )

            [Program] => Array
                (
                    [id] => 3
                    [program_id] => 0
                    [name] => Kiss Music Presenter
                    [same_information] => Kiss Music Presenter
                    [catch_copy] => 
                    [notice] => 15時から4時間にわたり、Kiss FM KOBE本社スタジオから生放送でお送りするプログラム。リクエストを始め、「今聴きたい！」選曲を藤原岬、ターザン山下の軽快なトークと共にオンエアー！また、旬のアーティストが登場するゲストコーナーも要チェック★ゲストやサウンドクルーへのメッセージももちろんいつでも受け付けています。最新トレンド情報も満載でお送りする必聴・必須のKiss FM看板番組♪


    @kmpdayo
    
                    [tp_title] => 最新トレンド情報も満載!
必聴・必須のKiss FM看板番組♪
                    [tp_description] => 15:00～ON AIR
サウンドクルーは
藤原岬！(月・火)
ターザン山下！(水・木)
ゲストやサウンドクルーへのメッセージももちろんいつでも受け付けています。
                    [tp_disp_mon] => 1
                    [tp_disp_tue] => 1
                    [tp_disp_wed] => 1
                    [tp_disp_thu] => 1
                    [tp_disp_fri] => 0
                    [tp_disp_sat] => 0
                    [tp_disp_sun] => 0
                    [url] => http://www.kiss-fm.co.jp/program_blog/presenter/
                    [mobile_url] => http://www.kiss-fm.co.jp/program_blog/presenter/
                    [corner] => 0
                    [request_mail] => k_m_presen_ter@kiss-fm.co.jp
                    [mail_type] => 1
                    [soundcrew] => 
                    [sort] => 3
                    [program_info] => 1
                    [radio_station] => 1
                    [present_flg] => 1
                    [release_start] => 2000-01-01
                    [release_end] => 2030-01-01
                    [radiko_contents1] =>  
                    [radiko_contents2] => 
                    [message_flg] => 0
                    [thumbnail] => 
                    [twitter] => 
                    [created] => 0000-00-00 00:00:00
                    [modified] => 2021-07-03 17:13:59
                )

            [BroadcastDay] => Array
                (
                    [id] => 4077
                    [year] => 2021
                    [month] => 10
                    [day] => 21
                    [created] => 2021-10-08 00:00:01
                    [modified] => 2021-10-08 00:00:01
                )

            [BroadcastTime] => Array
                (
                    [broadcast_day_id] => 4077
                    [program_id] => 3
                    [broadcast_start] => 15:00
                    [broadcast_end] => 18:50
                )

            [Guest] => Array
                (
                    [id] => 7561
                    [event_guest_id] => 6074
                    [flow] => 1
                    [type] => 101
                    [room] => 0
                    [room_etc] => 
                    [name] => 上田正樹
                    [guest_data] => 
                    [program_id] => 21
                    [user_id] => 
                    [onair_date] => 2021-10-21
                    [onair_date_multi] => 2021-10-21
                    [onair_time] => 16:00
                    [rec_date] => 
                    [rec_time] => 
                    [visit_time] => 
                    [release] => 
                    [msg] => 
                    [image1] => image16164e80b12825.jpg
                    [image2] => 
                    [image3] => 
                    [user_id_created] => 2
                    [user_id_modified] => 2
                    [open_flg] => 1
                    [delete_flg] => 0
                    [created] => 2021-10-11 14:19:55
                    [modified] => 2021-10-14 20:50:31
                    [buf_user_id] => 
                    [buf_user_id_created] => 
                    [buf_user_id_modified] => 
                    [buf_program_id] => 
                )

            [sort] => 2021-10-2115:0015:00
        )

    [4_0] => Array
        (
            [GuestEvent] => Array
                (
                    [id] => 6087
                    [kind] => guest
                    [event_date] => 2021-10-22
                    [article_title] => 第2・4金曜17時台は「（夜と）SAMPOのととのいステーション」（夜と）SAMPO
                    [description] => 放送日:10/22(金) 
    番組:Kiss Music Presenter スパシャン FRIDAY
                    [text] => 第2・4金曜17時台は「（夜と）SAMPOのととのいステーション」（夜と）SAMPO
                    [artist_info] => 
                    [url] => 
                    [image0] => image16168db8745ea0.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-15 19:00:00
                    [release_end] => 
                    [period_flg] => 0
                    [modified] => 2021-10-15 15:11:28
                    [created] => 2021-10-15 10:38:21
                    [program_id] => 2499
                    [guest_name] => 第2・4金曜17時台は「（夜と）SAMPOのととのいステーション」（夜と）SAMPO
                    [image] => Array
                        (
                            [0] => /kiss_editor/img/guest/7500-7599/7574/image16168db8745ea0_resize.jpg
                            [1] => 
                            [2] => 
                        )

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

                        )

                )

            [Program] => Array
                (
                    [id] => 2499
                    [program_id] => 0
                    [name] => Kiss Music Presenter スパシャン FRIDAY
                    [same_information] => Kiss Music Presenter スパシャン FRIDAY
                    [catch_copy] => 
                    [notice] => Kiss FM KOBE 夕方の看板番組が金曜日に拡大！今聴きたいリクエスト曲を軽快なトークと共にテンポよくオンエア。旬のアーティストや今後活躍が期待される関西在住のアーティストの楽曲・インタビュー・メッセージを紹介する3時間のミュージックプログラム。


    ＠kmp_fri
    
                    [tp_title] => 
                    [tp_description] => 
                    [tp_disp_mon] => 0
                    [tp_disp_tue] => 0
                    [tp_disp_wed] => 0
                    [tp_disp_thu] => 0
                    [tp_disp_fri] => 0
                    [tp_disp_sat] => 0
                    [tp_disp_sun] => 0
                    [url] => http://www.kiss-fm.co.jp/program_blog/presenter/
                    [mobile_url] => http://www.kiss-fm.co.jp/program_blog/presenter/
                    [corner] => 0
                    [request_mail] => k_m_presen_ter@kiss-fm.co.jp
                    [mail_type] => 1
                    [soundcrew] => 
                    [sort] => 4
                    [program_info] => 1
                    [radio_station] => 1
                    [present_flg] => 1
                    [release_start] => 2020-09-25
                    [release_end] => 2030-09-25
                    [radiko_contents1] => 
                    [radiko_contents2] => 
                    [message_flg] => 0
                    [thumbnail] => 
                    [twitter] => 
                    [created] => 2020-09-25 18:30:27
                    [modified] => 2021-07-03 17:13:59
                )

            [BroadcastDay] => Array
                (
                    [id] => 4078
                    [year] => 2021
                    [month] => 10
                    [day] => 22
                    [created] => 2021-10-09 00:00:01
                    [modified] => 2021-10-09 00:00:01
                )

            [BroadcastTime] => Array
                (
                    [broadcast_day_id] => 4078
                    [program_id] => 2499
                    [broadcast_start] => 16:00
                    [broadcast_end] => 19:00
                )

            [Guest] => Array
                (
                    [id] => 7574
                    [event_guest_id] => 6087
                    [flow] => 1
                    [type] => 101
                    [room] => 0
                    [room_etc] => 
                    [name] => 第2・4金曜17時台は「（夜と）SAMPOのととのいステーション」（夜と）SAMPO
                    [guest_data] => 
                    [program_id] => 37
                    [user_id] => 
                    [onair_date] => 2021-10-22
                    [onair_date_multi] => 2021-10-22
                    [onair_time] => 17:00
                    [rec_date] => 
                    [rec_time] => 
                    [visit_time] => 
                    [release] => 
                    [msg] => 
                    [image1] => image16168db8745ea0.jpg
                    [image2] => 
                    [image3] => 
                    [user_id_created] => 5
                    [user_id_modified] => 5
                    [open_flg] => 1
                    [delete_flg] => 0
                    [created] => 2021-10-15 10:38:21
                    [modified] => 2021-10-15 15:11:28
                    [buf_user_id] => 
                    [buf_user_id_created] => 
                    [buf_user_id_modified] => 
                    [buf_program_id] => 
                )

            [sort] => 2021-10-2216:0015:00
        )

    [3_0] => Array
        (
            [GuestEvent] => Array
                (
                    [id] => 6081
                    [kind] => guest
                    [event_date] => 2021-10-22
                    [article_title] => 超能力戦士ドリアン
                    [description] => 放送日:10/22(金) 
    番組:Kiss Music Presenter スパシャン FRIDAY
                    [text] => 
                    [artist_info] => 
                    [url] => 
                    [image0] => 
                    [image0_caption] => 
                    [image1] => 
                    [image1_caption] => 
                    [image2] => 
                    [image2_caption] => 
                    [movie_youtube] => 
                    [sort_number] => 1
                    [toppage_disp_flg_id] => 0
                    [visible_flg_id] => 1
                    [release_start] => 2021-10-15 19:00:00
                    [release_end] => 
                    [period_flg] => 0
                    [modified] => 2021-10-13 17:27:53
                    [created] => 2021-10-13 17:27:53
                    [program_id] => 2499
                    [guest_name] => 超能力戦士ドリアン
                    [image] => Array
                        (
                            [0] => 
                            [1] => 
                            [2] => 
                        )

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

                        )

                )

            [Program] => Array
                (
                    [id] => 2499
                    [program_id] => 0
                    [name] => Kiss Music Presenter スパシャン FRIDAY
                    [same_information] => Kiss Music Presenter スパシャン FRIDAY
                    [catch_copy] => 
                    [notice] => Kiss FM KOBE 夕方の看板番組が金曜日に拡大！今聴きたいリクエスト曲を軽快なトークと共にテンポよくオンエア。旬のアーティストや今後活躍が期待される関西在住のアーティストの楽曲・インタビュー・メッセージを紹介する3時間のミュージックプログラム。


    ＠kmp_fri
    
                    [tp_title] => 
                    [tp_description] => 
                    [tp_disp_mon] => 0
                    [tp_disp_tue] => 0
                    [tp_disp_wed] => 0
                    [tp_disp_thu] => 0
                    [tp_disp_fri] => 0
                    [tp_disp_sat] => 0
                    [tp_disp_sun] => 0
                    [url] => http://www.kiss-fm.co.jp/program_blog/presenter/
                    [mobile_url] => http://www.kiss-fm.co.jp/program_blog/presenter/
                    [corner] => 0
                    [request_mail] => k_m_presen_ter@kiss-fm.co.jp
                    [mail_type] => 1
                    [soundcrew] => 
                    [sort] => 4
                    [program_info] => 1
                    [radio_station] => 1
                    [present_flg] => 1
                    [release_start] => 2020-09-25
                    [release_end] => 2030-09-25
                    [radiko_contents1] => 
                    [radiko_contents2] => 
                    [message_flg] => 0
                    [thumbnail] => 
                    [twitter] => 
                    [created] => 2020-09-25 18:30:27
                    [modified] => 2021-07-03 17:13:59
                )

            [BroadcastDay] => Array
                (
                    [id] => 4078
                    [year] => 2021
                    [month] => 10
                    [day] => 22
                    [created] => 2021-10-09 00:00:01
                    [modified] => 2021-10-09 00:00:01
                )

            [BroadcastTime] => Array
                (
                    [broadcast_day_id] => 4078
                    [program_id] => 2499
                    [broadcast_start] => 16:00
                    [broadcast_end] => 19:00
                )

            [Guest] => Array
                (
                    [id] => 7568
                    [event_guest_id] => 6081
                    [flow] => 1
                    [type] => 0
                    [room] => 0
                    [room_etc] => 
                    [name] => 超能力戦士ドリアン
                    [guest_data] => 
                    [program_id] => 37
                    [user_id] => 
                    [onair_date] => 2021-10-22
                    [onair_date_multi] => 2021-10-22
                    [onair_time] => 18:00
                    [rec_date] => 
                    [rec_time] => 
                    [visit_time] => 
                    [release] => 
                    [msg] => 
                    [image1] => 
                    [image2] => 
                    [image3] => 
                    [user_id_created] => 5
                    [user_id_modified] => 5
                    [open_flg] => 1
                    [delete_flg] => 0
                    [created] => 2021-10-13 17:27:53
                    [modified] => 2021-10-13 17:27:53
                    [buf_user_id] => 
                    [buf_user_id_created] => 
                    [buf_user_id_modified] => 
                    [buf_program_id] => 
                )

            [sort] => 2021-10-2216:0015:00
        )

    [5_0] => Array
        (
            [GuestEvent] => Array
                (
                    [id] => 6033
                    [kind] => guest
                    [event_date] => 2021-10-25
                    [article_title] => 雨のパレード
                    [description] => 放送日:10/25(月) 
    番組:Wave!!!!
                    [text] => 
                    [artist_info] => 
                    [url] => 
                    [image0] => image161628527a261a.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-18 08:00:00
                    [release_end] => 
                    [period_flg] => 0
                    [modified] => 2021-10-10 15:16:54
                    [created] => 2021-09-30 15:56:27
                    [program_id] => 2626
                    [guest_name] => 雨のパレード
                    [image] => Array
                        (
                            [0] => /kiss_editor/img/guest/7500-7599/7522/image161628527a261a_resize.jpg
                            [1] => 
                            [2] => 
                        )

                    [event_date_array] => Array
                        (
                            [0] => Array
                                (
                                    [y] => 2021
                                    [m] => 10
                                    [d] => 25
                                    [day] => Mon
                                    [holiday] => 
                                )

                        )

                )

            [Program] => Array
                (
                    [id] => 2626
                    [program_id] => 0
                    [name] => Wave!!!!
                    [same_information] => Wave!!!!
                    [catch_copy] => 
                    [notice] => 海を眺める新スタジオから生放送でお送りするKiss FM KOBEのランドマークプログラム！リモートワークで、車の中で、オフィスで乗り降り自由！あなたの毎日にそっと寄り添う番組です。変化を続ける神戸・兵庫の今、ちょっと得する情報、明るいニュース、今日がちょっと楽しくなる情報を短くお伝えしていきます。


    @kissfmwave
    
                    [tp_title] => 
                    [tp_description] => 
                    [tp_disp_mon] => 0
                    [tp_disp_tue] => 0
                    [tp_disp_wed] => 0
                    [tp_disp_thu] => 0
                    [tp_disp_fri] => 0
                    [tp_disp_sat] => 0
                    [tp_disp_sun] => 0
                    [url] => https://www.kiss-fm.co.jp/wave/
                    [mobile_url] => https://www.kiss-fm.co.jp/wave/
                    [corner] => 0
                    [request_mail] => w_av_e@kiss-fm.co.jp
                    [mail_type] => 1
                    [soundcrew] => 
                    [sort] => 2
                    [program_info] => 1
                    [radio_station] => 1
                    [present_flg] => 1
                    [release_start] => 2021-03-25
                    [release_end] => 2040-03-25
                    [radiko_contents1] => 
                    [radiko_contents2] => 
                    [message_flg] => 1
                    [thumbnail] => 
                    [twitter] => 
                    [created] => 2021-03-25 11:57:54
                    [modified] => 2021-07-03 17:13:59
                )

            [BroadcastDay] => Array
                (
                    [id] => 4081
                    [year] => 2021
                    [month] => 10
                    [day] => 25
                    [created] => 2021-10-12 00:00:01
                    [modified] => 2021-10-12 00:00:01
                )

            [BroadcastTime] => Array
                (
                    [broadcast_day_id] => 4081
                    [program_id] => 2626
                    [broadcast_start] => 12:00
                    [broadcast_end] => 15:00
                )

            [Guest] => Array
                (
                    [id] => 7522
                    [event_guest_id] => 6033
                    [flow] => 1
                    [type] => 202
                    [room] => 0
                    [room_etc] => 
                    [name] => 雨のパレード
                    [guest_data] => 
                    [program_id] => 40
                    [user_id] => 4
                    [onair_date] => 2021-10-25
                    [onair_date_multi] => 2021-10-25
                    [onair_time] => 14:00
                    [rec_date] => 
                    [rec_time] => 
                    [visit_time] => 
                    [release] => 
                    [msg] => 
                    [image1] => image161628527a261a.jpg
                    [image2] => 
                    [image3] => 
                    [user_id_created] => 4
                    [user_id_modified] => 4
                    [open_flg] => 1
                    [delete_flg] => 0
                    [created] => 2021-09-30 15:56:27
                    [modified] => 2021-10-10 15:16:54
                    [buf_user_id] => 
                    [buf_user_id_created] => 
                    [buf_user_id_modified] => 
                    [buf_program_id] => 
                )

            [sort] => 2021-10-2512:0015:00
        )

    [6_0] => Array
        (
            [GuestEvent] => Array
                (
                    [id] => 6059
                    [kind] => guest
                    [event_date] => 2021-10-25
                    [article_title] => 森大翔（電話インタビュー）
                    [description] => 放送日:10/25(月) 
    番組:Kiss Music Presenter
                    [text] => 
                    [artist_info] => 
                    [url] => 
                    [image0] => image1615d41146b7b8.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-18 12:00:00
                    [release_end] => 
                    [period_flg] => 0
                    [modified] => 2021-10-18 12:16:24
                    [created] => 2021-10-06 12:55:19
                    [program_id] => 3
                    [guest_name] => 森大翔（電話インタビュー）
                    [image] => Array
                        (
                            [0] => /kiss_editor/img/guest/7500-7599/7546/image1615d41146b7b8_resize.jpg
                            [1] => 
                            [2] => 
                        )

                    [event_date_array] => Array
                        (
                            [0] => Array
                                (
                                    [y] => 2021
                                    [m] => 10
                                    [d] => 25
                                    [day] => Mon
                                    [holiday] => 
                                )

                        )

                )

            [Program] => Array
                (
                    [id] => 3
                    [program_id] => 0
                    [name] => Kiss Music Presenter
                    [same_information] => Kiss Music Presenter
                    [catch_copy] => 
                    [notice] => 15時から4時間にわたり、Kiss FM KOBE本社スタジオから生放送でお送りするプログラム。リクエストを始め、「今聴きたい！」選曲を藤原岬、ターザン山下の軽快なトークと共にオンエアー！また、旬のアーティストが登場するゲストコーナーも要チェック★ゲストやサウンドクルーへのメッセージももちろんいつでも受け付けています。最新トレンド情報も満載でお送りする必聴・必須のKiss FM看板番組♪


    @kmpdayo
    
                    [tp_title] => 最新トレンド情報も満載!
必聴・必須のKiss FM看板番組♪
                    [tp_description] => 15:00～ON AIR
サウンドクルーは
藤原岬！(月・火)
ターザン山下！(水・木)
ゲストやサウンドクルーへのメッセージももちろんいつでも受け付けています。
                    [tp_disp_mon] => 1
                    [tp_disp_tue] => 1
                    [tp_disp_wed] => 1
                    [tp_disp_thu] => 1
                    [tp_disp_fri] => 0
                    [tp_disp_sat] => 0
                    [tp_disp_sun] => 0
                    [url] => http://www.kiss-fm.co.jp/program_blog/presenter/
                    [mobile_url] => http://www.kiss-fm.co.jp/program_blog/presenter/
                    [corner] => 0
                    [request_mail] => k_m_presen_ter@kiss-fm.co.jp
                    [mail_type] => 1
                    [soundcrew] => 
                    [sort] => 3
                    [program_info] => 1
                    [radio_station] => 1
                    [present_flg] => 1
                    [release_start] => 2000-01-01
                    [release_end] => 2030-01-01
                    [radiko_contents1] =>  
                    [radiko_contents2] => 
                    [message_flg] => 0
                    [thumbnail] => 
                    [twitter] => 
                    [created] => 0000-00-00 00:00:00
                    [modified] => 2021-07-03 17:13:59
                )

            [BroadcastDay] => Array
                (
                    [id] => 4081
                    [year] => 2021
                    [month] => 10
                    [day] => 25
                    [created] => 2021-10-12 00:00:01
                    [modified] => 2021-10-12 00:00:01
                )

            [BroadcastTime] => Array
                (
                    [broadcast_day_id] => 4081
                    [program_id] => 3
                    [broadcast_start] => 15:00
                    [broadcast_end] => 18:50
                )

            [Guest] => Array
                (
                    [id] => 7546
                    [event_guest_id] => 6059
                    [flow] => 1
                    [type] => 102
                    [room] => 0
                    [room_etc] => 
                    [name] => 森大翔（電話インタビュー）
                    [guest_data] => 
                    [program_id] => 22
                    [user_id] => 
                    [onair_date] => 2021-10-25
                    [onair_date_multi] => 2021-10-25
                    [onair_time] => 18:00
                    [rec_date] => 
                    [rec_time] => 
                    [visit_time] => 
                    [release] => 
                    [msg] => 
                    [image1] => image1615d41146b7b8.jpg
                    [image2] => 
                    [image3] => 
                    [user_id_created] => 2
                    [user_id_modified] => 2
                    [open_flg] => 1
                    [delete_flg] => 0
                    [created] => 2021-10-06 12:55:19
                    [modified] => 2021-10-18 12:16:23
                    [buf_user_id] => 
                    [buf_user_id_created] => 
                    [buf_user_id_modified] => 
                    [buf_program_id] => 
                )

            [sort] => 2021-10-2515:0015:00
        )

    [7_0] => Array
        (
            [GuestEvent] => Array
                (
                    [id] => 6078
                    [kind] => guest
                    [event_date] => 2021-10-25
                    [article_title] => Analogfish（コメントオンエア）
                    [description] => 放送日:10/25(月) 
    番組:Kiss Music Presenter
                    [text] => 
                    [artist_info] => 
                    [url] => 
                    [image0] => image1616e1dbc9be7a.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-18 00:00:00
                    [release_end] => 
                    [period_flg] => 0
                    [modified] => 2021-10-19 10:22:54
                    [created] => 2021-10-12 18:08:07
                    [program_id] => 3
                    [guest_name] => Analogfish（コメントオンエア）
                    [image] => Array
                        (
                            [0] => /kiss_editor/img/guest/7500-7599/7565/image1616e1dbc9be7a_resize.jpg
                            [1] => 
                            [2] => 
                        )

                    [event_date_array] => Array
                        (
                            [0] => Array
                                (
                                    [y] => 2021
                                    [m] => 10
                                    [d] => 25
                                    [day] => Mon
                                    [holiday] => 
                                )

                        )

                )

            [Program] => Array
                (
                    [id] => 3
                    [program_id] => 0
                    [name] => Kiss Music Presenter
                    [same_information] => Kiss Music Presenter
                    [catch_copy] => 
                    [notice] => 15時から4時間にわたり、Kiss FM KOBE本社スタジオから生放送でお送りするプログラム。リクエストを始め、「今聴きたい！」選曲を藤原岬、ターザン山下の軽快なトークと共にオンエアー！また、旬のアーティストが登場するゲストコーナーも要チェック★ゲストやサウンドクルーへのメッセージももちろんいつでも受け付けています。最新トレンド情報も満載でお送りする必聴・必須のKiss FM看板番組♪


    @kmpdayo
    
                    [tp_title] => 最新トレンド情報も満載!
必聴・必須のKiss FM看板番組♪
                    [tp_description] => 15:00～ON AIR
サウンドクルーは
藤原岬！(月・火)
ターザン山下！(水・木)
ゲストやサウンドクルーへのメッセージももちろんいつでも受け付けています。
                    [tp_disp_mon] => 1
                    [tp_disp_tue] => 1
                    [tp_disp_wed] => 1
                    [tp_disp_thu] => 1
                    [tp_disp_fri] => 0
                    [tp_disp_sat] => 0
                    [tp_disp_sun] => 0
                    [url] => http://www.kiss-fm.co.jp/program_blog/presenter/
                    [mobile_url] => http://www.kiss-fm.co.jp/program_blog/presenter/
                    [corner] => 0
                    [request_mail] => k_m_presen_ter@kiss-fm.co.jp
                    [mail_type] => 1
                    [soundcrew] => 
                    [sort] => 3
                    [program_info] => 1
                    [radio_station] => 1
                    [present_flg] => 1
                    [release_start] => 2000-01-01
                    [release_end] => 2030-01-01
                    [radiko_contents1] =>  
                    [radiko_contents2] => 
                    [message_flg] => 0
                    [thumbnail] => 
                    [twitter] => 
                    [created] => 0000-00-00 00:00:00
                    [modified] => 2021-07-03 17:13:59
                )

            [BroadcastDay] => Array
                (
                    [id] => 4081
                    [year] => 2021
                    [month] => 10
                    [day] => 25
                    [created] => 2021-10-12 00:00:01
                    [modified] => 2021-10-12 00:00:01
                )

            [BroadcastTime] => Array
                (
                    [broadcast_day_id] => 4081
                    [program_id] => 3
                    [broadcast_start] => 15:00
                    [broadcast_end] => 18:50
                )

            [Guest] => Array
                (
                    [id] => 7565
                    [event_guest_id] => 6078
                    [flow] => 1
                    [type] => 202
                    [room] => 0
                    [room_etc] => 
                    [name] => Analogfish（コメントオンエア）
                    [guest_data] => 
                    [program_id] => 21
                    [user_id] => 
                    [onair_date] => 2021-10-25
                    [onair_date_multi] => 2021-10-25
                    [onair_time] => 
                    [rec_date] => 
                    [rec_time] => 
                    [visit_time] => 
                    [release] => 
                    [msg] => 
                    [image1] => image1616e1dbc9be7a.jpg
                    [image2] => 
                    [image3] => 
                    [user_id_created] => 2
                    [user_id_modified] => 2
                    [open_flg] => 1
                    [delete_flg] => 0
                    [created] => 2021-10-12 18:08:07
                    [modified] => 2021-10-19 10:22:54
                    [buf_user_id] => 
                    [buf_user_id_created] => 
                    [buf_user_id_modified] => 
                    [buf_program_id] => 
                )

            [sort] => 2021-10-2515:0015:00
        )

    [8_0] => Array
        (
            [GuestEvent] => Array
                (
                    [id] => 6030
                    [kind] => guest
                    [event_date] => 2021-10-26
                    [article_title] => ハナフサマユ
                    [description] => 放送日:10/26(火) 
    番組:Kiss Music Presenter
                    [text] => 
                    [artist_info] => 
                    [url] => 
                    [image0] => image1616e1e3f19a45.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-19 00:00:00
                    [release_end] => 
                    [period_flg] => 0
                    [modified] => 2021-10-19 10:24:20
                    [created] => 2021-09-30 13:03:09
                    [program_id] => 3
                    [guest_name] => ハナフサマユ
                    [image] => Array
                        (
                            [0] => /kiss_editor/img/guest/7500-7599/7519/image1616e1e3f19a45_resize.jpg
                            [1] => 
                            [2] => 
                        )

                    [event_date_array] => Array
                        (
                            [0] => Array
                                (
                                    [y] => 2021
                                    [m] => 10
                                    [d] => 26
                                    [day] => Tue
                                    [holiday] => 
                                )

                        )

                )

            [Program] => Array
                (
                    [id] => 3
                    [program_id] => 0
                    [name] => Kiss Music Presenter
                    [same_information] => Kiss Music Presenter
                    [catch_copy] => 
                    [notice] => 15時から4時間にわたり、Kiss FM KOBE本社スタジオから生放送でお送りするプログラム。リクエストを始め、「今聴きたい！」選曲を藤原岬、ターザン山下の軽快なトークと共にオンエアー！また、旬のアーティストが登場するゲストコーナーも要チェック★ゲストやサウンドクルーへのメッセージももちろんいつでも受け付けています。最新トレンド情報も満載でお送りする必聴・必須のKiss FM看板番組♪


    @kmpdayo
    
                    [tp_title] => 最新トレンド情報も満載!
必聴・必須のKiss FM看板番組♪
                    [tp_description] => 15:00～ON AIR
サウンドクルーは
藤原岬！(月・火)
ターザン山下！(水・木)
ゲストやサウンドクルーへのメッセージももちろんいつでも受け付けています。
                    [tp_disp_mon] => 1
                    [tp_disp_tue] => 1
                    [tp_disp_wed] => 1
                    [tp_disp_thu] => 1
                    [tp_disp_fri] => 0
                    [tp_disp_sat] => 0
                    [tp_disp_sun] => 0
                    [url] => http://www.kiss-fm.co.jp/program_blog/presenter/
                    [mobile_url] => http://www.kiss-fm.co.jp/program_blog/presenter/
                    [corner] => 0
                    [request_mail] => k_m_presen_ter@kiss-fm.co.jp
                    [mail_type] => 1
                    [soundcrew] => 
                    [sort] => 3
                    [program_info] => 1
                    [radio_station] => 1
                    [present_flg] => 1
                    [release_start] => 2000-01-01
                    [release_end] => 2030-01-01
                    [radiko_contents1] =>  
                    [radiko_contents2] => 
                    [message_flg] => 0
                    [thumbnail] => 
                    [twitter] => 
                    [created] => 0000-00-00 00:00:00
                    [modified] => 2021-07-03 17:13:59
                )

            [BroadcastDay] => Array
                (
                    [id] => 4082
                    [year] => 2021
                    [month] => 10
                    [day] => 26
                    [created] => 2021-10-13 00:00:01
                    [modified] => 2021-10-13 00:00:01
                )

            [BroadcastTime] => Array
                (
                    [broadcast_day_id] => 4082
                    [program_id] => 3
                    [broadcast_start] => 15:00
                    [broadcast_end] => 18:50
                )

            [Guest] => Array
                (
                    [id] => 7519
                    [event_guest_id] => 6030
                    [flow] => 1
                    [type] => 101
                    [room] => 0
                    [room_etc] => 
                    [name] => ハナフサマユ
                    [guest_data] => 
                    [program_id] => 21
                    [user_id] => 
                    [onair_date] => 2021-10-26
                    [onair_date_multi] => 2021-10-26
                    [onair_time] => 15:00
                    [rec_date] => 
                    [rec_time] => 
                    [visit_time] => 
                    [release] => 
                    [msg] => 生演奏あり
                    [image1] => image1616e1e3f19a45.jpg
                    [image2] => 
                    [image3] => 
                    [user_id_created] => 2
                    [user_id_modified] => 2
                    [open_flg] => 1
                    [delete_flg] => 0
                    [created] => 2021-09-30 13:03:09
                    [modified] => 2021-10-19 10:24:20
                    [buf_user_id] => 
                    [buf_user_id_created] => 
                    [buf_user_id_modified] => 
                    [buf_program_id] => 
                )

            [sort] => 2021-10-2615:0015:00
        )

)

  • 2021.10.21 - Thu

  • 2021.10.22 - Fri

  • 2021.10.25 - Mon

  • 2021.10.26 - Tue

(default) 22 queries took 417 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:49:16' AND ((`GuestEvent`.`release_end` >= '2021-10-21 14:49:16') 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:49'))) 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 111397
3SELECT `ProgramPresent`.`id` FROM `program_presents` AS `ProgramPresent` WHERE `ProgramPresent`.`program_id` = 2626 AND `ProgramPresent`.`release_start` <= '2021-10-21 09:49:16' AND `ProgramPresent`.`release_end` >= '2021-10-21 09:49:16' 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:49' ORDER BY LPAD(`BroadcastTime`.`broadcast_start`, 5, '0') DESC LIMIT 1110
5SELECT `GuestEvent`.*, `Program`.*, `BroadcastDay`.* FROM `guest_events` AS `GuestEvent` LEFT JOIN programs AS `Program` ON (`Program`.`id` = `GuestEvent`.`program_id`) LEFT JOIN broadcast_days AS `BroadcastDay` ON (`BroadcastDay`.`year` = DATE_FORMAT(RIGHT(`GuestEvent`.`event_date`,10), '%Y') AND `BroadcastDay`.`month` = DATE_FORMAT(RIGHT(`GuestEvent`.`event_date`,10), '%c') AND `BroadcastDay`.`day` = DATE_FORMAT(RIGHT(`GuestEvent`.`event_date`,10), '%e')) WHERE `GuestEvent`.`kind` = 'guest' AND `GuestEvent`.`visible_flg_id` = 1 AND `GuestEvent`.`release_start` <= '2021-10-21 14:49:16' AND RIGHT(`GuestEvent`.`event_date`, 10) >= '2021-10-21' AND ((`GuestEvent`.`release_end` >= '2021-10-21 14:49:16') OR (`GuestEvent`.`release_end` IS NULL)) ORDER BY LEFT(`GuestEvent`.`event_date`, 10) ASC, `Program`.`sort` ASC, `GuestEvent`.`sort_number` DESC, `GuestEvent`.`release_start` DESC 995
6SELECT `BroadcastTime`.`id`, `BroadcastTime`.`program_id`, `BroadcastTime`.`broadcast_day_id`, `BroadcastTime`.`sponsor`, `BroadcastTime`.`broadcast_start`, `BroadcastTime`.`broadcast_end`, `BroadcastTime`.`created`, `BroadcastTime`.`modified` FROM `broadcast_times` AS `BroadcastTime` WHERE `BroadcastTime`.`broadcast_day_id` = 4077 AND `BroadcastTime`.`program_id` = 414 110
7SELECT `BroadcastTime`.`id`, `BroadcastTime`.`program_id`, `BroadcastTime`.`broadcast_day_id`, `BroadcastTime`.`sponsor`, `BroadcastTime`.`broadcast_start`, `BroadcastTime`.`broadcast_end`, `BroadcastTime`.`created`, `BroadcastTime`.`modified` FROM `broadcast_times` AS `BroadcastTime` WHERE `BroadcastTime`.`broadcast_day_id` = 4077 AND `BroadcastTime`.`program_id` = 2626 221
8SELECT `BroadcastTime`.`id`, `BroadcastTime`.`program_id`, `BroadcastTime`.`broadcast_day_id`, `BroadcastTime`.`sponsor`, `BroadcastTime`.`broadcast_start`, `BroadcastTime`.`broadcast_end`, `BroadcastTime`.`created`, `BroadcastTime`.`modified` FROM `broadcast_times` AS `BroadcastTime` WHERE `BroadcastTime`.`broadcast_day_id` = 4077 AND `BroadcastTime`.`program_id` = 3 110
9SELECT `BroadcastTime`.`id`, `BroadcastTime`.`program_id`, `BroadcastTime`.`broadcast_day_id`, `BroadcastTime`.`sponsor`, `BroadcastTime`.`broadcast_start`, `BroadcastTime`.`broadcast_end`, `BroadcastTime`.`created`, `BroadcastTime`.`modified` FROM `broadcast_times` AS `BroadcastTime` WHERE `BroadcastTime`.`broadcast_day_id` = 4078 AND `BroadcastTime`.`program_id` = 2499 110
10SELECT `BroadcastTime`.`id`, `BroadcastTime`.`program_id`, `BroadcastTime`.`broadcast_day_id`, `BroadcastTime`.`sponsor`, `BroadcastTime`.`broadcast_start`, `BroadcastTime`.`broadcast_end`, `BroadcastTime`.`created`, `BroadcastTime`.`modified` FROM `broadcast_times` AS `BroadcastTime` WHERE `BroadcastTime`.`broadcast_day_id` = 4078 AND `BroadcastTime`.`program_id` = 2499 110
11SELECT `BroadcastTime`.`id`, `BroadcastTime`.`program_id`, `BroadcastTime`.`broadcast_day_id`, `BroadcastTime`.`sponsor`, `BroadcastTime`.`broadcast_start`, `BroadcastTime`.`broadcast_end`, `BroadcastTime`.`created`, `BroadcastTime`.`modified` FROM `broadcast_times` AS `BroadcastTime` WHERE `BroadcastTime`.`broadcast_day_id` = 4081 AND `BroadcastTime`.`program_id` = 2626 221
12SELECT `BroadcastTime`.`id`, `BroadcastTime`.`program_id`, `BroadcastTime`.`broadcast_day_id`, `BroadcastTime`.`sponsor`, `BroadcastTime`.`broadcast_start`, `BroadcastTime`.`broadcast_end`, `BroadcastTime`.`created`, `BroadcastTime`.`modified` FROM `broadcast_times` AS `BroadcastTime` WHERE `BroadcastTime`.`broadcast_day_id` = 4081 AND `BroadcastTime`.`program_id` = 3 110
13SELECT `BroadcastTime`.`id`, `BroadcastTime`.`program_id`, `BroadcastTime`.`broadcast_day_id`, `BroadcastTime`.`sponsor`, `BroadcastTime`.`broadcast_start`, `BroadcastTime`.`broadcast_end`, `BroadcastTime`.`created`, `BroadcastTime`.`modified` FROM `broadcast_times` AS `BroadcastTime` WHERE `BroadcastTime`.`broadcast_day_id` = 4081 AND `BroadcastTime`.`program_id` = 3 110
14SELECT `BroadcastTime`.`id`, `BroadcastTime`.`program_id`, `BroadcastTime`.`broadcast_day_id`, `BroadcastTime`.`sponsor`, `BroadcastTime`.`broadcast_start`, `BroadcastTime`.`broadcast_end`, `BroadcastTime`.`created`, `BroadcastTime`.`modified` FROM `broadcast_times` AS `BroadcastTime` WHERE `BroadcastTime`.`broadcast_day_id` = 4082 AND `BroadcastTime`.`program_id` = 3 110
15SELECT `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-10-21 14:49:16' AND `release_end` >= '2021-10-21 14:49:16' ORDER BY `Banner`.`sort_number` asc, `Banner`.`created` desc 991
16SELECT `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-10-21 14:49:16' AND `release_end` >= '2021-10-21 14:49:16' ORDER BY `Banner`.`sort_number` asc, `Banner`.`created` desc 331
17SELECT `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-10-21 14:49:16' AND `release_end` >= '2021-10-21 14:49:16' ORDER BY `Banner`.`sort_number` asc, `Banner`.`created` desc 20201
18SELECT `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-10-21 14:49:16' AND `release_end` >= '2021-10-21 14:49:16' ORDER BY `Banner`.`sort_number` asc, `Banner`.`created` desc 001
19SELECT `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-10-21 14:49:16' AND `release_end` >= '2021-10-21 14:49:16' ORDER BY `Banner`.`sort_number` asc, `Banner`.`created` desc 001
20SELECT `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-10-21 14:49:16' AND `end_datetime` >= '2021-10-21 14:49:16' ORDER BY `Present`.`sort_number` ASC 443
21SELECT `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
22SELECT `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 42425
(reg_db) 18 queries took 139 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT `Guest`.`id`, `Guest`.`event_guest_id`, `Guest`.`flow`, `Guest`.`type`, `Guest`.`room`, `Guest`.`room_etc`, `Guest`.`name`, `Guest`.`guest_data`, `Guest`.`program_id`, `Guest`.`user_id`, `Guest`.`onair_date`, `Guest`.`onair_date_multi`, `Guest`.`onair_time`, `Guest`.`rec_date`, `Guest`.`rec_time`, `Guest`.`visit_time`, `Guest`.`release`, `Guest`.`msg`, `Guest`.`image1`, `Guest`.`image2`, `Guest`.`image3`, `Guest`.`user_id_created`, `Guest`.`user_id_modified`, `Guest`.`open_flg`, `Guest`.`delete_flg`, `Guest`.`created`, `Guest`.`modified`, `Guest`.`buf_user_id`, `Guest`.`buf_user_id_created`, `Guest`.`buf_user_id_modified`, `Guest`.`buf_program_id` FROM `guests` AS `Guest` WHERE `Guest`.`event_guest_id` = 6026 LIMIT 1110
2SELECT `Guest`.`id`, `Guest`.`event_guest_id`, `Guest`.`flow`, `Guest`.`type`, `Guest`.`room`, `Guest`.`room_etc`, `Guest`.`name`, `Guest`.`guest_data`, `Guest`.`program_id`, `Guest`.`user_id`, `Guest`.`onair_date`, `Guest`.`onair_date_multi`, `Guest`.`onair_time`, `Guest`.`rec_date`, `Guest`.`rec_time`, `Guest`.`visit_time`, `Guest`.`release`, `Guest`.`msg`, `Guest`.`image1`, `Guest`.`image2`, `Guest`.`image3`, `Guest`.`user_id_created`, `Guest`.`user_id_modified`, `Guest`.`open_flg`, `Guest`.`delete_flg`, `Guest`.`created`, `Guest`.`modified`, `Guest`.`buf_user_id`, `Guest`.`buf_user_id_created`, `Guest`.`buf_user_id_modified`, `Guest`.`buf_program_id` FROM `guests` AS `Guest` WHERE `Guest`.`event_guest_id` = 6018 LIMIT 1110
3SELECT `Guest`.`id`, `Guest`.`event_guest_id`, `Guest`.`flow`, `Guest`.`type`, `Guest`.`room`, `Guest`.`room_etc`, `Guest`.`name`, `Guest`.`guest_data`, `Guest`.`program_id`, `Guest`.`user_id`, `Guest`.`onair_date`, `Guest`.`onair_date_multi`, `Guest`.`onair_time`, `Guest`.`rec_date`, `Guest`.`rec_time`, `Guest`.`visit_time`, `Guest`.`release`, `Guest`.`msg`, `Guest`.`image1`, `Guest`.`image2`, `Guest`.`image3`, `Guest`.`user_id_created`, `Guest`.`user_id_modified`, `Guest`.`open_flg`, `Guest`.`delete_flg`, `Guest`.`created`, `Guest`.`modified`, `Guest`.`buf_user_id`, `Guest`.`buf_user_id_created`, `Guest`.`buf_user_id_modified`, `Guest`.`buf_program_id` FROM `guests` AS `Guest` WHERE `Guest`.`event_guest_id` = 6074 LIMIT 1110
4SELECT `Guest`.`id`, `Guest`.`event_guest_id`, `Guest`.`flow`, `Guest`.`type`, `Guest`.`room`, `Guest`.`room_etc`, `Guest`.`name`, `Guest`.`guest_data`, `Guest`.`program_id`, `Guest`.`user_id`, `Guest`.`onair_date`, `Guest`.`onair_date_multi`, `Guest`.`onair_time`, `Guest`.`rec_date`, `Guest`.`rec_time`, `Guest`.`visit_time`, `Guest`.`release`, `Guest`.`msg`, `Guest`.`image1`, `Guest`.`image2`, `Guest`.`image3`, `Guest`.`user_id_created`, `Guest`.`user_id_modified`, `Guest`.`open_flg`, `Guest`.`delete_flg`, `Guest`.`created`, `Guest`.`modified`, `Guest`.`buf_user_id`, `Guest`.`buf_user_id_created`, `Guest`.`buf_user_id_modified`, `Guest`.`buf_program_id` FROM `guests` AS `Guest` WHERE `Guest`.`event_guest_id` = 6081 LIMIT 1111
5SELECT `Guest`.`id`, `Guest`.`event_guest_id`, `Guest`.`flow`, `Guest`.`type`, `Guest`.`room`, `Guest`.`room_etc`, `Guest`.`name`, `Guest`.`guest_data`, `Guest`.`program_id`, `Guest`.`user_id`, `Guest`.`onair_date`, `Guest`.`onair_date_multi`, `Guest`.`onair_time`, `Guest`.`rec_date`, `Guest`.`rec_time`, `Guest`.`visit_time`, `Guest`.`release`, `Guest`.`msg`, `Guest`.`image1`, `Guest`.`image2`, `Guest`.`image3`, `Guest`.`user_id_created`, `Guest`.`user_id_modified`, `Guest`.`open_flg`, `Guest`.`delete_flg`, `Guest`.`created`, `Guest`.`modified`, `Guest`.`buf_user_id`, `Guest`.`buf_user_id_created`, `Guest`.`buf_user_id_modified`, `Guest`.`buf_program_id` FROM `guests` AS `Guest` WHERE `Guest`.`event_guest_id` = 6087 LIMIT 1110
6SELECT `Guest`.`id`, `Guest`.`event_guest_id`, `Guest`.`flow`, `Guest`.`type`, `Guest`.`room`, `Guest`.`room_etc`, `Guest`.`name`, `Guest`.`guest_data`, `Guest`.`program_id`, `Guest`.`user_id`, `Guest`.`onair_date`, `Guest`.`onair_date_multi`, `Guest`.`onair_time`, `Guest`.`rec_date`, `Guest`.`rec_time`, `Guest`.`visit_time`, `Guest`.`release`, `Guest`.`msg`, `Guest`.`image1`, `Guest`.`image2`, `Guest`.`image3`, `Guest`.`user_id_created`, `Guest`.`user_id_modified`, `Guest`.`open_flg`, `Guest`.`delete_flg`, `Guest`.`created`, `Guest`.`modified`, `Guest`.`buf_user_id`, `Guest`.`buf_user_id_created`, `Guest`.`buf_user_id_modified`, `Guest`.`buf_program_id` FROM `guests` AS `Guest` WHERE `Guest`.`event_guest_id` = 6033 LIMIT 1113
7SELECT `Guest`.`id`, `Guest`.`event_guest_id`, `Guest`.`flow`, `Guest`.`type`, `Guest`.`room`, `Guest`.`room_etc`, `Guest`.`name`, `Guest`.`guest_data`, `Guest`.`program_id`, `Guest`.`user_id`, `Guest`.`onair_date`, `Guest`.`onair_date_multi`, `Guest`.`onair_time`, `Guest`.`rec_date`, `Guest`.`rec_time`, `Guest`.`visit_time`, `Guest`.`release`, `Guest`.`msg`, `Guest`.`image1`, `Guest`.`image2`, `Guest`.`image3`, `Guest`.`user_id_created`, `Guest`.`user_id_modified`, `Guest`.`open_flg`, `Guest`.`delete_flg`, `Guest`.`created`, `Guest`.`modified`, `Guest`.`buf_user_id`, `Guest`.`buf_user_id_created`, `Guest`.`buf_user_id_modified`, `Guest`.`buf_program_id` FROM `guests` AS `Guest` WHERE `Guest`.`event_guest_id` = 6059 LIMIT 1110
8SELECT `Guest`.`id`, `Guest`.`event_guest_id`, `Guest`.`flow`, `Guest`.`type`, `Guest`.`room`, `Guest`.`room_etc`, `Guest`.`name`, `Guest`.`guest_data`, `Guest`.`program_id`, `Guest`.`user_id`, `Guest`.`onair_date`, `Guest`.`onair_date_multi`, `Guest`.`onair_time`, `Guest`.`rec_date`, `Guest`.`rec_time`, `Guest`.`visit_time`, `Guest`.`release`, `Guest`.`msg`, `Guest`.`image1`, `Guest`.`image2`, `Guest`.`image3`, `Guest`.`user_id_created`, `Guest`.`user_id_modified`, `Guest`.`open_flg`, `Guest`.`delete_flg`, `Guest`.`created`, `Guest`.`modified`, `Guest`.`buf_user_id`, `Guest`.`buf_user_id_created`, `Guest`.`buf_user_id_modified`, `Guest`.`buf_program_id` FROM `guests` AS `Guest` WHERE `Guest`.`event_guest_id` = 6078 LIMIT 1111
9SELECT `Guest`.`id`, `Guest`.`event_guest_id`, `Guest`.`flow`, `Guest`.`type`, `Guest`.`room`, `Guest`.`room_etc`, `Guest`.`name`, `Guest`.`guest_data`, `Guest`.`program_id`, `Guest`.`user_id`, `Guest`.`onair_date`, `Guest`.`onair_date_multi`, `Guest`.`onair_time`, `Guest`.`rec_date`, `Guest`.`rec_time`, `Guest`.`visit_time`, `Guest`.`release`, `Guest`.`msg`, `Guest`.`image1`, `Guest`.`image2`, `Guest`.`image3`, `Guest`.`user_id_created`, `Guest`.`user_id_modified`, `Guest`.`open_flg`, `Guest`.`delete_flg`, `Guest`.`created`, `Guest`.`modified`, `Guest`.`buf_user_id`, `Guest`.`buf_user_id_created`, `Guest`.`buf_user_id_modified`, `Guest`.`buf_program_id` FROM `guests` AS `Guest` WHERE `Guest`.`event_guest_id` = 6030 LIMIT 1113
10SELECT `Guest`.`id`, `Guest`.`event_guest_id`, `Guest`.`flow`, `Guest`.`type`, `Guest`.`room`, `Guest`.`room_etc`, `Guest`.`name`, `Guest`.`guest_data`, `Guest`.`program_id`, `Guest`.`user_id`, `Guest`.`onair_date`, `Guest`.`onair_date_multi`, `Guest`.`onair_time`, `Guest`.`rec_date`, `Guest`.`rec_time`, `Guest`.`visit_time`, `Guest`.`release`, `Guest`.`msg`, `Guest`.`image1`, `Guest`.`image2`, `Guest`.`image3`, `Guest`.`user_id_created`, `Guest`.`user_id_modified`, `Guest`.`open_flg`, `Guest`.`delete_flg`, `Guest`.`created`, `Guest`.`modified`, `Guest`.`buf_user_id`, `Guest`.`buf_user_id_created`, `Guest`.`buf_user_id_modified`, `Guest`.`buf_program_id` FROM `guests` AS `Guest` WHERE `Guest`.`event_guest_id` = (6026) 1111
11SELECT `Guest`.`id`, `Guest`.`event_guest_id`, `Guest`.`flow`, `Guest`.`type`, `Guest`.`room`, `Guest`.`room_etc`, `Guest`.`name`, `Guest`.`guest_data`, `Guest`.`program_id`, `Guest`.`user_id`, `Guest`.`onair_date`, `Guest`.`onair_date_multi`, `Guest`.`onair_time`, `Guest`.`rec_date`, `Guest`.`rec_time`, `Guest`.`visit_time`, `Guest`.`release`, `Guest`.`msg`, `Guest`.`image1`, `Guest`.`image2`, `Guest`.`image3`, `Guest`.`user_id_created`, `Guest`.`user_id_modified`, `Guest`.`open_flg`, `Guest`.`delete_flg`, `Guest`.`created`, `Guest`.`modified`, `Guest`.`buf_user_id`, `Guest`.`buf_user_id_created`, `Guest`.`buf_user_id_modified`, `Guest`.`buf_program_id` FROM `guests` AS `Guest` WHERE `Guest`.`event_guest_id` IN (6026, 6018) 2212
12SELECT `Guest`.`id`, `Guest`.`event_guest_id`, `Guest`.`flow`, `Guest`.`type`, `Guest`.`room`, `Guest`.`room_etc`, `Guest`.`name`, `Guest`.`guest_data`, `Guest`.`program_id`, `Guest`.`user_id`, `Guest`.`onair_date`, `Guest`.`onair_date_multi`, `Guest`.`onair_time`, `Guest`.`rec_date`, `Guest`.`rec_time`, `Guest`.`visit_time`, `Guest`.`release`, `Guest`.`msg`, `Guest`.`image1`, `Guest`.`image2`, `Guest`.`image3`, `Guest`.`user_id_created`, `Guest`.`user_id_modified`, `Guest`.`open_flg`, `Guest`.`delete_flg`, `Guest`.`created`, `Guest`.`modified`, `Guest`.`buf_user_id`, `Guest`.`buf_user_id_created`, `Guest`.`buf_user_id_modified`, `Guest`.`buf_program_id` FROM `guests` AS `Guest` WHERE `Guest`.`event_guest_id` IN (6026, 6018, 6074) 3310
13SELECT `Guest`.`id`, `Guest`.`event_guest_id`, `Guest`.`flow`, `Guest`.`type`, `Guest`.`room`, `Guest`.`room_etc`, `Guest`.`name`, `Guest`.`guest_data`, `Guest`.`program_id`, `Guest`.`user_id`, `Guest`.`onair_date`, `Guest`.`onair_date_multi`, `Guest`.`onair_time`, `Guest`.`rec_date`, `Guest`.`rec_time`, `Guest`.`visit_time`, `Guest`.`release`, `Guest`.`msg`, `Guest`.`image1`, `Guest`.`image2`, `Guest`.`image3`, `Guest`.`user_id_created`, `Guest`.`user_id_modified`, `Guest`.`open_flg`, `Guest`.`delete_flg`, `Guest`.`created`, `Guest`.`modified`, `Guest`.`buf_user_id`, `Guest`.`buf_user_id_created`, `Guest`.`buf_user_id_modified`, `Guest`.`buf_program_id` FROM `guests` AS `Guest` WHERE `Guest`.`event_guest_id` IN (6026, 6018, 6074, 6087) 4411
14SELECT `Guest`.`id`, `Guest`.`event_guest_id`, `Guest`.`flow`, `Guest`.`type`, `Guest`.`room`, `Guest`.`room_etc`, `Guest`.`name`, `Guest`.`guest_data`, `Guest`.`program_id`, `Guest`.`user_id`, `Guest`.`onair_date`, `Guest`.`onair_date_multi`, `Guest`.`onair_time`, `Guest`.`rec_date`, `Guest`.`rec_time`, `Guest`.`visit_time`, `Guest`.`release`, `Guest`.`msg`, `Guest`.`image1`, `Guest`.`image2`, `Guest`.`image3`, `Guest`.`user_id_created`, `Guest`.`user_id_modified`, `Guest`.`open_flg`, `Guest`.`delete_flg`, `Guest`.`created`, `Guest`.`modified`, `Guest`.`buf_user_id`, `Guest`.`buf_user_id_created`, `Guest`.`buf_user_id_modified`, `Guest`.`buf_program_id` FROM `guests` AS `Guest` WHERE `Guest`.`event_guest_id` IN (6026, 6018, 6074, 6087, 6081) 5525
15SELECT `Guest`.`id`, `Guest`.`event_guest_id`, `Guest`.`flow`, `Guest`.`type`, `Guest`.`room`, `Guest`.`room_etc`, `Guest`.`name`, `Guest`.`guest_data`, `Guest`.`program_id`, `Guest`.`user_id`, `Guest`.`onair_date`, `Guest`.`onair_date_multi`, `Guest`.`onair_time`, `Guest`.`rec_date`, `Guest`.`rec_time`, `Guest`.`visit_time`, `Guest`.`release`, `Guest`.`msg`, `Guest`.`image1`, `Guest`.`image2`, `Guest`.`image3`, `Guest`.`user_id_created`, `Guest`.`user_id_modified`, `Guest`.`open_flg`, `Guest`.`delete_flg`, `Guest`.`created`, `Guest`.`modified`, `Guest`.`buf_user_id`, `Guest`.`buf_user_id_created`, `Guest`.`buf_user_id_modified`, `Guest`.`buf_program_id` FROM `guests` AS `Guest` WHERE `Guest`.`event_guest_id` IN (6026, 6018, 6074, 6087, 6081, 6033) 6617
16SELECT `Guest`.`id`, `Guest`.`event_guest_id`, `Guest`.`flow`, `Guest`.`type`, `Guest`.`room`, `Guest`.`room_etc`, `Guest`.`name`, `Guest`.`guest_data`, `Guest`.`program_id`, `Guest`.`user_id`, `Guest`.`onair_date`, `Guest`.`onair_date_multi`, `Guest`.`onair_time`, `Guest`.`rec_date`, `Guest`.`rec_time`, `Guest`.`visit_time`, `Guest`.`release`, `Guest`.`msg`, `Guest`.`image1`, `Guest`.`image2`, `Guest`.`image3`, `Guest`.`user_id_created`, `Guest`.`user_id_modified`, `Guest`.`open_flg`, `Guest`.`delete_flg`, `Guest`.`created`, `Guest`.`modified`, `Guest`.`buf_user_id`, `Guest`.`buf_user_id_created`, `Guest`.`buf_user_id_modified`, `Guest`.`buf_program_id` FROM `guests` AS `Guest` WHERE `Guest`.`event_guest_id` IN (6026, 6018, 6074, 6087, 6081, 6033, 6059) 7716
17SELECT `Guest`.`id`, `Guest`.`event_guest_id`, `Guest`.`flow`, `Guest`.`type`, `Guest`.`room`, `Guest`.`room_etc`, `Guest`.`name`, `Guest`.`guest_data`, `Guest`.`program_id`, `Guest`.`user_id`, `Guest`.`onair_date`, `Guest`.`onair_date_multi`, `Guest`.`onair_time`, `Guest`.`rec_date`, `Guest`.`rec_time`, `Guest`.`visit_time`, `Guest`.`release`, `Guest`.`msg`, `Guest`.`image1`, `Guest`.`image2`, `Guest`.`image3`, `Guest`.`user_id_created`, `Guest`.`user_id_modified`, `Guest`.`open_flg`, `Guest`.`delete_flg`, `Guest`.`created`, `Guest`.`modified`, `Guest`.`buf_user_id`, `Guest`.`buf_user_id_created`, `Guest`.`buf_user_id_modified`, `Guest`.`buf_program_id` FROM `guests` AS `Guest` WHERE `Guest`.`event_guest_id` IN (6026, 6018, 6074, 6087, 6081, 6033, 6059, 6078) 8810
18SELECT `Guest`.`id`, `Guest`.`event_guest_id`, `Guest`.`flow`, `Guest`.`type`, `Guest`.`room`, `Guest`.`room_etc`, `Guest`.`name`, `Guest`.`guest_data`, `Guest`.`program_id`, `Guest`.`user_id`, `Guest`.`onair_date`, `Guest`.`onair_date_multi`, `Guest`.`onair_time`, `Guest`.`rec_date`, `Guest`.`rec_time`, `Guest`.`visit_time`, `Guest`.`release`, `Guest`.`msg`, `Guest`.`image1`, `Guest`.`image2`, `Guest`.`image3`, `Guest`.`user_id_created`, `Guest`.`user_id_modified`, `Guest`.`open_flg`, `Guest`.`delete_flg`, `Guest`.`created`, `Guest`.`modified`, `Guest`.`buf_user_id`, `Guest`.`buf_user_id_created`, `Guest`.`buf_user_id_modified`, `Guest`.`buf_program_id` FROM `guests` AS `Guest` WHERE `Guest`.`event_guest_id` IN (6026, 6018, 6074, 6087, 6081, 6033, 6059, 6078, 6030) 9919