Without looking too deeply, because I don't have the time right now. You should get a performance boost by removing the ORDER BY's
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. Selburg