I have finally found a scenario where a subquery is faster than joins in #MySQL after 10-ish years of working with MySQL both in and out of #Django: filtering a table of ~300k going through an intermediate table of over 10M rows to another table of ~80k, filtering on an unindexed column (yes, I know; it's a rare view) in that third table.