SELECT (@i:=@i+1) xh,a.* FROM
(SELECT e.id,e.factory_no AS factoryNo,e.product_no AS productNo,e.model,e.license_no AS licenseNo,DATE_FORMAT(er.repair_date,'%Y-%m-%d') AS repairDate,er.malfunction,DATE_FORMAT(er.service_date,'%Y-%m-%d') AS serviceDate,
er.service_man AS serviceMan,er.maintenance_content AS maintenanceContent,group_concat(wem.name) as costName,SUM(wem.cost) as cost,e.device_type AS deviceType,e.fixed_assets_no AS fixedAssetsNo,e.manufacturer,e.variety,e.register_code as registerCode,e.register_no as registerNo from wms_equipment e
LEFT JOIN wms_equipment_repair er on er.equipment_id = e.id
LEFT JOIN wms_equipment_material wem on wem.pid = er.id
where e.type = 3 and e.del_flag=0 AND er.del_flag=0 GROUP BY er.id ) a,(SELECT @i:=0) as i