select
    p.id as id,
    p.batchNO as batchNO,
    p.description as description,
    p.price as price,
    p.batchDate as batchDate,
    pc.id as communityId,
    pc.houses as houses,
    pc.areaName as areaName,
    pc.address as address
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>
group by p.id
limit ${start!0},${limit!15}