SELECT * FROM mylime_register where status='1' AND profile_type='public' ORDER BY user_views LIMIT 0,10