New Listings
select property_unit.id,
initcap(property_building.street_number||' '||property_building.cass_street) as id_2 ,
property_building.cass_street ,
property_building.name as id_4 ,
property_unit.rooms as id_5 ,
property_unit.beds as beds ,
property_unit.baths as baths ,
property_unit__rent_status__re_dd.code as id_8 ,
to_char(property_unit.rent,'L999,999') as rent ,
re_nbhd.name as neighborhood ,
property_unit.sqft ,
to_char(property_unit.mod_time,'MM/DD') as updated,
property_unit.rent as sf_9,
property_ad.id as property_ad_id,
property_ad.title,
property_ad.description,
property_ad.agent__person_id,
case when property_ad.id is not null then 1 else 0 end as iorder
from property_unit
LEFT JOIN property_building on property_unit.property_building_id = property_building.id and property_building.active = 1
LEFT JOIN re_dd as property_unit__rent_status__re_dd on property_unit__rent_status__re_dd.id = property_unit.rent_status__re_dd_id
LEFT JOIN re_nbhd on property_building.re_nbhd_id = re_nbhd.id
LEFT JOIN property_ad on property_unit.id = property_ad.property_unit_id and property_ad.active = 1
and property_ad.ad_status__re_dd_id = 262
and property_ad.gpg_website = 1
where property_unit.active = 1
and property_unit.rent_status__re_dd_id = 201
and (property_unit.rent_type__re_dd_id = 185 or property_unit.rent_type__re_dd_id = 268 or property_unit.rent_type__re_dd_id = 184)
and (property_unit.mod_time + interval '5 days' > now() or property_ad.mod_time + interval '5 days' > now())
and property_building.id is not null
and rental = 1
order by iorder desc, property_unit.mod_time desc
limit 15
offset 0
ERROR: relation "re_nbhd" does not exist |
