[support] Issue with a Query that's running wild

[Earnie Boyd]

Quoting Allen Stern <allen at centernetworks.com>:

> My hoster is telling me that the query below is processing 52 million
> records every time it's run. Any ideas on where this query is, what it
> does or how to fix it would very much be appreciated. I have not changed
> anything in the installation in forever. The host thinks that the more
> content I write, somehow the query was pushed over the limit for warnings.
>
> QUERY:
> SELECT n.nid, n.type, n.status, n.promote, n.changed, u.dst FROM node n
> LEFT JOIN url_alias u ON u.src=CONCAT('node/',n.nid)
>

This query needs a "WHERE n.nid = %d" added to it.  What version of 
Drupal?  What modules?

Earnie -- http://for-my-kids.com/
-- http://give-me-an-offer.com/