Eugene

SELECT DISTINCT `m`.`id` 
FROM `movies` AS `m` 
LEFT JOIN (
 (
  SELECT `s`.`movie` FROM `schedule`
   WHERE `s`.`date` > '2012-11-01' AND `s`.`date` <= '2012-11-02' 
) AS `s` ON (
   `s`.`movie` = `m`.`id`
)
ORDER BY COUNT(`s`.`movie`) DESC 
LIMIT 0, 10