Refactor Query...

hi all,

i'm trying to refactor this query:

http://www.rafb.net/paste/results/RnkFWZ46.html

i've added notes to make its function a bit more
clear.  i have trie dto refactor it to get rid of the
"distinct on" function, but i've had no luck.

due to all the WHERE clauses, i can't figure out how
to do an inner join with something like this:

select max(t_inspect_result.inspect_result_timestamp)  as mstamp,  t_inspect_result.inspect_id
from t_inspect_result
group by t_inspect_result.inspect_id
) AS b

thanks in advance...

__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com