select parententi0_.id as col_0_0_ 
    from Parent parententi0_ 
left outer join Child2 parententi0_1_                                                                       on parententi0_.id=parententi0_1_.id 
left outer join Child5 parententi0_2_                                                                       on parententi0_.id=parententi0_2_.id 
left outer join Child4 parententi0_3_                                                                       on parententi0_.id=parententi0_3_.id 
left outer join Child1 parententi0_4_                                                                       on parententi0_.id=parententi0_4_.id 
left outer join Child3 parententi0_5_                                                                       on parententi0_.id=parententi0_5_.id     
left outer join (Child1 child1enti1_ inner join Parent child1enti1_1_ on child1enti1_.id=child1enti1_1_.id) on parententi0_.id=child1enti1_.id
left outer join (Child2 child2enti2_ inner join Parent child2enti2_1_ on child2enti2_.id=child2enti2_1_.id) on parententi0_.id=child2enti2_.id 
left outer join (Child3 child3enti3_ inner join Parent child3enti3_1_ on child3enti3_.id=child3enti3_1_.id) on parententi0_.id=child3enti3_.id
where
    case 
         when parententi0_1_.id is not null then 1 
         when parententi0_2_.id is not null then 2 
         when parententi0_3_.id is not null then 3 
         when parententi0_4_.id is not null then 4 
         when parententi0_5_.id is not null then 5 
         when parententi0_.id is not null then 0 
     end=4 
     and (child1enti1_.status like 'Enable') 
or 
    case 
        when parententi0_1_.id is not null then 1 
        when parententi0_2_.id is not null then 2 
        when parententi0_3_.id is not null then 3 
        when parententi0_4_.id is not null then 4 
        when parententi0_5_.id is not null then 5 
        when parententi0_.id is not null then 0 
     end=1 
     and (child2enti2_.status like 'Disable') 
or 
    case 
        when parententi0_1_.id is not null then 1 
        when parententi0_2_.id is not null then 2 
        when parententi0_3_.id is not null then 3 
        when parententi0_4_.id is not null then 4 
        when parententi0_5_.id is not null then 5 
        when parententi0_.id is not null then 0 
     end=5 
     and (child3enti3_.status like 'Enable')

left outer join (Child1 child1enti1_ inner join Parent child1enti1_1_ on child1enti1_.id=child1enti1_1_.id) on parententi0_.id=child1enti1_.id

select y.CategoryID, 
    y.CategoryName,
    round(x.actual_unit_price, 2) as "Actual Avg Unit Price",
    round(y.planned_unit_price, 2) as "Would-Like Avg Unit Price"
from
(
    select avg(a.UnitPrice) as actual_unit_price, c.CategoryID
    from order_details as a
    inner join products as b on b.ProductID = a.ProductID
    inner join categories as c on b.CategoryID = c.CategoryID
    group by c.CategoryID
) as x
inner join 
(
    select a.CategoryID, b.CategoryName, avg(a.UnitPrice) as planned_unit_price
    from products as a
    inner join categories as b on b.CategoryID = a.CategoryID
    group by a.CategoryID
) as y on x.CategoryID = y.CategoryID

select * from table0 join (select * from table1 join table2 on table1.id = table2.id) alias on alias.id = table0.id 

select * from table0 join (table1 alias1 join table2 alias2 on alias1.id = alias2.id)  on alias1.id = table0.id