it is continue from SELECT multiple column values - #24 by khtan
I am sorry if this sounds rude. But If you want others to help you, please post sample data and expected output. We have no idea how your table looks like and what are the data in there. Not to mention your query joins several table. By posting just a query we simply does not have sufficient information to help you.