Sorry for my english,I don't it understand verry well! I want to limit the number of items in the related tables for pagination! my query is that: Model_User::query()->where('id',1)->related('groups',array('limit'=>$limit,offset=>$offset))->get() My objective is to get $limit groups starting to offset of user tabe where id aqual 1!
If you use a related query, by default the limit is placed on the subquery to prevent incomplete results. If you don't care about that, use 'rows_limit' and 'rows_offset' instead.