{
	"param1": "SELECT
	sc.`community_id` communityId,
	sc.`name`,
	sc.`address`,
	sc.`nearby_landmarks` nearbyLandmarks,
	sc.`city_code` cityCode,
	sc.`map_x` mapX,
	sc.`map_y` mapY,
	scm.`community_member_id` communityMemberId,
	scm.`member_id` memberId,
	scm.`member_type_cd` memberTypeCd,
	scm.audit_status_cd auditStatusCd,
	scm.`status_cd` statusCd,
	ca.area_name areaName,
	ca.parent_area_name cityName,
	ca1.parent_area_name provName,
	sc.community_area communityArea
FROM
	s_community sc,
	s_community_member scm,
	city_area ca,
	city_area ca1
WHERE
	sc.`community_id` = scm.`community_id`
AND sc.`status_cd` = '0'
and sc.city_code = ca.area_code
and ca.parent_area_code = ca1.area_code
AND scm.`member_id` = #memberId#   AND scm.`member_type_cd` = #memberTypeCd#   AND scm.`status_cd` = '0' 
<if test=\"auditStatusCd ==null or auditStatusCd ==''\">
and scm.audit_status_cd in ('1000', '1100','1200')
</if>
<if test=\"auditStatusCd !=null and auditStatusCd !=''\">
and scm.audit_status_cd = #auditStatusCd#
</if>
group by sc.community_id
",
	"param2": "select sca.attr_id attrId,sca.spec_cd specCd,sca.value,s.name from s_community_attr sca,spec s where sca.status_cd = '0' and sca.community_id = #PARENT_communityId# and s.domain='COMMUNITY_ATTR' and s.spec_cd=sca.spec_cd"
}