
				SELECT *, project_resource.id AS project_resource_id, project_resource.status AS project_resource_status, resource.currency AS resource_currency,
				CONCAT(first_name, ' ', last_name) AS the_name
				FROM project_resource, project, resource
				WHERE project.id = project_resource.project
				AND resource.id = project_resource.resource
				AND project.id = 14447
				AND project_resource.status IN ('Candidate', 'Bid', 'Declined')
				ORDER BY last_name, first_name
			