SELECT
  f.id, f.tytul
  GROUP_CONCAT(r.imieNazwisko) AS rezyseria,
  GROUP_CONCAT(a.imieNazwisko) AS aktorzy
FROM
  filmy AS f
INNER JOIN
  (SELECT filmId, imieNazwisko FROM ludzie WHERE rola = 'reżyser') AS r
ON f.id = r.filmId
INNER JOIN
  (SELECT filmId, imieNazwisko FROM ludzie WHERE rola = 'aktor') AS a
ON f.id = a.filmId
GROUP BY f.id

SELECT
        film_b.idfilm 'id',
        film_b.tytul_ang,
        film_b.rok_prod 'produkcja',
        GROUP_CONCAT( DISTINCT CONCAT(czlowiek_filmu_b.imie,' ',czlowiek_filmu_b.nazwisko)) 'rezyseria',
        GROUP_CONCAT( DISTINCT CONCAT(a.imie,' ',a.nazwisko)) 'aktorzy',
        GROUP_CONCAT( DISTINCT gatunek.nazwa) 'gatunek'
        
FROM
        film AS film_b,
        rola AS rola_b,
        czlowiek_filmu AS czlowiek_filmu_b,
        czlowiek_filmu_do_film AS czlowiek_filmu_do_film_b,
        gatunek,
        film_do_gatunek
        
INNER JOIN   (
    
SELECT
        film_a.idfilm 'id',
        czlowiek_filmu_a.imie,
        czlowiek_filmu_a.nazwisko
        
FROM
        film AS film_a,
        rola AS rola_a,
        czlowiek_filmu AS czlowiek_filmu_a,
        czlowiek_filmu_do_film AS czlowiek_filmu_do_film_a
        
WHERE    
        rola_a.rola = 'aktor' AND
        czlowiek_filmu_do_film_a.czlowiek_filmu_idczlowiek_filmu = czlowiek_filmu_a.idczlowiek_filmu AND
        czlowiek_filmu_do_film_a.film_idfilm = film_a.idfilm AND
        czlowiek_filmu_do_film_a.rola_idrola = rola_a.idrola ) AS a
        ON a.id = id

WHERE    rola_b.rola = 'rezyser' AND
        czlowiek_filmu_do_film_b.czlowiek_filmu_idczlowiek_filmu = czlowiek_filmu_b.idczlowiek_filmu AND
        czlowiek_filmu_do_film_b.film_idfilm = film_b.idfilm AND
        czlowiek_filmu_do_film_b.rola_idrola = rola_b.idrola AND
        film_do_gatunek.film_idfilm = film_b.idfilm  AND
        film_do_gatunek.gatunek_idgatunek = gatunek.idgatunek GROUP BY film_b.idfilm

GROUP_CONCAT( DISTINCT CONCAT(a.imie,' ',a.nazwisko) ORDER BY a.nazwisko, a.imie) 'aktorzy',

                SELECT
                        film_a.idfilm 'film_id',
                        GROUP_CONCAT( DISTINCT CONCAT(czlowiek_filmu_a.nazwisko,' ',czlowiek_filmu_a.imie)) 'imieNazwisko'
        
                FROM
                        film AS film_a,
                        rola AS rola_a,
                        czlowiek_filmu AS czlowiek_filmu_a,
                        czlowiek_filmu_do_film AS czlowiek_filmu_do_film_a
        
                WHERE    
                        rola_a.rola = 'aktor' AND
                        czlowiek_filmu_do_film_a.czlowiek_filmu_idczlowiek_filmu = czlowiek_filmu_a.idczlowiek_filmu AND
                        czlowiek_filmu_do_film_a.film_idfilm = film_a.idfilm AND
                        czlowiek_filmu_do_film_a.rola_idrola = rola_a.idrola GROUP BY film_id

ON a.id = id

ON a.id = film_b.idfilm

#1054 - Unknown column 'film_b.idfilm' in 'on clause'

create table t1 (a int);
create table t2 (b int);
create table t3 (c int);

select * from t1, t2 join t3 on t1.a=t3.c;
ERROR 1054 (42S22): Unknown column 't1.a' in 'on clause'

select * from t1, t2 left outer join t3 on t1.a=t3.c;
ERROR 1054 (42S22): Unknown column 't1.a' in 'on clause'

select * from t1 join t2 join t3 on t1.a=t3.c;
//.. this works ..

select * from t1 join t2 left outer join t3 on t1.a=t3.c;
//.. this works ..

I had the same problem and the fix is very simple.

All you have to do is adding parentheses to the implicit join after FROM

select * from (t1, t2) join t3 on t1.a=t3.c;
select * from (t1, t2) left outer join t3 on t1.a=t3.c;

It should work.

This is because MySQL is now in compliance with some new rules of SQL language. I have seen some other solutions but I believe this is the easier.

[SQL] pobierz, plaintext 
aktorzy IN ('Bruce Willis')
[SQL] pobierz, plaintext 

#1247 - Reference 'aktorzy' not supported (reference to group function)

[SQL] pobierz, plaintext 
gatunek.nazwa IN ('akcja')
[SQL] pobierz, plaintext