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.user_type LIKE '%Promoter/Dj%' ORDER BY rate_num DESC LIMIT 0,10