Change join to left join

Left join it’s necessary to keep in the results the rows that don’t
have relations