SUM () OVER (Partition By) на MySQL 5.7

Гуру MySQL, подскажите, как синтаксически переписать примерно такой запрос, где используется SUM (...) OVER (Partition By...) и ROW_NUMBER() OVER, все єто дело идет как вложенный позапрос.

Пример:

SELECT ils.QuantityOnHand ,
       ROW_NUMBER() OVER ( ORDER BY ai.AdjustmentType, 
                                    ai.[LineNo] ) AS [LineNo],
                                    ( ils.QuantityOnHand + SUM(( CASE WHEN ai.AdjustmentType = 2 
                                                                      THEN ai.Quant  * ai.ConvFac
                                                                      WHEN ai.AdjustmentType = 3 
                                                                      THEN -ai.Quant  * ai.ConvFac
                                                                      ELSE ai.Quant  * ai.ConvFac - ils.QuantityOnHand 
                                                                  END 
                                                               )) OVER ( PARTITION BY ai.InvLocPK ) 
                                    ) AS NewOnHand 
FROM      AdjItem  AS ai
JOIN InvLoc AS il ON ai.InvLocPK = il.InvLocPK
JOIN Locs AS loc ON il.LocPK = loc.LocPK
LEFT JOIN InvTrack AS it ON it.InvPK = il.InvPK
                        AND it.FacilityPK = loc.FacilityPK
JOIN InvLocStat AS ils ON il.InvLocPK = ils.InvLocPK