SELECT st.name, COUNT( e.email_id ) sent 
FROM site_table st 
LEFT JOIN email e ON (st.site_id = e.site_id) 
WHERE e.last_modified > '2007-12-01 00:00:00' AND e.email_status_id = 4 GROUP BY st.name ORDER BY sent DESC;