SELECT s.storyID, s.authorHtml, s.heading, s.summary, s.subheading, s.productParent, s.sku, s.filename, s.body, count( * ) AS score, u.userID, u.fname, u.lname, s.productIDlook, datecreate, s.discussionCount, s.activityCount, s.screamer FROM story s INNER JOIN user u ON userIDlook=u.userID INNER JOIN storyxmetadata x ON s.storyid = x.storyidlook WHERE s.privatedocuments LIKE 'n' AND s.deprecated like 'n' AND s.allowbrowse LIKE 'y' GROUP BY s.storyID having score>=0 ORDER BY s.presentationOrder DESC, s.datecreate DESC