Added inner joins
Refactored duplicated code
Create join only once
Force isNull operator on null value
Added fetchOne() to ResourceRepository
Added basic docs about auto joins