Skip navigation
Help

_node_access_join_sql

6 node.module _node_access_join_sql($node_alias = 'n', $node_access_alias = 'na')

Generate an SQL join clause for use in fetching a node listing.

Parameters

$node_alias: If the node table has been given an SQL alias other than the default "n", that must be passed here.

$node_access_alias: If the node_access table has been given an SQL alias other than the default "na", that must be passed here.

Return value

An SQL join clause.

Related topics

1 call to _node_access_join_sql()

File

drupal/modules/node/node.module, line 2091
The core that allows content to be submitted to the site. Modules and scripts may programmatically submit nodes using the usual form API pattern.

Code

function _node_access_join_sql($node_alias = 'n', $node_access_alias = 'na') {
  if (user_access('administer nodes')) {
    return '';
  }

  return 'INNER JOIN {node_access} ' . $node_access_alias . ' ON ' . $node_access_alias . '.nid = ' . $node_alias . '.nid';
}