SELECT property_fr.title AS title_fr, property_fr.shortDescription AS shortDescription_fr, property_fr.description AS description_fr, property.* FROM property LEFT JOIN property_fr ON (property_fr.propertyID = property.propertyID) WHERE property.propertyID = '616'