LEFT JOIN(SUBQUERY) AND ORDER BY

Post-push fix for main.derived:
Windows prefers derived table names in lowercase.