virtual fields cakphp
// ------------------- CONCAT USE virtualFields $this->virtualFields['myField'] = "CONCAT(language.name, ' (', language.description, ')' )"; // using this for use concat return $this->find('list', array( 'fields' => array( 'ImageType.id', 'myField', ), 'conditions' => array( 'ImageType.slug LIKE' => $slug, ), 'joins' => array( array( 'table' => Environment::read('table_prefix') . 'image_type_languages', 'alias' => 'language', 'type' => 'INNER', 'conditions'=> array( 'ImageType.id = language.image_type_id', 'language.alias = \'' . $language . '\'', ) ), ), ));