SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'utf8_bin';
1
1
0
3
SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'utf8_general_ci';
1
1
0
4
SHOW FULL COLUMNS FROM `prefs`
2
2
0
5
SHOW FULL COLUMNS FROM `jobs`
2
2
0
6
SHOW FULL COLUMNS FROM `sexes`
2
2
0
7
SHOW FULL COLUMNS FROM `mailmag_pc_flgs`
2
2
0
8
SHOW FULL COLUMNS FROM `mailmag_mobile_flgs`
2
2
0
9
SHOW FULL COLUMNS FROM `htmlmail_flgs`
2
2
0
10
SHOW FULL COLUMNS FROM `now_playings`
6
6
0
11
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
12
SHOW FULL COLUMNS FROM `program_presents`
9
9
1
13
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` = 1840) 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
3
3
1
14
SELECT `Program`.`id`, `Program`.`name`, `Program`.`request_mail`, `Program`.`present_flg`, `Program`.`thumbnail` FROM `programs` AS `Program` WHERE `Program`.`id` = 1840 AND LENGTH(`Program`.`request_mail`) > 5 AND ((`Program`.`release_start` <= CURDATE()) OR (`Program`.`id` = 2762)) AND ((`Program`.`release_end` is null) OR (((`Program`.`release_end` is not null) AND (`Program`.`release_end` >= CURDATE())))) LIMIT 1
