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.