Thank you so much @aurovrata ! We hope you are safe and well. Take care.
Hi Aurovrata,
We are having a similar issue after upgrading WP to 5.3.2. On this site we have a custom post type category being reordered: https://nelsenpartners.com/?project_type=entertainment#portfolio. You can sort by project type, those are the categories. Here is a screenshot of the backend: https://www.dropbox.com/s/8x7oc1tejlkjhcj/screen%20shot%202019-12-19%20at%2010.57.21%20am.jpg?dl=0
I did the LEFT JOIN fix and also did not have success. Thanks so much for your help.