Ok here are the 2 querys that are suverly slowing down my website
SELECT jos_eventlist_dates.ID AS catID, TLD, SUBSTRING(countrys.Name,1,21) AS Name, (SELECT count(catsid) FROM jos_eventlist_dates WHERE countrys.TLD = jos_eventlist_dates.locationcountry && published = 1 && unix_timestamp(enddates) >= '1195974000') AS numEvents FROM countrys LEFT JOIN jos_eventlist_dates ON countrys.TLD = locationcountry GROUP BY Name ORDER BY Name ASC
and
SELECT jos_eventlist_categories.id AS catID, jos_eventlist_categories.catname AS catName, (SELECT count(catsid) FROM jos_eventlist_dates WHERE jos_eventlist_dates.catsid = jos_eventlist_categories.id && published = 1 && unix_timestamp(enddates) >= '1195974000') AS numEvents FROM jos_eventlist_categories LEFT JOIN jos_eventlist_dates ON jos_eventlist_categories.id = jos_eventlist_dates.catsid GROUP BY catname ORDER BY catname ASC
Any Advice would be appreciated