Warning (512): SQL Error: 1054: Unknown column 'Work.open_flagimages' in 'where clause' [CORE/cake/libs/model/datasources/dbo_source.php, line 684]
Query: SELECT `Work`.`work_id`, `Work`.`companion_id`, `Work`.`reception1`, `Work`.`reception2`, `Work`.`reception3`, `Work`.`reception4`, `Work`.`reception5`, `Work`.`reception6`, `Work`.`reception7`, `Work`.`reception8`, `Work`.`reception9`, `Work`.`reception10`, `Work`.`reception11`, `Work`.`reception12`, `Work`.`reception13`, `Work`.`reception14`, `Work`.`reception15`, `Work`.`reception16`, `Work`.`reception17`, `Work`.`reception18`, `Work`.`reception19`, `Work`.`reception20`, `Work`.`reception21`, `Work`.`start_time1`, `Work`.`end_time1`, `Work`.`start_time2`, `Work`.`end_time2`, `Work`.`start_time3`, `Work`.`end_time3`, `Work`.`start_time4`, `Work`.`end_time4`, `Work`.`start_time5`, `Work`.`end_time5`, `Work`.`start_time6`, `Work`.`end_time6`, `Work`.`start_time7`, `Work`.`end_time7`, `Work`.`start_time8`, `Work`.`end_time8`, `Work`.`start_time9`, `Work`.`end_time9`, `Work`.`start_time10`, `Work`.`end_time10`, `Work`.`start_time11`, `Work`.`end_time11`, `Work`.`start_time12`, `Work`.`end_time12`, `Work`.`start_time13`, `Work`.`end_time13`, `Work`.`start_time14`, `Work`.`end_time14`, `Work`.`start_time15`, `Work`.`end_time15`, `Work`.`start_time16`, `Work`.`end_time16`, `Work`.`start_time17`, `Work`.`end_time17`, `Work`.`start_time18`, `Work`.`end_time18`, `Work`.`start_time19`, `Work`.`end_time19`, `Work`.`start_time20`, `Work`.`end_time20`, `Work`.`start_time21`, `Work`.`end_time21`, `Work`.`open_flag1`, `Work`.`close_flag1`, `Work`.`open_flag2`, `Work`.`close_flag2`, `Work`.`open_flag3`, `Work`.`close_flag3`, `Work`.`open_flag4`, `Work`.`close_flag4`, `Work`.`open_flag5`, `Work`.`close_flag5`, `Work`.`open_flag6`, `Work`.`close_flag6`, `Work`.`open_flag7`, `Work`.`close_flag7`, `Work`.`open_flag8`, `Work`.`close_flag8`, `Work`.`open_flag9`, `Work`.`close_flag9`, `Work`.`open_flag10`, `Work`.`close_flag10`, `Work`.`open_flag11`, `Work`.`close_flag11`, `Work`.`open_flag12`, `Work`.`close_flag12`, `Work`.`open_flag13`, `Work`.`close_flag13`, `Work`.`open_flag14`, `Work`.`close_flag14`, `Work`.`open_flag15`, `Work`.`close_flag15`, `Work`.`open_flag16`, `Work`.`close_flag16`, `Work`.`open_flag17`, `Work`.`close_flag17`, `Work`.`open_flag18`, `Work`.`close_flag18`, `Work`.`open_flag19`, `Work`.`close_flag19`, `Work`.`open_flag20`, `Work`.`close_flag20`, `Work`.`open_flag21`, `Work`.`close_flag21`, `Companion`.`companion_id`, `Companion`.`name`, `Companion`.`real_name`, `Companion`.`age`, `Companion`.`birthday`, `Companion`.`shop_date`, `Companion`.`height`, `Companion`.`bust`, `Companion`.`waist`, `Companion`.`hip`, `Companion`.`bust_type`, `Companion`.`comment`, `Companion`.`picup_comment`, `Companion`.`photo_url`, `Companion`.`twitter_url`, `Companion`.`blog_url`, `Companion`.`manager_comment`, `Companion`.`visitor_comment`, `Companion`.`question1`, `Companion`.`question2`, `Companion`.`question3`, `Companion`.`question4`, `Companion`.`question5`, `Companion`.`question6`, `Companion`.`question7`, `Companion`.`question8`, `Companion`.`question9`, `Companion`.`question10`, `Companion`.`question11`, `Companion`.`question12`, `Companion`.`question13`, `Companion`.`question14`, `Companion`.`question15`, `Companion`.`question16`, `Companion`.`question17`, `Companion`.`question18`, `Companion`.`question19`, `Companion`.`question20`, `Companion`.`option1`, `Companion`.`option2`, `Companion`.`option3`, `Companion`.`option4`, `Companion`.`option5`, `Companion`.`option6`, `Companion`.`option7`, `Companion`.`option8`, `Companion`.`option9`, `Companion`.`option10`, `Companion`.`option11`, `Companion`.`option12`, `Companion`.`option13`, `Companion`.`option14`, `Companion`.`option15`, `Companion`.`option16`, `Companion`.`option17`, `Companion`.`option18`, `Companion`.`option19`, `Companion`.`option20`, `Companion`.`icon1`, `Companion`.`icon2`, `Companion`.`icon3`, `Companion`.`icon4`, `Companion`.`icon5`, `Companion`.`icon6`, `Companion`.`icon7`, `Companion`.`icon8`, `Companion`.`icon9`, `Companion`.`icon10`, `Companion`.`icon11`, `Companion`.`icon12`, `Companion`.`icon13`, `Companion`.`icon14`, `Companion`.`icon15`, `Companion`.`icon16`, `Companion`.`icon17`, `Companion`.`icon18`, `Companion`.`icon19`, `Companion`.`icon20`, `Companion`.`icon21`, `Companion`.`icon22`, `Companion`.`icon23`, `Companion`.`icon24`, `Companion`.`icon25`, `Companion`.`icon26`, `Companion`.`icon27`, `Companion`.`icon28`, `Companion`.`icon29`, `Companion`.`icon30`, `Companion`.`icon31`, `Companion`.`icon32`, `Companion`.`icon33`, `Companion`.`icon34`, `Companion`.`icon35`, `Companion`.`icon36`, `Companion`.`icon37`, `Companion`.`icon38`, `Companion`.`icon39`, `Companion`.`icon40`, `Companion`.`icon41`, `Companion`.`icon42`, `Companion`.`icon43`, `Companion`.`icon44`, `Companion`.`icon45`, `Companion`.`icon46`, `Companion`.`icon47`, `Companion`.`icon48`, `Companion`.`icon49`, `Companion`.`icon50`, `Companion`.`icon51`, `Companion`.`icon52`, `Companion`.`icon53`, `Companion`.`icon54`, `Companion`.`icon55`, `Companion`.`icon56`, `Companion`.`icon57`, `Companion`.`icon58`, `Companion`.`icon59`, `Companion`.`icon60`, `Companion`.`reception1`, `Companion`.`reception2`, `Companion`.`reception3`, `Companion`.`reception4`, `Companion`.`reception5`, `Companion`.`reception6`, `Companion`.`reception7`, `Companion`.`reception8`, `Companion`.`reception9`, `Companion`.`reception10`, `Companion`.`reception11`, `Companion`.`reception12`, `Companion`.`reception13`, `Companion`.`reception14`, `Companion`.`reception15`, `Companion`.`reception16`, `Companion`.`reception17`, `Companion`.`reception18`, `Companion`.`reception19`, `Companion`.`reception20`, `Companion`.`small_photo1`, `Companion`.`small_photo2`, `Companion`.`small_photo3`, `Companion`.`small_photo4`, `Companion`.`small_photo5`, `Companion`.`small_photo6`, `Companion`.`small_photo7`, `Companion`.`normal_photo1`, `Companion`.`normal_photo2`, `Companion`.`normal_photo3`, `Companion`.`normal_photo4`, `Companion`.`normal_photo5`, `Companion`.`normal_photo6`, `Companion`.`normal_photo7`, `Companion`.`large_photo1`, `Companion`.`large_photo2`, `Companion`.`large_photo3`, `Companion`.`large_photo4`, `Companion`.`large_photo5`, `Companion`.`large_photo6`, `Companion`.`large_photo7`, `Companion`.`photo_setting1`, `Companion`.`photo_setting2`, `Companion`.`photo_setting3`, `Companion`.`photo_setting4`, `Companion`.`photo_setting5`, `Companion`.`photo_setting6`, `Companion`.`photo_setting7`, `Companion`.`photo_name1`, `Companion`.`photo_name2`, `Companion`.`photo_name3`, `Companion`.`photo_name4`, `Companion`.`photo_name5`, `Companion`.`photo_name6`, `Companion`.`photo_name7`, `Companion`.`movie`, `Companion`.`free_text1`, `Companion`.`free_text2`, `Companion`.`free_text3`, `Companion`.`free_photo1`, `Companion`.`free_photo2`, `Companion`.`free_photo3`, `Companion`.`free_url1`, `Companion`.`free_url2`, `Companion`.`free_url3`, `Companion`.`free_photo_name1`, `Companion`.`free_photo_name2`, `Companion`.`free_photo_name3`, `Companion`.`order`, `Companion`.`open_flag`, `Companion`.`picup_flag`, `Companion`.`powerpush1_flag`, `Companion`.`powerpush2_flag`, `Companion`.`newcomer_flag`, `Companion`.`created`, `Companion`.`modified` FROM `works` AS `Work` LEFT JOIN `companions` AS `Companion` ON (`Work`.`companion_id` = `Companion`.`companion_id`) WHERE `Companion`.`open_flag` = 1 AND ((`Work`.`open_flagimages` = 1) OR (((`Work`.`close_flagimages` != 1) AND (`Work`.`end_timeimages` IS NOT NULL))) OR (`Work`.`close_flagimages` = 1))
Warning (2): Invalid argument supplied for foreach() [APP/controllers/schedules_controller.php, line 73]
Query: SELECT COUNT(*) AS `count` FROM `works` AS `Work` LEFT JOIN `companions` AS `Companion` ON (`Work`.`companion_id` = `Companion`.`companion_id`) WHERE `Companion`.`open_flag` = 1 AND ((`Work`.`open_flagimages` = 1) OR (((`Work`.`close_flagimages` != 1) AND (`Work`.`end_timeimages` IS NOT NULL))) OR (`Work`.`close_flagimages` = 1))
Query: SELECT `Work`.`work_id`, `Work`.`companion_id`, `Work`.`reception1`, `Work`.`reception2`, `Work`.`reception3`, `Work`.`reception4`, `Work`.`reception5`, `Work`.`reception6`, `Work`.`reception7`, `Work`.`reception8`, `Work`.`reception9`, `Work`.`reception10`, `Work`.`reception11`, `Work`.`reception12`, `Work`.`reception13`, `Work`.`reception14`, `Work`.`reception15`, `Work`.`reception16`, `Work`.`reception17`, `Work`.`reception18`, `Work`.`reception19`, `Work`.`reception20`, `Work`.`reception21`, `Work`.`start_time1`, `Work`.`end_time1`, `Work`.`start_time2`, `Work`.`end_time2`, `Work`.`start_time3`, `Work`.`end_time3`, `Work`.`start_time4`, `Work`.`end_time4`, `Work`.`start_time5`, `Work`.`end_time5`, `Work`.`start_time6`, `Work`.`end_time6`, `Work`.`start_time7`, `Work`.`end_time7`, `Work`.`start_time8`, `Work`.`end_time8`, `Work`.`start_time9`, `Work`.`end_time9`, `Work`.`start_time10`, `Work`.`end_time10`, `Work`.`start_time11`, `Work`.`end_time11`, `Work`.`start_time12`, `Work`.`end_time12`, `Work`.`start_time13`, `Work`.`end_time13`, `Work`.`start_time14`, `Work`.`end_time14`, `Work`.`start_time15`, `Work`.`end_time15`, `Work`.`start_time16`, `Work`.`end_time16`, `Work`.`start_time17`, `Work`.`end_time17`, `Work`.`start_time18`, `Work`.`end_time18`, `Work`.`start_time19`, `Work`.`end_time19`, `Work`.`start_time20`, `Work`.`end_time20`, `Work`.`start_time21`, `Work`.`end_time21`, `Work`.`open_flag1`, `Work`.`close_flag1`, `Work`.`open_flag2`, `Work`.`close_flag2`, `Work`.`open_flag3`, `Work`.`close_flag3`, `Work`.`open_flag4`, `Work`.`close_flag4`, `Work`.`open_flag5`, `Work`.`close_flag5`, `Work`.`open_flag6`, `Work`.`close_flag6`, `Work`.`open_flag7`, `Work`.`close_flag7`, `Work`.`open_flag8`, `Work`.`close_flag8`, `Work`.`open_flag9`, `Work`.`close_flag9`, `Work`.`open_flag10`, `Work`.`close_flag10`, `Work`.`open_flag11`, `Work`.`close_flag11`, `Work`.`open_flag12`, `Work`.`close_flag12`, `Work`.`open_flag13`, `Work`.`close_flag13`, `Work`.`open_flag14`, `Work`.`close_flag14`, `Work`.`open_flag15`, `Work`.`close_flag15`, `Work`.`open_flag16`, `Work`.`close_flag16`, `Work`.`open_flag17`, `Work`.`close_flag17`, `Work`.`open_flag18`, `Work`.`close_flag18`, `Work`.`open_flag19`, `Work`.`close_flag19`, `Work`.`open_flag20`, `Work`.`close_flag20`, `Work`.`open_flag21`, `Work`.`close_flag21`, `Companion`.`companion_id`, `Companion`.`name`, `Companion`.`real_name`, `Companion`.`age`, `Companion`.`birthday`, `Companion`.`shop_date`, `Companion`.`height`, `Companion`.`bust`, `Companion`.`waist`, `Companion`.`hip`, `Companion`.`bust_type`, `Companion`.`comment`, `Companion`.`picup_comment`, `Companion`.`photo_url`, `Companion`.`twitter_url`, `Companion`.`blog_url`, `Companion`.`manager_comment`, `Companion`.`visitor_comment`, `Companion`.`question1`, `Companion`.`question2`, `Companion`.`question3`, `Companion`.`question4`, `Companion`.`question5`, `Companion`.`question6`, `Companion`.`question7`, `Companion`.`question8`, `Companion`.`question9`, `Companion`.`question10`, `Companion`.`question11`, `Companion`.`question12`, `Companion`.`question13`, `Companion`.`question14`, `Companion`.`question15`, `Companion`.`question16`, `Companion`.`question17`, `Companion`.`question18`, `Companion`.`question19`, `Companion`.`question20`, `Companion`.`option1`, `Companion`.`option2`, `Companion`.`option3`, `Companion`.`option4`, `Companion`.`option5`, `Companion`.`option6`, `Companion`.`option7`, `Companion`.`option8`, `Companion`.`option9`, `Companion`.`option10`, `Companion`.`option11`, `Companion`.`option12`, `Companion`.`option13`, `Companion`.`option14`, `Companion`.`option15`, `Companion`.`option16`, `Companion`.`option17`, `Companion`.`option18`, `Companion`.`option19`, `Companion`.`option20`, `Companion`.`icon1`, `Companion`.`icon2`, `Companion`.`icon3`, `Companion`.`icon4`, `Companion`.`icon5`, `Companion`.`icon6`, `Companion`.`icon7`, `Companion`.`icon8`, `Companion`.`icon9`, `Companion`.`icon10`, `Companion`.`icon11`, `Companion`.`icon12`, `Companion`.`icon13`, `Companion`.`icon14`, `Companion`.`icon15`, `Companion`.`icon16`, `Companion`.`icon17`, `Companion`.`icon18`, `Companion`.`icon19`, `Companion`.`icon20`, `Companion`.`icon21`, `Companion`.`icon22`, `Companion`.`icon23`, `Companion`.`icon24`, `Companion`.`icon25`, `Companion`.`icon26`, `Companion`.`icon27`, `Companion`.`icon28`, `Companion`.`icon29`, `Companion`.`icon30`, `Companion`.`icon31`, `Companion`.`icon32`, `Companion`.`icon33`, `Companion`.`icon34`, `Companion`.`icon35`, `Companion`.`icon36`, `Companion`.`icon37`, `Companion`.`icon38`, `Companion`.`icon39`, `Companion`.`icon40`, `Companion`.`icon41`, `Companion`.`icon42`, `Companion`.`icon43`, `Companion`.`icon44`, `Companion`.`icon45`, `Companion`.`icon46`, `Companion`.`icon47`, `Companion`.`icon48`, `Companion`.`icon49`, `Companion`.`icon50`, `Companion`.`icon51`, `Companion`.`icon52`, `Companion`.`icon53`, `Companion`.`icon54`, `Companion`.`icon55`, `Companion`.`icon56`, `Companion`.`icon57`, `Companion`.`icon58`, `Companion`.`icon59`, `Companion`.`icon60`, `Companion`.`reception1`, `Companion`.`reception2`, `Companion`.`reception3`, `Companion`.`reception4`, `Companion`.`reception5`, `Companion`.`reception6`, `Companion`.`reception7`, `Companion`.`reception8`, `Companion`.`reception9`, `Companion`.`reception10`, `Companion`.`reception11`, `Companion`.`reception12`, `Companion`.`reception13`, `Companion`.`reception14`, `Companion`.`reception15`, `Companion`.`reception16`, `Companion`.`reception17`, `Companion`.`reception18`, `Companion`.`reception19`, `Companion`.`reception20`, `Companion`.`small_photo1`, `Companion`.`small_photo2`, `Companion`.`small_photo3`, `Companion`.`small_photo4`, `Companion`.`small_photo5`, `Companion`.`small_photo6`, `Companion`.`small_photo7`, `Companion`.`normal_photo1`, `Companion`.`normal_photo2`, `Companion`.`normal_photo3`, `Companion`.`normal_photo4`, `Companion`.`normal_photo5`, `Companion`.`normal_photo6`, `Companion`.`normal_photo7`, `Companion`.`large_photo1`, `Companion`.`large_photo2`, `Companion`.`large_photo3`, `Companion`.`large_photo4`, `Companion`.`large_photo5`, `Companion`.`large_photo6`, `Companion`.`large_photo7`, `Companion`.`photo_setting1`, `Companion`.`photo_setting2`, `Companion`.`photo_setting3`, `Companion`.`photo_setting4`, `Companion`.`photo_setting5`, `Companion`.`photo_setting6`, `Companion`.`photo_setting7`, `Companion`.`photo_name1`, `Companion`.`photo_name2`, `Companion`.`photo_name3`, `Companion`.`photo_name4`, `Companion`.`photo_name5`, `Companion`.`photo_name6`, `Companion`.`photo_name7`, `Companion`.`movie`, `Companion`.`free_text1`, `Companion`.`free_text2`, `Companion`.`free_text3`, `Companion`.`free_photo1`, `Companion`.`free_photo2`, `Companion`.`free_photo3`, `Companion`.`free_url1`, `Companion`.`free_url2`, `Companion`.`free_url3`, `Companion`.`free_photo_name1`, `Companion`.`free_photo_name2`, `Companion`.`free_photo_name3`, `Companion`.`order`, `Companion`.`open_flag`, `Companion`.`picup_flag`, `Companion`.`powerpush1_flag`, `Companion`.`powerpush2_flag`, `Companion`.`newcomer_flag`, `Companion`.`created`, `Companion`.`modified` FROM `works` AS `Work` LEFT JOIN `companions` AS `Companion` ON (`Work`.`companion_id` = `Companion`.`companion_id`) WHERE `Companion`.`open_flag` = 1 AND ((`Work`.`open_flagimages` = 1) OR (((`Work`.`close_flagimages` != 1) AND (`Work`.`end_timeimages` IS NOT NULL))) OR (`Work`.`close_flagimages` = 1)) ORDER BY if(start_timeimages < '6:00:00', addtime(start_timeimages ,'24:00:00'), start_timeimages) , `Companion`.`order` ASC LIMIT 50
Warning (2): Invalid argument supplied for foreach() [APP/app_controller.php, line 72]
Query: SELECT COUNT(*) AS `count` FROM `works` AS `Work` LEFT JOIN `companions` AS `Companion` ON (`Work`.`companion_id` = `Companion`.`companion_id`) WHERE `Companion`.`open_flag` = 1 AND ((`Work`.`open_flagimages` = 1) OR (((`Work`.`close_flagimages` != 1) AND (`Work`.`end_timeimages` IS NOT NULL))) OR (`Work`.`close_flagimages` = 1))
Query: SELECT `Work`.`work_id`, `Work`.`companion_id`, `Work`.`reception1`, `Work`.`reception2`, `Work`.`reception3`, `Work`.`reception4`, `Work`.`reception5`, `Work`.`reception6`, `Work`.`reception7`, `Work`.`reception8`, `Work`.`reception9`, `Work`.`reception10`, `Work`.`reception11`, `Work`.`reception12`, `Work`.`reception13`, `Work`.`reception14`, `Work`.`reception15`, `Work`.`reception16`, `Work`.`reception17`, `Work`.`reception18`, `Work`.`reception19`, `Work`.`reception20`, `Work`.`reception21`, `Work`.`start_time1`, `Work`.`end_time1`, `Work`.`start_time2`, `Work`.`end_time2`, `Work`.`start_time3`, `Work`.`end_time3`, `Work`.`start_time4`, `Work`.`end_time4`, `Work`.`start_time5`, `Work`.`end_time5`, `Work`.`start_time6`, `Work`.`end_time6`, `Work`.`start_time7`, `Work`.`end_time7`, `Work`.`start_time8`, `Work`.`end_time8`, `Work`.`start_time9`, `Work`.`end_time9`, `Work`.`start_time10`, `Work`.`end_time10`, `Work`.`start_time11`, `Work`.`end_time11`, `Work`.`start_time12`, `Work`.`end_time12`, `Work`.`start_time13`, `Work`.`end_time13`, `Work`.`start_time14`, `Work`.`end_time14`, `Work`.`start_time15`, `Work`.`end_time15`, `Work`.`start_time16`, `Work`.`end_time16`, `Work`.`start_time17`, `Work`.`end_time17`, `Work`.`start_time18`, `Work`.`end_time18`, `Work`.`start_time19`, `Work`.`end_time19`, `Work`.`start_time20`, `Work`.`end_time20`, `Work`.`start_time21`, `Work`.`end_time21`, `Work`.`open_flag1`, `Work`.`close_flag1`, `Work`.`open_flag2`, `Work`.`close_flag2`, `Work`.`open_flag3`, `Work`.`close_flag3`, `Work`.`open_flag4`, `Work`.`close_flag4`, `Work`.`open_flag5`, `Work`.`close_flag5`, `Work`.`open_flag6`, `Work`.`close_flag6`, `Work`.`open_flag7`, `Work`.`close_flag7`, `Work`.`open_flag8`, `Work`.`close_flag8`, `Work`.`open_flag9`, `Work`.`close_flag9`, `Work`.`open_flag10`, `Work`.`close_flag10`, `Work`.`open_flag11`, `Work`.`close_flag11`, `Work`.`open_flag12`, `Work`.`close_flag12`, `Work`.`open_flag13`, `Work`.`close_flag13`, `Work`.`open_flag14`, `Work`.`close_flag14`, `Work`.`open_flag15`, `Work`.`close_flag15`, `Work`.`open_flag16`, `Work`.`close_flag16`, `Work`.`open_flag17`, `Work`.`close_flag17`, `Work`.`open_flag18`, `Work`.`close_flag18`, `Work`.`open_flag19`, `Work`.`close_flag19`, `Work`.`open_flag20`, `Work`.`close_flag20`, `Work`.`open_flag21`, `Work`.`close_flag21`, `Companion`.`companion_id`, `Companion`.`name`, `Companion`.`real_name`, `Companion`.`age`, `Companion`.`birthday`, `Companion`.`shop_date`, `Companion`.`height`, `Companion`.`bust`, `Companion`.`waist`, `Companion`.`hip`, `Companion`.`bust_type`, `Companion`.`comment`, `Companion`.`picup_comment`, `Companion`.`photo_url`, `Companion`.`twitter_url`, `Companion`.`blog_url`, `Companion`.`manager_comment`, `Companion`.`visitor_comment`, `Companion`.`question1`, `Companion`.`question2`, `Companion`.`question3`, `Companion`.`question4`, `Companion`.`question5`, `Companion`.`question6`, `Companion`.`question7`, `Companion`.`question8`, `Companion`.`question9`, `Companion`.`question10`, `Companion`.`question11`, `Companion`.`question12`, `Companion`.`question13`, `Companion`.`question14`, `Companion`.`question15`, `Companion`.`question16`, `Companion`.`question17`, `Companion`.`question18`, `Companion`.`question19`, `Companion`.`question20`, `Companion`.`option1`, `Companion`.`option2`, `Companion`.`option3`, `Companion`.`option4`, `Companion`.`option5`, `Companion`.`option6`, `Companion`.`option7`, `Companion`.`option8`, `Companion`.`option9`, `Companion`.`option10`, `Companion`.`option11`, `Companion`.`option12`, `Companion`.`option13`, `Companion`.`option14`, `Companion`.`option15`, `Companion`.`option16`, `Companion`.`option17`, `Companion`.`option18`, `Companion`.`option19`, `Companion`.`option20`, `Companion`.`icon1`, `Companion`.`icon2`, `Companion`.`icon3`, `Companion`.`icon4`, `Companion`.`icon5`, `Companion`.`icon6`, `Companion`.`icon7`, `Companion`.`icon8`, `Companion`.`icon9`, `Companion`.`icon10`, `Companion`.`icon11`, `Companion`.`icon12`, `Companion`.`icon13`, `Companion`.`icon14`, `Companion`.`icon15`, `Companion`.`icon16`, `Companion`.`icon17`, `Companion`.`icon18`, `Companion`.`icon19`, `Companion`.`icon20`, `Companion`.`icon21`, `Companion`.`icon22`, `Companion`.`icon23`, `Companion`.`icon24`, `Companion`.`icon25`, `Companion`.`icon26`, `Companion`.`icon27`, `Companion`.`icon28`, `Companion`.`icon29`, `Companion`.`icon30`, `Companion`.`icon31`, `Companion`.`icon32`, `Companion`.`icon33`, `Companion`.`icon34`, `Companion`.`icon35`, `Companion`.`icon36`, `Companion`.`icon37`, `Companion`.`icon38`, `Companion`.`icon39`, `Companion`.`icon40`, `Companion`.`icon41`, `Companion`.`icon42`, `Companion`.`icon43`, `Companion`.`icon44`, `Companion`.`icon45`, `Companion`.`icon46`, `Companion`.`icon47`, `Companion`.`icon48`, `Companion`.`icon49`, `Companion`.`icon50`, `Companion`.`icon51`, `Companion`.`icon52`, `Companion`.`icon53`, `Companion`.`icon54`, `Companion`.`icon55`, `Companion`.`icon56`, `Companion`.`icon57`, `Companion`.`icon58`, `Companion`.`icon59`, `Companion`.`icon60`, `Companion`.`reception1`, `Companion`.`reception2`, `Companion`.`reception3`, `Companion`.`reception4`, `Companion`.`reception5`, `Companion`.`reception6`, `Companion`.`reception7`, `Companion`.`reception8`, `Companion`.`reception9`, `Companion`.`reception10`, `Companion`.`reception11`, `Companion`.`reception12`, `Companion`.`reception13`, `Companion`.`reception14`, `Companion`.`reception15`, `Companion`.`reception16`, `Companion`.`reception17`, `Companion`.`reception18`, `Companion`.`reception19`, `Companion`.`reception20`, `Companion`.`small_photo1`, `Companion`.`small_photo2`, `Companion`.`small_photo3`, `Companion`.`small_photo4`, `Companion`.`small_photo5`, `Companion`.`small_photo6`, `Companion`.`small_photo7`, `Companion`.`normal_photo1`, `Companion`.`normal_photo2`, `Companion`.`normal_photo3`, `Companion`.`normal_photo4`, `Companion`.`normal_photo5`, `Companion`.`normal_photo6`, `Companion`.`normal_photo7`, `Companion`.`large_photo1`, `Companion`.`large_photo2`, `Companion`.`large_photo3`, `Companion`.`large_photo4`, `Companion`.`large_photo5`, `Companion`.`large_photo6`, `Companion`.`large_photo7`, `Companion`.`photo_setting1`, `Companion`.`photo_setting2`, `Companion`.`photo_setting3`, `Companion`.`photo_setting4`, `Companion`.`photo_setting5`, `Companion`.`photo_setting6`, `Companion`.`photo_setting7`, `Companion`.`photo_name1`, `Companion`.`photo_name2`, `Companion`.`photo_name3`, `Companion`.`photo_name4`, `Companion`.`photo_name5`, `Companion`.`photo_name6`, `Companion`.`photo_name7`, `Companion`.`movie`, `Companion`.`free_text1`, `Companion`.`free_text2`, `Companion`.`free_text3`, `Companion`.`free_photo1`, `Companion`.`free_photo2`, `Companion`.`free_photo3`, `Companion`.`free_url1`, `Companion`.`free_url2`, `Companion`.`free_url3`, `Companion`.`free_photo_name1`, `Companion`.`free_photo_name2`, `Companion`.`free_photo_name3`, `Companion`.`order`, `Companion`.`open_flag`, `Companion`.`picup_flag`, `Companion`.`powerpush1_flag`, `Companion`.`powerpush2_flag`, `Companion`.`newcomer_flag`, `Companion`.`created`, `Companion`.`modified` FROM `works` AS `Work` LEFT JOIN `companions` AS `Companion` ON (`Work`.`companion_id` = `Companion`.`companion_id`) WHERE `Companion`.`open_flag` = 1 AND ((`Work`.`open_flagimages` = 1) OR (((`Work`.`close_flagimages` != 1) AND (`Work`.`end_timeimages` IS NOT NULL))) OR (`Work`.`close_flagimages` = 1)) ORDER BY if(start_timeimages < '6:00:00', addtime(start_timeimages ,'24:00:00'), start_timeimages) , `Companion`.`order` ASC LIMIT 50