{"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
FROM s_community sc
WHERE sc.status_cd = '0'
and sc.name = #name#
and not exists(
	select 1 from s_community_member scm 
    where scm.status_cd <> '1'
    and scm.community_id = sc.community_id
    and scm.member_id = #memberId#
    and scm.member_type_cd = #memberTypeCd#
)","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"}1