@questions = Question.paginate_by_sql "SELECT MAX(questions.id) as question_id, users.nickname
FROM questions
INNER JOIN users ON users.id = questions.user_id
WHERE questions.active = 1
GROUP BY questions.user_id ORDER BY questions.created_at DESC" ,:per_page => 36, :page => params[:page]
Partial:
<%=question.nickname %> <%= question.question_id %><br>
Mam coś takiego:
@questions = Question.paginate :all, "??MAX??", :joins => 'INNER JOIN users ON users.id = questions.user_id',
:conditions => ['questions.active = ?',1],:order => 'questions.created_at DESC',:group => 'questions.user_id',
:per_page => 36, :page => params[:page]
Ale nie wiem gdzie wsadzić MAX, sprawę załatwiałoby
@questions = Question.maximum(:id,:group => :user) # + warunki...
ale nie działa z paginate.