SELECT d.main_id,d.spu, s.mid ,b.suppliers_id, b.id, b.update_date_time
FROM `tp_goods_inquiry_detail` d
LEFT JOIN
(
SELECT main_id, MAX(id) AS MID
FROM `tp_goods_inquiry_suppliers_back`
WHERE suppliers_id = 17
GROUP BY main_id ) s ON d.main_id=s.main_id
LEFT JOIN tp_goods_inquiry_suppliers_back b ON b.id = s.mid