SELECT top ${limit} image.image_min_url, image.image_max_url, tab.* FROM ( SELECT 赛事地点 show_location, main_game_name, shows_detail, max(top_dog) top_dog, min(id) id, min(赛事编号) show_num, min(organizer) organizer, min(cku_caipanid) cku_caipanid, MIN(开始日期) AS starting_data, MAX(结束日期) AS ending_data, MAX(cku_endtime) AS expiry_time FROM tab_games GROUP BY 赛事地点,main_game_name,shows_detail ) tab LEFT JOIN cku_image image on tab.show_location = image.remarks WHERE tab.id NOT IN ( SELECT top ${page} min(id) id FROM tab_games GROUP BY 赛事地点 ORDER BY id DESC ) AND datediff(day,expiry_time,getdate()) 0 ORDER BY id DESC SELECT image.image_min_url, image.image_max_url, tab.* FROM ( SELECT 赛事地点 show_location, main_game_name, shows_detail, max(top_dog) top_dog, min(id) id, min(赛事编号) show_num, min(organizer) organizer, min(cku_caipanid) cku_caipanid, MIN(开始日期) AS starting_data, MAX(结束日期) AS ending_data, MAX(cku_endtime) AS expiry_time FROM tab_games GROUP BY 赛事地点,main_game_name,shows_detail ) tab LEFT JOIN cku_image image on tab.show_location = image.remarks WHERE datediff(day,expiry_time,getdate()) 0 ORDER BY id 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 id, 开始日期 starting_data, 结束日期 ending_data, 赛事名称 show_name, 赛事地点 show_location, 赛事编号 show_num, bmFei FROM tab_games where 赛事地点 = #{showLocation} and id in (${ids}) SELECT game.*, cku. NAME, cku.phone FROM cku_game_sponsor game LEFT JOIN cku_sponsor_contacts cku ON game.id = cku.sponsor_id WHERE city = #{organizer} SELECT id, 开始日期 starting_data, 结束日期 ending_data, 赛事名称 show_name, 赛事地点 show_location, 赛事编号 show_num, showSystem showSystem, bmFei, main_game_name, gameType, organizer FROM tab_games where 赛事编号 = #{showNum} SELECT min(开始日期) starting_data FROM tab_games where 赛事编号 in (${showNums}) update show_main isTop = 0, isTop = 1, where show_location =#{showLocation} SELECT TOP ${limit} image.*, tab.* FROM ( SELECT 赛事地点 show_location, main_game_name, shows_detail, MAX (top_dog) top_dog, MIN (id) id, MIN (赛事编号) show_num, MIN (organizer) organizer, MIN (cku_caipanid) cku_caipanid, MIN (开始日期) AS starting_data, MAX (结束日期) AS ending_data, MAX (cku_endtime) AS expiry_time, MIN (bmFei) AS bmFei, MIN (赛事名称) AS show_name, MIN (showSystem) AS showSystem, MIN (gameType) AS gameType, MIN (isTop) AS isTop, MIN(topMessage) AS topMessage FROM tab_games GROUP BY 赛事地点, main_game_name, shows_detail ) tab LEFT JOIN cku_image image ON tab.show_location = image.remarks WHERE tab.id NOT IN ( SELECT TOP ${start} MIN (id) id FROM tab_games GROUP BY 赛事地点 ORDER BY id DESC ) AND tab.isTop = '1' AND datediff(day,expiry_time,getdate()) 0 ORDER BY id DESC SELECT show_location 赛事地点 from show_main where id=#{id} select id,赛事地点 as show_location,topMessage from tab_games where id=#{id} select image.image_max_url from tab_games tab,cku_image image where image.showLocation_isTop=tab.id and tab.id=#{id}