id_, name_, code_, address_, addvcd_, addvcd_name_, longitude_, latitude_, map_, asset_type_, asset_business_, asset_src_, asset_nature_, asset_belong_, belongs_org_id_, belongs_org_name_, belongs_org_full_id_, land_area_, buy_price_, book_value_, is_out_asset_, land_status_, asset_audit_, remark_, create_by_, create_name_, create_org_id_, create_org_name_, create_dept_id_, create_dept_name_, create_time_, update_by_, update_name_, update_org_id_, update_org_name_, update_dept_id_, update_dept_name_, update_time_, is_dele_, last_time_, tenant_id_ select * from (SELECT b.*,w.is_get_warrents_ FROM biz_asset_land_info b left join biz_asset_land_warrents w on w.land_id_ = b.id_ ) s ${ew.customSqlSegment} SELECT IFNULL( sum(book_value_), 0) as book_value_ FROM biz_asset_land_info WHERE is_dele_='0' and asset_audit_='2' and belongs_org_full_id_ like '${fullId}%' SELECT IFNULL(sum(book_value_), 0) AS bookValue, IFNULL(sum(land_area_), 0) AS landArea FROM biz_asset_land_info WHERE is_dele_ = '0' AND asset_audit_ = '2' and belongs_org_full_id_ like '${fullId}%' SELECT u.fill_year_ as year, IFNULL(sum(u.unused_area_), 0) AS unusedArea FROM biz_asset_land_info l LEFT JOIN biz_asset_land_use u ON u.land_id_ = l.id_ WHERE l.is_dele_ = '0' AND l.asset_audit_ = '2' and belongs_org_full_id_ like '${fullId}%' and u.fill_year_ in #{year} GROUP BY u.fill_year_ SELECT land_status_ AS loadStatus, IFNULL(sum(land_area_), 0) AS landArea FROM biz_asset_land_info WHERE is_dele_ = '0' AND asset_audit_ = '2' AND belongs_org_full_id_ LIKE '${fullId}%' GROUP BY land_status_