SELECT
	r.daros_number,
	r.date_issued,
	r.date_cancelled,
	r.forecast_date_issued,
	r.forecast_date_cancelled,
	op_region.name op_region_name,
	op_area.name op_area_name,
	zone.name zone_name,
	priority.name priority_name,
	status.name status_name,
	job_category.name job_category_name,
	job_type.name job_type_name,
	r.ophours
FROM 
	forecast_requests r
	JOIN operating_areas op_area ON op_area.id = r.operating_area_id
	JOIN operating_regions op_region ON op_region.id = op_area.op_region_id
	JOIN zones zone ON zone.id = r.zone_id
	LEFT JOIN priorities priority ON priority.id = r.priority_id
	LEFT JOIN statuses status ON status.id = r.status_id
	LEFT JOIN job_categories job_category ON job_category.id = r.job_category_id
	LEFT JOIN job_types job_type ON job_type.id = r.job_type_id
WHERE 
	r.date_issued >= '2013-01-01'