SELECT DISTINCT `property`.*, `property_lang`.*
FROM (`property`)
JOIN `property_lang` ON `property`.`id` = `property_lang`.`property_id`
WHERE `language_id` =  '2'
AND `is_activated` =  '1'
AND `property_id` =  '5777'