联查嵌套子查询

SELECT
 f.isMine,
 f.text,
 c.u_thumb,
 c.relname,
 a.ifpay,
 a.zid,
 a.keywords,
 a.money,
 a.orders,
 a.ordertype,
 a.startime,
 a.template AS pingjia,
 a.pingjia1,
 label_Insect,
 label_vegetation,
 label_crop,
 a.imgurlA,
 a.imgurlB,
 a.imgurlC,
 b.z_name AS zhuanjia_name,
 b.advertisement,
 d.caiyangname,
 d.caiyangtime,
 d.caiyangtype,
 d.youxianji,
 d.caiyangren,
 d.caiyangneirong,
 d.imgurlA AS caiyangimgurlA,
 d.imgurlB AS caiyangimgurlB,
 d.imgurlC AS caiyangimgurlC,
 e.wenzhentime,
 e.wenzhenaddress,
 e.wenzhenjielun,
 e.imgurlA AS wenzhenimgurlA,
 e.imgurlB AS wenzhenimgurlB,
 e.imgurlC AS wenzhenimgurlC

FROM
 ims_hyb_yl_wenzorder AS a
 LEFT JOIN ims_hyb_yl_zhuanjia AS b ON a.zid = b.zid
 LEFT JOIN ims_hyb_yl_userinfo AS c ON a.openid = c.openid
 LEFT JOIN `ims_hyb_yl_wenzheninfo` AS d ON d.order_id = a.orders
 LEFT JOIN ims_hyb_yl_wenzhenjielun AS e ON e.order_id = a.orders 
 left join (select  order_id,isMine,text from (select * from ims_hyb_yl_dialogues order by create_time desc) dia group by order_id) f on f.order_id = a.orders