public static function find($id)
 {
     $query = DB::connection()->prepare('SELECT * FROM Competition WHERE id = :id LIMIT 1');
     $query->execute(array('id' => $id));
     $row = $query->fetch();
     if ($row) {
         return new Competition(Competition::get_attributes($row));
     }
     return null;
 }