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
SHOW FULL COLUMNS FROM `program_presents`
9
9
1
3
SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'utf8_general_ci';
1
1
1
4
SELECT `ProgramPresent`.`id`, `ProgramPresent`.`kind`, `ProgramPresent`.`program_id`, `ProgramPresent`.`name`, `ProgramPresent`.`description`, `ProgramPresent`.`release_start`, `ProgramPresent`.`release_end` FROM `program_presents` AS `ProgramPresent` WHERE ((`ProgramPresent`.`program_id` = 2777) 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'))))))) ORDER BY `ProgramPresent`.`release_start` DESC, `ProgramPresent`.`release_end` ASC, `ProgramPresent`.`id` DESC
1
1
0
5
SELECT `Program`.`id`, `Program`.`name`, `Program`.`request_mail`, `Program`.`present_flg`, `Program`.`thumbnail` FROM `programs` AS `Program` WHERE `Program`.`id` = 2777 AND LENGTH(`Program`.`request_mail`) > 5 AND ((`Program`.`release_start` <= CURDATE()) OR (`Program`.`id` = 2762) OR (`Program`.`id` = 2775)) AND ((`Program`.`release_end` is null) OR (((`Program`.`release_end` is not null) AND (`Program`.`release_end` >= CURDATE())))) LIMIT 1
