Two Left Joins = Connection Reset Error

[eluser]yacman[/eluser]
If the raw sql produces the same disconnect, then you need to check your database logs. Most likely you are running into a memory or disk space issue that kills the connection due timeout.

Can you run the sql from the mysql command prompt and see the execution time or how much data is being generated?