Mysq сортировка с группировкой

Есть запрос

SELECT
  star_user.id AS id,
  star_user.last_name AS last_name,
  star_user.first_name AS first_name,
  star_user.username AS username,
  star_user.email AS email,
  star_user.dtb AS dtb,
  star_user.sex AS sex,
  star_user.flg_expert AS flg_expert,
  star_user.flg_reg AS flg_reg,
  star_user.uid AS uid,
  star_user.dt_reg AS dt_reg,
  star_user.flg_new AS flg_new,
  profile.userpic AS userpic,
  profile.country_live AS country_live,
  profile.site AS site,
  profile.town_live AS town_live,
  star_user.flg_show_ru AS flg_show_ru,
  v_event_count.eid AS eid,
  v_user_follower.fid AS fid
FROM star_user
  INNER JOIN profile
    ON star_user.id = profile.user_id
  LEFT OUTER JOIN v_user_follower
    ON v_user_follower.user_id = star_user.id
  LEFT OUTER JOIN v_event_count
    ON v_event_count.user_id = star_user.id

Я его оформляю в представление (view) view_test и потом в этом представление сортирую select *from view_test order by eid или select *from view_test order by fid

но сортировка не работает, построение записей не меняется, в чем может быть дело?