rendered paste body $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 ";