Untitled

'LEFT JOIN `opportunities_audit` `oa` ON ' .				'`oa`.`parent_id` = `op`.`id` AND ' .				'`oa`.`before_value_string` = `op`.`sales_stage` AND ' .				'`oa`.`date_created` = (' .					'SELECT ' .					'MAX(`date_created`) `date_created` ' .					'FROM `opportunities_audit` `oa1` ' .					'WHERE ' .						'`oa1`.`parent_id` = `op`.`id` AND ' .						'`oa1`.`before_value_string` = `op`.`sales_stage`' .				') ' .