[drupal-devel] rewrite node queries

[Andre Molnar]

 From node/12347

last line:
..."this way nid can be replaced with DISTINCT(nid) should there be a 
need for it."

maybe should read:

this way the node_rewrite_sql() function can rewrite the query to use 
DISTINCT(nid) should there be a need for it.

This adds clarity to those that aren't familiar with the recent changes.
I would edit the handbook myself - but edit option is gone from handbook 
again.

andre

Dries Buytaert wrote:
> Dries Buytaert wrote:
> 
>> I just committed chx's node query rewrite patch.  If your module 
>> queries the node table, you might want to look into issue #14731 
>> (http://drupal.org/node/14731) and update your module accordingly.
>>
>> In short, you should no longer use node_access_join_sql() or 
>> node_access_where_sql() but wrap your query in a call to 
>> node_rewrite_sql().
>>
>> I hope chx will update the upgrade-page in the module developers guide.
> 
> 
> Chx sent me a snippet which I added to the upgrade guide (after I made 
> some modifications): http://drupal.org/node/12347.
>