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

Saturday Junction

放送時間
土 11:00~12:55
SOUND CREW
藤原 岬
公式サイト
https://kiss-fm.co.jp/junction/

※ 必須項目

PROGRAM
番組
Saturday Junction
PERSENT TYPE
プレゼント
Saturday Junctionステッカー
RADIO NAME
ラジオネーム
番組内で読まれる名前です
REQUEST
リクエストアーティスト
リクエスト曲
MESSAGE
メッセージ
GENDER
性別
AGE
年齢
半角数字
NAME
カナ
漢字
ADDRESS
郵便番号

半角数字
都道府県
市区町村
それ以降
TELEPHONE
電話番号
OCCUPATION
ご職業
LISTENING METHOD
主にどこで聴いていますか?
主にどの方法で聴いてますか?
(default) 16 queries took 1340 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-12-04 20:29:19' AND ((`GuestEvent`.`release_end` >= '2021-12-04 20:29:19') OR (`GuestEvent`.`release_end` IS NULL)) GROUP BY `GuestEvent`.`program_id`, `GuestEvent`.`event_date` ORDER BY `GuestEvent`.`sort_number` ASC ) AS `subGuestEvent` ON (`subGuestEvent`.`program_id` = `Program`.`id` AND `subGuestEvent`.`event_date` Like CONCAT('%', date_format(CONCAT(`BroadcastDay`.`year`,'-',`BroadcastDay`.`month`,'-',`BroadcastDay`.`day`), '%Y-%m-%d'), '%')) WHERE ((((`BroadcastDay`.`year` = 2021) AND (`BroadcastDay`.`month` = 12) AND (`BroadcastDay`.`day` = '04') AND (LPAD(`BroadcastTime`.`broadcast_end`, 5, '0') > '20:29'))) OR (((`BroadcastDay`.`year` = 2021) AND (`BroadcastDay`.`month` = 12) AND (`BroadcastDay`.`day` = 5)))) ORDER BY `BroadcastDay`.`year` ASC, `BroadcastDay`.`month` ASC, `BroadcastDay`.`day` ASC, LPAD(`BroadcastTime`.`broadcast_start`, 5, '0') ASC LIMIT 111744
3SELECT `ProgramPresent`.`id` FROM `program_presents` AS `ProgramPresent` WHERE `ProgramPresent`.`program_id` = 185 AND `ProgramPresent`.`release_start` <= '2021-12-04 15:29:19' AND `ProgramPresent`.`release_end` >= '2021-12-04 15:29:19' 000
4SELECT `Program`.*, `BroadcastTime`.* FROM `broadcast_times` AS `BroadcastTime` INNER JOIN programs AS `Program` ON (`Program`.`id` = `BroadcastTime`.`program_id` AND `Program`.`program_id` = '185' AND `Program`.`corner` = 1) WHERE `BroadcastTime`.`broadcast_day_id` = 4121 AND LPAD(`BroadcastTime`.`broadcast_start`, 5, '0') <= '20:29' ORDER BY LPAD(`BroadcastTime`.`broadcast_start`, 5, '0') DESC LIMIT 1001
5SELECT `Sex`.`id`, `Sex`.`name` FROM `sexes` AS `Sex` WHERE 1 = 1 220
6SELECT `Job`.`id`, `Job`.`name` FROM `jobs` AS `Job` WHERE 1 = 1 15150
7SELECT `Pref`.`id`, `Pref`.`name` FROM `prefs` AS `Pref` WHERE 1 = 1 47470
8SHOW FULL COLUMNS FROM `spots`221
9SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'utf8_general_ci';110
10SELECT `Spot`.`id`, `Spot`.`name` FROM `spots` AS `Spot` WHERE 1 = 1 550
11SHOW FULL COLUMNS FROM `listen_witches`221
12SELECT `ListenWitch`.`id`, `ListenWitch`.`name` FROM `listen_witches` AS `ListenWitch` WHERE 1 = 1 550
13SHOW FULL COLUMNS FROM `request_mails`26261
14SELECT `Program`.`id`, `Program`.`name`, `Program`.`catch_copy`, `Program`.`notice`, `Program`.`url`, `DefBroadcastTime`.`broadcast_start`, `DefBroadcastTime`.`broadcast_end`, `DefBroadcastTime`.`week`, `BroadcastTime`.`broadcast_start`, `BroadcastTime`.`broadcast_end`, `BroadcastTime`.`week`, `Soundcrew`.`id`, `Soundcrew`.`name` FROM `programs` AS `Program` INNER JOIN broadcast_days AS `BroadcastDay` ON (((`BroadcastDay`.`year` = '2021') AND (`BroadcastDay`.`month` = '12') AND (`BroadcastDay`.`day` = '04'))) LEFT JOIN (select program_id,broadcast_day_id,broadcast_start,broadcast_end,6 as week from broadcast_times) AS `BroadcastTime` ON (`BroadcastTime`.`broadcast_day_id` = `BroadcastDay`.`id` AND `BroadcastTime`.`program_id` = `Program`.`id` AND LPAD(`BroadcastTime`.`broadcast_start`,5,'0') <= '20:29' AND LPAD(`BroadcastTime`.`broadcast_end`,5,'0') > '20:29') LEFT 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 ((LENGTH(`Program`.`request_mail`) > 5) AND (`Program`.`release_start` <= CURDATE()) AND (`Program`.`mail_type` > 0) AND (((`BroadcastTime`.`week` is not null) OR (`DefBroadcastTime`.`week` is not null) OR (`Program`.`message_flg` = 1)))) ORDER BY `Program`.`sort` ASC, `Program`.`id` ASC, `DefBroadcastTime`.`week` ASC 4848591
15SELECT `Program`.`id`, `Program`.`name`, `Program`.`request_mail`, `Program`.`present_flg`, `ProgramPresent`.`name` FROM `programs` AS `Program` INNER JOIN program_presents AS `ProgramPresent` ON (((`ProgramPresent`.`id` = '3865') AND (`ProgramPresent`.`program_id` = `Program`.`id`) AND (`ProgramPresent`.`release_start` <= ADDTIME(NOW(), '-05:00:00')) AND (((`ProgramPresent`.`release_end` is null) OR (((`ProgramPresent`.`release_end` is not null) AND (`ProgramPresent`.`release_end` >= ADDTIME(NOW(), '-05:00:00')))))))) WHERE `Program`.`id` = 2628 AND LENGTH(`Program`.`request_mail`) > 5 AND `Program`.`release_start` <= CURDATE() AND ((`Program`.`release_end` is null) OR (((`Program`.`release_end` is not null) AND (`Program`.`release_end` >= CURDATE())))) LIMIT 1111
16SELECT `ProgramPresent`.`id`, `ProgramPresent`.`kind`, `ProgramPresent`.`program_id`, `ProgramPresent`.`name`, `ProgramPresent`.`description`, `ProgramPresent`.`release_start`, `ProgramPresent`.`release_end`, `ProgramPresent`.`created`, `ProgramPresent`.`modified` FROM `program_presents` AS `ProgramPresent` WHERE `id` = 3865 LIMIT 1110