Re: Need help optimizing this query

On Jul 18, 2007, at 16:12 , Pat Maddox wrote:

> ERROR:  invalid reference to FROM-clause entry for table "video_views"
> LINE 20: JOIN assets ON (video_views.video_id=videos.id)
>                         ^
> HINT:  There is an entry for table "video_views", but it cannot be
> referenced from this part of the query.

It's because I mismatched the JOIN clauses during my copy-and-paste :(

> On 7/18/07, Michael Glaesemann <grzm@seespotcode.net> wrote:

>> FROM video_views
>> JOIN assets ON (video_views.video_id=videos.id)
>> JOIN videos ON (video_views.asset_id=assets.id)

This should be

FROM video_views
JOIN assets ON (video_views.asset_id=assets.id)
JOIN videos ON (video_views.video_id=videos.id)

Do you have the EXPLAIN ANALYE output of the query?

Michael Glaesemann
grzm seespotcode net