SELECT p.*, p.id as propertyid, pl.propertylocation as location, pl.seo_name as location_url, pt.propertytype as type_name, pt.seo_name as type_url, ptl.top_location as top_location, ptl.seo_name as top_location_url, ptl.id as top_location_id FROM pm_properties p INNER JOIN pm_propertylocations pl on (p.propertylocation=pl.id) INNER JOIN pm_propertytoplocations ptl on (pl.top_location=ptl.id) INNER JOIN pm_propertytypes pt on (p.propertytype=pt.id) WHERE p.id='92' AND p.propertyshow=1 LIMIT 1
in , | Property Id | Real Estate
