Comment Comment by MoronInAHurry What exactly makes that "one of the worst-performing SQL queries you've ever seen"?It has two left joins on foreign/primary keys, and 4 trivially-indexed where conditions. That's all it has, and none of that is even slightly complex. parent MoronInAHurry 6 years ago
It has two left joins on foreign/primary keys, and 4 trivially-indexed where conditions. That's all it has, and none of that is even slightly complex.