Love seeing the use of ctes to compartmentalize the queries. It makes everything eminently easier to parse than one big mess.