title: SQL query for fetching rows in certain language (with default lang)
body: <p>I have a table with cities:</p>
  
  <ul>
  <li>city_id</li>
  <li>name</li>
  <li>languagecode</li>
  </ul>
  
  <p>Sample data (city_id, name, languagecode):</p>
  
  <ul>
  <li>1, LondonName, en </li>
  <li>1, LondonName, de</li>
  <li>1, LondonName123, jp </li>
  <li>2, Barcelona, en</li>
  <li>2, Barcelona123, de,</li>
  <li>3, Madrid, en</li>
  </ul>
  
  <p>How can I fetch all cities in certain language (i.e. de), but if there there aren't city translation in that language I want fetch translation in default language (i.e. english) for this row.</p>
  
  <p>So, result for languagecode "de" should be like this:</p>
  
  <ul>
  <li>1, LondonName, de</li>
  <li>2, Barcelona123, de</li>
  <li>3, Madrid, en</li>
  </ul>
  
  <p>Database: MySQL</p>