Can you please simplify the query (remove all unions) and test each sub-union query? This will enable to you view each query in the visual editor and it will tell you if there is a problem. When all 4 of the queries work correctly, then you can union them together.
Does that make sense? It'll also help us to help you troubleshoot the problem.
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.