Apnea ranking
Query failed(showrank.php): SELECT Pid,pd.Gender,Firstname,Lastname,pd.Country,ap,rp,Result,Outcome,Notes,Date(StartDay) as Date,comp.Name as CompName,comp.idCompetitions FROM ( SELECT DISTINCT PersonData_idPersonData FROM Starts ) as md JOIN Starts as st ON st.idStarts = ( SELECT idStarts FROM Starts as topStart left join subCompetition as sub on topStart.SubCompetition_idSubCompetition= sub.idSubCompetition WHERE topStart.PersonData_idPersonData = md.PersonData_idPersonData and sub.CompetitionsTypes_idCompetitionsTypes= 3 ORDER BY Result desc,ABS(AP-RP) asc LIMIT 1 ) join subCompetition as sub on st.SubCompetition_idSubCompetition= sub.idSubCompetition join Competitions as comp on sub.Competitions_idCompetitions= comp.idCompetitions join PersonData as pd on st.PersonData_idPersonData= pd.idPersonData where 1 and pd.Gender= 'F' order by st.Result desc,ABS(AP-RP) asc limit 30
MySQL server has gone away