$sql = "SELECT DISTINCT n.uid, n.nid, n.title, n.created, n2.title group_title, n2.nid group_nid,  " .
               " (SELECT max(c.timestamp) FROM comments c WHERE c.nid = n.nid) timestamp, " .
               " (SELECT count(*) FROM comments c WHERE c.nid = n.nid) comments, " .
               " (SELECT uid FROM comments c WHERE c.nid = n.nid ORDER BY c.timestamp LIMIT 1) last_uid " .
               "FROM {forum} f " .
               "LEFT JOIN {node} n ON f.nid = n.nid " .
               "LEFT JOIN {comments} c ON f.nid = c.nid " .
               "LEFT JOIN {term_node} tn ON tn.nid = n.nid " .
               "LEFT JOIN {og_ancestry} oga ON n.nid = oga.nid " .
               "LEFT JOIN {node} n2 ON n2.nid = oga.group_nid " .
               "WHERE tn.tid = %d " .
               "ORDER BY timestamp DESC, n.created DESC ";