public innerJoin (mixed $model, [mixed $conditions], [mixed $alias]) Adds an INNER join to the query $criteria->innerJoin('Robots'); $criteria->innerJoin('Robots', 'r.id = RobotsParts.robots_id'); $criteria->innerJoin('Robots', 'r.id = RobotsParts.robots_id', 'r');

public join (mixed $model, [mixed $conditions], [mixed $alias], [mixed $type]) Adds an INNER join to the query $criteria->join('Robots'); $criteria->join('Robots', 'r.id = RobotsParts.robots_id'); $criteria->join('Robots', 'r.id = RobotsParts.robots_id', 'r'); $criteria->join('Robots', 'r.id = RobotsParts.robots_id', 'r', 'LEFT');

public notBetweenWhere (mixed $expr, mixed $minimum, mixed $maximum) Appends a NOT BETWEEN condition to the current conditions $criteria->notBetweenWhere('price', 100.25, 200.50);

public leftJoin (mixed $model, [mixed $conditions], [mixed $alias]) Adds a LEFT join to the query $criteria->leftJoin('Robots', 'r.id = RobotsParts.robots_id', 'r');

public inWhere (mixed $expr, array $values) Appends an IN condition to the current conditions $criteria->inWhere('id', [1, 2, 3]);

public limit (mixed $limit, [mixed $offset]) Adds the limit parameter to the criteria

public groupBy (mixed $group) Adds the group-by clause to the criteria

public getModelName () Returns an internal model name on which the criteria will be applied

public getWhere () Returns the conditions parameter in the criteria

public array getParams () Returns all the parameters defined in the criteria