You are here

function og_views_handler_field_og_post_count::query in Organic groups 6

Same name and namespace in other branches

6.2 modules/og_views/includes/og_views_handler_field_og_post_count.inc \og_views_handler_field_og_post_count::query()

File

modules/og_views/includes/og_views_handler_field_og_post_count.inc, line 6

Class

og_views_handler_field_og_post_count: We do not try to run db_rewrite_sql() on this subquery so the count is potentially more than the user can see.

Code

function query() {
  $table = $this->query
    ->ensure_table('og');
  $sql = "SELECT COUNT(n.nid) FROM {node} n INNER JOIN {og_ancestry} oga ON n.nid = oga.nid WHERE n.status = 1 AND oga.group_nid = %d";
  $sql = str_replace('%d', 'og.nid', $sql);
  $this->query
    ->add_field('', "({$sql})", 'post_count');
  $this->field_alias = 'post_count';
}