
			
		SELECT *,
		project.id AS project_id,
		project.status AS project_status,
		project.verify_code AS project_verify_code,
		DATE_FORMAT(project.createdTS, '%b %e %Y') AS my_date
	,
				project_resource.id AS project_resource_id,
				project_resource.status AS project_resource_status,
				project_resource.verify_code AS project_resource_verify_code
			FROM
				project, project_resource
			WHERE
				project.status = 'Begun' AND project_resource.status = 'Selected'
		AND (parent_project IS NULL OR parent_project = '')
		AND (project.status <> 'Cancel' OR cancellation_confirmed IS NULL)
	
				AND
				project.id = project_resource.project
				AND
				resource = 11480
			ORDER BY project.status_changed DESC