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

清华大佬耗费三个月吐血整理的几百G的资源,免费分享!....>>>

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