select b.id from hsy_ticket a left join hsy_game b on a.gameId=b.id where b.isShow=1 and b.isShowPc=1 and a.stock >0 and a.price >0 and vdate >= CURDATE() and (cityName like '%Ecuador%' or venueName like '%Ecuador%' or enVname like '%Ecuador%' or homeTeamName like '%Ecuador%' or awayTeamName like '%Ecuador%') and b.sportId=34 and b.tournamentId=669 and FIND_IN_SET(395,b.idList) and DATE_FORMAT(vdate, '%m')=11 group by a.gameId Server shutdown in progress
select b.id,b.enVname as vname,note,venueId,marvellous,vdate,vtime,erciqueren,hdyouhui,jjweishuai,tournamentId,cityName,idList,imagePath,b.isSale,b.homeTeamId,b.awayTeamId from hsy_ticket a left join hsy_game b on a.gameId=b.id where b.isShow=1 and b.isShowPc=1 and a.stock >0 and a.price >0 and vdate >= CURDATE() and (cityName like '%Ecuador%' or venueName like '%Ecuador%' or enVname like '%Ecuador%' or homeTeamName like '%Ecuador%' or awayTeamName like '%Ecuador%') and b.sportId=34 and b.tournamentId=669 and FIND_IN_SET(395,b.idList) and DATE_FORMAT(vdate, '%m')=11 group by a.gameId order by b.sort asc,vdate asc,vtime asc limit 0,0 MySQL server has gone away Mydiggo.com | Global Events Tickets & Activities default数据库节点，链接失败！