Club Drupal

  if ($entity_type == 'comment') {

    // Adding the 'comment_access' tag is sadly insufficient for comments: core


    // requires us to also know about the concept of 'published' and


    if (!user_access('administer comments')) {

      $query->condition('comment.status', COMMENT_PUBLISHED);

    }

    // Join to a node if the user does not have node access bypass permissions


    if (!user_access('bypass node access')) {

      $node_alias = $query->innerJoin('node', 'n', '%alias.nid = comment.nid');

      $query->condition($node_alias . '.status', NODE_PUBLISHED);