id_, warehouse_, material_id_, material_name_, model_, unit_, quantity_, last_time_ SELECT q.quantity_,m.*, c.NAME_ as className,q.AMOUNT_ FROM cmgt_material_info m LEFT JOIN cmgt_material_quantity q on q.material_id_ = m.ID_ LEFT JOIN cmgt_material_class c on c.ID_ = m.CLASS_ID_ ${ew.customSqlSegment} WHERE AND m.IS_DELE_ = '0' and c.is_dele_='0'