title: mysql rows from select tag of html, option all of these
body: <p>table like this</p>
  
  <pre><code> id_film  |  ID_ZANER 
  
  195       |      1 
  
  195       |      4 
  
  155       |      4
  </code></pre>
  
  <p>....</p>
  
  <p>of 20 mil. rows </p>
  
  <p>my query is </p>
  
  <pre><code>SELECT id_film 
  FROM csfd_zanre_odkazy 
  where ID_ZANER in (1,4) 
  group by id_film having count(*)=2
  </code></pre>
  
  <p>this select id_film = 195, but i have many rows and this query is slow and non effective. </p>
  
  <p>can you help me </p>