On Mar 8, 2005, at 21:28, Larry Rosenman wrote:
On Tuesday 08 March 2005 06:21 am, Michael Glaesemann wrote:[snip]Larry,
Restating your SQL in a more reader-friendly form:This is from an error page (and machine generated to boot :) )
Regardless if it's machine-generated or not, I'd still reformat it so I could read it more easily, and definitely before sending it to a mailing list to ask for advice. But that's me.
I can see you're using a lot of left joins. You are beginning your left
joins off of ec, so I believe neither e nor c can be referenced as join
conditions. It might work if you reorder the first part of the FROM
clause as the following:
FROM serendipity_category c , serendipity_entrycat ec , serendipity_entries e LEFT OUTER JOIN serendipity_entryproperties ep_cache_extended
So, did this work?
Michael Glaesemann grzm myrealbox com
---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
