public offset (mixed $offset) Sets an OFFSET clause $builder->offset(30);

public Phalcon\Mvc\Model\Query\Builder rightJoin (string $model, [string $conditions], [string $alias]) Adds a RIGHT join to the query $builder->rightJoin('Robots', 'r.id = RobotsParts.robots_id', 'r');

public Phalcon\Mvc\Model\Query\Builder leftJoin (string $model, [string $conditions], [string $alias]) Adds a LEFT join to the query $builder->leftJoin('Robots', 'r.id = RobotsParts.robots_id', 'r');

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

public limit ([mixed $limit], [mixed $offset]) Sets a LIMIT clause, optionally an offset clause $builder->limit(100); $builder->limit(100, 20);

public notInWhere (mixed $expr, array $values, [mixed $operator]) Appends a NOT IN condition to the current conditions $builder->notInWhere('id', [1, 2, 3]);

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

public Phalcon\Mvc\Model\Query\Builder join (string $model, [string $conditions], [string $alias], [string $type]) Adds an INNER join to the query // Inner Join model 'Robots' with automatic conditions and alias $builder->join('Robots'); // Inner Join model 'Robots' specifing conditions $builder->join('Robots', 'Robots.id = RobotsParts.robots_id'); // Inner Join model 'Robots' specifing conditions and alias $builder->join('Robots', 'r.id = RobotsParts.robots_id', 'r'); // Left

public having (mixed $having) Sets a HAVING condition clause. You need to escape PHQL reserved words using [ and ] delimiters $builder->having('SUM(Robots.price) > 0');

public Phalcon\Mvc\Model\Query\Builder groupBy (string | array $group) Sets a GROUP BY clause $builder->groupBy(array('Robots.name'));