drupal node 节点 点击量 排序 有大用 有大大用

drupal节点按点击量排序

SELECT DISTINCT(n.nid), n.sticky, n.title, n.created, nm.totalcount FROM node n INNER JOIN term_node tn ON n.vid = tn.vid LEFT JOIN node_counter nm ON n.nid=nm.nid WHERE n.status = 1 ORDER BY n.created DESC ,nm.totalcount DESC

来自 http://hi.baidu.com/097633/item/00c9cec568d73946a8ba9454