New posts in Query Refactor

Avoiding multiple `or` expressions

Fetch the newest row grouped by a column in MySQL

How do you approach refactoring an ugly procedure/query?