title: SELECT data from two tables with multiple arguments
body: <p>I try to select data from two tables. <br>
  In first table i store some content in default language.<br>
  Second table store's translations for data contained in first table.
  <br><br>
  I want to retrieve row for specific language.
  <br><br>
  For example:<br>
  id, content, id_language, content_translation.</p>
  
  <p>I,ve made query like this:</p>
  
  <pre><code>SELECT content_static.*,
  content_static_t.*
  FROM content_static
  LEFT JOIN content_static_t on content_static_t.parent_id = content_static.id
  WHERE content_static.id = 1;
  </code></pre>
  
  <p>It works fine, but when i have 2 languages it displays two rows, each one for each language. </p>
  
  <p>I want to display only one row, only for one language.<br>
  I also wonder it is possible to get data for multiple ID's from table content_static only in SQL query.</p>
  
  <p><a href="http://sqlfiddle.com/#!9/fa076/2" rel="nofollow noreferrer">http://sqlfiddle.com/#!9/fa076/2</a></p>
  
  <p>I add to query addition condition ( AND content_static_t.language_id = '2'). When I set argument to '2' it's ok, but when I set it to '4' i get no data.
  In this case i wat to display only data from the table content_static. </p>