select * from estimates, estimate_histories
where AND estimates.deleted != 1
AND estimates.status = 'won'
and estimate_histories.id = (select top 1 id from estimate_histories where estimate_histories ON estimate_histories.estimate_id = estimates.id and estimate_histories.status = estimates.status order by estimate_histories.date)