here actually request

SELECT id, name_film, slug_film, created_at FROM `fl_film`) UNION (SELECT id, name_mfilm, slug_mfilm, created_at FROM `fl_mfilm`) UNION (SELECT id, name_serial, slug_serial, created_at FROM `fl_serial`) ORDER BY `created_at` DESC LIMIT 10 

how to make it a request.

    2 answers 2

    Probably through the findBySql method. Read more here: link to api

      I would refuse UNION if I were you. It is not necessary to spread data on different tables which should be displayed in one list. I recommend to look towards PostgreSQL. And first, read about Inheriting tables in Postgresql . For my project I once chose Single Table Inheritance and have never regret it.