SELECT COUNT(refnum) as num FROM properties AS p WHERE active = 1 GROUP BY 'a'SELECT COUNT(refnum) as num FROM properties AS p WHERE active = 1 GROUP BY 'a'SELECT COUNT(refnum) as num FROM properties p WHERE active = 1 AND ( countryID = 23 ) AND (p.holidaytype LIKE ('%#20#%')) GROUP BY 'a'