EVOSandru6

['is not', new Expression("JSON_EXTRACT({$table}.data, '$.someParam')"), null],

public static function  getProviderByTotalParams()
    {
        $mainTable = self::tableName();

        $sql = '
             SELECT m_departments.id, m_departments.name, 
             COUNT(m_news.id) + COUNT(m_posts.id) + COUNT(m_forums.id) + COUNT(m_questions.id) AS total_count
            FROM m_departments 
            LEFT JOIN m_news ON m_departments.id = m_news.department_id
            LEFT JOIN m_posts ON m_departments.id = m_posts.department_id
            
            GROUP BY m_departments.id
            ORDER BY total_count DESC
            LIMIT 5
        ';

        $dataProvider = new SqlDataProvider([
            'sql' => $sql, 
            'totalCount' => 5, 
            'pagination' => [
                'pageSize' => 5, 
            ],
        ]);;

        return $dataProvider;
    }

'defaultOrder' => [
                    'id' => SORT_DESC,
                    // 'name' => SORT_ASC,
                ]

<?php yii\widgets\Pjax::begin(['id' => 'new_note']) ?>
    <?php $form = ActiveForm::begin(
        [
            'fieldConfig' => [
                'template' => '{label}{error}{input}',
                'inputOptions'=>[
                    'class'=>'form-control h-form__input h-input-response'
                ],
                'options' => [
                    'tag' => 'div',
                ],
            ],
            'options' => [
                'data-pjax' => true,
            ]
        ]); ?>

    <?= $form->field($model, 'description')->textarea([
        'rows' => 6,
        'style' => 'margin-bottom:0;'
    ])->label(false) ?>

    <div class="c-voices__footer">
        <?= Html::submitButton( Yii::t('app', 'send'), [
            'class' => 'btn btn-success pull-right'
        ]) ?>
    </div>

    <?php ActiveForm::end(); ?>
    <?php Pjax::end(); ?>
</div>

'cache' =>
    [
        'class'=> 'CApcCache'
    ],

protected function performAjaxValidation($model)

public function performAjaxValidation($model)