SELECT image.image_min_url AS "image_min_url", image.image_max_url AS "image_max_url", tab.show_location AS "show_location", tab.main_show_name AS "main_game_name", tab.branch_show_detail AS "shows_detail", tab.dog_num_max AS "top_dog", tab.id AS "id", tab.organizer AS "organizer", tab.referee AS "cku_caipanid", tab.start_time AS "starting_data", tab.end_time AS "ending_data", tab.closing_time AS "expiry_time", tab.attention AS "attention", tab.register AS "register", c.show_code AS "show_num", c.cac_type AS "cacType", tab.orgnize_type AS "orgnizeType", tab.office_id AS "officeId" FROM show_main tab LEFT JOIN (select t.remarks,t.image_min_url,t.image_max_url from (select remarks,image_min_url,image_max_url from cku_image order by create_time asc) t group by t.remarks ) image ON tab.show_location = image.remarks LEFT JOIN (select min(show_code) show_code,group_concat(distinct case when cac_type = '0' then 'CAC' when cac_type = '1' then 'CACIB' end ) cac_type,main_show_id from show_child group by main_show_id ) c on tab.id = c.main_show_id WHERE tab.del_flag = '0' AND tab.register = '1' AND tab.closing_time >= now() and tab.start_time>=date_sub(curdate(), interval 1 year) ORDER BY tab.isTop desc , tab.is_top_time desc , tab.register desc, tab.closing_time ASC, tab.create_date desc LIMIT ${page},${limit} SELECT image.image_min_url AS "image_min_url", image.image_max_url AS "image_max_url", tab.show_location AS "show_location", tab.main_show_name AS "main_game_name", tab.branch_show_detail AS "shows_detail", tab.dog_num_max AS "top_dog", tab.id AS "id", tab.organizer AS "organizer", tab.referee AS "cku_caipanid", tab.start_time AS "starting_data", tab.end_time AS "ending_data", tab.closing_time AS "expiry_time", tab.attention AS "attention", c.show_code AS "show_num" FROM show_main tab LEFT JOIN (select t.remarks,t.image_min_url,t.image_max_url from (select remarks,image_min_url,image_max_url from cku_image order by create_time asc) t group by t.remarks )image ON tab.show_location = image.remarks LEFT JOIN (select min(show_code) show_code,main_show_id from show_child group by main_show_id ) c on tab.id = c.main_show_id WHERE tab.del_flag = '0' AND tab.register = '1' AND tab.closing_time >= now() and tab.start_time>=date_sub(curdate(), interval 1 year) ORDER BY tab.register desc, tab.closing_time desc, tab.create_date desc SELECT tab.* FROM ( SELECT min(id) id, 赛事地点 show_location, shows_detail, MIN(开始日期) AS starting_data, MAX(结束日期) AS ending_data, MAX(cku_endtime) AS expiry_time, main_game_name, shows_detail, max(top_dog) top_dog, min(赛事编号) show_num FROM tab_games GROUP BY 赛事地点, main_game_name, shows_detail ) tab WHERE tab.show_location = #{showLocation} SELECT a.id, a.start_time starting_data, a.end_time ending_data, a.show_name show_name, b.show_location show_location, b.undertaker undertaker, a.show_code show_num, a.fee bmFei, a.cac_type showSystem FROM show_child a LEFT JOIN show_main b ON a.main_show_id = b.id WHERE b.show_location = #{showLocation} and b.register = '1' and a.del_flag = '0' and b.del_flag = '0' and a.id !='720e92783d5e43ad8573a3c6da39e3e9' and a.id in (${ids}) order by a.show_code SELECT game.*, cku.name, cku.phone FROM cku_game_sponsor game LEFT JOIN cku_sponsor_contacts cku ON game.id = cku.sponsor_id WHERE game.id = #{organizer} or game.city = #{organizer} SELECT a.id, a.start_time starting_data, a.end_time ending_data, a.show_name show_name, b.show_location show_location, a.show_code show_num, a.show_rules showSystem, a.cac_type cacType, a.fee bmFei, b.main_show_name main_game_name, b.orgnize_type gameType, b.organizer organizer, b.business_model_flag businessModelFlag, b.dog_num_max top_dog, b.closing_time expiry_time, b.handler_photo_flag handlerPhotoFlag, a.main_show_id mainShowId, b.start_time mainShowStartTime FROM show_child a LEFT JOIN show_main b ON a.main_show_id = b.id WHERE a.show_code = #{showNum} and a.del_flag = '0' and b.del_flag = '0' SELECT min(start_time) starting_data FROM show_child where show_code in (${showNums}) and del_flag = '0' update tab_games isTop = 0, isTop = 1, where 赛事地点 =#{showLocation} SELECT image.image_min_url AS "image_min_url", image.image_max_url AS "image_max_url", tab.show_location AS "show_location", tab.main_show_name AS "main_game_name", tab.branch_show_detail AS "shows_detail", tab.dog_num_max AS "top_dog", tab.id AS "id", tab.organizer AS "organizer", tab.referee AS "cku_caipanid", tab.start_time AS "starting_data", tab.end_time AS "ending_data", tab.closing_time AS "expiry_time", tab.attention AS "attention", c.show_code AS "show_num" FROM show_main tab LEFT JOIN cku_image image ON tab.show_location = image.remarks LEFT JOIN (select min(show_code) show_code,main_show_id from show_child group by main_show_id ) c on tab.id = c.main_show_id WHERE TIMESTAMPDIFF(SECOND ,SYSDATE(),tab.closing_time) =]]> 0 AND tab.isTop = '1' ORDER BY tab.id, tab.closing_time LIMIT ${start},${limit} SELECT show_location from show_child where id=#{id} select id,赛事地点 as show_location,topMessage from tab_games where id=#{id} select image.image_max_url from show_main tab,cku_image image where image.showLocation_isTop=tab.id and tab.id=#{id} SELECT manager FROM show_office where id=#{showOfficeId}