Re: Query issue/8.0.1/Serendipity

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(at)lerctr(dot)org
US Mail: 3535 Gaspar Drive, Dallas, TX 75220-3611