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

イベント情報

EVENT

2021.07.11 - SUN

Kiss FM KOBE後援 826aska 20th Anniversary Live Tour “smile”

SHARE

日時:2021年9月25日(土)16:00開演(15:15開場)
会場:加古川市民会館・中ホール  兵庫県加古川市加古川町北在家2000
入場料:全席指定:4,500円(消費税込)

注意事項 
※未就学児入場不可 
※券売は、座席収容率の100%で販売しています。
※声を出しての声援はご遠慮ください。
※マスクの着用をお願いいたします。マスクを着用されない場合、ご退場いただくことがあります。
※公演中での、写真撮影、録音、録画はお断りします。
※終演後のサイン会や撮影会は、行いません。

一般発売日 7月7日(水)

■ジョーカンチケットセンタ  077-535-9001
〔24hWEB購入も可能 http://www.joukan.co.jp/
■加古川市民会館(窓口販売のみ)  079-424-5381
■ローソンチケット/ローソンの「Loppi」にて購入可能 
https://l-tike.com/ (Lコード:53939)

お問い合わせ ジョーカンチケットセンタ 077-535-9001
受付時間 12:00~17:00(土・日・祝は定休)

イベントに応募する

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

(default) 13 queries took 4 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-26 21:53:41' AND ((`GuestEvent`.`release_end` >= '2021-10-26 21:53:41') 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` = 26) AND (LPAD(`BroadcastTime`.`broadcast_end`, 5, '0') > '21:53'))) OR (((`BroadcastDay`.`year` = 2021) AND (`BroadcastDay`.`month` = 10) AND (`BroadcastDay`.`day` = 27)))) ORDER BY `BroadcastDay`.`year` ASC, `BroadcastDay`.`month` ASC, `BroadcastDay`.`day` ASC, LPAD(`BroadcastTime`.`broadcast_start`, 5, '0') ASC LIMIT 1110
3SELECT `ProgramPresent`.`id` FROM `program_presents` AS `ProgramPresent` WHERE `ProgramPresent`.`program_id` = 1954 AND `ProgramPresent`.`release_start` <= '2021-10-26 16:53:41' AND `ProgramPresent`.`release_end` >= '2021-10-26 16:53:41' 000
4SELECT `Program`.*, `BroadcastTime`.* FROM `broadcast_times` AS `BroadcastTime` INNER JOIN programs AS `Program` ON (`Program`.`id` = `BroadcastTime`.`program_id` AND `Program`.`program_id` = '1954' AND `Program`.`corner` = 1) WHERE `BroadcastTime`.`broadcast_day_id` = 4082 AND LPAD(`BroadcastTime`.`broadcast_start`, 5, '0') <= '21:53' ORDER BY LPAD(`BroadcastTime`.`broadcast_start`, 5, '0') DESC LIMIT 1000
5SELECT `GuestEvent`.`id`, `GuestEvent`.`kind`, `GuestEvent`.`event_date`, `GuestEvent`.`article_title`, `GuestEvent`.`description`, `GuestEvent`.`text`, `GuestEvent`.`artist_info`, `GuestEvent`.`url`, `GuestEvent`.`image0`, `GuestEvent`.`image0_caption`, `GuestEvent`.`image1`, `GuestEvent`.`image1_caption`, `GuestEvent`.`image2`, `GuestEvent`.`image2_caption`, `GuestEvent`.`movie_youtube`, `GuestEvent`.`sort_number`, `GuestEvent`.`toppage_disp_flg_id`, `GuestEvent`.`visible_flg_id`, `GuestEvent`.`release_start`, `GuestEvent`.`release_end`, `GuestEvent`.`period_flg`, `GuestEvent`.`modified`, `GuestEvent`.`created`, `GuestEvent`.`program_id`, `GuestEvent`.`guest_name` FROM `guest_events` AS `GuestEvent` WHERE `GuestEvent`.`id` = 5871 AND `GuestEvent`.`kind` = 'event' AND `GuestEvent`.`release_start` <= '2021-10-26 21:53:41' AND `GuestEvent`.`visible_flg_id` = 1 LIMIT 1110
6SELECT `Banner`.`id`, `Banner`.`banner_type`, `Banner`.`word`, `Banner`.`url`, `Banner`.`image`, `Banner`.`image_l`, `Banner`.`popup_flg`, `Banner`.`release_start`, `Banner`.`release_end`, `Banner`.`visible_flg_id`, `Banner`.`sort_number`, `Banner`.`career_flg`, `Banner`.`modified`, `Banner`.`created` FROM `banners` AS `Banner` WHERE `visible_flg_id` = 1 AND `banner_type` = 5 AND `career_flg` = 0 AND `release_start` <= '2021-10-26 21:53:41' AND `release_end` >= '2021-10-26 21:53:41' ORDER BY `Banner`.`sort_number` asc, `Banner`.`created` desc 990
7SELECT `Banner`.`id`, `Banner`.`banner_type`, `Banner`.`word`, `Banner`.`url`, `Banner`.`image`, `Banner`.`image_l`, `Banner`.`popup_flg`, `Banner`.`release_start`, `Banner`.`release_end`, `Banner`.`visible_flg_id`, `Banner`.`sort_number`, `Banner`.`career_flg`, `Banner`.`modified`, `Banner`.`created` FROM `banners` AS `Banner` WHERE `visible_flg_id` = 1 AND `banner_type` = 4 AND `career_flg` = 0 AND `release_start` <= '2021-10-26 21:53:41' AND `release_end` >= '2021-10-26 21:53:41' ORDER BY `Banner`.`sort_number` asc, `Banner`.`created` desc 330
8SELECT `Banner`.`id`, `Banner`.`banner_type`, `Banner`.`word`, `Banner`.`url`, `Banner`.`image`, `Banner`.`image_l`, `Banner`.`popup_flg`, `Banner`.`release_start`, `Banner`.`release_end`, `Banner`.`visible_flg_id`, `Banner`.`sort_number`, `Banner`.`career_flg`, `Banner`.`modified`, `Banner`.`created` FROM `banners` AS `Banner` WHERE `visible_flg_id` = 1 AND `banner_type` = 2 AND `career_flg` = 0 AND `release_start` <= '2021-10-26 21:53:41' AND `release_end` >= '2021-10-26 21:53:41' ORDER BY `Banner`.`sort_number` asc, `Banner`.`created` desc 20200
9SELECT `Banner`.`id`, `Banner`.`banner_type`, `Banner`.`word`, `Banner`.`url`, `Banner`.`image`, `Banner`.`image_l`, `Banner`.`popup_flg`, `Banner`.`release_start`, `Banner`.`release_end`, `Banner`.`visible_flg_id`, `Banner`.`sort_number`, `Banner`.`career_flg`, `Banner`.`modified`, `Banner`.`created` FROM `banners` AS `Banner` WHERE `visible_flg_id` = 1 AND `banner_type` = 3 AND `career_flg` = 0 AND `release_start` <= '2021-10-26 21:53:41' AND `release_end` >= '2021-10-26 21:53:41' ORDER BY `Banner`.`sort_number` asc, `Banner`.`created` desc 000
10SELECT `Banner`.`id`, `Banner`.`banner_type`, `Banner`.`word`, `Banner`.`url`, `Banner`.`image`, `Banner`.`image_l`, `Banner`.`popup_flg`, `Banner`.`release_start`, `Banner`.`release_end`, `Banner`.`visible_flg_id`, `Banner`.`sort_number`, `Banner`.`career_flg`, `Banner`.`modified`, `Banner`.`created` FROM `banners` AS `Banner` WHERE `visible_flg_id` = 1 AND `banner_type` = 1 AND `career_flg` = 0 AND `release_start` <= '2021-10-26 21:53:41' AND `release_end` >= '2021-10-26 21:53:41' ORDER BY `Banner`.`sort_number` asc, `Banner`.`created` desc 000
11SELECT `Present`.`id`, `Present`.`title`, `Present`.`capacity`, `Present`.`description`, `Present`.`text`, `Present`.`override_url`, `Present`.`client_name`, `Present`.`client_url`, `Present`.`img_main1`, `Present`.`img_main2`, `Present`.`img_main3`, `Present`.`img_main4`, `Present`.`img_main5`, `Present`.`img_main6`, `Present`.`img_main7`, `Present`.`img_main8`, `Present`.`img_main9`, `Present`.`img_main10`, `Present`.`img_caption1`, `Present`.`img_caption2`, `Present`.`img_caption3`, `Present`.`img_caption4`, `Present`.`img_caption5`, `Present`.`img_caption6`, `Present`.`img_caption7`, `Present`.`img_caption8`, `Present`.`img_caption9`, `Present`.`img_caption10`, `Present`.`img_thmb`, `Present`.`img_mobile`, `Present`.`start_datetime`, `Present`.`end_datetime`, `Present`.`require_member_flg_id`, `Present`.`popup_id`, `Present`.`visible_flg_id`, `Present`.`sort_number`, `Present`.`status_code`, `Present`.`modified`, `Present`.`created`, `require_member_flg`.`id`, `require_member_flg`.`name`, `visible_flg`.`id`, `visible_flg`.`name` FROM `presents` AS `Present` LEFT JOIN `require_member_flgs` AS `require_member_flg` ON (`Present`.`require_member_flg_id` = `require_member_flg`.`id`) LEFT JOIN `visible_flgs` AS `visible_flg` ON (`Present`.`visible_flg_id` = `visible_flg`.`id`) WHERE `visible_flg_id` = 1 AND `status_code` = 0 AND `start_datetime` <= '2021-10-26 21:53:41' AND `end_datetime` >= '2021-10-26 21:53:41' ORDER BY `Present`.`sort_number` ASC 330
12SELECT `NewsFlashCategoryWhere`.`id`, `NewsFlashCategoryWhere`.`category`, `NewsFlashCategoryWhere`.`gi_category`, `NewsFlashCategoryWhere`.`gi_subcategory`, `NewsFlashCategoryWhere`.`open_flg`, `NewsFlashCategoryWhere`.`sort` FROM `news_flash_category_where` AS `NewsFlashCategoryWhere` WHERE `open_flg` = 1 440
13SELECT `Program`.`id`, `Program`.`name`, `Program`.`same_information`, `Program`.`catch_copy`, `Program`.`notice`, `Program`.`soundcrew`, `Program`.`url`, `Program`.`twitter`, `DefBroadcastTime`.`broadcast_start`, `DefBroadcastTime`.`broadcast_end`, `DefBroadcastTime`.`week`, `Soundcrew`.`id`, `Soundcrew`.`name`, `Soundcrew`.`name_kana` FROM `programs` AS `Program` INNER JOIN def_broadcast_times AS `DefBroadcastTime` ON (`Program`.`id` = `DefBroadcastTime`.`program_id` AND `DefBroadcastTime`.`release_start` <= CURDATE() AND ((`DefBroadcastTime`.`release_end` is null) OR (((`DefBroadcastTime`.`release_end` is not null) AND (`DefBroadcastTime`.`release_end` >= CURDATE()))))) LEFT JOIN def_program_soundcrews AS `DefProgramSoundcrew` ON (`DefBroadcastTime`.`id` = `DefProgramSoundcrew`.`broadcast_time_id`) LEFT JOIN soundcrews AS `Soundcrew` ON (`DefProgramSoundcrew`.`soundcrew_id` = `Soundcrew`.`id` AND `Soundcrew`.`release_start` <= CURDATE() AND ((`Soundcrew`.`release_end` is null) OR (((`Soundcrew`.`release_end` is not null) AND (`Soundcrew`.`release_end` >= CURDATE()))))) WHERE ((`Program`.`corner` = 0) AND (`Program`.`program_info` > 0) AND (`Program`.`radio_station` = 1) AND (`Program`.`release_start` <= CURDATE()) AND (((`Program`.`release_end` is null) OR (((`Program`.`release_end` is not null) AND (`Program`.`release_end` >= CURDATE())))))) ORDER BY `Program`.`sort` ASC, `DefBroadcastTime`.`week` ASC, `Program`.`same_information` ASC, `Program`.`id` ASC 42424