Answered by : purple-team

public function static findProductsOnSale($ids)
{ return $this->find()->where(['in', 'product_id', $ids])->count();
}

Source : https://stackoverflow.com/questions/31271499/yii2-where-in-with-active-record | Last Update : Fri, 08 Apr 22