Differences between ‘knp_paginator’ for distinct: false and distinct: true

https://gist.github.com/kraksoft/9e92b03db66176562358

A Visual Explanation of SQL Joins

http://sephiro.boo.pl/index.php/2012/07/21/zlaczenia-w-mysql-mysql-joins/ http://www.codinghorror.com/blog/2007/10/a-visual-explanation-of-sql-joins.html