РА
А скажи, почему ты условия JOIN-а второй таблицы пишешь в JOIN-е последней?
у меня вроде все таблицы в последнем join
SELECT t1.film_id
FROM entities_to_film as t1
JOIN entities_to_film as t2
JOIN entities_to_film as t3
JOIN entities_to_film as t4
JOIN films as t5
ON t1.film_id = t2.film_id and t2.film_id = t3.film_id and t3.film_id = t4.film_id and t4.film_id = t5.id
WHERE (t1.entity_id = 10 and t1.entity = 7836) and (t2.entity_id = 8 and t2.entity = 23330) and (t3.entity_id = 3 and t3.entity = 1) and (t4.entity_id = 4 and t4.entity = 3) and t5.date = 2003;
