id_, name_, code_, address_, addvcd_, addvcd_name_, longitude_, latitude_, map_, asset_type_, asset_business_, asset_src_, belongs_org_id_, belongs_org_name_, belongs_org_full_id_, is_move_, move_reason_, management_unit_, confirm_size_, unconfirm_size_, unit_, invest_plan_, invest_over_, is_deputy_, house_num_, book_value_, 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 i.id_, i.name_, i.code_, i.address_, i.addvcd_, i.addvcd_name_, i.longitude_, i.latitude_, i.asset_type_, i.asset_business_, i.asset_src_, i.belongs_org_id_, i.belongs_org_name_, i.is_move_, i.move_reason_, i.management_unit_, i.confirm_size_, i.unconfirm_size_, i.unit_, i.invest_plan_, i.invest_over_, i.is_deputy_, i.house_num_, i.book_value_, i.asset_audit_, w.is_get_warrents_, w.warrents_no_, w.warrents_org_name_, w.warrents_reason_, u.fill_year_, u.completed_size_, u.used_size_, u.unused_size_, u.building_size_, u.plan_size_, u.unit_ AS planUnit FROM biz_asset_pubilc_info i LEFT JOIN biz_asset_public_warrents w ON i.id_ = w.public_id_ LEFT JOIN ( SELECT a.* FROM biz_asset_public_use a INNER JOIN ( SELECT Max( fill_year_ ) fill_year_, public_id_ FROM biz_asset_public_use where is_dele_='0' GROUP BY public_id_ ) tab ON a.public_id_ = tab.public_id_ AND a.fill_year_ = tab.fill_year_ ) u ON i.id_ = u.public_id_ WHERE i.is_dele_ = '0' and w.is_dele_='0' AND ${@com.artfess.base.ognl.Ognl@withOutWhere(ew.customSqlSegment)} SELECT IFNULL( sum(book_value_), 0) as bookValue FROM biz_asset_pubilc_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( count(*), 0) as count, IFNULL( sum(invest_plan_), 0) as investPlan, IFNULL( sum(invest_over_), 0) as investOver FROM biz_asset_pubilc_info WHERE is_dele_='0' and asset_audit_='2' and belongs_org_full_id_ like '${fullId}%'