>
> Use LEFT JOINs instead of subqueries, they are sooooo much mrore
> efficient.

thanks, i wouldn't even know how to use them in this case, how can i
specify the ON clause on the result of the UNION statement.
Furthermore, i am actually interested to know why the above query
fails

thanks