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

无详细内容 OSCHINA 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

<无详细内容> OSCHINA

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