Mine
public text v1 · immutableSELECT 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;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;