$query = "SELECT user.,count() as fanscount FROM user,fans WHERE fans.uid = user.uid GROUP BY fans.uid ORDER BY fanscount DESC LIMIT 10";
user(uid,name)
fans(uid,…)
统计每个用户的粉丝数,并按粉丝数排序(多的在前),取前10.
$query = "SELECT user.,count() as fanscount FROM user,fans WHERE fans.uid = user.uid GROUP BY fans.uid ORDER BY fanscount DESC LIMIT 10";
user(uid,name)
fans(uid,…)
统计每个用户的粉丝数,并按粉丝数排序(多的在前),取前10.
user做个relation,count fans的量。但不清楚是否可以排序。