original_string: public function get_assessment_of_submission_by_user($submissionid, $reviewerid) {
          global $DB;
  
          $reviewerfields = user_picture::fields('reviewer', null, 'revieweridx', 'reviewer');
          $authorfields   = user_picture::fields('author', null, 'authorid', 'author');
          $overbyfields   = user_picture::fields('overby', null, 'gradinggradeoverbyx', 'overby');
          $sql = "SELECT a.*, s.title, $reviewerfields, $authorfields, $overbyfields
                    FROM {workshop_assessments} a
              INNER JOIN {user} reviewer ON (a.reviewerid = reviewer.id)
              INNER JOIN {workshop_submissions} s ON (a.submissionid = s.id AND s.example = 0)
              INNER JOIN {user} author ON (s.authorid = author.id)
               LEFT JOIN {user} overby ON (a.gradinggradeoverby = overby.id)
                   WHERE s.id = :sid AND reviewer.id = :rid AND s.workshopid = :workshopid";
          $params = array('sid' => $submissionid, 'rid' => $reviewerid, 'workshopid' => $this->id);
  
          return $DB->get_record_sql($sql, $params, IGNORE_MISSING);
      }
code: public function get_assessment_of_submission_by_user($submissionid, $reviewerid) {
          global $DB;
  
          $reviewerfields = user_picture::fields('reviewer', null, 'revieweridx', 'reviewer');
          $authorfields   = user_picture::fields('author', null, 'authorid', 'author');
          $overbyfields   = user_picture::fields('overby', null, 'gradinggradeoverbyx', 'overby');
          $sql = "SELECT a.*, s.title, $reviewerfields, $authorfields, $overbyfields
                    FROM {workshop_assessments} a
              INNER JOIN {user} reviewer ON (a.reviewerid = reviewer.id)
              INNER JOIN {workshop_submissions} s ON (a.submissionid = s.id AND s.example = 0)
              INNER JOIN {user} author ON (s.authorid = author.id)
               LEFT JOIN {user} overby ON (a.gradinggradeoverby = overby.id)
                   WHERE s.id = :sid AND reviewer.id = :rid AND s.workshopid = :workshopid";
          $params = array('sid' => $submissionid, 'rid' => $reviewerid, 'workshopid' => $this->id);
  
          return $DB->get_record_sql($sql, $params, IGNORE_MISSING);
      }
code_tokens: public function get_assessment_of_submission_by_user ( $ submissionid , $ reviewerid ) { global $ DB ; $ reviewerfields = user_picture :: fields ( 'reviewer' , null , 'revieweridx' , 'reviewer' ) ; $ authorfields = user_picture :: fields ( 'author' , null , 'authorid' , 'author' ) ; $ overbyfields = user_picture :: fields ( 'overby' , null , 'gradinggradeoverbyx' , 'overby' ) ; $ sql = "SELECT a.*, s.title, $reviewerfields, $authorfields, $overbyfields
                    FROM {workshop_assessments} a
              INNER JOIN {user} reviewer ON (a.reviewerid = reviewer.id)
              INNER JOIN {workshop_submissions} s ON (a.submissionid = s.id AND s.example = 0)
              INNER JOIN {user} author ON (s.authorid = author.id)
               LEFT JOIN {user} overby ON (a.gradinggradeoverby = overby.id)
                   WHERE s.id = :sid AND reviewer.id = :rid AND s.workshopid = :workshopid" ; $ params = array ( 'sid' => $ submissionid , 'rid' => $ reviewerid , 'workshopid' => $ this -> id ) ; return $ DB -> get_record_sql ( $ sql , $ params , IGNORE_MISSING ) ; }
docstring: Get the complete information about the user's assessment of the given submission
  
  @param int $sid submission ID
  @param int $uid user ID of the reviewer
  @return false|stdclass false if not found, stdclass otherwise
docstring_tokens: Get the complete information about the user s assessment of the given submission