Recently I got asked how you could paginate data from a HABTM (hasAndBelongsToMany) relationship. As the answer could be interesting for others, too, I will show a potential solution here. Let’s say you have the two models Category and Product, and you want to paginate the Products of a certain Category. Your table definition looks like: create table categories ( id int(11) not null auto_increment