shabaz-ejaz · October 16, 2018 13:11
diff --git a/Join query.php b/Join query.php
 $products = AirtablesProduct:: find()
            ->with('airtablesProductsTypes.airtablesProductType')
            ->with('airtablesProductsComponents.airtablesComponent')
            ->with('airtablesProductsSizes.airtablesProductSize')
            ->with('airtablesProductsSpecies.airtablesSpecie')
            ->orderBy('name ASC')
            ->asArray();
diff --git a/join table and count records.php b/join table and count records.php
 return static::find()->where(['user_referred_by' => $this->id ])->andWhere(['NOT',['user_subscription.id' => null]])->joinWith('subscription')->asArray()->count(); die;
diff --git a/join tables with activerecord b/join tables with activerecord
 https://stackoverflow.com/questions/28525945/retrieve-data-from-junction-table-in-yii2
	$products = AirtablesProduct:: find()
	->with('airtablesProductsTypes.airtablesProductType')
	->with('airtablesProductsComponents.airtablesComponent')
	->with('airtablesProductsSizes.airtablesProductSize')
	->with('airtablesProductsSpecies.airtablesSpecie')
	->orderBy('name ASC')
	->asArray();