.....tulis beberapa controh query yg agak kompleks ...
Query Builder, http://www.yiiframework.com/doc/guide/1.1/en/database.query-builder
