SELECT DISTINCT	pw.wbs_id,
		pw.proj_id,
		pw.obs_id,
		pw.status_code,
		pw.seq_num,
		pw.wbs_short_name,
		pw.wbs_name,
		pw.parent_wbs_id,
		pw.proj_node_flag 
FROM		projwbs as pw
LEFT JOIN	(
			SELECT		proj_id 
			FROM		UACCESS
			WHERE		USER_ID = 583
					AND ACCESS_FLAG = 'Y'
			GROUP BY	proj_id
		) AS s ON s.proj_id = pw.proj_id
LEFT JOIN	(
			SELECT		t.wbs_id
			FROM		task as t
			INNER JOIN	taskrsrc AS tr ON tr.task_id = t.task_id
			INNER JOIN	rsrc AS r ON r.rsrc_id = tr.rsrc_id
			WHERE		r.ts_approve_user_id = '583'
			GROUP BY	t.wbs_id
		) AS t ON t.wbs_id = pw.wbs_id
WHERE		s.proj_id IS NOT NULL
		OR t.wbs_id IS NOT NULL
ORDER BY	pw.wbs_id