innerJoinWith() public method Inner joins with the specified relations. This is a shortcut method to joinWith() with the join type set as "INNER JOIN". Please refer to joinWith() for detailed usage of this method. See also joinWith(). public $this innerJoinWith ( $with, $eagerLoading = true )$with string|array The relations to be joined with. $eagerLoading boolean|array Whether to eager loading the relations. return $this The query object itself

init() public method Initializes the object. This method is called at the end of the constructor. The default implementation will trigger an EVENT_INIT event. If you override this method, make sure you call the parent implementation at the end to ensure triggering of the event. public void init ( )

EVENT_INIT event of type \yii\db\Event An event that is triggered when the query is initialized via init().

createCommand() public method Creates a DB command that can be used to execute this query. public yii\db\Command createCommand ( $db = null )$db yii\db\Connection The DB connection used to create the DB command. If null, the DB connection returned by $modelClass will be used. return yii\db\Command The created DB command instance.

andOnCondition() public method Adds an additional ON condition to the existing one. The new condition and the existing one will be joined using the 'AND' operator. See also: onCondition() orOnCondition() public $this andOnCondition ( $condition, $params = [] )$condition string|array The new ON condition. Please refer to where() on how to specify this parameter. $params array The parameters (name => value) to be bound to the query. return $this The query object itself

all() public method Executes query and returns all results as an array. public array|yii\db\ActiveRecord[] all ( $db = null )$db yii\db\Connection The DB connection used to create the DB command. If null, the DB connection returned by $modelClass will be used. return array|yii\db\ActiveRecord[] The query results. If the query results in nothing, an empty array will be returned.

alias() public method (available since version 2.0.7) Define an alias for the table defined in $modelClass. This method will adjust from() so that an already defined alias will be overwritten. If none was defined, from() will be populated with the given alias. public $this alias ( $alias )$alias string The table alias. return $this The query object itself

$sql public property The SQL statement to be executed for retrieving AR records. This is set by yii\db\ActiveRecord::findBySql(). public string $sql = null

$on public property The join condition to be used when this query is used in a relational context. The condition will be used in the ON part when yii\db\ActiveQuery::joinWith() is called. Otherwise, the condition will be used in the WHERE part of a query. Please refer to yii\db\Query::where() on how to specify this parameter. See also onCondition(). public string|array $on = null

$joinWith public property A list of relations that this query should be joined with public array $joinWith = null