Please add your comment for post: Using Derived Tables To Generate "Stats" For An Outer Query JOIN In MySQL 5.6.49