
	SELECT
		project.id AS project_id, project.service, project.number_of_words, project.title, project.staff, project.client_draft_deadlineMonth, project.client_draft_deadlineYear, project.client_draft_deadlineDay, project.client_draft_deadline_hour, project.resource_draft_deadlineMonth, project.resource_draft_deadlineYear, project.resource_draft_deadlineDay, project.resource_draft_deadline_hour,
		CONCAT(client.first_name, ' ', client.last_name) AS client_name,
		CONCAT(staff.first_name, ' ', staff.last_name) AS staff_name,
		CONCAT(resource.first_name, ' ', resource.last_name) AS resource_name
	FROM client, staff, project
	LEFT JOIN project_resource ON project_resource.project = project.id AND project_resource.status = 'Selected'
	LEFT JOIN resource ON resource.id = project_resource.resource
	WHERE project.client = client.id
	AND project.staff = staff.id
	AND project.status in ('Approved', 'Begun')
	ORDER BY client_draft_deadlineYear, client_draft_deadlineMonth, client_draft_deadlineDay
