列出 OSCHINA 被收藏最多的前 10 个软件

SELECT p.name FROM osc_favorites f, osc_projects p WHERE f.obj_id = p.id AND f.type = 1 GROUP by f.obj_id ORDER BY count(f.obj_id) DESC LIMIT 10

编程技巧