phphil, Built a request super slow because I thought CTEs (Common Table Expressions) in #MySQL are "cached".
I had one CTE and then queried it 5 times to further refine and structure the result.
Turns out CTEs work more like views and this led to the query in the CTE being executed 5 times.