How to Resolve "0 row(s) modified" Error When Using Row Number() Over (Partition By) in MySQL with Outer Join