1 | SELECT `Information`.`id`, `Information`.`kind`, `Information`.`event_date`, `Information`.`article_title`, `Information`.`description`, `Information`.`article_name`, `Information`.`text`, `Information`.`artist_info`, `Information`.`article_info`, `Information`.`override_url`, `Information`.`url`, `Information`.`image0`, `Information`.`image0_caption`, `Information`.`image1`, `Information`.`image1_caption`, `Information`.`image2`, `Information`.`image2_caption`, `Information`.`movie_youtube`, `Information`.`sort_number`, `Information`.`toppage_disp_flg_id`, `Information`.`visible_flg_id`, `Information`.`delete_flag`, `Information`.`release_start`, `Information`.`release_end`, `Information`.`period_flg`, `Information`.`modified`, `Information`.`created`, `Information`.`program_id`, `Information`.`guest_name` FROM `informations` AS `Information` WHERE `visible_flg_id` = 1 AND `delete_flag` = 0 AND `toppage_disp_flg_id` = 1 AND `release_start` <= '2022-04-15 17:12:01' AND `release_end` >= '2022-04-15 17:12:01' ORDER BY `sort_number` ASC, `id` DESC | | 17 | 17 | 3 |
2 | SELECT `Guest`.`id`, `Guest`.`event_guest_id`, `Guest`.`flow`, `Guest`.`type`, `Guest`.`room`, `Guest`.`room_etc`, `Guest`.`name`, `Guest`.`guest_data`, `Guest`.`program_id`, `Guest`.`user_id`, `Guest`.`onair_date`, `Guest`.`onair_date_multi`, `Guest`.`onair_time`, `Guest`.`rec_date`, `Guest`.`rec_time`, `Guest`.`visit_time`, `Guest`.`release`, `Guest`.`msg`, `Guest`.`image1`, `Guest`.`image2`, `Guest`.`image3`, `Guest`.`user_id_created`, `Guest`.`user_id_modified`, `Guest`.`open_flg`, `Guest`.`delete_flg`, `Guest`.`created`, `Guest`.`modified`, `Guest`.`buf_user_id`, `Guest`.`buf_user_id_created`, `Guest`.`buf_user_id_modified`, `Guest`.`buf_program_id` FROM `guests` AS `Guest` WHERE `Guest`.`event_guest_id` = 6455 LIMIT 1 | | 1 | 1 | 1 |
3 | SELECT `Guest`.`id`, `Guest`.`event_guest_id`, `Guest`.`flow`, `Guest`.`type`, `Guest`.`room`, `Guest`.`room_etc`, `Guest`.`name`, `Guest`.`guest_data`, `Guest`.`program_id`, `Guest`.`user_id`, `Guest`.`onair_date`, `Guest`.`onair_date_multi`, `Guest`.`onair_time`, `Guest`.`rec_date`, `Guest`.`rec_time`, `Guest`.`visit_time`, `Guest`.`release`, `Guest`.`msg`, `Guest`.`image1`, `Guest`.`image2`, `Guest`.`image3`, `Guest`.`user_id_created`, `Guest`.`user_id_modified`, `Guest`.`open_flg`, `Guest`.`delete_flg`, `Guest`.`created`, `Guest`.`modified`, `Guest`.`buf_user_id`, `Guest`.`buf_user_id_created`, `Guest`.`buf_user_id_modified`, `Guest`.`buf_program_id` FROM `guests` AS `Guest` WHERE `Guest`.`event_guest_id` = 6486 LIMIT 1 | | 1 | 1 | 3 |
4 | SELECT `Guest`.`id`, `Guest`.`event_guest_id`, `Guest`.`flow`, `Guest`.`type`, `Guest`.`room`, `Guest`.`room_etc`, `Guest`.`name`, `Guest`.`guest_data`, `Guest`.`program_id`, `Guest`.`user_id`, `Guest`.`onair_date`, `Guest`.`onair_date_multi`, `Guest`.`onair_time`, `Guest`.`rec_date`, `Guest`.`rec_time`, `Guest`.`visit_time`, `Guest`.`release`, `Guest`.`msg`, `Guest`.`image1`, `Guest`.`image2`, `Guest`.`image3`, `Guest`.`user_id_created`, `Guest`.`user_id_modified`, `Guest`.`open_flg`, `Guest`.`delete_flg`, `Guest`.`created`, `Guest`.`modified`, `Guest`.`buf_user_id`, `Guest`.`buf_user_id_created`, `Guest`.`buf_user_id_modified`, `Guest`.`buf_program_id` FROM `guests` AS `Guest` WHERE `Guest`.`event_guest_id` = 6502 LIMIT 1 | | 1 | 1 | 1 |
5 | SELECT `Guest`.`id`, `Guest`.`event_guest_id`, `Guest`.`flow`, `Guest`.`type`, `Guest`.`room`, `Guest`.`room_etc`, `Guest`.`name`, `Guest`.`guest_data`, `Guest`.`program_id`, `Guest`.`user_id`, `Guest`.`onair_date`, `Guest`.`onair_date_multi`, `Guest`.`onair_time`, `Guest`.`rec_date`, `Guest`.`rec_time`, `Guest`.`visit_time`, `Guest`.`release`, `Guest`.`msg`, `Guest`.`image1`, `Guest`.`image2`, `Guest`.`image3`, `Guest`.`user_id_created`, `Guest`.`user_id_modified`, `Guest`.`open_flg`, `Guest`.`delete_flg`, `Guest`.`created`, `Guest`.`modified`, `Guest`.`buf_user_id`, `Guest`.`buf_user_id_created`, `Guest`.`buf_user_id_modified`, `Guest`.`buf_program_id` FROM `guests` AS `Guest` WHERE `Guest`.`event_guest_id` = 6446 LIMIT 1 | | 1 | 1 | 1 |
6 | SELECT `Guest`.`id`, `Guest`.`event_guest_id`, `Guest`.`flow`, `Guest`.`type`, `Guest`.`room`, `Guest`.`room_etc`, `Guest`.`name`, `Guest`.`guest_data`, `Guest`.`program_id`, `Guest`.`user_id`, `Guest`.`onair_date`, `Guest`.`onair_date_multi`, `Guest`.`onair_time`, `Guest`.`rec_date`, `Guest`.`rec_time`, `Guest`.`visit_time`, `Guest`.`release`, `Guest`.`msg`, `Guest`.`image1`, `Guest`.`image2`, `Guest`.`image3`, `Guest`.`user_id_created`, `Guest`.`user_id_modified`, `Guest`.`open_flg`, `Guest`.`delete_flg`, `Guest`.`created`, `Guest`.`modified`, `Guest`.`buf_user_id`, `Guest`.`buf_user_id_created`, `Guest`.`buf_user_id_modified`, `Guest`.`buf_program_id` FROM `guests` AS `Guest` WHERE `Guest`.`event_guest_id` = 6462 LIMIT 1 | | 1 | 1 | 2 |
7 | SELECT `Guest`.`id`, `Guest`.`event_guest_id`, `Guest`.`flow`, `Guest`.`type`, `Guest`.`room`, `Guest`.`room_etc`, `Guest`.`name`, `Guest`.`guest_data`, `Guest`.`program_id`, `Guest`.`user_id`, `Guest`.`onair_date`, `Guest`.`onair_date_multi`, `Guest`.`onair_time`, `Guest`.`rec_date`, `Guest`.`rec_time`, `Guest`.`visit_time`, `Guest`.`release`, `Guest`.`msg`, `Guest`.`image1`, `Guest`.`image2`, `Guest`.`image3`, `Guest`.`user_id_created`, `Guest`.`user_id_modified`, `Guest`.`open_flg`, `Guest`.`delete_flg`, `Guest`.`created`, `Guest`.`modified`, `Guest`.`buf_user_id`, `Guest`.`buf_user_id_created`, `Guest`.`buf_user_id_modified`, `Guest`.`buf_program_id` FROM `guests` AS `Guest` WHERE `Guest`.`event_guest_id` = 6485 LIMIT 1 | | 1 | 1 | 1 |
8 | SELECT `Guest`.`id`, `Guest`.`event_guest_id`, `Guest`.`flow`, `Guest`.`type`, `Guest`.`room`, `Guest`.`room_etc`, `Guest`.`name`, `Guest`.`guest_data`, `Guest`.`program_id`, `Guest`.`user_id`, `Guest`.`onair_date`, `Guest`.`onair_date_multi`, `Guest`.`onair_time`, `Guest`.`rec_date`, `Guest`.`rec_time`, `Guest`.`visit_time`, `Guest`.`release`, `Guest`.`msg`, `Guest`.`image1`, `Guest`.`image2`, `Guest`.`image3`, `Guest`.`user_id_created`, `Guest`.`user_id_modified`, `Guest`.`open_flg`, `Guest`.`delete_flg`, `Guest`.`created`, `Guest`.`modified`, `Guest`.`buf_user_id`, `Guest`.`buf_user_id_created`, `Guest`.`buf_user_id_modified`, `Guest`.`buf_program_id` FROM `guests` AS `Guest` WHERE `Guest`.`event_guest_id` = 6512 LIMIT 1 | | 1 | 1 | 2 |
9 | SELECT `Guest`.`id`, `Guest`.`event_guest_id`, `Guest`.`flow`, `Guest`.`type`, `Guest`.`room`, `Guest`.`room_etc`, `Guest`.`name`, `Guest`.`guest_data`, `Guest`.`program_id`, `Guest`.`user_id`, `Guest`.`onair_date`, `Guest`.`onair_date_multi`, `Guest`.`onair_time`, `Guest`.`rec_date`, `Guest`.`rec_time`, `Guest`.`visit_time`, `Guest`.`release`, `Guest`.`msg`, `Guest`.`image1`, `Guest`.`image2`, `Guest`.`image3`, `Guest`.`user_id_created`, `Guest`.`user_id_modified`, `Guest`.`open_flg`, `Guest`.`delete_flg`, `Guest`.`created`, `Guest`.`modified`, `Guest`.`buf_user_id`, `Guest`.`buf_user_id_created`, `Guest`.`buf_user_id_modified`, `Guest`.`buf_program_id` FROM `guests` AS `Guest` WHERE `Guest`.`event_guest_id` = 6487 LIMIT 1 | | 1 | 1 | 1 |
10 | SELECT `Guest`.`id`, `Guest`.`event_guest_id`, `Guest`.`flow`, `Guest`.`type`, `Guest`.`room`, `Guest`.`room_etc`, `Guest`.`name`, `Guest`.`guest_data`, `Guest`.`program_id`, `Guest`.`user_id`, `Guest`.`onair_date`, `Guest`.`onair_date_multi`, `Guest`.`onair_time`, `Guest`.`rec_date`, `Guest`.`rec_time`, `Guest`.`visit_time`, `Guest`.`release`, `Guest`.`msg`, `Guest`.`image1`, `Guest`.`image2`, `Guest`.`image3`, `Guest`.`user_id_created`, `Guest`.`user_id_modified`, `Guest`.`open_flg`, `Guest`.`delete_flg`, `Guest`.`created`, `Guest`.`modified`, `Guest`.`buf_user_id`, `Guest`.`buf_user_id_created`, `Guest`.`buf_user_id_modified`, `Guest`.`buf_program_id` FROM `guests` AS `Guest` WHERE `Guest`.`event_guest_id` = 6465 LIMIT 1 | | 1 | 1 | 2 |
11 | SELECT `Guest`.`id`, `Guest`.`event_guest_id`, `Guest`.`flow`, `Guest`.`type`, `Guest`.`room`, `Guest`.`room_etc`, `Guest`.`name`, `Guest`.`guest_data`, `Guest`.`program_id`, `Guest`.`user_id`, `Guest`.`onair_date`, `Guest`.`onair_date_multi`, `Guest`.`onair_time`, `Guest`.`rec_date`, `Guest`.`rec_time`, `Guest`.`visit_time`, `Guest`.`release`, `Guest`.`msg`, `Guest`.`image1`, `Guest`.`image2`, `Guest`.`image3`, `Guest`.`user_id_created`, `Guest`.`user_id_modified`, `Guest`.`open_flg`, `Guest`.`delete_flg`, `Guest`.`created`, `Guest`.`modified`, `Guest`.`buf_user_id`, `Guest`.`buf_user_id_created`, `Guest`.`buf_user_id_modified`, `Guest`.`buf_program_id` FROM `guests` AS `Guest` WHERE `Guest`.`event_guest_id` = 6492 LIMIT 1 | | 1 | 1 | 3 |
12 | SELECT `Guest`.`id`, `Guest`.`event_guest_id`, `Guest`.`flow`, `Guest`.`type`, `Guest`.`room`, `Guest`.`room_etc`, `Guest`.`name`, `Guest`.`guest_data`, `Guest`.`program_id`, `Guest`.`user_id`, `Guest`.`onair_date`, `Guest`.`onair_date_multi`, `Guest`.`onair_time`, `Guest`.`rec_date`, `Guest`.`rec_time`, `Guest`.`visit_time`, `Guest`.`release`, `Guest`.`msg`, `Guest`.`image1`, `Guest`.`image2`, `Guest`.`image3`, `Guest`.`user_id_created`, `Guest`.`user_id_modified`, `Guest`.`open_flg`, `Guest`.`delete_flg`, `Guest`.`created`, `Guest`.`modified`, `Guest`.`buf_user_id`, `Guest`.`buf_user_id_created`, `Guest`.`buf_user_id_modified`, `Guest`.`buf_program_id` FROM `guests` AS `Guest` WHERE `Guest`.`event_guest_id` = 6438 LIMIT 1 | | 1 | 1 | 0 |