SELECT FROM SELECT aidbid AS seaservice_idacreate_timebtalent_user_idbcompany_idbtitlebpay_amountbpayment_waybcurrencybcompletion_timebsea_service_statusbservice_address COALESCEcshort

可以使用DISTINCT关键字来去重，同时使用子查询和MAX函数来获取每个seaservice_id对应的最新申请数据，如下所示：

SELECT DISTINCT T.seaservice_id, T.* FROM ( SELECT a.id,b.id AS seaservice_id,a.create_time,b.talent_user_id,b.company_id,b.title,b.pay_amount,b.payment_way,b.currency,b.completion_time,b.sea_service_status,b.service_address, COALESCE(c.short_name_cn,e.realname, e.nickname, e.username) AS companyName,a.status AS applyStatus,IFNULL(d.has_withdraw,0) as hasWithdraw FROM iw_seaservice_apply a LEFT JOIN iw_seaservice b ON a.seaservice_id = b.id LEFT JOIN iw_company c ON b.company_id = c.id LEFT JOIN iw_seaservice_completion_apply d ON a.id = d.seaservice_apply_id LEFT JOIN iw_talent_user e ON b.talent_user_id = e.id ) T INNER JOIN ( SELECT seaservice_id, MAX(create_time) AS max_create_time FROM iw_seaservice_apply GROUP BY seaservice_id ) A ON T.seaservice_id = A.seaservice_id AND T.create_time = A.max_create_time ${ew.customSqlSegment} AND pay_amount >= #{minPayAmount} AND pay_amount <= #{maxPayAmount} AND applyStatus = #{applyStatus} AND companyName LIKE '${companyName}%' ORDER BY create_time DES