public Select::countQuery() Get the

public SelectExtender::where($snippet, $args = array())

Array of fields to update to an expression in case of a duplicate record. This variable is a nested array in the following format:

Array of conditions. Type:

public Insert::from(SelectInterface $query) Sets

public AlterableInterface::hasTag($tag)

public SelectExtender::addJoin($type, $table, $alias = NULL

public QueryConditionTrait::compiled()

public Select::compile(Connection $connection, PlaceholderInterface $queryP

The fields by which to order this query. This is an associative array. The keys are the fields to order, and the value is the direction to order