EFC Cadet Performance Percentages about web HOT 6 CLOSED

SELECT results.fencerID, fencerFirstname, fencerSurname, yob, clubName, efr, count(*) AS comps,  SUM((100 / entries) * eventPosition) / count(*) AS InterPerc
FROM results 
LEFT OUTER JOIN eventData ON eventData.eventID = results.eventID AND eventData.dateID = results.dateID
LEFT OUTER JOIN fencers ON fencers.ID = results.fencerID 
LEFT OUTER JOIN events ON events.ID = results.eventID     
LEFT JOIN clubs ON clubs.ID = (SELECT clubs.ID FROM results AS r 
                                                                  INNER JOIN clubs ON r.fencerClubID = clubs.ID 
                                                                  INNER JOIN eventDates ON r.dateID = eventDates.ID 
                                                                  WHERE fencers.ID = r.fencerID AND cty = 1
                                                                  ORDER BY eventDates.fullDate DESC LIMIT 0,1)
WHERE eventData.catID = 6 AND results.eventCat = 6 AND (fencers.country IN ('ENG', 'SCO', 'WAL', 'GBR', 'NIR', 'GUE') OR clubName = 'Great Britain')
AND eventType = 'EFC'
GROUP BY results.fencerID
ORDER BY InterPerc ASC

SELECT results.fencerID, fencerFirstname, fencerSurname, yob, clubName, efr, count(*) AS comps,  SUM((100 / entries) * eventPosition) / count(*) AS InterPerc
FROM results 
INNER JOIN eventData ON eventData.eventID = results.eventID AND eventData.dateID = results.dateID
INNER JOIN fencers ON fencers.ID = results.fencerID 
INNER JOIN events ON events.ID = results.eventID     
LEFT JOIN clubs ON clubs.ID = results.fencerClubID
WHERE eventData.catID = 6 AND results.eventCat = 6 
AND (clubName = 'Great Britain')
AND eventType = 'EFC'
GROUP BY results.fencerID  
ORDER BY `InterPerc` ASC

SELECT
 results.fencerID, fencerFirstname, fencerSurname, yob, clubName, efr, count(*) AS comps,  
 SUM((100 / entries) * eventPosition) / count(*) AS InterPerc
FROM results 
INNER JOIN eventData ON eventData.eventID = results.eventID AND eventData.dateID = results.dateID
INNER JOIN eventDates ON eventDates.eventID = eventData.eventID AND eventDates.ID = results.dateID
INNER JOIN fencers ON fencers.ID = results.fencerID 
INNER JOIN events ON events.ID = results.eventID     
LEFT JOIN clubs ON clubs.ID = results.fencerClubID
WHERE eventData.catID = 6 AND results.eventCat = 6 AND (clubName = 'Great Britain') AND eventType = 'EFC' 
  AND (fullDate > '2018-04-20' AND fullDate < '2019-04-20')
GROUP BY results.fencerID