[eluser]Narkboy[/eluser]
I try to avoid using alias' in querys. It's a pain to type more, but it does cause readability and debugging problems. In a years time, the alias version will be meaningless but a full text version will still be clear.
That said - some joins just beg to be abbreviated!!!