SELECT f.`project_id`, f.`version`, f.`name`, t.`value`
FROM (strings s inner join files f
ON s.file_id = f.file_id
AND s.value like '%!!YourInterestingValue!!%'
AND f.is_active = 1
AND s.is_active = 1 )
left join translations t
ON s.string_id = t.string_id
AND t.language_id = !!YourLanguageId!!
AND t.is_active = 1
order by 1,2,3;