Bring all data from a table with joins with where clause that may not exist in the other table

Question

I'm having a hard time setting up a query(select). Database is not my specialty, so I'm turning to the experts. Let me show what I need.

----companies---     ----company_server-----     -----servers----    -----print------------------------
| id |   name   |    | company | server   |     | id |   name  |    | id |page|copy | date     |server
|----|--------  |    |---------|----------|     |----|-------- |    |----|----|-----|-------------
|  1 | Company1 |1--N|    1    |    1     |N*--1|  1 | Server1 |1--N|  1 |  2 |  3  | 2020-1-11 |   1
|  2 | Company2 |    |    2    |    1     |     |  2 | Server2 |    |  2 |  1 |  6  | 2020-1-12 |   3
|  3 | Company3 |    |    3    |    2     |     |  3 | Server3 |    |  3 |  4 |  5  | 2020-1-13 |   4
                     |    3    |    3     |     |  4 | Server4 |    |  4 |  5 |  3  | 2020-1-15 |   2
                                                                    |  5 |  3 |  4  | 2020-1-15 |   4
                                                                    |  6 |  1 |  2  | 2020-1-16 |   3
                                                                    |  7 |  2 |  2  | 2020-1-16 |   4

What I need? Example where date between CAST(2020-1-12 AS DATE) AND CAST(2020-1-15 AS DATE) group by servers.id

|       companies       |    server     |        sum                 |  percent
------------------------------------------------------------------------------------
| company1,company2     |    server1    | sum(page*copy) = 0 or null |    0 or NULL
| company3              |    server2    | sum(page*copy) = 15        |    28.30
| company3              |    server3    | sum(page*copy) = 6         |    11.32
| NULL                  |    server4    | sum(page*copy) = 32        |    60.38

Few notes:

1. I need this query for MYSQL;
2. Every Company is linked to at least one server.
3. I need result grouped by server. So, every company linked to that server must be concatenated by a comma.
4. If the company has not yet been registered, the value null should be presented.
5. The sum (page * copie) must be presented as zero or null (I don't care) in the case that there was no printing in the date range.
6. The percentage should be calculated according to the date range entered and not with all records in the database.
7. The field date is stored as MYSQL DATE.

Experts, I thank you in advance for your help. I currently solve this problem with at least 03 queries to the database, but I have a conviction that I could do it with just one query.

Added a fiddle. Sorry. Im still learing how to use this. https://www.db-fiddle.com/f/dXej7QCPe9iDopfYd1SfVh/2

Follows the query that more or less represents how far I had arrived. Notice that in the middle of the way 'server4' disappeared because there are no values ​​for it in print in the period searched for him and I am in possession of the total of the period but I cannot calculate the percentage. i'm stuck

select
*
from 
 (select
      sum(p.copy * p.page) as sum1,
      s.name as s_name,
      s.id as s_id
  from
      print p
  join servers s on s.id = p.server
  where p.date between cast('2020-1-12' as date) and cast('2020-1-15' as date)
  group by s.id) as t1
join company_server cs on cs.server = t1.s_id
right join companies c on c.id = cs.company
cross join(
  select
      sum(p1.copy * p1.page) sum2
  from
      print p1
  where p1.date between cast('2020-1-12' as date) and cast('2020-1-15' as date)
) as c;

Answer 1

I did this query before you add fiddle, so may be name of column of mine is not same as you. Anyway, this is my solution, hope it help you.

select group_concat(c.name separator ',') as name_company,
    ss.name, 
    sum_print as sum,
    (sum_print/total) *100 as percentage
    from companies c
    inner join company_server cs on c.id = cs.company 
    right join servers ss on ss.id = cs.id
    left join 
        (
            select server,sum(page*copy) as sum_print, date from print 
            where date between CAST('2020-1-12' AS DATE) AND CAST('2020-1-15' AS DATE)
            group by server
        ) tmp on tmp.server = ss.id 
    cross join  
        (select sum(page*copy) as total from print where date between CAST('2020-1-12' AS DATE) AND CAST('2020-1-15' AS DATE)) tmp2
    group by id

1. Group and concat by comma, using GROUP_CONCAT .
2. You can reference this image for JOIN clause. https://i.stack.imgur.com/6cioZ.png