Unnamed

SELECT
                    sta_title,
                    count(DISTINCT iss_id) as total
                 FROM
                    eventum.eventum_issue,
                    eventum.eventum_status,
                    eventum.eventum_issue_history
                 WHERE
                    his_iss_id = iss_id AND
                    iss_sta_id = sta_id AND
                    iss_prj_id = 1 AND
                    his_usr_id = 2 AND
                    his_created_date BETWEEN '2011-05-22 22:00:00' AND '2011-05-29 21:59:59'
                 GROUP BY
                    sta_title
                 ORDER BY
                    sta_rank