[ticket/12890] Convert other memberlist joins to INNER JOINS

In order to prevent SQL errors when searching/sorting by CPF as well

PHPBB3-12890