....
Please note the importance of good code formatting - it making the code much easier to read.
Also, I would classify your query as "noodles" and suggest refactoring your inner selects (subqueries) into LEFT JOIN's as all of them must return maximum single match (otherwise they wouldn't work).
************************************************************************
Code is removed.
Look's like OP is in trouble for posting the real one...
_____________________________________________
"The only true wisdom is in knowing you know nothing"
"O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
(So many miracle inventions provided by MS to us...)
How to post your question to get the best and quick help[/url]