SELECT a.titlesubject, a.status, b.description, b.username, b.email, b.date 
FROM 
(
	SELECT i.titlesubject, s.name AS status, i.index 
	FROM wit_issues i, wit_statuses s, wit_projects p 
	WHERE i.project=p.index 
	AND p.name='ARG[PROJECT_NAME]' 
	AND s.index=i.status
) a, 
(
	SELECT t.description, t.issue, l.username, l.email,t.changedate AS date 
	FROM wit_threads t, login l 
	WHERE threadorder='1' 
	AND t.author=l.index
) b 
WHERE a.index=b.issue 
AND a.status != 'Closed'