Phosphorum\Badges\Badge\Virtuoso::getExpertQuery PHP Method

getExpertQuery() public method

public getExpertQuery ( Users $user )
$user Phosphorum\Models\Users
    public function getExpertQuery(Users $user)
    {
        if (!$this->query) {
            $this->query = $user->getModelsManager()->createBuilder()->columns(['p.categories_id', 'COUNT(*)'])->from(['r' => 'Phosphorum\\Models\\PostsReplies'])->join('Phosphorum\\Models\\Posts', null, 'p')->where('r.users_id = ?0 AND r.accepted = "Y"')->notInWhere('p.categories_id', $this->getNoBountyCategories())->groupBy('p.categories_id')->having('COUNT(*) >= 5')->getQuery();
        }
        return $this->query;
    }