SELECT titre, date_debut_affiche, id_film, COUNT(DISTINCT id_membre) as nb_vues
FROM film
NATURAL JOIN historique_membre
GROUP BY id_film
ORDER BY nb_vues DESC, id_film ASC
LIMIT 50;