SQLize Online / PHPize Online  /  SQLtest Online

create table Schedule (id int, name varchar(64)); insert into Schedule values (1, 'TEST'); create table Attribute (id int, id_schedule int, name varchar(64)); insert into Attribute values (1, 1, 'Ivan'),(2, 1, 'Semen'); create table Access (id int, `limit` int, id_attribute int); insert into Access values (1, 1, 1),(2, 3, 1),(3, 2, 2),(4, 4, 2); create table Close (id int, status int, id_access int); insert into Close values (1, 0, 1),(2, 0, 1),(3, 0, 3); select S.*, Atr.name AS Aname, SUM(`limit`) AS `limit` from Schedule S join Attribute Atr ON Atr.id_schedule = S.id join Access Acc on Acc.id_attribute = Atr.id group by Atr.name, S.id, S.name ;