SELECT classificator_code, COUNT(*)
  FROM efis_film JOIN efis_film_maker 
     ON efis_film_maker.film_id=efis_film.id
  GROUP BY classificator_code
   ORDER BY COUNT(*);
 

| FILM_MAKER_EDITOR                                 |     3741 |
| FILM_MAKER_SCREENWRITER                           |     4453 |
| FILM_MAKER_CONTENT_EDITOR                         |     5169 |
| FILM_MAKER_DIRECTOR                               |    13251 |
| FILM_MAKER_CINEMATOGRAPHER                        |    15118 |
+---------------------------------------------------+----------+

Mängufilm 56
Dokumentaalfilm 6

SELECT classificator_code, film_type_id,  COUNT(*)
  FROM efis_film JOIN efis_film_maker 
     ON efis_film_maker.film_id=efis_film.id
   JOIN efis_film_type_rel 
     ON efis_film_type_rel.film_id=efis_film.id
   WHERE efis_film_type_rel.film_type_id IN (56, 6) AND
     classificator_code IN ('FILM_MAKER_CINEMATOGRAPHER',
	   'FILM_MAKER_DIRECTOR', 'FILM_MAKER_CONTENT_EDITOR')
  GROUP BY classificator_code, film_type_id;
  

+----------------------------+--------------+----------+
| classificator_code         | film_type_id | COUNT(*) |
+----------------------------+--------------+----------+
| FILM_MAKER_CINEMATOGRAPHER |            6 |     3038 |
| FILM_MAKER_CINEMATOGRAPHER |           56 |      272 |
| FILM_MAKER_CONTENT_EDITOR  |            6 |      855 |
| FILM_MAKER_CONTENT_EDITOR  |           56 |      129 |
| FILM_MAKER_DIRECTOR        |            6 |     2504 |
| FILM_MAKER_DIRECTOR        |           56 |      273 |
+----------------------------+--------------+----------+


SELECT classificator_code, 
   MAX(if(film_type_id= 6, kogus, 0)) AS dokfilm,
   MAX(if(film_type_id=56, kogus, 0)) AS mangufilm  FROM
 (SELECT classificator_code, film_type_id,  COUNT(*) AS kogus
  FROM efis_film JOIN efis_film_maker 
     ON efis_film_maker.film_id=efis_film.id
   JOIN efis_film_type_rel 
     ON efis_film_type_rel.film_id=efis_film.id
   WHERE efis_film_type_rel.film_type_id IN (56, 6) AND
     classificator_code IN ('FILM_MAKER_CINEMATOGRAPHER',
	   'FILM_MAKER_DIRECTOR', 'FILM_MAKER_CONTENT_EDITOR')
  GROUP BY classificator_code, film_type_id) AS abitabel
  GROUP BY classificator_code;
	  
+----------------------------+---------+-----------+
| classificator_code         | dokfilm | mangufilm |
+----------------------------+---------+-----------+
| FILM_MAKER_CINEMATOGRAPHER |    3038 |       272 |
| FILM_MAKER_CONTENT_EDITOR  |     855 |       129 |
| FILM_MAKER_DIRECTOR        |    2504 |       273 |
+----------------------------+---------+-----------+