SELECT *
FROM (
    SELECT *
    FROM `film`
    WHERE 
        film_type=1
        AND movie_type=2
        AND votes_kp>1000
        AND status=1
    ORDER BY rating_kp DESC
    LIMIT 1000
) f
JOIN `con_genre` g1 ON g1.film_id=f.film_id AND g1.genre_id=101 JOIN `con_genre` g2 ON g2.film_id=f.film_id AND g2.genre_id=121 JOIN `con_genre` g3 ON g3.film_id=f.film_id AND g3.genre_id=123
WHERE f.film_id != 200735
AND f.film_id NOT IN ()
LIMIT 8;