Коллеги,
помогите перевести запрос на ORM.
Есть несколько таблиц справочников: tvh4_Name, tvh4_Genre, tvh4_Persons
Есть таблица связей Film, с полями: Film_ID, Type_record_ID,Object_ID.
Где:
Film_ID — номер фильма
Type_record_ID — справочник
Object_ID — объект справочника
Создано EntityORM для 3 справочников.

Не понимаю как реализовать логику для Film, в частности запрос вида:

$sql = "SELECT
Film.ID, Film.Film_ID, Film.Type_record_ID, Film.Object_ID, Name.Language_ID AS Name_Language_ID, 
		Name.Name_Text, Genre.Language_ID AS Genre_Language_ID, Genre_Text, 
		Persons.Language_ID AS Persons_Language_ID, Persons.Persons_Name
		FROM
		" . Config::Get('db.table.Film') . "
		AS Film
			LEFT JOIN tvh4.tvh4_Name Name ON ( Film.`Object_ID` = Name.ID AND Film.Type_record_ID =1 )
			LEFT JOIN tvh4.tvh4_Genre Genre ON ( Film.`Object_ID` = Genre.ID AND Film.Type_record_ID =2 )
			LEFT JOIN tvh4.tvh4_Persons Persons ON ( Film.`Object_ID` = Persons.ID
				AND ( Film.Type_record_ID =3 OR Film.Type_record_ID =4 OR Film.Type_record_ID =7 OR Film.Type_record_ID =8
				OR Film.Type_record_ID =9 OR Film.Type_record_ID =10 OR Film.Type_record_ID =11 OR Film.Type_record_ID =12
				OR Film.Type_record_ID =13 OR Film.Type_record_ID =14 OR Film.Type_record_ID =15)) 
		WHERE
		    Film.Film_ID IN (?a)
		ORDER BY Film.ID
		";