- SELECT DISTINCT(node.nid), comments.timestamp AS comments_timestamp_timestamp, node.title AS node_title, node.changed AS node_changed FROM node node LEFT JOIN comments comments ON node.nid = comments.nid WHERE (node.status = '1') AND (node.type IN ('link')) AND (.uid IS NOT NULL '***ANY_USER***') GROUP BY node.nid, node.nid, comments_timestamp_timestamp ORDER BY comments_timestamp_timestamp DESC LIMIT 0, 3
