I am using following query to get details.
$moods = $this->Mood->find('all', array('conditions'=>$conditions,
'joins' => array(
array(
'table' => 'users',
'alias' => 'user',
'type' => 'INNER',
'conditions' => array(
'user.id = Mood.userId',
)
)
),
'fields' => array('user.id','user.name','user.email','user.imagePath',
'Mood.id', 'Mood.moods', 'Mood.body', 'Mood.created', 'Mood.group', 'Mood.mediaName', 'Mood.mediaType', 'Mood.isPrivate'),
'order' => array('Mood.created DESC'),
'limit' => 10,
'page' => $offset
));
However the page is not workign no mater what offset i put the result is same , what is going on