番組
PROGRAM
アフター 純喫茶 山石
- 放送時間
-
毎週 日 20:30~20:55
- 番組内容
- 公式サイト
- https://www.kiss-fm.co.jp/yamaishi_after/
Array ( [0] => Array ( [week] => Array ( [0] => Array ( [week] => 0 [week_time] => 20:30~20:55 ) [1] => Array ( [week] => 6 [week_time] => 20:30~20:55 ) ) [soundcrews] => Array ( [0] => Array ( [id] => [week] => 0 [name] => [name_kana] => ) [1] => Array ( [id] => 8 [week] => 6 [name] => ターザン山下 [name_kana] => たーざん やました ) ) [id] => 2560 [name] => アフター 純喫茶 山石 [same_information] => アフター 純喫茶 山石 [catch_copy] => [notice] => [soundcrew] => ターザン山下、山本俊之、金澤佳世 [broadcast] => 毎週 日 20:30~20:55 [thumbnail] => thumbnail.jpg [url] => https://www.kiss-fm.co.jp/yamaishi_after/ [twitter] => [program_week] => 毎週 日 20:30~20:55 [program_week_cnt] => 1 [program_soundcrew] => ターザン山下、山本俊之、金澤佳世 [image] => Array ( [thumbnail] => /img/src/program/2560/thumbnail.jpg ) [image_data] => Array ( [path] => /home/kiss-fm.co.jp/public_html/www.kiss-fm.co.jp/img/src/program/2500-2599/2560 [name] => thumbnail.jpg [src] => https://www.kiss-fm.co.jp/img/src/program/2500-2599/2560/thumbnail.jpg ) ) )
PROGRAM
毎週 日 20:30~20:55
Nr | Query | Error | Affected | Num. rows | Took (ms) |
---|---|---|---|---|---|
1 | SELECT `NowPlaying`.`id`, `NowPlaying`.`on_air_time`, `NowPlaying`.`artist`, `NowPlaying`.`song`, `NowPlaying`.`created`, `NowPlaying`.`modified` FROM `now_playings` AS `NowPlaying` WHERE `NowPlaying`.`id` = 1 LIMIT 1 | 1 | 1 | 0 | |
2 | SELECT `Program`.`id`, `Program`.`name`, `Program`.`same_information`, `Program`.`catch_copy`, `Program`.`notice`, `Program`.`soundcrew`, `Program`.`broadcast`, `Program`.`thumbnail`, `Program`.`url`, `Program`.`twitter`, `DefBroadcastTime`.`broadcast_start`, `DefBroadcastTime`.`broadcast_end`, `DefBroadcastTime`.`week`, `Soundcrew`.`id`, `Soundcrew`.`name`, `Soundcrew`.`name_kana` FROM `programs` AS `Program` 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` 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 | 30 | 30 | 3 |