Esempio n. 1
0
 private function getFollow($userId, $columns, $limit, $offset)
 {
     return QuestionFollow::query()->columns($columns)->leftJoin('Apps\\Common\\Models\\Question', 'Apps\\Common\\Models\\Question.question_id = Apps\\Common\\Models\\QuestionFollow.question_id')->leftJoin('Apps\\Common\\Models\\UserBase', 'Apps\\Common\\Models\\Question.user_id = u.user_id', 'u')->where('question_state > 0 AND Apps\\Common\\Models\\QuestionFollow.user_id = :user_id:')->bind(['user_id' => $userId])->orderBy('question_id desc')->limit($limit, $offset)->execute()->toArray();
 }