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 FROM mylime_register a WHERE a.status = '1' AND a.profile_type='public' AND a.location='Other' ORDER BY id DESC, user_views DESC LIMIT 0,10