select x.address as address from (
    select address from db_price_community where houses=:houses
    union all
    select distinct deal.address from data_data_qiyu_deal deal where deal.houses=:houses
    union all
    select distinct up.address from data_data_qiyu_up up where up.houses=:houses
    union all
    select distinct address from db_data_lianjia lj where lj.houses=:houses
    union all
    select distinct address from db_data_lianjia_up lj where lj.houses=:houses
    union all
    select distinct o.address from db_data_order o where o.houses=:houses
    union all
    select distinct o.address from ds_guide_price o where o.houses=:houses
) x
where x.address is not null
group by x.address
order by address desc