mysql rows from select tag of html, option all of these -

mysql rows from select tag of html, option all of these -

table this

id_film | id_zaner 195 | 1 195 | 4 155 | 4

....

of 20 mil. rows

my query

select id_film csfd_zanre_odkazy id_zaner in (1,4) grouping id_film having count(*)=2

this select id_film = 195, have many rows , query slow , non effective.

can help me

try add together "distinct" after "select" on query.

select distinct id_film csfd_zanre_odkazy id_zaner in (1,4) grouping id_film having count(*)=2

mysql