CREATE TABLE `film` (
`kod` int( 12 ) NOT NULL auto_increment,
`film_name` varchar( 255 ) NOT NULL default '',
`description` text,
PRIMARY KEY (`kod`),
) TYPE=MyISAM COMMENT='Movies details'

CREATE TABLE `starring` (
`kod` bigint( 20 ) unsigned NOT NULL auto_increment,
`film_kod` int( 12 ) NOT NULL default '0',
`role` char( 1 ) NOT NULL default '',
`starname_kod` int( 12 ) NOT NULL default '0',
PRIMARY KEY (`kod`),
) TYPE=MyISAM COMMENT=' Movies and actors (role is ‘a’) and directors (role is ‘d’)
relations';

CREATE TABLE `users_prefer` (
`id` int( 10 ) unsigned NOT NULL auto_increment,
`uid` int( 12 ) NOT NULL default '0',
`value_type` enum('actor','director') NOT NULL default 'actor',
`value_code` int( 12 ) NOT NULL default '0',
`value` int( 11 ) NOT NULL default '0',
PRIMARY KEY (`id`)
) TYPE=MyISAM COMMENT='Users prefers';

Number of the records at the tables:
films -  50000 
starring -  100000 
users_prefer -  50000 

	SELECT film_name,SUM(a.value) as ord
    FROM users_prefer AS a
    LEFT JOIN starring AS b ON b.starname_kod = a.value_code
    LEFT JOIN film AS c ON c.kod = b.film_kod
    WHERE a.uid="тут должен быть идентификатор пользователя"
    AND ((a.value_type = 'actor' AND b.role='a') OR (a.value_type = 'director' AND b.role='d'))
    GROUP BY b.film_kod ORDER BY ord DESC