Single SQL statement to do pagination assuming there is HAS_MANY or MANY_MANY relations? - by may7 Single SQL statement to do pagination assuming there is HAS_MANY or MANY_MANY relations? Read the article