select 
  ru.user_id, 
  ru.rank_id, 
  ru.order_cnt, 
  ru.order_amount, 
  ru.confirmed_date, 
  ru.target_order_ids, 
  ru.coupon_ids, 
  ru.email_sent_time, 
  rmr.name as rank_name, 
  rmr.low_sales_cnt, 
  rmr.low_sales_price, 
  reu.user_id as exclusion_user_id, 
  ippan_ug.status as ippan_status, 
  inryo_ug.status as inryo_status, 
  shuhan_ug.status as shuhan_status, 
  tonya_ug.status as tonya_status 
from 
  cscart_rank_user as ru 
  left join cscart_rank_mst_rank as rmr on ru.rank_id = rmr.id 
  left join cscart_rank_exclusion_user as reu on ru.user_id = reu.user_id 
  left join cscart_usergroup_links as ippan_ug on ru.user_id = ippan_ug.user_id 
  and ippan_ug.usergroup_id = 7 
  and ippan_ug.status = 'A' 
  left join cscart_usergroup_links as inryo_ug on ru.user_id = inryo_ug.user_id 
  and inryo_ug.usergroup_id = 8 
  and inryo_ug.status = 'A' 
  left join cscart_usergroup_links as shuhan_ug on ru.user_id = shuhan_ug.user_id 
  and shuhan_ug.usergroup_id = 9 
  and shuhan_ug.status = 'A' 
  left join cscart_usergroup_links as tonya_ug on ru.user_id = tonya_ug.user_id 
  and tonya_ug.usergroup_id = 10 
  and tonya_ug.status = 'A' 
where 
  ru.user_id = 0