Untitled

   SELECT assignee.usr_full_name as assignee_name
        , reporter.usr_full_name as reporter_name
        , iss_id, iss_summary
        , sta_title
        , iss_sta_id
        , iss_created_date
        , iss_updated_date
        , iss_last_response_date
        , sta_color 
     FROM ( eventum.eventum_issue
        , eventum.eventum_issue_user
        , eventum.eventum_user as assignee
        , eventum.eventum_user as reporter ) 
LEFT JOIN eventum.eventum_status ON iss_sta_id=sta_id 
    WHERE sta_is_closed=0 
      AND iss_prj_id=1 AND iss_id=isu_iss_id 
      AND isu_usr_id=assignee.usr_id 
      AND iss_usr_id=reporter.usr_id 
      AND UNIX_TIMESTAMP(iss_created_date) < (UNIX_TIMESTAMP() - 604800) 
 ORDER BY assignee.usr_full_name