That's not a rare case, when data from referenced table should be displayed along with data from table being viewed.
To do that "LEFT JOIN" clause is added a SELECT query being used for data retrieval from database.
That's not a bad habit actually. But, when table contains 1 million records and has 5 LEFT JOINs on it, then it really slows COUNT database query, used to calculate pagination for that grid.
I propose that we dynamically remove "LEFT JOIN" parts of database query if JOINed table isn't used anywhere in that database query. For example this query doesn't use JOINed table at all, so we can remove it automatically: