Where is the best place to place a query with the output of the nth number of rows?

Question

MySQL

There is such a request that displays information about the orders of a certain manager, as well as files attached to this order.

SELECT orders_design.id_order_design, clients.name, orders_design.id_order_print, orders_design.type_product, 

orders_design.parameters, orders_design.date_order FROM orders_design INNER JOIN clients ON orders_design.id_client = 

clients.id_client WHERE clients.id_manager = '1' AND files.name IN ( SELECT name FROM files WHERE id_order_design = 

orders_design.id_order_design)

The question is whether to leave a subrequest with the issuance of files or already make a separate request?
That is, roughly speaking, already in the code, take the order id and, depending on it, display files, there are simply orders without files, while I understood the request with a sub-request will not produce anything.

Answer 1

Your request still does not display file names.

SELECT `od`.`id_order_design`, `c`.`name`, `od`.`id_order_print`, 
        `od`.`type_product`, `od`.`parameters`, `od`.`date_order`, 
        `f`.`filelist`
    FROM `orders_design` AS `od`
    JOIN `clients` AS `c` ON `od`.`id_client` = `c`.`id_client`
    LEFT JOIN (
        SELECT `id_order_design`, GROUP_CONCAT(`name` SEPARATOR '|') AS `filelist`
            FROM `files`
            GROUP BY `id_order_design`
    ) AS `f` ON `f`.`id_order_design` = `od`.`id_order_design`
    WHERE `c`.`id_manager` = 1

Answer 2

something is not a request, but some kind of heresy, you know that it will not be executed?
I think while you debug the request, then the solution will come by itself ... separate the flies from the cutlets