Not sure if it is a bug, feature or inconsistancy but ignore_common filters not applied to left join table in query with left join.
I would expect that ignore is for all.
Not a big issue because you can set the commonfilter on the respected tables to None just before query execution.