Change join to left join
Change join to left join

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

RJacksonm1/searchable,svrnm/searchable,masterweb121/searchable,jarnovanleeuwen/searchable,wunc/searchable,nicolaslopezj/searchable