select
    count(p.id) as total
from ds_guide_price p
left join db_price_community pc on p.communityId=pc.id
where 1=1
<#if batchNO?has_content>
    AND p.batchNO=:batchNO
</#if>

<#if name?has_content>
    AND pc.houses like :name
</#if>