Hello Dan,
ooops I forgot to mention that I enhanced general_comments with comment_type. It is 1 for an opinion, 2 for a comment 3 for an advice and 4 for an article...
general_bewertung (=how valued) and general_gelesen (=how many times read) don't belong to openacs either.
What information would you additionally need?
Is it normal that the subselect can't find the gc.user_id and gc.comment_type from general_comments above?