1054 - Unknown column 'a1.address' in 'field list'

select a1.area, a1.areaunit, a1.bedrooms, a1.bathrooms, a1.address, a1.sub_city, a1.city, a1.state_id, a1.price, b1.title, a1.propertyfor, a1.property_id from property_listing as a1, property_listing_trans as b1 where a1.property_id=b1.property_id && a1.member_id='343668' and a1.status='1' and b1.proj_id='13795' order by a1.property_id desc

[TEP STOP]