>How many subquery can be written in one select command.
>
>Yours
>Nafees

Not sure there is a limit, just takes a fair bit of memory, and time