On Tuesday 08 March 2005 06:35 am, Michael Glaesemann wrote: > On Mar 8, 2005, at 21:28, Larry Rosenman wrote: > > On Tuesday 08 March 2005 06:21 am, Michael Glaesemann wrote: > >> Larry, > >> > >> Restating your SQL in a more reader-friendly form: > > > > [snip] > > > > 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_entriess e > >> LEFT OUTER JOIN serendipity_entryproperties ep_cache_extended > > So, did this work? Yes, as I stated in another post.
I've reported it to the Serendipity folks (as I'm not sure where the query is coming from. Thanks (to all, btw). LER > > Michael Glaesemann > grzm myrealbox com -- Larry Rosenman http://www.lerctr.org/~ler Phone: +1 214-351-4152 E-Mail: ler@lerctr.org US Mail: 3535 Gaspar Drive, Dallas, TX 75220-3611 ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
