createCommand() public method Creates a DB command that

one() public method Executes the query and returns a single

$union public property This is used to construct the UNION clause(s)

where() public method Sets the WHERE part of the query

orWhere() public method Adds an additional WHERE condition

addSelect() public method Add more columns to the SELECT

queryScalar() protected method Queries a scalar value

leftJoin() public method Appends a LEFT OUTER JOIN part

andHaving() public method Adds an additional HAVING condition

groupBy() public method Sets the GROUP BY part of the