select * from ((
			SELECT
				b.l_id,
				b.l_desc,
				e.lt_id,
				e.lt_desc,
				c.*
			FROM
			location_value_rels AS a
			LEFT JOIN location_values AS b ON b.l_id = a.c_l_id AND b.lt_id = a.c_lt_id
			LEFT JOIN (
				SELECT 
					cc.loc_id, 
					cc.loc_type,
					cc.time_period,
					cc.sld_total_sp,
					dd.sld_total_sp AS ytd_sld_total_sp,
					cc.num_sold_listings,
					dd.num_sold_listings AS ytd_num_sold_listings,
					cc.num_new_listings,
					dd.num_new_listings AS ytd_num_new_listings,
					cc.num_active_listings,
					dd.num_active_listings AS ytd_num_active_listings,
					cc.num_pending_listings,
					dd.num_pending_listings AS ytd_num_pending_listings,
					cc.num_new_pending_listings,
					dd.num_new_pending_listings AS ytd_num_new_pending_listings,
					cc.sld_med_lp,
					dd.sld_med_lp AS ytd_sld_med_lp,
					cc.sld_avg_lp,
					dd.sld_avg_lp AS ytd_sld_avg_lp,
					cc.sld_avg_sp_per_sqft,
					dd.sld_avg_sp_per_sqft AS ytd_sld_avg_sp_per_sqft,
					cc.sld_med_lp_per_sqft,
					dd.sld_med_lp_per_sqft AS ytd_sld_med_lp_per_sqft,
					cc.sld_avg_lp_per_sqft,
					dd.sld_avg_lp_per_sqft AS ytd_sld_avg_lp_per_sqft,
					cc.sld_med_sp,
					dd.sld_med_sp AS ytd_sld_med_sp,
					cc.sld_avg_sp,
					dd.sld_avg_sp AS ytd_sld_avg_sp,
					cc.sld_med_days_to_settle,
					dd.sld_med_days_to_settle AS ytd_sld_med_days_to_settle,
					cc.sld_avg_days_to_settle,
					dd.sld_avg_days_to_settle AS ytd_sld_avg_days_to_settle,
					cc.sld_med_sp_per_sqft,
					dd.sld_med_sp_per_sqft AS ytd_sld_med_sp_per_sqft,
					cc.sld_avg_sp_to_olp_ratio,
					dd.sld_avg_sp_to_olp_ratio AS ytd_sld_avg_sp_to_olp_ratio,
					cc.sld_med_days_to_contract,
					dd.sld_med_days_to_contract AS ytd_sld_med_days_to_contract,
					cc.sld_avg_days_to_contract,
					dd.sld_avg_days_to_contract AS ytd_sld_avg_days_to_contract,				 
				  cc.sld_med_dom,
				  dd.sld_med_dom AS ytd_sld_med_dom,
				  cc.sld_avg_dom,
				  dd.sld_avg_dom AS ytd_sld_avg_dom
				FROM facet_aggregations AS cc
				JOIN facet_aggregations_ytd AS dd
					ON dd.loc_id = cc.loc_id AND dd.loc_type = cc.loc_type AND dd.time_period = cc.time_period AND dd.f_id = cc.f_id
				WHERE cc.f_id = 1000 AND cc.loc_type = 4 AND (cc.time_period = 201606 OR cc.time_period = 201506)
				AND cc.loc_id IN (
						SELECT c_l_id FROM location_value_rels WHERE p_l_id = 1000 AND p_lt_id = 1 AND c_lt_id = 4
				) 
			) AS c ON c.loc_id = b.l_id AND c.loc_type = b.lt_id
			LEFT JOIN location_types AS e ON e.lt_id = b.lt_id
			WHERE a.p_l_id = 1000 AND a.p_lt_id = 1 AND a.c_lt_id = 4
			ORDER BY
					b.l_id,
					c.time_period
			) union (
			SELECT
				 b.l_id,
				 b.l_desc,
				 e.lt_id,
				 e.lt_desc,
				
				 c.loc_id, 
				 c.loc_type,
				 c.time_period,
				 c.sld_total_sp,
				 d.sld_total_sp AS ytd_sld_total_sp,
				 c.num_sold_listings,
				 d.num_sold_listings AS ytd_num_sold_listings,
				 c.num_new_listings,
				 d.num_new_listings AS ytd_num_new_listings,
				 c.num_active_listings,
				 d.num_active_listings AS ytd_num_active_listings,
				 c.num_pending_listings,
				 d.num_pending_listings AS ytd_num_pending_listings,
				 c.num_new_pending_listings,
				 d.num_new_pending_listings AS ytd_num_new_pending_listings,
				 c.sld_med_lp,
				 d.sld_med_lp AS ytd_sld_med_lp,
				 c.sld_avg_lp,
				 d.sld_avg_lp AS ytd_sld_avg_lp,
				 c.sld_avg_sp_per_sqft,
				 d.sld_avg_sp_per_sqft AS ytd_sld_avg_sp_per_sqft,
				 c.sld_med_lp_per_sqft,
				 d.sld_med_lp_per_sqft AS ytd_sld_med_lp_per_sqft,
				 c.sld_avg_lp_per_sqft,
				 d.sld_avg_lp_per_sqft AS ytd_sld_avg_lp_per_sqft,
				 c.sld_med_sp,
				 d.sld_med_sp AS ytd_sld_med_sp,
				 c.sld_avg_sp,
				 d.sld_avg_sp AS ytd_sld_avg_sp,
				 c.sld_med_days_to_settle,
				 d.sld_med_days_to_settle AS ytd_sld_med_days_to_settle,
				 c.sld_avg_days_to_settle,
				 d.sld_avg_days_to_settle AS ytd_sld_avg_days_to_settle,
				 c.sld_med_sp_per_sqft,
				 c.sld_med_sp_per_sqft AS ytd_sld_med_sp_per_sqft,
				 c.sld_avg_sp_to_olp_ratio,
				 d.sld_avg_sp_to_olp_ratio	AS ytd_sld_avg_sp_to_olp_ratio,
				 c.sld_med_days_to_contract,
				 d.sld_med_days_to_contract AS ytd_sld_med_days_to_contract,
				 c.sld_avg_days_to_contract,
				 d.sld_avg_days_to_contract AS ytd_sld_avg_days_to_contract,				 
				 c.sld_med_dom,
				 d.sld_med_dom AS ytd_sld_med_dom,
				 c.sld_avg_dom,
				 d.sld_avg_dom AS ytd_sld_avg_dom
				 
				FROM
				 
					location_values AS b 
					LEFT JOIN facet_aggregations AS c ON 
						c.loc_id = b.l_id AND 
						c.loc_type = b.lt_id
					JOIN facet_aggregations_ytd AS d ON 
						d.loc_id = c.loc_id AND 
						d.loc_type = c.loc_type AND 
						d.time_period = c.time_period AND 
						d.f_id = c.f_id
					JOIN location_types AS e ON 
						e.lt_id = b.lt_id
				WHERE
				 c.f_id = 1000
				AND c.loc_type = 1
				AND b.l_id = 1000
				AND(
			c.time_period = 201606 OR c.time_period = 201506)   
				ORDER BY b.l_id, c.time_period								 
			) union (
			SELECT
				 b.l_id,
				 b.l_desc,
				 e.lt_id,
				 e.lt_desc,
				
				 c.loc_id, 
				 c.loc_type,
				 c.time_period,
				 c.sld_total_sp,
				 d.sld_total_sp AS ytd_sld_total_sp,
				 c.num_sold_listings,
				 d.num_sold_listings AS ytd_num_sold_listings,
				 c.num_new_listings,
				 d.num_new_listings AS ytd_num_new_listings,
				 c.num_active_listings,
				 d.num_active_listings AS ytd_num_active_listings,
				 c.num_pending_listings,
				 d.num_pending_listings AS ytd_num_pending_listings,
				 c.num_new_pending_listings,
				 d.num_new_pending_listings AS ytd_num_new_pending_listings,
				 c.sld_med_lp,
				 d.sld_med_lp AS ytd_sld_med_lp,
				 c.sld_avg_lp,
				 d.sld_avg_lp AS ytd_sld_avg_lp,
				 c.sld_avg_sp_per_sqft,
				 d.sld_avg_sp_per_sqft AS ytd_sld_avg_sp_per_sqft,
				 c.sld_med_lp_per_sqft,
				 d.sld_med_lp_per_sqft AS ytd_sld_med_lp_per_sqft,
				 c.sld_avg_lp_per_sqft,
				 d.sld_avg_lp_per_sqft AS ytd_sld_avg_lp_per_sqft,
				 c.sld_med_sp,
				 d.sld_med_sp AS ytd_sld_med_sp,
				 c.sld_avg_sp,
				 d.sld_avg_sp AS ytd_sld_avg_sp,
				 c.sld_med_days_to_settle,
				 d.sld_med_days_to_settle AS ytd_sld_med_days_to_settle,
				 c.sld_avg_days_to_settle,
				 d.sld_avg_days_to_settle AS ytd_sld_avg_days_to_settle,
				 c.sld_med_sp_per_sqft,
				 c.sld_med_sp_per_sqft AS ytd_sld_med_sp_per_sqft,
				 c.sld_avg_sp_to_olp_ratio,
				 d.sld_avg_sp_to_olp_ratio	AS ytd_sld_avg_sp_to_olp_ratio,
				 c.sld_med_days_to_contract,
				 d.sld_med_days_to_contract AS ytd_sld_med_days_to_contract,
				 c.sld_avg_days_to_contract,
				 d.sld_avg_days_to_contract AS ytd_sld_avg_days_to_contract,				 
				 c.sld_med_dom,
				 d.sld_med_dom AS ytd_sld_med_dom,
				 c.sld_avg_dom,
				 d.sld_avg_dom AS ytd_sld_avg_dom

				FROM
				 	facet_aggregations AS c
					JOIN location_values AS b ON 
						b.l_id = c.loc_id
					JOIN facet_aggregations_ytd AS d ON 
						d.loc_id = c.loc_id AND 
						d.loc_type = c.loc_type AND 
						d.time_period = c.time_period AND 
						d.f_id = c.f_id
					JOIN location_types AS e ON 
						e.lt_id = b.lt_id
				WHERE
				c.f_id = 1000 
				AND c.loc_type = 4
				AND c.loc_id IN (SELECT l_id FROM location_values where lt_id = 4)
				AND(
			c.time_period = 201606 OR c.time_period = 201506)   
				ORDER BY c.loc_id, c.time_period								 
			)) as zz order by zz.l_id