dy-house/target/classes/fmt/guidePrice_data.fmt

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}