I am trying to create a list of entries in a weblog, sorted by both latest comment, and when the original entry was made - I have used the query from http://ellislab.com/forums/viewthread/82670/ and this sorts in the correct order.
However, it doesn’t include all the fields I need - and editing just gives me lots of SQL errors (I am not a natural coder!). I additionally need the url_title, author, author_id, and comment_total. Can anyone help me with how to include these fields?!