select user.user_id, user.user_name, user_profile.profile_fullname, user_profile.profile_avatar, user_view.view_count
from
user left outer join user_profile
on
user.user_id = user_profile.user_id
left outer join user_view
on
user.user_id = user_view.user_id
where
user.is_active = "1" order by user_view.view_count desc limit 19380, 60