Event % year on year entries change about web HOT 3 OPEN

SELECT eventData.eventID, eventName, 
SUM(CASE WHEN year = 2018 AND catID = 25 THEN entries ELSE 0 END),
SUM(CASE WHEN year = 2018 AND catID = 26 THEN entries ELSE 0 END),
SUM(CASE WHEN year = 2019 AND catID = 25 THEN entries ELSE 0 END),
SUM(CASE WHEN year = 2019 AND catID = 26 THEN entries ELSE 0 END)
FROM eventData
INNER JOIN eventDates ON eventDates.ID = dateID
INNER JOIN events ON events.ID = eventData.eventID
WHERE (catID= 25 OR catID= 26) AND (year = 2018 or year = 2019)
GROUP BY eventData.eventID

from web.

Unrelated, but dumping here;

SELECT clubName, count(*)
FROM results
INNER JOIN eventData ON eventData.eventID = results.eventID AND eventData.dateID = results.dateID
INNER JOIN eventDates ON eventDates.ID = results.dateID
INNER JOIN events ON events.ID = eventData.eventID
INNER JOIN clubs ON clubs.ID = fencerClubID
WHERE year = 2019 AND cty = 0 AND sch = 0 AND uni = 0 AND region = 0
GROUP BY clubName
ORDER BY count(*) DESC

from web.

SELECT clubName, count()
FROM results
INNER JOIN eventData ON eventData.eventID = results.eventID AND eventData.dateID = results.dateID AND eventData.catID = results.eventCat
INNER JOIN eventDates ON eventDates.ID = results.dateID
INNER JOIN events ON events.ID = eventData.eventID
INNER JOIN clubs ON clubs.ID = fencerClubID
WHERE year = 2019 AND cty = 0 AND sch = 0 AND uni = 0 AND region = 0 AND results.eventCat IN (10,11,8,15,3,17,5,13,9,12,7,16,4,18,1,14)
GROUP BY clubName
ORDER BY count() DESC

from web.