SELECT a.id, a.fname, a.lname,a.rated_user,a.user_views, a.user_type,a.image, a.one_star + a.two_star + a.three_star + a.four_star + a.five_star AS rate, a.staff_pick,a.one_star , a.two_star ,a.three_star , a.four_star , a.five_star, a.status , count( b.fav_id ) AS fav FROM `mylime_register` a , mylime_user_favorite b WHERE a.status = '1' AND a.id=b.fav_id AND a.profile_type='public' GROUP BY b.fav_id ORDER BY fav DESC LIMIT 0,10