Ejemplo n.º 1
0
 /**
  * getTypes
  * @return self
  */
 public function getTypes()
 {
     $types = \Application\MusicianType\Table::select()->select('mtypes.type, m.id, mtypes.id as type_id')->from('musician_type', 'musician_type')->innerJoin('musician_type', 'music_types', 'mtypes', 'musician_type.type_id = mtypes.id')->innerJoin('musician_type', 'musician', 'm', 'musician_type.musician_id = m.id')->where('musician_type.musician_id = ?', $this->id)->execute();
     return $types;
 }