SELECT * FROM `efis_people` WHERE first_name='Kaljo' AND last_name='Kiisk'

id 1018

Filmid, kus Kaljo Kiisk on mänginud

SELECT film_id FROM efis_film_role_person WHERE people_id=1018;

79 filmi - koodid 298, 25, 

Isikud, kes on mänginud Kaljo Kiisaga samas filmis
SELECT tabel2.people_id, tabel2.film_id  FROM
  efis_film_role_person AS tabel1 JOIN
  efis_film_role_person AS tabel2 ON tabel1.film_id=tabel2.film_id
  WHERE tabel1.people_id=1018 
    AND tabel1.language='et' AND tabel2.language='et'

  	
people_id film_id
1754 298
1018 298