How to merge CDbCriteria in Yii 1?

Question

Yii

Hello! Wanted to combine the conditions.

$criteriaCompare = new CDbCriteria();
            $criteriaCompare->with = array('manufacturer');
            $criteriaCompare->compare('manufacturer.archive' , 'n');

            $criteriaCondition = new CDbCriteria();
            $criteriaCondition->order = 'RAND()';
            $criteriaCondition->limit = self::SIDEBAR_LIDERS_COUNT;
            $criteriaCondition->addCondition("of_month = '" . self::OF_MONTH_YES . "'");
            $criteriaCondition->addCondition("category_id = '$category->id'");
            $criteriaCondition->addCondition("archive = '" . self::ARCHIVE_NO . "'");

            //Объединяем критерии
            $criteriaCompare->mergeWith($criteriaCondition);

            $products = Product::model()->findAll($criteriaCompare);

It throws an error.... CDbCommand failed to execute SQL query: SQLSTATE[23000]: Integrity constraint violation: 1052 Column 'archive' in where clause is ambiguous.
Separate requests work.

Answer 1

criteriaCondition->addColumnCondition(['t.archive'=>self::ARCHIVE_NO]);