如下图语句：

select t.*,

  w.name warehouse_name,

  u.nickname create_user_name,

  d.name create_dept_name,

  e.name merchant_name

from (

  select *  from form_in  where #{jeelowcode_auto_where}  

) t

  left join data_warehouse w on t.warehouse_id=w.id

  left join data_merchant m on t.merchant_id=m.id

  left join system_users u on t.create_user = u.id

  left join system_dept d on t.create_dept = d.id

  left join data_merchant e on t.merchant_id = e.id

，排序无效