X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 4CAE854F2C for ; Tue, 8 Mar 2005 12:35:18 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 50994-07 for ; Tue, 8 Mar 2005 12:35:14 +0000 (GMT) Received: from laughter.local (unknown [61.197.227.146]) by svr1.postgresql.org (Postfix) with ESMTP id 77D3753C92 for ; Tue, 8 Mar 2005 12:35:13 +0000 (GMT) Received: from [127.0.0.1] (localhost [127.0.0.1]) by laughter.local (Postfix) with ESMTP id 513E04C51BC; Tue, 8 Mar 2005 21:35:16 +0900 (JST) In-Reply-To: <200503080628.39117.ler@lerctr.org> References: <200503080548.17179.ler@lerctr.org> <200503080628.39117.ler@lerctr.org> Mime-Version: 1.0 (Apple Message framework v619.2) Content-Type: text/plain; charset=US-ASCII; format=flowed Message-Id: Content-Transfer-Encoding: 7bit Cc: pgsql-sql@postgresql.org From: Michael Glaesemann Subject: Re: Query issue/8.0.1/Serendipity Date: Tue, 8 Mar 2005 21:35:15 +0900 To: Larry Rosenman X-Mailer: Apple Mail (2.619.2) X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.001 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200503/130 X-Sequence-Number: 20609 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_entries e >> LEFT OUTER JOIN serendipity_entryproperties ep_cache_extended So, did this work? Michael Glaesemann grzm myrealbox com