>the syntax for nested list comprehensions has a rather... incomprehensible order

I remember reading a blog post pointing out that the for-loop order stays the same between comprehensions and normal nested code. You write the outer loop first.