On Wed, Oct 20, 2010 at 11:05 PM, Tim Uckun <timuckun@gmail.com> wrote:
>>
>> No, it isn't. This is a three-way join between consolidated_urls, cu,
>> and tu --- the fact that cu is the same underlying table as
>
> cu is an alias for consolidated_urls. tu is an alias for trending_urls.
>
> There are only two tables in the query.
What does
explain update (your query continues) say about it? I'm betting you
get a nice big row count in there somewhere.