title: mysql join with multiple conditions (not OR but AND)
body: <p>i have problem with join table and use multiple conditions...
  My code:</p>
  
  <pre><code>SELECT * FROM 
     (SELECT sid, MAX(info_date_add) AS max_info_date_add FROM skiresort GROUP BY sid) skiresort_max 
  INNER JOIN skiresort 
     ON 
        skiresort_max.sid = skiresort.sid AND 
        skiresort_max.max_info_date_add = skiresort.info_date_add 
  JOIN skiresort_theme_value 
     ON skiresort_theme_value.skiresort_id = skiresort.id 
  WHERE 
     skiresort_theme_value.skiresort_theme_id = '1' AND 
     skiresort_theme_value.skiresort_theme_id = '2' AND 
     skiresort_theme_value.skiresort_theme_id = '4' 
  GROUP BY skiresort.sid 
  ORDER BY skiresort.title_en
  </code></pre>
  
  <p>In this code, the conditions are in WHERE clausule. I also tried to put in into JOIN ON (...) but it also didn't work.
  When i have only one condition it works. I read some articles about using OR instead of AND, it worked but not as i expected. I need to search only rows with certain IDs (multiple).</p>