In MySQL, the same query thrashes really hard. After some experimentation, it seems like the subquery itself is the problem. For instance: ...

Swan noted that all queries won't translate successfully (if they contain functions specific to MySQL, for example), but even if it doesn't work, it can provide clues to help write the translated ...