I would break it down into smaller pieces.
>It is at the end of whole statement just before results and group by.
>
>I don't usually get this detailed either, I am converting someone else's code.
>
>Now that I think of it I don't know what the word results at the end means.
>
>Thanks for your help.
'If the people lead, the leaders will follow'
'War does not determine who is RIGHT, just who is LEFT'