/home/shquier/easyconf.net/easychair/app/helpers/conflict.php:12:            WHERE reviewer_id = ?
/home/shquier/easyconf.net/easychair/app/views/admin/conference_home/platform_performance_capacity_center.php:23:=> $stats['review_assignments'],
/home/shquier/easyconf.net/easychair/app/views/admin/review_assignments/bulk.php:94:                <input type="checkbox" name="reviewer_ids[]" value="<?= e((string)$r['id']) ?>">
/home/shquier/easyconf.net/easychair/app/views/admin/review_assignments/index.php:44:                  <input type="hidden" name="review_assignment_id" value="<?= e((string)$r['assignment_id']) ?>">
/home/shquier/easyconf.net/easychair/app/views/admin/review_assignments/index.php:45:                  <input type="hidden" name="reviewer_id" value="<?= e((string)$r['reviewer_id']) ?>">
/home/shquier/easyconf.net/easychair/app/views/admin/business_tools/index.php:212:                        <select name="reviewer_id" class="form-select" required>
/home/shquier/easyconf.net/easychair/app/views/admin/submissions_workflow/view.php:134:              <select class="form-select" name="reviewer_ids[]" multiple size="8" required>
/home/shquier/easyconf.net/easychair/app/views/admin/partials/user_profile_action.php:9:$uid = (int)($userRow['user_id'] ?? $userRow['id'] ?? $userRow['reviewer_id'] ?? 0);
/home/shquier/easyconf.net/easychair/app/views/admin/reviewers_stable/index.php:28:                  <input type="hidden" name="reviewer_id" value="<?= e((string)$id) ?>">
/home/shquier/easyconf.net/easychair/app/views/admin/reviewer_analytics/index.php:126:<td><?= (int)$o['reviewer_id'] ?></td>
/home/shquier/easyconf.net/easychair/app/views/admin/review_assignments_tenant/index.php:35:          <select class="form-select" name="reviewer_id" required>
/home/shquier/easyconf.net/easychair/app/views/admin/conference_templates/form.php:16:        <input type="text" name="event_key" class="form-control rounded-3" value="<?= e((string) ($item['event_key'] ?? '')) ?>" placeholder="submission_created, review_assigned, decision_made, revision_uploaded, camera_ready_reminder" required>
/home/shquier/easyconf.net/easychair/app/views/admin/assignments/index.php:42:                    <select name="reviewer_id" class="form-select" required>
/home/shquier/easyconf.net/easychair/app/views/admin/reviewer_assignments/index.php:348:ON u.id=rrs.suggested_reviewer_id
/home/shquier/easyconf.net/easychair/app/views/admin/reviewer_assignments/index.php:591:name="reviewer_id"
/home/shquier/easyconf.net/easychair/app/views/admin/reviewer_assignments/index.php:1208:$('select[name="reviewer_id"]')
/home/shquier/easyconf.net/easychair/app/views/admin/reviewer_assignments/index.php:1251:            'select[name="reviewer_id"]'
/home/shquier/easyconf.net/easychair/app/views/admin/submissions/index.php.before_professional_table_ui:761:name="reviewer_id"
/home/shquier/easyconf.net/easychair/app/views/admin/submissions/index.php.before_professional_table_ui:854:'select[name="reviewer_id"]'
/home/shquier/easyconf.net/easychair/app/views/admin/submissions/show.php:19:name="reviewer_ids[]"
/home/shquier/easyconf.net/easychair/app/views/admin/submissions/show.php:93:'select[name="reviewer_id"]'
/home/shquier/easyconf.net/easychair/app/views/admin/submissions/index.php:851:name="reviewer_id"
/home/shquier/easyconf.net/easychair/app/views/admin/submissions/index.php:944:'select[name="reviewer_id"]'
/home/shquier/easyconf.net/easychair/app/views/admin/reviewer_certificates/index.php:70:href="/easychair/admin/reviewer-certificates/generate?id=<?= (int)$r['reviewer_id'] ?>"
/home/shquier/easyconf.net/easychair/app/views/admin/_backup_before_review_restore_2026-04-29_2121/review_assignments/bulk.php:94:                <input type="checkbox" name="reviewer_ids[]" value="<?= e((string)$r['id']) ?>">
/home/shquier/easyconf.net/easychair/app/views/admin/_backup_before_review_restore_2026-04-29_2121/review_assignments/index.php:44:                  <input type="hidden" name="review_assignment_id" value="<?= e((string)$r['assignment_id']) ?>">
/home/shquier/easyconf.net/easychair/app/views/admin/_backup_before_review_restore_2026-04-29_2121/review_assignments/index.php:45:                  <input type="hidden" name="reviewer_id" value="<?= e((string)$r['reviewer_id']) ?>">
/home/shquier/easyconf.net/easychair/app/views/admin/_backup_before_review_restore_2026-04-29_2121/reviewers_stable/index.php:28:                  <input type="hidden" name="reviewer_id" value="<?= e((string)$id) ?>">
/home/shquier/easyconf.net/easychair/app/views/admin/_backup_before_review_restore_2026-04-29_2121/reviewer_analytics/index.php:16:<td><a href="<?= e(base_path('certificate/reviewer?reviewer_id=' . (int) $row['id'])) ?>" class="btn ec-btn btn-sm btn-outline-primary rounded-3"><?= e(trans('generate_certificate')) ?></a></td>
/home/shquier/easyconf.net/easychair/app/views/admin/_backup_before_review_restore_2026-04-29_2121/review_assignments_tenant/index.php:35:          <select class="form-select" name="reviewer_id" required>
/home/shquier/easyconf.net/easychair/app/views/admin/_backup_before_review_restore_2026-04-29_2121/reviewer_assignments/index.php:17:        <select class="form-select" name="reviewer_id" required>
/home/shquier/easyconf.net/easychair/app/views/admin/index.php:65:            <div class="kpi-label"><?= e(trans('review_assignments')) ?></div>
/home/shquier/easyconf.net/easychair/app/views/reviewer/form.php:25:        <h1 class="page-title"><?= e(trans('review_assignments')) ?></h1>
/home/shquier/easyconf.net/easychair/app/views/reviewer/mentorship.php:47:<td>#<?= (int)$r['mentee_reviewer_id'] ?></td>
/home/shquier/easyconf.net/easychair/app/views/reviewer/mentorship.php:99:<td>#<?= (int)$r['mentor_reviewer_id'] ?></td>
/home/shquier/easyconf.net/easychair/app/views/reviews/my_assignments.php:5:        <h1 class="fw-bold mb-0"><?= e(trans('my_review_assignments')) ?></h1>
/home/shquier/easyconf.net/easychair/app/views/reviews/reviewer_assignments.php:4:    <h1 class="page-title"><?= e(trans('review_assignments')) ?></h1>
/home/shquier/easyconf.net/easychair/app/views/reviews/assignments_manage.php:5:        <h1 class="page-title"><?= e(trans('review_assignments')) ?></h1>
/home/shquier/easyconf.net/easychair/app/views/reviews/assignments_manage.php:31:                    <select name="reviewer_ids[]" class="form-select rounded-3" multiple size="8" required>
/home/shquier/easyconf.net/easychair/app/views/reviews/assignments_manage.php:75:                                <input type="hidden" name="review_assignment_id" value="<?= e((string) $a['id']) ?>">
/home/shquier/easyconf.net/easychair/app/views/reviews/assignments_manage.php:76:                                <input type="hidden" name="reviewer_id" value="<?= e((string) $a['reviewer_id']) ?>">
/home/shquier/easyconf.net/easychair/app/views/reviews/assignments_index.php:4:    <h1 class="page-title"><i class="fa-solid fa-user-check me-2"></i><?= e(trans('review_assignments')) ?></h1>
/home/shquier/easyconf.net/easychair/app/controllers/AdminCertificatesRulesController.php:76:              JOIN review_assignments ra ON ra.id = r.assignment_id
/home/shquier/easyconf.net/easychair/app/controllers/AdminCertificatesRulesController.php:78:              WHERE s.conference_id=:c AND ra.reviewer_id=:u
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_conference_brochure:13638:            FROM review_assignments ra
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_conference_brochure:13641:                ON u.id = ra.reviewer_id
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_conference_brochure:13852:            FROM review_assignments
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_conference_brochure:13953:            UPDATE review_assignments
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_conference_brochure:14210:            LEFT JOIN review_assignments ra
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_conference_brochure:14297:            LEFT JOIN review_assignments ra
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_conference_brochure:14476:            LEFT JOIN review_assignments ra
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_conference_brochure:14585:            LEFT JOIN review_assignments ra
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_conference_brochure:14721:            LEFT JOIN review_assignments ra
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_conference_brochure:14844:            LEFT JOIN review_assignments ra
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_conference_brochure:14983:            LEFT JOIN review_assignments ra
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_conference_brochure:15564:            LEFT JOIN review_assignments ra
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_conference_brochure:15734:                LEFT JOIN review_assignments ra
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_conference_brochure:15770:                LEFT JOIN review_assignments ra
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_conference_brochure:16009:            INNER JOIN review_assignments ra
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_conference_brochure:16010:                ON ra.reviewer_id=u.id
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_conference_brochure:16118:            INNER JOIN conference_reviewers cr
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_conference_brochure:16124:            LEFT JOIN review_assignments ra
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_conference_brochure:16125:                ON ra.reviewer_id=u.id
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_conference_brochure:16262:            LEFT JOIN review_assignments ra
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_conference_brochure:16399:            LEFT JOIN review_assignments ra
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_conference_brochure:16538:            LEFT JOIN review_assignments ra
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_conference_brochure:16729:            LEFT JOIN review_assignments ra
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_conference_brochure:16866:                reviewer_id,
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_conference_brochure:16870:            FROM review_assignments
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_conference_brochure:16874:            GROUP BY reviewer_id
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_conference_brochure:16900:                $row['reviewer_id'] .
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_conference_brochure:16966:            INNER JOIN review_assignments ra
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_conference_brochure:17073:            LEFT JOIN review_assignments ra
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_conference_brochure:17189:            LEFT JOIN review_assignments ra
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_conference_brochure:17296:                FROM review_assignments
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_conference_brochure:17304:                FROM conference_reviewers
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_conference_brochure:17360:                SELECT reviewer_id
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_conference_brochure:17362:                FROM review_assignments
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_conference_brochure:17366:                GROUP BY reviewer_id
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_conference_brochure:17386:                INNER JOIN review_assignments ra
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_conference_brochure:17464:        INNER JOIN conference_reviewers cr ON cr.user_id=u.id
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_conference_brochure:17466:        LEFT JOIN review_assignments ra
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_conference_brochure:17467:            ON ra.reviewer_id=u.id
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_conference_brochure:17494:        LEFT JOIN review_assignments ra ON ra.submission_id=s.id
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_conference_brochure:18937:            SELECT COUNT(DISTINCT reviewer_id)
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_conference_brochure:18938:            FROM review_assignments
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_conference_brochure:19029:            INNER JOIN review_assignments ra
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_conference_brochure:19030:                ON ra.reviewer_id=u.id
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_conference_brochure:19113:            SELECT COUNT(DISTINCT reviewer_id)
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_conference_brochure:19114:            FROM review_assignments
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_conference_brochure:19126:            FROM review_assignments
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_conference_brochure:19139:            FROM review_assignments
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_conference_brochure:19152:            FROM review_assignments
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_conference_brochure:19206:            INNER JOIN review_assignments ra
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_conference_brochure:19207:                ON ra.reviewer_id=u.id
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_conference_brochure:19321:            LEFT JOIN review_assignments ra
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_conference_brochure:19400:            SELECT COUNT(DISTINCT reviewer_id)
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_conference_brochure:19401:            FROM review_assignments
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_conference_brochure:19407:            FROM review_assignments
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_conference_brochure:19540:            FROM review_assignments
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_conference_brochure:19576:            JOIN review_assignments ra
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_conference_brochure:19577:                ON ra.reviewer_id=u.id
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_conference_brochure:19732:            FROM review_assignments
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_conference_brochure:19918:            LEFT JOIN review_assignments ra
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_conference_brochure:20044:            SELECT COUNT(DISTINCT reviewer_id)
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_conference_brochure:20045:            FROM review_assignments
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_conference_brochure:20108:            FROM review_assignments
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_conference_brochure:20575:            FROM review_assignments ra
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_conference_brochure:20769:    $stats['review_assignments'] =
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_conference_brochure:20772:            FROM review_assignments
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_conference_brochure:20783:            SELECT COUNT(DISTINCT reviewer_id)
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_conference_brochure:20784:            FROM review_assignments
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_conference_brochure:20798:                $stats['review_assignments']
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_conference_brochure:20823:                    $stats['review_assignments']
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_conference_brochure:20866:            LEFT JOIN review_assignments ra
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_conference_brochure:20936:            SELECT COUNT(DISTINCT reviewer_id)
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_conference_brochure:20937:            FROM review_assignments
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_conference_brochure:21003:            FROM review_assignments
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_conference_brochure:21051:            LEFT JOIN review_assignments ra
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_conference_brochure:21324:            FROM review_assignments
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_conference_brochure:21537:            SELECT COUNT(DISTINCT reviewer_id)
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_conference_brochure:21538:            FROM review_assignments
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_conference_brochure:22151:            FROM review_assignments
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_conference_brochure:22320:            SELECT COUNT(DISTINCT reviewer_id)
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_conference_brochure:22321:            FROM review_assignments
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_conference_brochure:22490:            INNER JOIN review_assignments ra
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_conference_brochure:22491:                ON ra.reviewer_id=u.id
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_conference_brochure:22538:            FROM review_assignments
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_conference_brochure:22816:        FROM review_assignments
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_conference_brochure:22840:        FROM review_assignment_events
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_conference_brochure:22989:        LEFT JOIN review_assignments ra
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_conference_brochure:23064:                DISTINCT reviewer_id
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_conference_brochure:23066:            FROM review_assignments
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_conference_brochure:23078:                DISTINCT reviewer_id
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_conference_brochure:23080:            FROM review_assignments
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_conference_brochure:23299:            FROM review_assignments
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_conference_brochure:23324:            FROM review_assignment_events
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_conference_brochure:23451:            INNER JOIN review_assignments ra
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_conference_brochure:23452:                ON ra.reviewer_id=u.id
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_conference_brochure:23490:        SELECT COUNT(DISTINCT reviewer_id)
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_conference_brochure:23491:        FROM review_assignments
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_conference_brochure:23496:        FROM review_assignments
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_conference_brochure:23501:        SELECT COUNT(DISTINCT reviewer_id)
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_conference_brochure:23502:        FROM review_assignments
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_conference_brochure:23508:        FROM review_assignments
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_conference_brochure:23514:        FROM review_assignments
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_conference_brochure:23560:        INNER JOIN review_assignments ra
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_conference_brochure:23561:                ON ra.reviewer_id=u.id
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_conference_brochure:23807:            FROM review_assignments
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_conference_brochure:23870:            LEFT JOIN review_assignments ra
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_conference_brochure:24053:            FROM review_assignments
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_conference_brochure:24084:            SELECT COUNT(DISTINCT reviewer_id)
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_conference_brochure:24085:            FROM review_assignments
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_conference_brochure:24096:            FROM review_assignments
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_conference_brochure:24286:            LEFT JOIN review_assignments ra
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_conference_brochure:24380:            SELECT COUNT(DISTINCT reviewer_id)
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_conference_brochure:24381:            FROM review_assignments
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_conference_brochure:24392:            SELECT COUNT(DISTINCT reviewer_id)
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_conference_brochure:24393:            FROM review_assignments
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_conference_brochure:24410:            FROM review_assignments
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_conference_brochure:24577:            FROM review_assignments
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_conference_brochure:24588:            SELECT COUNT(DISTINCT reviewer_id)
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_conference_brochure:24589:            FROM review_assignments
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_conference_brochure:24729:            LEFT JOIN review_assignments ra
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_conference_brochure:24785:            FROM review_assignments
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_conference_brochure:24797:            SELECT COUNT(DISTINCT reviewer_id)
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_conference_brochure:24798:            FROM review_assignments
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_conference_brochure:24988:            FROM review_assignments
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_conference_brochure:24995:            FROM review_assignments
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_conference_brochure:25213:            FROM review_assignments
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_conference_brochure:25363:            LEFT JOIN review_assignments ra
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_conference_brochure:25704:            FROM review_assignments
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_conference_brochure:25710:            SELECT COUNT(DISTINCT reviewer_id)
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_conference_brochure:25711:            FROM review_assignments
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_conference_brochure:26149:            FROM conference_reviewers
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_conference_brochure:26154:            SELECT COUNT(DISTINCT reviewer_id)
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_conference_brochure:26155:            FROM review_assignments
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_conference_brochure:26279:            LEFT JOIN conference_reviewers cr
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_conference_brochure:26348:            SELECT COUNT(DISTINCT reviewer_id)
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_conference_brochure:26349:            FROM review_assignments
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_conference_brochure:26354:            SELECT COUNT(DISTINCT reviewer_id)
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_conference_brochure:26355:            FROM review_assignments
/home/shquier/easyconf.net/easychair/app/controllers/ReviewerInteractionController.php:52:            FROM review_assignments ra
/home/shquier/easyconf.net/easychair/app/controllers/ReviewerInteractionController.php:66:        if ($role === 'reviewer' && (int)$a['reviewer_id'] !== (int)$_SESSION['user_id']) {
/home/shquier/easyconf.net/easychair/app/controllers/ReviewerInteractionController.php:93:            WHERE reviewer_id=?
/home/shquier/easyconf.net/easychair/app/controllers/ReviewerInteractionController.php:134:            (org_id, conference_id, reviewer_id, submission_id, preference, expertise_score, notes)
/home/shquier/easyconf.net/easychair/app/controllers/ReviewerInteractionController.php:155:                (org_id, conference_id, submission_id, reviewer_id, conflict_type, reason, declared_by)
/home/shquier/easyconf.net/easychair/app/controllers/AdminAssignmentController.php:95:            LEFT JOIN review_assignments ra ON ra.submission_id = s.id
/home/shquier/easyconf.net/easychair/app/controllers/AdminAssignmentController.php:116:            LEFT JOIN review_assignments ra ON ra.reviewer_id = u.id AND ra.conference_id = uc.conference_id
/home/shquier/easyconf.net/easychair/app/controllers/AdminAssignmentController.php:132:            FROM review_assignments ra
/home/shquier/easyconf.net/easychair/app/controllers/AdminAssignmentController.php:134:            JOIN users u ON u.id = ra.reviewer_id
/home/shquier/easyconf.net/easychair/app/controllers/AdminAssignmentController.php:158:        $reviewerId = (int)($_POST['reviewer_id'] ?? 0);
/home/shquier/easyconf.net/easychair/app/controllers/AdminAssignmentController.php:200:            FROM review_assignments
/home/shquier/easyconf.net/easychair/app/controllers/AdminAssignmentController.php:202:              AND reviewer_id = ?
/home/shquier/easyconf.net/easychair/app/controllers/AdminAssignmentController.php:214:            INSERT INTO review_assignments
/home/shquier/easyconf.net/easychair/app/controllers/AdminAssignmentController.php:215:            (submission_id, conference_id, reviewer_id, assigned_by, due_date, status, assigned_at, round_no, org_id)
/home/shquier/easyconf.net/easychair/app/controllers/AuthorWorkflowController.php.save:253:                LEFT JOIN review_assignments ra 
/home/shquier/easyconf.net/easychair/app/controllers/AuthorWorkflowController.php.save:254:                       ON ra.id = COALESCE(rv.assignment_id, rv.review_assignment_id)
/home/shquier/easyconf.net/easychair/app/controllers/AdminReviewAssignmentController.php:22:            (int)($_POST['reviewer_id'] ?? 0);
/home/shquier/easyconf.net/easychair/app/controllers/AdminReviewAssignmentController.php:61:                    INSERT INTO review_assignments
/home/shquier/easyconf.net/easychair/app/controllers/AdminReviewAssignmentController.php:65:                        reviewer_id,
/home/shquier/easyconf.net/easychair/app/controllers/ReviewerDashboardController.php.pack719_stable:65:FROM review_assignments ra
/home/shquier/easyconf.net/easychair/app/controllers/ReviewerDashboardController.php.pack719_stable:71:ON rv.review_assignment_id=ra.id
/home/shquier/easyconf.net/easychair/app/controllers/ReviewerDashboardController.php.pack719_stable:74:ra.reviewer_id=?
/home/shquier/easyconf.net/easychair/app/controllers/ReviewerDashboardController.php.pack719_stable:322:        FROM review_assignments ra
/home/shquier/easyconf.net/easychair/app/controllers/ReviewerDashboardController.php.pack719_stable:325:        AND ra.reviewer_id = ?
/home/shquier/easyconf.net/easychair/app/controllers/ReviewerDashboardController.php.pack719_stable:466:        FROM review_assignments ra
/home/shquier/easyconf.net/easychair/app/controllers/ReviewerDashboardController.php.pack719_stable:469:        AND ra.reviewer_id = ?
/home/shquier/easyconf.net/easychair/app/controllers/ReviewerDashboardController.php.pack719_stable:566:            review_assignment_id,
/home/shquier/easyconf.net/easychair/app/controllers/ReviewerDashboardController.php.pack719_stable:568:            reviewer_id,
/home/shquier/easyconf.net/easychair/app/controllers/ReviewerDashboardController.php.pack719_stable:637:        UPDATE review_assignments
/home/shquier/easyconf.net/easychair/app/controllers/ReviewerDashboardController.php.pack719_stable:674:        WHERE r.reviewer_id = ?
/home/shquier/easyconf.net/easychair/app/controllers/AdminReviewerController.php:156:         * Fallback includes reviewers already assigned in review_assignments.
/home/shquier/easyconf.net/easychair/app/controllers/AdminReviewerController.php:178:                    reviewer_id,
/home/shquier/easyconf.net/easychair/app/controllers/AdminReviewerController.php:182:                FROM review_assignments
/home/shquier/easyconf.net/easychair/app/controllers/AdminReviewerController.php:184:                GROUP BY reviewer_id
/home/shquier/easyconf.net/easychair/app/controllers/AdminReviewerController.php:185:            ) stats ON stats.reviewer_id = u.id
/home/shquier/easyconf.net/easychair/app/controllers/AdminReviewerController.php:206:            FROM review_assignments ra
/home/shquier/easyconf.net/easychair/app/controllers/AdminReviewerController.php:207:            INNER JOIN users u ON u.id = ra.reviewer_id
/home/shquier/easyconf.net/easychair/app/controllers/AdminReviewerController.php:210:                    reviewer_id,
/home/shquier/easyconf.net/easychair/app/controllers/AdminReviewerController.php:214:                FROM review_assignments
/home/shquier/easyconf.net/easychair/app/controllers/AdminReviewerController.php:216:                GROUP BY reviewer_id
/home/shquier/easyconf.net/easychair/app/controllers/AdminReviewerController.php:217:            ) stats ON stats.reviewer_id = u.id
/home/shquier/easyconf.net/easychair/app/controllers/AdminReviewerController.php:272:                    ra.reviewer_id
/home/shquier/easyconf.net/easychair/app/controllers/AdminReviewerController.php:273:                FROM review_assignments ra
/home/shquier/easyconf.net/easychair/app/controllers/AdminReviewerController.php:368:            FROM conference_reviewers cr
/home/shquier/easyconf.net/easychair/app/controllers/AdminReviewerController.php:371:                ON u.id=cr.reviewer_id
/home/shquier/easyconf.net/easychair/app/controllers/AdminReviewerController.php:376:            LEFT JOIN review_assignments ra
/home/shquier/easyconf.net/easychair/app/controllers/AdminReviewerController.php:377:                ON ra.reviewer_id=u.id
/home/shquier/easyconf.net/easychair/app/controllers/AdminReviewMatrixController.php:36:          LEFT JOIN review_assignments ra ON ra.submission_id=s.id
/home/shquier/easyconf.net/easychair/app/controllers/AdminSubmissionsTenantController.php:79:          FROM review_assignments ra
/home/shquier/easyconf.net/easychair/app/controllers/AdminSubmissionsTenantController.php:80:          JOIN users u ON u.id=ra.reviewer_id
/home/shquier/easyconf.net/easychair/app/controllers/AdminReviewAssignmentsSuggestController.php:66:        $as = $db->prepare("SELECT reviewer_id FROM review_assignments WHERE submission_id=:sid AND round_no=:rn AND submission_id IN (SELECT id FROM submissions WHERE conference_id IN (SELECT id FROM conferences WHERE org_id=".(int)$orgId.")) ");
/home/shquier/easyconf.net/easychair/app/controllers/AdminReviewAssignmentsSuggestController.php:70:        $this->view('admin/review_assignments/suggest', [
/home/shquier/easyconf.net/easychair/app/controllers/AdminSubmissionController.php.pre_layout_fix:216:                LEFT JOIN review_assignments ra
/home/shquier/easyconf.net/easychair/app/controllers/AdminSubmissionController.php.pre_layout_fix:253:FROM conference_reviewers cr
/home/shquier/easyconf.net/easychair/app/controllers/AdminUserController.php:546:INSERT IGNORE INTO conference_reviewers
/home/shquier/easyconf.net/easychair/app/controllers/AdminUserController.php:833:                FROM conference_reviewers
/home/shquier/easyconf.net/easychair/app/controllers/AdminUserController.php:841:                    INSERT INTO conference_reviewers
/home/shquier/easyconf.net/easychair/app/controllers/AdminUserController.php:952:                'conference_reviewers',
/home/shquier/easyconf.net/easychair/app/controllers/AdminUserController.php:965:                $db->prepare("DELETE FROM review_assignments WHERE reviewer_id = ?")
/home/shquier/easyconf.net/easychair/app/controllers/AdminUserController.php:1673:                            INSERT IGNORE INTO conference_reviewers
/home/shquier/easyconf.net/easychair/app/controllers/AdminUserController.php:1676:                                reviewer_id
/home/shquier/easyconf.net/easychair/app/controllers/AdminReviewerAssignmentsController.php.fix_parse_20260526_040725:100:          FROM review_assignments ra
/home/shquier/easyconf.net/easychair/app/controllers/AdminReviewerAssignmentsController.php.fix_parse_20260526_040725:101:          JOIN users u ON u.id=ra.reviewer_id
/home/shquier/easyconf.net/easychair/app/controllers/AdminReviewerAssignmentsController.php.fix_parse_20260526_040725:125:        $rid=(int)($_POST['reviewer_id']??0);
/home/shquier/easyconf.net/easychair/app/controllers/AdminReviewerAssignmentsController.php.fix_parse_20260526_040725:142:INSERT IGNORE INTO review_assignments
/home/shquier/easyconf.net/easychair/app/controllers/AdminReviewerAssignmentsController.php.fix_parse_20260526_040725:145:reviewer_id,
/home/shquier/easyconf.net/easychair/app/controllers/AdminSubmissionWorkflowController.php:265:            FROM review_assignments ra
/home/shquier/easyconf.net/easychair/app/controllers/AdminSubmissionWorkflowController.php:266:            LEFT JOIN users u ON u.id=ra.reviewer_id
/home/shquier/easyconf.net/easychair/app/controllers/AdminReviewAssignmentsTenantController.php:38:LEFT JOIN review_assignments ra
/home/shquier/easyconf.net/easychair/app/controllers/AdminReviewAssignmentsTenantController.php:79:FROM conference_reviewers cr
/home/shquier/easyconf.net/easychair/app/controllers/AdminReviewAssignmentsTenantController.php:84:LEFT JOIN review_assignments ra
/home/shquier/easyconf.net/easychair/app/controllers/AdminReviewAssignmentsTenantController.php:85:ON ra.reviewer_id=u.id
/home/shquier/easyconf.net/easychair/app/controllers/AdminReviewAssignmentsTenantController.php:130:FROM review_assignments ra
/home/shquier/easyconf.net/easychair/app/controllers/AdminReviewAssignmentsTenantController.php:136:ON u.id=ra.reviewer_id
/home/shquier/easyconf.net/easychair/app/controllers/AuthController.php:291:            FROM conference_reviewers cr
/home/shquier/easyconf.net/easychair/app/controllers/AdminSubmissionWorkflowController.php.before_pack956A_workflow_sync:262:            FROM review_assignments ra
/home/shquier/easyconf.net/easychair/app/controllers/AdminSubmissionWorkflowController.php.before_pack956A_workflow_sync:263:            LEFT JOIN users u ON u.id=ra.reviewer_id
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_pack1149:13540:            FROM review_assignments ra
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_pack1149:13543:                ON u.id = ra.reviewer_id
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_brochure_fullfix:13638:            FROM review_assignments ra
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_brochure_fullfix:13641:                ON u.id = ra.reviewer_id
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_brochure_fullfix:13852:            FROM review_assignments
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_brochure_fullfix:13953:            UPDATE review_assignments
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_brochure_fullfix:14210:            LEFT JOIN review_assignments ra
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_brochure_fullfix:14297:            LEFT JOIN review_assignments ra
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_brochure_fullfix:14476:            LEFT JOIN review_assignments ra
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_brochure_fullfix:14585:            LEFT JOIN review_assignments ra
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_brochure_fullfix:14721:            LEFT JOIN review_assignments ra
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_brochure_fullfix:14844:            LEFT JOIN review_assignments ra
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_brochure_fullfix:14983:            LEFT JOIN review_assignments ra
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_brochure_fullfix:15564:            LEFT JOIN review_assignments ra
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_brochure_fullfix:15734:                LEFT JOIN review_assignments ra
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_brochure_fullfix:15770:                LEFT JOIN review_assignments ra
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_brochure_fullfix:16009:            INNER JOIN review_assignments ra
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_brochure_fullfix:16010:                ON ra.reviewer_id=u.id
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_brochure_fullfix:16118:            INNER JOIN conference_reviewers cr
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_brochure_fullfix:16124:            LEFT JOIN review_assignments ra
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_brochure_fullfix:16125:                ON ra.reviewer_id=u.id
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_brochure_fullfix:16262:            LEFT JOIN review_assignments ra
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_brochure_fullfix:16399:            LEFT JOIN review_assignments ra
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_brochure_fullfix:16538:            LEFT JOIN review_assignments ra
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_brochure_fullfix:16729:            LEFT JOIN review_assignments ra
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_brochure_fullfix:16866:                reviewer_id,
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_brochure_fullfix:16870:            FROM review_assignments
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_brochure_fullfix:16874:            GROUP BY reviewer_id
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_brochure_fullfix:16900:                $row['reviewer_id'] .
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_brochure_fullfix:16966:            INNER JOIN review_assignments ra
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_brochure_fullfix:17073:            LEFT JOIN review_assignments ra
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_brochure_fullfix:17189:            LEFT JOIN review_assignments ra
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_brochure_fullfix:17296:                FROM review_assignments
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_brochure_fullfix:17304:                FROM conference_reviewers
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_brochure_fullfix:17360:                SELECT reviewer_id
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_brochure_fullfix:17362:                FROM review_assignments
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_brochure_fullfix:17366:                GROUP BY reviewer_id
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_brochure_fullfix:17386:                INNER JOIN review_assignments ra
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_brochure_fullfix:17464:        INNER JOIN conference_reviewers cr ON cr.user_id=u.id
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_brochure_fullfix:17466:        LEFT JOIN review_assignments ra
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_brochure_fullfix:17467:            ON ra.reviewer_id=u.id
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_brochure_fullfix:17494:        LEFT JOIN review_assignments ra ON ra.submission_id=s.id
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_brochure_fullfix:18937:            SELECT COUNT(DISTINCT reviewer_id)
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_brochure_fullfix:18938:            FROM review_assignments
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_brochure_fullfix:19029:            INNER JOIN review_assignments ra
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_brochure_fullfix:19030:                ON ra.reviewer_id=u.id
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_brochure_fullfix:19113:            SELECT COUNT(DISTINCT reviewer_id)
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_brochure_fullfix:19114:            FROM review_assignments
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_brochure_fullfix:19126:            FROM review_assignments
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_brochure_fullfix:19139:            FROM review_assignments
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_brochure_fullfix:19152:            FROM review_assignments
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_brochure_fullfix:19206:            INNER JOIN review_assignments ra
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_brochure_fullfix:19207:                ON ra.reviewer_id=u.id
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_brochure_fullfix:19321:            LEFT JOIN review_assignments ra
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_brochure_fullfix:19400:            SELECT COUNT(DISTINCT reviewer_id)
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_brochure_fullfix:19401:            FROM review_assignments
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_brochure_fullfix:19407:            FROM review_assignments
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_brochure_fullfix:19540:            FROM review_assignments
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_brochure_fullfix:19576:            JOIN review_assignments ra
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_brochure_fullfix:19577:                ON ra.reviewer_id=u.id
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_brochure_fullfix:19732:            FROM review_assignments
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_brochure_fullfix:19918:            LEFT JOIN review_assignments ra
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_brochure_fullfix:20044:            SELECT COUNT(DISTINCT reviewer_id)
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_brochure_fullfix:20045:            FROM review_assignments
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_brochure_fullfix:20108:            FROM review_assignments
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_brochure_fullfix:20575:            FROM review_assignments ra
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_brochure_fullfix:20769:    $stats['review_assignments'] =
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_brochure_fullfix:20772:            FROM review_assignments
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_brochure_fullfix:20783:            SELECT COUNT(DISTINCT reviewer_id)
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_brochure_fullfix:20784:            FROM review_assignments
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_brochure_fullfix:20798:                $stats['review_assignments']
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_brochure_fullfix:20823:                    $stats['review_assignments']
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_brochure_fullfix:20866:            LEFT JOIN review_assignments ra
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_brochure_fullfix:20936:            SELECT COUNT(DISTINCT reviewer_id)
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_brochure_fullfix:20937:            FROM review_assignments
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_brochure_fullfix:21003:            FROM review_assignments
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_brochure_fullfix:21051:            LEFT JOIN review_assignments ra
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_brochure_fullfix:21324:            FROM review_assignments
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_brochure_fullfix:21537:            SELECT COUNT(DISTINCT reviewer_id)
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_brochure_fullfix:21538:            FROM review_assignments
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_brochure_fullfix:22151:            FROM review_assignments
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_brochure_fullfix:22320:            SELECT COUNT(DISTINCT reviewer_id)
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_brochure_fullfix:22321:            FROM review_assignments
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_brochure_fullfix:22490:            INNER JOIN review_assignments ra
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_brochure_fullfix:22491:                ON ra.reviewer_id=u.id
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_brochure_fullfix:22538:            FROM review_assignments
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_brochure_fullfix:22816:        FROM review_assignments
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_brochure_fullfix:22840:        FROM review_assignment_events
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_brochure_fullfix:22989:        LEFT JOIN review_assignments ra
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_brochure_fullfix:23064:                DISTINCT reviewer_id
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_brochure_fullfix:23066:            FROM review_assignments
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_brochure_fullfix:23078:                DISTINCT reviewer_id
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_brochure_fullfix:23080:            FROM review_assignments
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_brochure_fullfix:23299:            FROM review_assignments
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_brochure_fullfix:23324:            FROM review_assignment_events
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_brochure_fullfix:23451:            INNER JOIN review_assignments ra
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_brochure_fullfix:23452:                ON ra.reviewer_id=u.id
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_brochure_fullfix:23490:        SELECT COUNT(DISTINCT reviewer_id)
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_brochure_fullfix:23491:        FROM review_assignments
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_brochure_fullfix:23496:        FROM review_assignments
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_brochure_fullfix:23501:        SELECT COUNT(DISTINCT reviewer_id)
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_brochure_fullfix:23502:        FROM review_assignments
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_brochure_fullfix:23508:        FROM review_assignments
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_brochure_fullfix:23514:        FROM review_assignments
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_brochure_fullfix:23560:        INNER JOIN review_assignments ra
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_brochure_fullfix:23561:                ON ra.reviewer_id=u.id
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_brochure_fullfix:23807:            FROM review_assignments
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_brochure_fullfix:23870:            LEFT JOIN review_assignments ra
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_brochure_fullfix:24053:            FROM review_assignments
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_brochure_fullfix:24084:            SELECT COUNT(DISTINCT reviewer_id)
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_brochure_fullfix:24085:            FROM review_assignments
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_brochure_fullfix:24096:            FROM review_assignments
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_brochure_fullfix:24286:            LEFT JOIN review_assignments ra
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_brochure_fullfix:24380:            SELECT COUNT(DISTINCT reviewer_id)
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_brochure_fullfix:24381:            FROM review_assignments
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_brochure_fullfix:24392:            SELECT COUNT(DISTINCT reviewer_id)
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_brochure_fullfix:24393:            FROM review_assignments
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_brochure_fullfix:24410:            FROM review_assignments
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_brochure_fullfix:24577:            FROM review_assignments
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_brochure_fullfix:24588:            SELECT COUNT(DISTINCT reviewer_id)
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_brochure_fullfix:24589:            FROM review_assignments
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_brochure_fullfix:24729:            LEFT JOIN review_assignments ra
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_brochure_fullfix:24785:            FROM review_assignments
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_brochure_fullfix:24797:            SELECT COUNT(DISTINCT reviewer_id)
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_brochure_fullfix:24798:            FROM review_assignments
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_brochure_fullfix:24988:            FROM review_assignments
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_brochure_fullfix:24995:            FROM review_assignments
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_brochure_fullfix:25213:            FROM review_assignments
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_brochure_fullfix:25363:            LEFT JOIN review_assignments ra
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_brochure_fullfix:25704:            FROM review_assignments
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_brochure_fullfix:25710:            SELECT COUNT(DISTINCT reviewer_id)
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_brochure_fullfix:25711:            FROM review_assignments
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_brochure_fullfix:26149:            FROM conference_reviewers
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_brochure_fullfix:26154:            SELECT COUNT(DISTINCT reviewer_id)
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_brochure_fullfix:26155:            FROM review_assignments
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_brochure_fullfix:26279:            LEFT JOIN conference_reviewers cr
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_brochure_fullfix:26348:            SELECT COUNT(DISTINCT reviewer_id)
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_brochure_fullfix:26349:            FROM review_assignments
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_brochure_fullfix:26354:            SELECT COUNT(DISTINCT reviewer_id)
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_brochure_fullfix:26355:            FROM review_assignments
/home/shquier/easyconf.net/easychair/app/controllers/BadgeController.php:32:            $reviewerId = (int) ($_GET['reviewer_id'] ?? 0);
/home/shquier/easyconf.net/easychair/app/controllers/AdminReviewAssignmentsController.php:28:          FROM review_assignments ra
/home/shquier/easyconf.net/easychair/app/controllers/AdminReviewAssignmentsController.php:31:          LEFT JOIN users u ON u.id=ra.reviewer_id
/home/shquier/easyconf.net/easychair/app/controllers/AdminReviewAssignmentsController.php:40:        $this->view('admin/review_assignments/index',['rows'=>$rows,'q'=>'']);
/home/shquier/easyconf.net/easychair/app/controllers/PublicConferenceHomeController.php:86:            'assignments' => "SELECT COUNT(*) FROM review_assignments WHERE conference_id = ?",
/home/shquier/easyconf.net/easychair/app/controllers/PublicConferenceHomeController.php:87:            'reviewers' => "SELECT COUNT(DISTINCT reviewer_id) FROM review_assignments WHERE conference_id = ?",
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceBusinessController.php:932:                FROM review_assignments ra
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceBusinessController.php:933:                JOIN users u ON u.id = ra.reviewer_id
/home/shquier/easyconf.net/easychair/app/controllers/AdminSubmissionSearchController.php:291:LEFT JOIN review_assignments ra
/home/shquier/easyconf.net/easychair/app/controllers/AuthorSubmissionController.php:941:    LEFT JOIN review_assignments ra
/home/shquier/easyconf.net/easychair/app/controllers/AuthorSubmissionController.php:942:        ON ra.id = r.review_assignment_id
/home/shquier/easyconf.net/easychair/app/controllers/AuthorSubmissionController.php:945:        ON u.id = r.reviewer_id
/home/shquier/easyconf.net/easychair/app/controllers/ReviewerAssignmentsController.php:55:FROM review_assignments ra
/home/shquier/easyconf.net/easychair/app/controllers/ReviewerAssignmentsController.php:64:ra.reviewer_id=:uid
/home/shquier/easyconf.net/easychair/app/controllers/ReviewerAssignmentsController.php:132:FROM review_assignments ra
/home/shquier/easyconf.net/easychair/app/controllers/ReviewerAssignmentsController.php:142:AND ra.reviewer_id=:uid
/home/shquier/easyconf.net/easychair/app/controllers/RoleDashboardController.php.before_pack1115:143:                ['key'=>'dashboard.kpi.review_assignments', 'label'=>'Review Assignments', 'value'=>$this->countTable('review_assignments', 'conference_id=? AND org_id=?', [$confId,$orgId]), 'icon'=>'fa-user-check'],
/home/shquier/easyconf.net/easychair/app/controllers/RoleDashboardController.php.before_pack1115:145:                ['key'=>'dashboard.kpi.late_reviews', 'label'=>'Late Reviews', 'value'=>$this->countTable('review_assignments', "conference_id=? AND org_id=? AND due_date IS NOT NULL AND due_date < CURDATE() AND COALESCE(status,'assigned') NOT IN ('completed','submitted')", [$confId,$orgId]), 'icon'=>'fa-triangle-exclamation'],
/home/shquier/easyconf.net/easychair/app/controllers/RoleDashboardController.php.before_pack1115:157:                ['key'=>'dashboard.kpi.review_assignments', 'label'=>'Review Assignments', 'value'=>$this->countTable('review_assignments', 'conference_id=? AND org_id=?', [$confId,$orgId]), 'icon'=>'fa-user-check'],
/home/shquier/easyconf.net/easychair/app/controllers/AdminUserController.php.broken_pack188_20260526_014743:524:FROM conference_reviewers
/home/shquier/easyconf.net/easychair/app/controllers/AdminUserController.php.broken_pack188_20260526_014743:537:INSERT INTO conference_reviewers
/home/shquier/easyconf.net/easychair/app/controllers/DashboardController.php:240:        $data['review_assignments_count'] = $this->scalar("
/home/shquier/easyconf.net/easychair/app/controllers/DashboardController.php:242:            FROM review_assignments ra
/home/shquier/easyconf.net/easychair/app/controllers/DashboardController.php:248:            FROM review_assignments ra
/home/shquier/easyconf.net/easychair/app/controllers/DashboardController.php:260:            SELECT COUNT(DISTINCT ra.reviewer_id)
/home/shquier/easyconf.net/easychair/app/controllers/DashboardController.php:261:            FROM review_assignments ra
/home/shquier/easyconf.net/easychair/app/controllers/DashboardController.php:323:        $where = " WHERE ra.reviewer_id = ? ";
/home/shquier/easyconf.net/easychair/app/controllers/DashboardController.php:334:            FROM review_assignments ra
/home/shquier/easyconf.net/easychair/app/controllers/DashboardController.php:341:            FROM review_assignments ra
/home/shquier/easyconf.net/easychair/app/controllers/DashboardController.php:348:            FROM review_assignments ra
/home/shquier/easyconf.net/easychair/app/controllers/DashboardController.php:355:            FROM review_assignments ra
/home/shquier/easyconf.net/easychair/app/controllers/DashboardController.php:370:            FROM review_assignments ra
/home/shquier/easyconf.net/easychair/app/controllers/AdminAutoAssignController.php:51:            SELECT ra.reviewer_id, COUNT(*) AS cnt
/home/shquier/easyconf.net/easychair/app/controllers/AdminAutoAssignController.php:52:            FROM review_assignments ra
/home/shquier/easyconf.net/easychair/app/controllers/AdminAutoAssignController.php:55:            GROUP BY ra.reviewer_id
/home/shquier/easyconf.net/easychair/app/controllers/AdminAutoAssignController.php:60:            $loadMap[(int)$r['reviewer_id']] = (int)$r['cnt'];
/home/shquier/easyconf.net/easychair/app/controllers/AdminAutoAssignController.php:65:            INSERT IGNORE INTO review_assignments (submission_id, reviewer_id, assigned_by, round_no, due_date, status)
/home/shquier/easyconf.net/easychair/app/controllers/AdminAutoAssignController.php:73:            $st = $db->prepare("SELECT reviewer_id FROM review_assignments WHERE submission_id=:sid AND round_no=:rn");
/home/shquier/easyconf.net/easychair/app/controllers/OperationsController.php:367:        $reviewerId = (int) ($_GET['reviewer_id'] ?? 0);
/home/shquier/easyconf.net/easychair/app/controllers/ReviewerController.php:146:                ra.reviewer_id,
/home/shquier/easyconf.net/easychair/app/controllers/ReviewerController.php:154:            FROM review_assignments ra
/home/shquier/easyconf.net/easychair/app/controllers/ReviewerController.php:185:        (int)$assignment['reviewer_id']
/home/shquier/easyconf.net/easychair/app/controllers/ReviewerController.php:206:    INNER JOIN review_assignments ra
/home/shquier/easyconf.net/easychair/app/controllers/ReviewerController.php:208:    WHERE ra.reviewer_id = ?
/home/shquier/easyconf.net/easychair/app/controllers/ReviewerController.php:277:            reviewer_id
/home/shquier/easyconf.net/easychair/app/controllers/ReviewerController.php:278:        FROM review_assignments
/home/shquier/easyconf.net/easychair/app/controllers/ReviewerController.php:291:    (int)$assignment['reviewer_id'] !== (int)$_SESSION['user_id']
/home/shquier/easyconf.net/easychair/app/controllers/ReviewerController.php:316:    AND reviewer_id = ?
/home/shquier/easyconf.net/easychair/app/controllers/ReviewerController.php:335:            reviewer_id,
/home/shquier/easyconf.net/easychair/app/controllers/ReviewerController.php:365:        UPDATE review_assignments
/home/shquier/easyconf.net/easychair/app/controllers/ReviewerController.php:430:            FROM conference_reviewers
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_storeSection_full_fix:13702:            FROM review_assignments ra
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_storeSection_full_fix:13705:                ON u.id = ra.reviewer_id
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_storeSection_full_fix:13916:            FROM review_assignments
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_storeSection_full_fix:14017:            UPDATE review_assignments
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_storeSection_full_fix:14274:            LEFT JOIN review_assignments ra
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_storeSection_full_fix:14361:            LEFT JOIN review_assignments ra
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_storeSection_full_fix:14540:            LEFT JOIN review_assignments ra
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_storeSection_full_fix:14649:            LEFT JOIN review_assignments ra
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_storeSection_full_fix:14785:            LEFT JOIN review_assignments ra
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_storeSection_full_fix:14908:            LEFT JOIN review_assignments ra
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_storeSection_full_fix:15047:            LEFT JOIN review_assignments ra
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_storeSection_full_fix:15628:            LEFT JOIN review_assignments ra
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_storeSection_full_fix:15798:                LEFT JOIN review_assignments ra
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_storeSection_full_fix:15834:                LEFT JOIN review_assignments ra
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_storeSection_full_fix:16073:            INNER JOIN review_assignments ra
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_storeSection_full_fix:16074:                ON ra.reviewer_id=u.id
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_storeSection_full_fix:16182:            INNER JOIN conference_reviewers cr
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_storeSection_full_fix:16188:            LEFT JOIN review_assignments ra
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_storeSection_full_fix:16189:                ON ra.reviewer_id=u.id
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_storeSection_full_fix:16326:            LEFT JOIN review_assignments ra
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_storeSection_full_fix:16463:            LEFT JOIN review_assignments ra
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_storeSection_full_fix:16602:            LEFT JOIN review_assignments ra
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_storeSection_full_fix:16793:            LEFT JOIN review_assignments ra
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_storeSection_full_fix:16930:                reviewer_id,
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_storeSection_full_fix:16934:            FROM review_assignments
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_storeSection_full_fix:16938:            GROUP BY reviewer_id
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_storeSection_full_fix:16964:                $row['reviewer_id'] .
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_storeSection_full_fix:17030:            INNER JOIN review_assignments ra
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_storeSection_full_fix:17137:            LEFT JOIN review_assignments ra
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_storeSection_full_fix:17253:            LEFT JOIN review_assignments ra
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_storeSection_full_fix:17360:                FROM review_assignments
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_storeSection_full_fix:17368:                FROM conference_reviewers
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_storeSection_full_fix:17424:                SELECT reviewer_id
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_storeSection_full_fix:17426:                FROM review_assignments
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_storeSection_full_fix:17430:                GROUP BY reviewer_id
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_storeSection_full_fix:17450:                INNER JOIN review_assignments ra
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_storeSection_full_fix:17528:        INNER JOIN conference_reviewers cr ON cr.user_id=u.id
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_storeSection_full_fix:17530:        LEFT JOIN review_assignments ra
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_storeSection_full_fix:17531:            ON ra.reviewer_id=u.id
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_storeSection_full_fix:17558:        LEFT JOIN review_assignments ra ON ra.submission_id=s.id
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_storeSection_full_fix:19001:            SELECT COUNT(DISTINCT reviewer_id)
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_storeSection_full_fix:19002:            FROM review_assignments
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_storeSection_full_fix:19093:            INNER JOIN review_assignments ra
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_storeSection_full_fix:19094:                ON ra.reviewer_id=u.id
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_storeSection_full_fix:19177:            SELECT COUNT(DISTINCT reviewer_id)
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_storeSection_full_fix:19178:            FROM review_assignments
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_storeSection_full_fix:19190:            FROM review_assignments
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_storeSection_full_fix:19203:            FROM review_assignments
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_storeSection_full_fix:19216:            FROM review_assignments
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_storeSection_full_fix:19270:            INNER JOIN review_assignments ra
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_storeSection_full_fix:19271:                ON ra.reviewer_id=u.id
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_storeSection_full_fix:19385:            LEFT JOIN review_assignments ra
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_storeSection_full_fix:19464:            SELECT COUNT(DISTINCT reviewer_id)
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_storeSection_full_fix:19465:            FROM review_assignments
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_storeSection_full_fix:19471:            FROM review_assignments
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_storeSection_full_fix:19604:            FROM review_assignments
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_storeSection_full_fix:19640:            JOIN review_assignments ra
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_storeSection_full_fix:19641:                ON ra.reviewer_id=u.id
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_storeSection_full_fix:19796:            FROM review_assignments
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_storeSection_full_fix:19982:            LEFT JOIN review_assignments ra
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_storeSection_full_fix:20108:            SELECT COUNT(DISTINCT reviewer_id)
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_storeSection_full_fix:20109:            FROM review_assignments
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_storeSection_full_fix:20172:            FROM review_assignments
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_storeSection_full_fix:20639:            FROM review_assignments ra
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_storeSection_full_fix:20833:    $stats['review_assignments'] =
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_storeSection_full_fix:20836:            FROM review_assignments
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_storeSection_full_fix:20847:            SELECT COUNT(DISTINCT reviewer_id)
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_storeSection_full_fix:20848:            FROM review_assignments
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_storeSection_full_fix:20862:                $stats['review_assignments']
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_storeSection_full_fix:20887:                    $stats['review_assignments']
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_storeSection_full_fix:20930:            LEFT JOIN review_assignments ra
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_storeSection_full_fix:21000:            SELECT COUNT(DISTINCT reviewer_id)
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_storeSection_full_fix:21001:            FROM review_assignments
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_storeSection_full_fix:21067:            FROM review_assignments
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_storeSection_full_fix:21115:            LEFT JOIN review_assignments ra
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_storeSection_full_fix:21388:            FROM review_assignments
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_storeSection_full_fix:21601:            SELECT COUNT(DISTINCT reviewer_id)
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_storeSection_full_fix:21602:            FROM review_assignments
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_storeSection_full_fix:22215:            FROM review_assignments
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_storeSection_full_fix:22384:            SELECT COUNT(DISTINCT reviewer_id)
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_storeSection_full_fix:22385:            FROM review_assignments
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_storeSection_full_fix:22554:            INNER JOIN review_assignments ra
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_storeSection_full_fix:22555:                ON ra.reviewer_id=u.id
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_storeSection_full_fix:22602:            FROM review_assignments
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_storeSection_full_fix:22880:        FROM review_assignments
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_storeSection_full_fix:22904:        FROM review_assignment_events
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_storeSection_full_fix:23053:        LEFT JOIN review_assignments ra
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_storeSection_full_fix:23128:                DISTINCT reviewer_id
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_storeSection_full_fix:23130:            FROM review_assignments
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_storeSection_full_fix:23142:                DISTINCT reviewer_id
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_storeSection_full_fix:23144:            FROM review_assignments
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_storeSection_full_fix:23363:            FROM review_assignments
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_storeSection_full_fix:23388:            FROM review_assignment_events
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_storeSection_full_fix:23515:            INNER JOIN review_assignments ra
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_storeSection_full_fix:23516:                ON ra.reviewer_id=u.id
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_storeSection_full_fix:23554:        SELECT COUNT(DISTINCT reviewer_id)
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_storeSection_full_fix:23555:        FROM review_assignments
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_storeSection_full_fix:23560:        FROM review_assignments
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_storeSection_full_fix:23565:        SELECT COUNT(DISTINCT reviewer_id)
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_storeSection_full_fix:23566:        FROM review_assignments
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_storeSection_full_fix:23572:        FROM review_assignments
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_storeSection_full_fix:23578:        FROM review_assignments
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_storeSection_full_fix:23624:        INNER JOIN review_assignments ra
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_storeSection_full_fix:23625:                ON ra.reviewer_id=u.id
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_storeSection_full_fix:23871:            FROM review_assignments
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_storeSection_full_fix:23934:            LEFT JOIN review_assignments ra
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_storeSection_full_fix:24117:            FROM review_assignments
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_storeSection_full_fix:24148:            SELECT COUNT(DISTINCT reviewer_id)
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_storeSection_full_fix:24149:            FROM review_assignments
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_storeSection_full_fix:24160:            FROM review_assignments
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_storeSection_full_fix:24350:            LEFT JOIN review_assignments ra
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_storeSection_full_fix:24444:            SELECT COUNT(DISTINCT reviewer_id)
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_storeSection_full_fix:24445:            FROM review_assignments
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_storeSection_full_fix:24456:            SELECT COUNT(DISTINCT reviewer_id)
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_storeSection_full_fix:24457:            FROM review_assignments
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_storeSection_full_fix:24474:            FROM review_assignments
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_storeSection_full_fix:24641:            FROM review_assignments
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_storeSection_full_fix:24652:            SELECT COUNT(DISTINCT reviewer_id)
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_storeSection_full_fix:24653:            FROM review_assignments
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_storeSection_full_fix:24793:            LEFT JOIN review_assignments ra
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_storeSection_full_fix:24849:            FROM review_assignments
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_storeSection_full_fix:24861:            SELECT COUNT(DISTINCT reviewer_id)
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_storeSection_full_fix:24862:            FROM review_assignments
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_storeSection_full_fix:25052:            FROM review_assignments
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_storeSection_full_fix:25059:            FROM review_assignments
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_storeSection_full_fix:25277:            FROM review_assignments
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_storeSection_full_fix:25427:            LEFT JOIN review_assignments ra
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_storeSection_full_fix:25768:            FROM review_assignments
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_storeSection_full_fix:25774:            SELECT COUNT(DISTINCT reviewer_id)
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_storeSection_full_fix:25775:            FROM review_assignments
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_storeSection_full_fix:26213:            FROM conference_reviewers
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_storeSection_full_fix:26218:            SELECT COUNT(DISTINCT reviewer_id)
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_storeSection_full_fix:26219:            FROM review_assignments
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_storeSection_full_fix:26343:            LEFT JOIN conference_reviewers cr
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_storeSection_full_fix:26412:            SELECT COUNT(DISTINCT reviewer_id)
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_storeSection_full_fix:26413:            FROM review_assignments
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_storeSection_full_fix:26418:            SELECT COUNT(DISTINCT reviewer_id)
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php.before_storeSection_full_fix:26419:            FROM review_assignments
/home/shquier/easyconf.net/easychair/app/controllers/AdminSubmissionController.php:208:LEFT JOIN review_assignments ra
/home/shquier/easyconf.net/easychair/app/controllers/AdminSubmissionController.php:265:reviewer_id,
/home/shquier/easyconf.net/easychair/app/controllers/AdminSubmissionController.php:267:FROM review_assignments
/home/shquier/easyconf.net/easychair/app/controllers/AdminSubmissionController.php:269:GROUP BY reviewer_id
/home/shquier/easyconf.net/easychair/app/controllers/AdminSubmissionController.php:273:ON loads.reviewer_id=u.id
/home/shquier/easyconf.net/easychair/app/controllers/AdminSubmissionsController.php:74:public function assignReviewer()
/home/shquier/easyconf.net/easychair/app/controllers/AdminSubmissionsController.php:90:        $_POST['reviewer_ids'] ?? [];
/home/shquier/easyconf.net/easychair/app/controllers/AdminSubmissionsController.php:106:                    reviewer_id,
/home/shquier/easyconf.net/easychair/app/controllers/AdminSubmissionController.php.broken_before_restore_2026-05-25_044105:166:LEFT JOIN review_assignments ra
/home/shquier/easyconf.net/easychair/app/controllers/AdminSubmissionController.php.broken_before_restore_2026-05-25_044105:200:FROM conference_reviewers cr
/home/shquier/easyconf.net/easychair/app/controllers/RoleDashboardController.php:143:                ['key'=>'dashboard.kpi.review_assignments', 'label'=>'Review Assignments', 'value'=>$this->countTable('review_assignments', 'conference_id=? AND org_id=?', [$confId,$orgId]), 'icon'=>'fa-user-check'],
/home/shquier/easyconf.net/easychair/app/controllers/RoleDashboardController.php:145:                ['key'=>'dashboard.kpi.late_reviews', 'label'=>'Late Reviews', 'value'=>$this->countTable('review_assignments', "conference_id=? AND org_id=? AND due_date IS NOT NULL AND due_date < CURDATE() AND COALESCE(status,'assigned') NOT IN ('completed','submitted')", [$confId,$orgId]), 'icon'=>'fa-triangle-exclamation'],
/home/shquier/easyconf.net/easychair/app/controllers/RoleDashboardController.php:157:                ['key'=>'dashboard.kpi.review_assignments', 'label'=>'Review Assignments', 'value'=>$this->countTable('review_assignments', 'conference_id=? AND org_id=?', [$confId,$orgId]), 'icon'=>'fa-user-check'],
/home/shquier/easyconf.net/easychair/app/controllers/AuthorWorkflowController.php:258:                LEFT JOIN review_assignments ra 
/home/shquier/easyconf.net/easychair/app/controllers/AuthorWorkflowController.php:259:                       ON ra.id = COALESCE(rv.assignment_id, rv.review_assignment_id)
/home/shquier/easyconf.net/easychair/app/controllers/AdminBusinessToolsController.php:502:FROM conference_reviewers cr
/home/shquier/easyconf.net/easychair/app/controllers/AdminBusinessToolsController.php:552:        reviewer_id,
/home/shquier/easyconf.net/easychair/app/controllers/AdminBusinessToolsController.php:565:            (int)$r['reviewer_id']
/home/shquier/easyconf.net/easychair/app/controllers/AdminBusinessToolsController.php:584:        reviewer_id,
/home/shquier/easyconf.net/easychair/app/controllers/AdminBusinessToolsController.php:596:            (int)$r['reviewer_id']
/home/shquier/easyconf.net/easychair/app/controllers/AdminBusinessToolsController.php:614:        reviewer_id,
/home/shquier/easyconf.net/easychair/app/controllers/AdminBusinessToolsController.php:624:            (int)$r['reviewer_id']
/home/shquier/easyconf.net/easychair/app/controllers/AdminBusinessToolsController.php:635:        reviewer_id,
/home/shquier/easyconf.net/easychair/app/controllers/AdminBusinessToolsController.php:637:        FROM review_assignments
/home/shquier/easyconf.net/easychair/app/controllers/AdminBusinessToolsController.php:643:        GROUP BY reviewer_id
/home/shquier/easyconf.net/easychair/app/controllers/AdminBusinessToolsController.php:649:            (int)$r['reviewer_id']
/home/shquier/easyconf.net/easychair/app/controllers/AdminBusinessToolsController.php:660:        reviewer_id,
/home/shquier/easyconf.net/easychair/app/controllers/AdminBusinessToolsController.php:662:        FROM review_assignments
/home/shquier/easyconf.net/easychair/app/controllers/AdminBusinessToolsController.php:664:        GROUP BY reviewer_id
/home/shquier/easyconf.net/easychair/app/controllers/AdminBusinessToolsController.php:670:            (int)$r['reviewer_id']
/home/shquier/easyconf.net/easychair/app/controllers/AdminBusinessToolsController.php:880:FROM review_assignments ra
/home/shquier/easyconf.net/easychair/app/controllers/AdminBusinessToolsController.php:886:ON u.id=ra.reviewer_id
/home/shquier/easyconf.net/easychair/app/controllers/AdminBusinessToolsController.php:969:        FROM review_assignment_reminders
/home/shquier/easyconf.net/easychair/app/controllers/AdminBusinessToolsController.php:1042:        ON u.id=rp.reviewer_id
/home/shquier/easyconf.net/easychair/app/controllers/AdminBusinessToolsController.php:1051:        reviewer_id,
/home/shquier/easyconf.net/easychair/app/controllers/AdminBusinessToolsController.php:1053:        FROM review_assignments
/home/shquier/easyconf.net/easychair/app/controllers/AdminBusinessToolsController.php:1060:        GROUP BY reviewer_id
/home/shquier/easyconf.net/easychair/app/controllers/AdminBusinessToolsController.php:1113:        ON u.id=ra.reviewer_id
/home/shquier/easyconf.net/easychair/app/controllers/AdminBusinessToolsController.php:1155:        WHERE reviewer_id=?
/home/shquier/easyconf.net/easychair/app/controllers/AdminBusinessToolsController.php:1185:            reviewer_id,
/home/shquier/easyconf.net/easychair/app/controllers/AdminBusinessToolsController.php:1244:        ON u.id=rp.reviewer_id
/home/shquier/easyconf.net/easychair/app/controllers/AdminBusinessToolsController.php:1301:public function autoAssignReviewers()
/home/shquier/easyconf.net/easychair/app/controllers/AdminBusinessToolsController.php:1357:            $r['reviewer_id']
/home/shquier/easyconf.net/easychair/app/controllers/AdminBusinessToolsController.php:1378:                        reviewer_id,
/home/shquier/easyconf.net/easychair/app/controllers/AdminBusinessToolsController.php:1390:                    $r['reviewer_id'],
/home/shquier/easyconf.net/easychair/app/controllers/AdminBusinessToolsController.php:1404:            FROM review_assignments
/home/shquier/easyconf.net/easychair/app/controllers/AdminBusinessToolsController.php:1406:            AND reviewer_id=?
/home/shquier/easyconf.net/easychair/app/controllers/AdminBusinessToolsController.php:1411:            $r['reviewer_id']
/home/shquier/easyconf.net/easychair/app/controllers/AdminBusinessToolsController.php:1419:            INSERT INTO review_assignments
/home/shquier/easyconf.net/easychair/app/controllers/AdminBusinessToolsController.php:1422:                reviewer_id,
/home/shquier/easyconf.net/easychair/app/controllers/AdminBusinessToolsController.php:1435:            $r['reviewer_id']
/home/shquier/easyconf.net/easychair/app/controllers/AdminBusinessToolsController.php:1443:                reviewer_id,
/home/shquier/easyconf.net/easychair/app/controllers/AdminBusinessToolsController.php:1455:            $r['reviewer_id'],
/home/shquier/easyconf.net/easychair/app/controllers/AdminBusinessToolsController.php:3453:        ON u.id=rnm.reviewer_id
/home/shquier/easyconf.net/easychair/app/controllers/AdminBusinessToolsController.php:3587:        ON u.id=rre.reviewer_id
/home/shquier/easyconf.net/easychair/app/controllers/AdminBusinessToolsController.php:3692:        ON u.id=ras.reviewer_id
/home/shquier/easyconf.net/easychair/app/controllers/AdminBusinessToolsController.php:3807:        ON u.id=re.reviewer_id
/home/shquier/easyconf.net/easychair/app/controllers/AdminBusinessToolsController.php:3810:        ON ur.id=re.replacement_reviewer_id
/home/shquier/easyconf.net/easychair/app/controllers/AdminBusinessToolsController.php:4011:<td><?= (int)$r['reviewer_id'] ?></td>
/home/shquier/easyconf.net/easychair/app/controllers/AdminBusinessToolsController.php:4072:        ON u.id=rc.reviewer_id
/home/shquier/easyconf.net/easychair/app/controllers/AdminBusinessToolsController.php:4187:        ON u.id=rcf.reviewer_id
/home/shquier/easyconf.net/easychair/app/controllers/AdminBusinessToolsController.php:4279:        INSERT INTO review_assignment_events
/home/shquier/easyconf.net/easychair/app/controllers/AdminBusinessToolsController.php:4375:        (int)($_POST['reviewer_id'] ?? 0);
/home/shquier/easyconf.net/easychair/app/controllers/AdminBusinessToolsController.php:4433:    FROM review_assignments
/home/shquier/easyconf.net/easychair/app/controllers/AdminBusinessToolsController.php:4435:      AND reviewer_id = ?
/home/shquier/easyconf.net/easychair/app/controllers/AdminBusinessToolsController.php:4486:        'review_assignments',
/home/shquier/easyconf.net/easychair/app/controllers/AdminBusinessToolsController.php:4499:            'reviewer_id' =>
/home/shquier/easyconf.net/easychair/app/controllers/AdminBusinessToolsController.php:4709:        $this->deleteById('review_assignments', (int)($_GET['id'] ?? 0), $conference);
/home/shquier/easyconf.net/easychair/app/controllers/AdminBusinessToolsController.php:6657:<td>#<?= (int)$r['reviewer_id'] ?></td>
/home/shquier/easyconf.net/easychair/app/controllers/AdminBusinessToolsController.php:6747:<td>#<?= (int)$r['reviewer_id'] ?></td>
/home/shquier/easyconf.net/easychair/app/controllers/AdminBusinessToolsController.php:6816:<td>#<?= (int)$r['reviewer_id'] ?></td>
/home/shquier/easyconf.net/easychair/app/controllers/AdminBusinessToolsController.php:6871:<td>#<?= (int)$r['reviewer_id'] ?></td>
/home/shquier/easyconf.net/easychair/app/controllers/AdminBusinessToolsController.php:6941:<td>#<?= (int)$r['reviewer_id'] ?></td>
/home/shquier/easyconf.net/easychair/app/controllers/AdminBusinessToolsController.php:7021:<td>#<?= (int)$r['reviewer_id'] ?></td>
/home/shquier/easyconf.net/easychair/app/controllers/AdminBusinessToolsController.php:7103:<td>#<?= (int)$r['reviewer_id'] ?></td>
/home/shquier/easyconf.net/easychair/app/controllers/AdminBusinessToolsController.php:7179:<td>#<?= (int)$r['reviewer_id'] ?></td>
/home/shquier/easyconf.net/easychair/app/controllers/AdminBusinessToolsController.php:7263:<td>#<?= (int)$r['reviewer_id'] ?></td>
/home/shquier/easyconf.net/easychair/app/controllers/AdminBusinessToolsController.php:7343:<td>#<?= (int)$r['reviewer_id'] ?></td>
/home/shquier/easyconf.net/easychair/app/controllers/AdminBusinessToolsController.php:7427:<td>#<?= (int)$r['reviewer_id'] ?></td>
/home/shquier/easyconf.net/easychair/app/controllers/AdminBusinessToolsController.php:7508:<td>#<?= (int)$r['reviewer_id'] ?></td>
/home/shquier/easyconf.net/easychair/app/controllers/PublicConferenceBusinessController.php:455:        SELECT COUNT(DISTINCT reviewer_id)
/home/shquier/easyconf.net/easychair/app/controllers/AdminReviewersController.php:43:        $reviewerId = (int)($_POST['reviewer_id'] ?? $_POST['id'] ?? 0);
/home/shquier/easyconf.net/easychair/app/controllers/AdminReviewersController.php:48:            if (function_exists('flash_set')) flash_set('danger', 'Missing reviewer_id');
/home/shquier/easyconf.net/easychair/app/controllers/AdminReviewersController.php:60:                reviewer_id BIGINT UNSIGNED NOT NULL,
/home/shquier/easyconf.net/easychair/app/controllers/AdminReviewersController.php:67:                KEY idx_reviewer (reviewer_id)
/home/shquier/easyconf.net/easychair/app/controllers/AdminReviewersController.php:77:        if (in_array('reviewer_id',$cols,true)) { $sqlCols[]='reviewer_id'; $sqlVals[]=':rid'; $params[':rid']=$reviewerId; }
/home/shquier/easyconf.net/easychair/app/controllers/AdminReviewAssignmentsCloneController.php:38:          INSERT IGNORE INTO review_assignments (submission_id, reviewer_id, assigned_by, round_no, due_date, status)
/home/shquier/easyconf.net/easychair/app/controllers/AdminReviewAssignmentsCloneController.php:39:          SELECT ra.submission_id, ra.reviewer_id, :by, :toRound, NULL, 'assigned'
/home/shquier/easyconf.net/easychair/app/controllers/AdminReviewAssignmentsCloneController.php:40:          FROM review_assignments ra
/home/shquier/easyconf.net/easychair/app/controllers/AdminReviewerExpertiseController.php:149:                    FROM review_assignments ra
/home/shquier/easyconf.net/easychair/app/controllers/AdminReviewerExpertiseController.php:150:                    WHERE ra.reviewer_id=u.id
/home/shquier/easyconf.net/easychair/app/controllers/AdminUsersController.php:381:                'conference_reviewers',
/home/shquier/easyconf.net/easychair/app/controllers/AdminUsersController.php:383:                'review_assignments',
/home/shquier/easyconf.net/easychair/app/controllers/AdminUsersController.php:392:            if ($this->tableExists('review_assignments') && $this->hasCol('review_assignments', 'reviewer_id')) {
/home/shquier/easyconf.net/easychair/app/controllers/AdminUsersController.php:393:                $st = $this->db->prepare("DELETE FROM review_assignments WHERE reviewer_id = ?");
/home/shquier/easyconf.net/easychair/app/controllers/AdminUserController.php.before_pack1301_reset_delete:546:INSERT IGNORE INTO conference_reviewers
/home/shquier/easyconf.net/easychair/app/controllers/AdminUserController.php.before_pack1301_reset_delete:801:                FROM conference_reviewers
/home/shquier/easyconf.net/easychair/app/controllers/AdminUserController.php.before_pack1301_reset_delete:809:                    INSERT INTO conference_reviewers
/home/shquier/easyconf.net/easychair/app/controllers/CommunicationsController.php:46:        $reviewerId = (int) ($_GET['reviewer_id'] ?? 0);
/home/shquier/easyconf.net/easychair/app/controllers/CommunicationsController.php:60:            WHERE u.id = :reviewer_id AND c.id = :conference_id
/home/shquier/easyconf.net/easychair/app/controllers/CommunicationsController.php:64:            ':reviewer_id' => $reviewerId,
/home/shquier/easyconf.net/easychair/app/controllers/AdminReviewerAssignmentsController.php:231:            reviewer_id,
/home/shquier/easyconf.net/easychair/app/controllers/AdminReviewerAssignmentsController.php:233:        FROM review_assignments
/home/shquier/easyconf.net/easychair/app/controllers/AdminReviewerAssignmentsController.php:239:        GROUP BY reviewer_id
/home/shquier/easyconf.net/easychair/app/controllers/AdminReviewerAssignmentsController.php:250:            (int)$row['reviewer_id']
/home/shquier/easyconf.net/easychair/app/controllers/AdminReviewerAssignmentsController.php:275:            reviewer_id,
/home/shquier/easyconf.net/easychair/app/controllers/AdminReviewerAssignmentsController.php:284:        FROM review_assignments
/home/shquier/easyconf.net/easychair/app/controllers/AdminReviewerAssignmentsController.php:285:        GROUP BY reviewer_id
/home/shquier/easyconf.net/easychair/app/controllers/AdminReviewerAssignmentsController.php:294:            (int)$row['reviewer_id']
/home/shquier/easyconf.net/easychair/app/controllers/AdminReviewerAssignmentsController.php:336:            ra.reviewer_id,
/home/shquier/easyconf.net/easychair/app/controllers/AdminReviewerAssignmentsController.php:339:        FROM review_assignments ra
/home/shquier/easyconf.net/easychair/app/controllers/AdminReviewerAssignmentsController.php:344:            ra.reviewer_id,
/home/shquier/easyconf.net/easychair/app/controllers/AdminReviewerAssignmentsController.php:354:            (int)$row['reviewer_id']
/home/shquier/easyconf.net/easychair/app/controllers/AdminReviewerAssignmentsController.php:368:            reviewer_id,
/home/shquier/easyconf.net/easychair/app/controllers/AdminReviewerAssignmentsController.php:377:        GROUP BY reviewer_id
/home/shquier/easyconf.net/easychair/app/controllers/AdminReviewerAssignmentsController.php:386:            (int)$row['reviewer_id']
/home/shquier/easyconf.net/easychair/app/controllers/AdminReviewerAssignmentsController.php:498:FROM review_assignments ra
/home/shquier/easyconf.net/easychair/app/controllers/AdminReviewerAssignmentsController.php:501:ON u.id=ra.reviewer_id
/home/shquier/easyconf.net/easychair/app/controllers/AdminReviewerAssignmentsController.php:545:        FROM review_assignments
/home/shquier/easyconf.net/easychair/app/controllers/AdminReviewerAssignmentsController.php:564:        FROM review_assignments
/home/shquier/easyconf.net/easychair/app/controllers/AdminReviewerAssignmentsController.php:587:        FROM review_assignments
/home/shquier/easyconf.net/easychair/app/controllers/AdminReviewerAssignmentsController.php:610:        FROM review_assignment_reminders
/home/shquier/easyconf.net/easychair/app/controllers/AdminReviewerAssignmentsController.php:676:        $rid=(int)($_POST['reviewer_id']??0);
/home/shquier/easyconf.net/easychair/app/controllers/AdminReviewerAssignmentsController.php:747:FROM review_assignments
/home/shquier/easyconf.net/easychair/app/controllers/AdminReviewerAssignmentsController.php:749:AND reviewer_id=?
/home/shquier/easyconf.net/easychair/app/controllers/AdminReviewerAssignmentsController.php:889:    FROM review_assignments
/home/shquier/easyconf.net/easychair/app/controllers/AdminReviewerAssignmentsController.php:890:    WHERE reviewer_id=?
/home/shquier/easyconf.net/easychair/app/controllers/AdminReviewerAssignmentsController.php:919:INSERT IGNORE INTO review_assignments
/home/shquier/easyconf.net/easychair/app/controllers/AdminReviewerAssignmentsController.php:922:reviewer_id,
/home/shquier/easyconf.net/easychair/app/controllers/AdminReviewerAssignmentsController.php:994:        FROM review_assignments ra
/home/shquier/easyconf.net/easychair/app/controllers/AdminReviewerAssignmentsController.php:997:            ON u.id=ra.reviewer_id
/home/shquier/easyconf.net/easychair/app/controllers/AdminReviewerAssignmentsController.php:1076:        FROM review_assignments
/home/shquier/easyconf.net/easychair/app/controllers/AdminReviewerAssignmentsController.php:1088:        FROM review_assignments
/home/shquier/easyconf.net/easychair/app/controllers/AdminReviewerAssignmentsController.php:1188:                (int)($a['reviewer_id'] ?? 0),
/home/shquier/easyconf.net/easychair/app/controllers/AdminReviewerAssignmentsController.php:1252:        FROM review_assignments ra
/home/shquier/easyconf.net/easychair/app/controllers/AdminReviewerAssignmentsController.php:1254:            ON u.id=ra.reviewer_id
/home/shquier/easyconf.net/easychair/app/controllers/AdminReviewerAssignmentsController.php:1323:        $a['reviewer_id'],
/home/shquier/easyconf.net/easychair/app/controllers/ReviewController.php:27:          FROM review_assignments ra
/home/shquier/easyconf.net/easychair/app/controllers/ReviewController.php:30:          WHERE ra.reviewer_id = :uid
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php:13638:            FROM review_assignments ra
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php:13641:                ON u.id = ra.reviewer_id
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php:13852:            FROM review_assignments
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php:13953:            UPDATE review_assignments
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php:14210:            LEFT JOIN review_assignments ra
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php:14297:            LEFT JOIN review_assignments ra
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php:14476:            LEFT JOIN review_assignments ra
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php:14585:            LEFT JOIN review_assignments ra
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php:14721:            LEFT JOIN review_assignments ra
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php:14844:            LEFT JOIN review_assignments ra
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php:14983:            LEFT JOIN review_assignments ra
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php:15564:            LEFT JOIN review_assignments ra
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php:15734:                LEFT JOIN review_assignments ra
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php:15770:                LEFT JOIN review_assignments ra
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php:16009:            INNER JOIN review_assignments ra
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php:16010:                ON ra.reviewer_id=u.id
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php:16118:            INNER JOIN conference_reviewers cr
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php:16124:            LEFT JOIN review_assignments ra
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php:16125:                ON ra.reviewer_id=u.id
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php:16262:            LEFT JOIN review_assignments ra
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php:16399:            LEFT JOIN review_assignments ra
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php:16538:            LEFT JOIN review_assignments ra
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php:16729:            LEFT JOIN review_assignments ra
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php:16866:                reviewer_id,
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php:16870:            FROM review_assignments
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php:16874:            GROUP BY reviewer_id
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php:16900:                $row['reviewer_id'] .
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php:16966:            INNER JOIN review_assignments ra
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php:17073:            LEFT JOIN review_assignments ra
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php:17189:            LEFT JOIN review_assignments ra
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php:17296:                FROM review_assignments
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php:17304:                FROM conference_reviewers
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php:17360:                SELECT reviewer_id
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php:17362:                FROM review_assignments
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php:17366:                GROUP BY reviewer_id
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php:17386:                INNER JOIN review_assignments ra
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php:17464:        INNER JOIN conference_reviewers cr ON cr.user_id=u.id
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php:17466:        LEFT JOIN review_assignments ra
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php:17467:            ON ra.reviewer_id=u.id
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php:17494:        LEFT JOIN review_assignments ra ON ra.submission_id=s.id
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php:18937:            SELECT COUNT(DISTINCT reviewer_id)
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php:18938:            FROM review_assignments
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php:19029:            INNER JOIN review_assignments ra
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php:19030:                ON ra.reviewer_id=u.id
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php:19113:            SELECT COUNT(DISTINCT reviewer_id)
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php:19114:            FROM review_assignments
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php:19126:            FROM review_assignments
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php:19139:            FROM review_assignments
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php:19152:            FROM review_assignments
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php:19206:            INNER JOIN review_assignments ra
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php:19207:                ON ra.reviewer_id=u.id
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php:19321:            LEFT JOIN review_assignments ra
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php:19400:            SELECT COUNT(DISTINCT reviewer_id)
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php:19401:            FROM review_assignments
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php:19407:            FROM review_assignments
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php:19540:            FROM review_assignments
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php:19576:            JOIN review_assignments ra
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php:19577:                ON ra.reviewer_id=u.id
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php:19732:            FROM review_assignments
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php:19918:            LEFT JOIN review_assignments ra
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php:20044:            SELECT COUNT(DISTINCT reviewer_id)
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php:20045:            FROM review_assignments
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php:20108:            FROM review_assignments
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php:20575:            FROM review_assignments ra
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php:20769:    $stats['review_assignments'] =
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php:20772:            FROM review_assignments
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php:20783:            SELECT COUNT(DISTINCT reviewer_id)
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php:20784:            FROM review_assignments
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php:20798:                $stats['review_assignments']
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php:20823:                    $stats['review_assignments']
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php:20866:            LEFT JOIN review_assignments ra
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php:20936:            SELECT COUNT(DISTINCT reviewer_id)
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php:20937:            FROM review_assignments
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php:21003:            FROM review_assignments
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php:21051:            LEFT JOIN review_assignments ra
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php:21324:            FROM review_assignments
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php:21537:            SELECT COUNT(DISTINCT reviewer_id)
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php:21538:            FROM review_assignments
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php:22151:            FROM review_assignments
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php:22320:            SELECT COUNT(DISTINCT reviewer_id)
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php:22321:            FROM review_assignments
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php:22490:            INNER JOIN review_assignments ra
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php:22491:                ON ra.reviewer_id=u.id
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php:22538:            FROM review_assignments
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php:22816:        FROM review_assignments
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php:22840:        FROM review_assignment_events
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php:22989:        LEFT JOIN review_assignments ra
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php:23064:                DISTINCT reviewer_id
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php:23066:            FROM review_assignments
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php:23078:                DISTINCT reviewer_id
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php:23080:            FROM review_assignments
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php:23299:            FROM review_assignments
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php:23324:            FROM review_assignment_events
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php:23451:            INNER JOIN review_assignments ra
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php:23452:                ON ra.reviewer_id=u.id
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php:23490:        SELECT COUNT(DISTINCT reviewer_id)
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php:23491:        FROM review_assignments
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php:23496:        FROM review_assignments
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php:23501:        SELECT COUNT(DISTINCT reviewer_id)
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php:23502:        FROM review_assignments
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php:23508:        FROM review_assignments
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php:23514:        FROM review_assignments
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php:23560:        INNER JOIN review_assignments ra
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php:23561:                ON ra.reviewer_id=u.id
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php:23807:            FROM review_assignments
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php:23870:            LEFT JOIN review_assignments ra
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php:24053:            FROM review_assignments
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php:24084:            SELECT COUNT(DISTINCT reviewer_id)
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php:24085:            FROM review_assignments
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php:24096:            FROM review_assignments
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php:24286:            LEFT JOIN review_assignments ra
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php:24380:            SELECT COUNT(DISTINCT reviewer_id)
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php:24381:            FROM review_assignments
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php:24392:            SELECT COUNT(DISTINCT reviewer_id)
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php:24393:            FROM review_assignments
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php:24410:            FROM review_assignments
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php:24577:            FROM review_assignments
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php:24588:            SELECT COUNT(DISTINCT reviewer_id)
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php:24589:            FROM review_assignments
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php:24729:            LEFT JOIN review_assignments ra
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php:24785:            FROM review_assignments
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php:24797:            SELECT COUNT(DISTINCT reviewer_id)
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php:24798:            FROM review_assignments
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php:24988:            FROM review_assignments
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php:24995:            FROM review_assignments
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php:25213:            FROM review_assignments
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php:25363:            LEFT JOIN review_assignments ra
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php:25704:            FROM review_assignments
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php:25710:            SELECT COUNT(DISTINCT reviewer_id)
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php:25711:            FROM review_assignments
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php:26149:            FROM conference_reviewers
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php:26154:            SELECT COUNT(DISTINCT reviewer_id)
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php:26155:            FROM review_assignments
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php:26279:            LEFT JOIN conference_reviewers cr
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php:26348:            SELECT COUNT(DISTINCT reviewer_id)
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php:26349:            FROM review_assignments
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php:26354:            SELECT COUNT(DISTINCT reviewer_id)
/home/shquier/easyconf.net/easychair/app/controllers/AdminConferenceHomeController.php:26355:            FROM review_assignments
/home/shquier/easyconf.net/easychair/app/controllers/ReviewerReviewController.php:32:              AND sr.reviewer_id = ?
/home/shquier/easyconf.net/easychair/app/controllers/ReviewerReviewController.php:46:              AND reviewer_id = ?
/home/shquier/easyconf.net/easychair/app/controllers/ReviewerReviewController.php:83:              AND reviewer_id = ?
/home/shquier/easyconf.net/easychair/app/controllers/ReviewerReviewController.php:94:                WHERE submission_id=? AND reviewer_id=? AND round_no=?
/home/shquier/easyconf.net/easychair/app/controllers/ReviewerReviewController.php:105:                (submission_id, reviewer_id, round_no,
/home/shquier/easyconf.net/easychair/app/controllers/AuthorDashboardController.php:2342:            LEFT JOIN review_assignments ra
/home/shquier/easyconf.net/easychair/app/controllers/AdminReviewersStableController.php:21:        if(!$this->tableExists($db,'review_assignments')) return 0;
/home/shquier/easyconf.net/easychair/app/controllers/AdminReviewersStableController.php:22:        $st = $db->prepare("SELECT id FROM review_assignments WHERE reviewer_id=:rid AND org_id = :org_id  ORDER BY id DESC LIMIT 1");
/home/shquier/easyconf.net/easychair/app/controllers/AdminReviewersStableController.php:36:        $reviewerId   = (int)($_POST['reviewer_id'] ?? $_POST['id'] ?? 0);
/home/shquier/easyconf.net/easychair/app/controllers/AdminReviewersStableController.php:37:        $assignmentId = (int)($_POST['review_assignment_id'] ?? $_POST['assignment_id'] ?? 0);
/home/shquier/easyconf.net/easychair/app/controllers/AdminReviewersStableController.php:43:            if (function_exists('flash_set')) flash_set('danger', 'Missing reviewer_id');
/home/shquier/easyconf.net/easychair/app/controllers/AdminReviewersStableController.php:48:        // FK requires real review_assignment_id -> derive if missing
/home/shquier/easyconf.net/easychair/app/controllers/AdminReviewersStableController.php:69:        // Upsert by UNIQUE review_assignment_id
/home/shquier/easyconf.net/easychair/app/controllers/AdminReviewersStableController.php:72:            (review_assignment_id, reviewer_id, rated_by, rating_score, rating_notes)
/home/shquier/easyconf.net/easychair/app/controllers/AdminReviewersStableController.php:76:            reviewer_id=VALUES(reviewer_id),
/home/shquier/easyconf.net/easychair/app/controllers/AdminReviewMonitorController.php:157:            LEFT JOIN review_assignments ra
/home/shquier/easyconf.net/easychair/app/controllers/AdminReviewMonitorController.php:163:                    rv.review_assignment_id=ra.id
/home/shquier/easyconf.net/easychair/app/controllers/AdminReviewMonitorController.php:194:    u.id reviewer_id,
/home/shquier/easyconf.net/easychair/app/controllers/AdminReviewMonitorController.php:234:LEFT JOIN review_assignments ra
/home/shquier/easyconf.net/easychair/app/controllers/AdminReviewMonitorController.php:235:ON ra.reviewer_id=u.id
/home/shquier/easyconf.net/easychair/app/controllers/MyIntelligenceController.php:115:                WHERE reviewer_id=?
/home/shquier/easyconf.net/easychair/app/controllers/MyIntelligenceController.php:123:                WHERE reviewer_id=?
/home/shquier/easyconf.net/easychair/app/controllers/MyIntelligenceController.php:131:                WHERE reviewer_id=?
/home/shquier/easyconf.net/easychair/app/controllers/MyIntelligenceController.php:139:                WHERE reviewer_id=?
/home/shquier/easyconf.net/easychair/app/controllers/ReviewerDashboardController.php:61:        FROM review_assignments ra
/home/shquier/easyconf.net/easychair/app/controllers/ReviewerDashboardController.php:68:        WHERE ra.reviewer_id = ?
/home/shquier/easyconf.net/easychair/app/controllers/ReviewerDashboardController.php:329:FROM review_assignments
/home/shquier/easyconf.net/easychair/app/controllers/ReviewerDashboardController.php:335:        AND ra.reviewer_id = ?
/home/shquier/easyconf.net/easychair/app/controllers/ReviewerDashboardController.php:483:        FROM review_assignments
/home/shquier/easyconf.net/easychair/app/controllers/ReviewerDashboardController.php:485:        AND reviewer_id=?
/home/shquier/easyconf.net/easychair/app/controllers/ReviewerDashboardController.php:506:            UPDATE review_assignments
/home/shquier/easyconf.net/easychair/app/controllers/ReviewerDashboardController.php:526:            UPDATE review_assignments
/home/shquier/easyconf.net/easychair/app/controllers/ReviewerDashboardController.php:565:                    (int)($assignment['reviewer_id'] ?? 0)
/home/shquier/easyconf.net/easychair/app/controllers/ReviewerDashboardController.php:680:        FROM review_assignments ra
/home/shquier/easyconf.net/easychair/app/controllers/ReviewerDashboardController.php:683:        AND ra.reviewer_id = ?
/home/shquier/easyconf.net/easychair/app/controllers/ReviewerDashboardController.php:780:            review_assignment_id,
/home/shquier/easyconf.net/easychair/app/controllers/ReviewerDashboardController.php:782:            reviewer_id,
/home/shquier/easyconf.net/easychair/app/controllers/ReviewerDashboardController.php:851:        UPDATE review_assignments
/home/shquier/easyconf.net/easychair/app/controllers/ReviewerDashboardController.php:888:        WHERE r.reviewer_id = ?
/home/shquier/easyconf.net/easychair/app/controllers/ReviewerDashboardController.php:943:                 WHERE reviewer_id=?
/home/shquier/easyconf.net/easychair/app/controllers/ReviewerDashboardController.php:986:        WHERE reviewer_id=?
/home/shquier/easyconf.net/easychair/app/controllers/ReviewerDashboardController.php:1033:            WHERE reviewer_id=?
/home/shquier/easyconf.net/easychair/app/controllers/ReviewerDashboardController.php:1050:            WHERE reviewer_id=?
/home/shquier/easyconf.net/easychair/app/controllers/ReviewerDashboardController.php:1067:            WHERE reviewer_id=?
/home/shquier/easyconf.net/easychair/app/controllers/ReviewerDashboardController.php:1084:            WHERE reviewer_id=?
/home/shquier/easyconf.net/easychair/app/controllers/ReviewerDashboardController.php:1126:            WHERE reviewer_id=?
/home/shquier/easyconf.net/easychair/app/controllers/ReviewerDashboardController.php:1169:            WHERE reviewer_id=?
/home/shquier/easyconf.net/easychair/app/controllers/ReviewerDashboardController.php:1186:            WHERE reviewer_id=?
/home/shquier/easyconf.net/easychair/app/controllers/ReviewerDashboardController.php:1203:            WHERE reviewer_id=?
/home/shquier/easyconf.net/easychair/app/controllers/ReviewerDashboardController.php:1245:            WHERE mentor_reviewer_id=?
/home/shquier/easyconf.net/easychair/app/controllers/ReviewerDashboardController.php:1260:            WHERE mentee_reviewer_id=?
/home/shquier/easyconf.net/easychair/app/controllers/ReviewerDashboardController.php:1299:            WHERE reviewer_id=?
/home/shquier/easyconf.net/easychair/app/controllers/ReviewerDashboardController.php:1316:            WHERE reviewer_id=?
/home/shquier/easyconf.net/easychair/app/controllers/ReviewerDashboardController.php:1358:            WHERE reviewer_id=?
/home/shquier/easyconf.net/easychair/app/controllers/ReviewerDashboardController.php:1375:            WHERE reviewer_id=?
/home/shquier/easyconf.net/easychair/app/controllers/ReviewerDashboardController.php:1392:            WHERE reviewer_id=?
/home/shquier/easyconf.net/easychair/app/controllers/ReviewerDashboardController.php:1433:            WHERE reviewer_id=?
/home/shquier/easyconf.net/easychair/app/controllers/ReviewerDashboardController.php:1474:            WHERE reviewer_id=?
/home/shquier/easyconf.net/easychair/app/controllers/ReviewerDashboardController.php:1515:            WHERE reviewer_id=?
/home/shquier/easyconf.net/easychair/app/controllers/ReviewerDashboardController.php:1532:            WHERE reviewer_id=?
/home/shquier/easyconf.net/easychair/app/services/ReviewerLoadService.php:18:            FROM review_assignments
/home/shquier/easyconf.net/easychair/app/services/ReviewerLoadService.php:19:            WHERE reviewer_id = ?
/home/shquier/easyconf.net/easychair/app/services/ReviewerLoadService.php:125:            FROM review_assignments
/home/shquier/easyconf.net/easychair/app/services/ReviewerLoadService.php:127:            AND reviewer_id = ?
/home/shquier/easyconf.net/easychair/app/services/Governance/ReviewerIntegrityService.php:37:                ra.reviewer_id,
/home/shquier/easyconf.net/easychair/app/services/Governance/ReviewerIntegrityService.php:47:            FROM review_assignments ra
/home/shquier/easyconf.net/easychair/app/services/Governance/ReviewerIntegrityService.php:53:                ON u.id = ra.reviewer_id
/home/shquier/easyconf.net/easychair/app/services/Governance/ReviewerIntegrityService.php:71:                (int)$row['reviewer_id'] <= 0
/home/shquier/easyconf.net/easychair/app/services/GovernanceEngine.php:42:                    FROM review_assignments
/home/shquier/easyconf.net/easychair/app/services/GovernanceEngine.php:48:                    FROM conference_reviewers
/home/shquier/easyconf.net/easychair/app/services/GovernanceEngine.php:82:                    SELECT reviewer_id
/home/shquier/easyconf.net/easychair/app/services/GovernanceEngine.php:84:                    FROM review_assignments
/home/shquier/easyconf.net/easychair/app/services/GovernanceEngine.php:88:                    GROUP BY reviewer_id
/home/shquier/easyconf.net/easychair/app/services/GovernanceEngine.php:106:                    JOIN review_assignments ra
/home/shquier/easyconf.net/easychair/app/services/ReviewRoundService.php:72:                SELECT reviewer_id
/home/shquier/easyconf.net/easychair/app/services/ReviewRoundService.php:73:                FROM review_assignments
/home/shquier/easyconf.net/easychair/app/services/ReviewRoundService.php:93:                INSERT INTO review_assignments
/home/shquier/easyconf.net/easychair/app/services/ReviewRoundService.php:96:                    reviewer_id,
/home/shquier/easyconf.net/easychair/app/services/SubmissionWorkflowService.php.before_pack956A_workflow_sync:560:        FROM review_assignments
/home/shquier/easyconf.net/easychair/app/services/CronService.php:101:                       u.id AS reviewer_id, u.first_name, u.last_name, u.email, u.preferred_lang
/home/shquier/easyconf.net/easychair/app/services/CronService.php:102:                FROM review_assignments ra
/home/shquier/easyconf.net/easychair/app/services/CronService.php:104:                INNER JOIN users u ON u.id = ra.reviewer_id
/home/shquier/easyconf.net/easychair/app/services/CronService.php:113:                    'id' => (int) $row['reviewer_id'],
/home/shquier/easyconf.net/easychair/app/services/CronService.php:130:                    'review_assignments',
/home/shquier/easyconf.net/easychair/app/services/CronService.php:142:                       u.id AS reviewer_id, u.first_name, u.last_name, u.email, u.preferred_lang
/home/shquier/easyconf.net/easychair/app/services/CronService.php:143:                FROM review_assignments ra
/home/shquier/easyconf.net/easychair/app/services/CronService.php:145:                INNER JOIN users u ON u.id = ra.reviewer_id
/home/shquier/easyconf.net/easychair/app/services/CronService.php:154:                    'id' => (int) $row['reviewer_id'],
/home/shquier/easyconf.net/easychair/app/services/CronService.php:171:                    'review_assignments',
/home/shquier/easyconf.net/easychair/app/services/CronService.php:212:                INNER JOIN review_assignments ra ON ra.submission_id = s.id AND ra.status = 'completed'
/home/shquier/easyconf.net/easychair/app/services/CronService.php:213:                INNER JOIN reviews r ON r.review_assignment_id = ra.id
/home/shquier/easyconf.net/easychair/app/services/StageTransitionService.php:88:            FROM review_assignments
/home/shquier/easyconf.net/easychair/app/services/ReviewConflictService.php:56:                FROM review_assignments
/home/shquier/easyconf.net/easychair/app/services/ReviewConflictService.php:58:                AND reviewer_id = ?
/home/shquier/easyconf.net/easychair/app/services/ReviewConflictService.php:83:                AND reviewer_id = ?
/home/shquier/easyconf.net/easychair/app/services/Certification/WorkflowStateValidator.php:199:            FROM review_assignments
/home/shquier/easyconf.net/easychair/app/services/Certification/WorkflowStateValidator.php:208:            FROM review_assignments
/home/shquier/easyconf.net/easychair/app/services/SubmissionWorkflowService.php:561:        FROM review_assignments
/home/shquier/easyconf.net/easychair/app/services/ReviewReminderService.php:23:                    ra.reviewer_id,
/home/shquier/easyconf.net/easychair/app/services/ReviewReminderService.php:27:                FROM review_assignments ra
/home/shquier/easyconf.net/easychair/app/services/ReviewReminderService.php:29:                    ON u.id = ra.reviewer_id
/home/shquier/easyconf.net/easychair/app/services/ReviewReminderService.php:50:                (int)$r['reviewer_id']
/home/shquier/easyconf.net/easychair/app/services/ConferenceEmailTemplateService.php:53:            'review_assigned',
/home/shquier/easyconf.net/easychair/app/services/ReviewerReassignmentService.php:23:                FROM review_assignments
/home/shquier/easyconf.net/easychair/app/services/ReviewerReassignmentService.php:41:                FROM review_assignments ra
/home/shquier/easyconf.net/easychair/app/services/ReviewerReassignmentService.php:43:                ra.reviewer_id=u.id
/home/shquier/easyconf.net/easychair/app/services/ReviewerReassignmentService.php:52:        FROM conference_reviewers cr
/home/shquier/easyconf.net/easychair/app/services/ReviewerReassignmentService.php:79:            FROM review_assignments
/home/shquier/easyconf.net/easychair/app/services/ReviewerReassignmentService.php:93:                    old_reviewer_id,
/home/shquier/easyconf.net/easychair/app/services/ReviewerReassignmentService.php:94:                    suggested_reviewer_id,
/home/shquier/easyconf.net/easychair/app/cron/reviewer_ecosystem_actions_rebuild.php:19:m.reviewer_id,
/home/shquier/easyconf.net/easychair/app/cron/reviewer_ecosystem_actions_rebuild.php:78:        reviewer_id,
/home/shquier/easyconf.net/easychair/app/cron/reviewer_ecosystem_actions_rebuild.php:90:        $r['reviewer_id'],
/home/shquier/easyconf.net/easychair/app/cron/reviewer_awards_rebuild.php:48:        reviewer_id,
/home/shquier/easyconf.net/easychair/app/cron/reviewer_awards_rebuild.php:60:        $r['reviewer_id'],
/home/shquier/easyconf.net/easychair/app/cron/reviewer_leadership_pipeline_rebuild.php:19:reviewer_id,
/home/shquier/easyconf.net/easychair/app/cron/reviewer_leadership_pipeline_rebuild.php:86:        reviewer_id,
/home/shquier/easyconf.net/easychair/app/cron/reviewer_leadership_pipeline_rebuild.php:98:        $r['reviewer_id'],
/home/shquier/easyconf.net/easychair/app/cron/reviewer_marketplace_rebuild.php:19:rla.reviewer_id,
/home/shquier/easyconf.net/easychair/app/cron/reviewer_marketplace_rebuild.php:24:ON rri.reviewer_id=rla.reviewer_id
/home/shquier/easyconf.net/easychair/app/cron/reviewer_marketplace_rebuild.php:26:rla.reviewer_id,
/home/shquier/easyconf.net/easychair/app/cron/reviewer_marketplace_rebuild.php:58:        reviewer_id,
/home/shquier/easyconf.net/easychair/app/cron/reviewer_marketplace_rebuild.php:72:        $r['reviewer_id'],
/home/shquier/easyconf.net/easychair/app/cron/reviewer_assignment_score_rebuild.php:27:ON rws.reviewer_id=rp.reviewer_id
/home/shquier/easyconf.net/easychair/app/cron/reviewer_assignment_score_rebuild.php:80:        reviewer_id,
/home/shquier/easyconf.net/easychair/app/cron/reviewer_assignment_score_rebuild.php:95:        $r['reviewer_id'],
/home/shquier/easyconf.net/easychair/app/cron/reviewer_mentorship_network_rebuild.php:19:reviewer_id,
/home/shquier/easyconf.net/easychair/app/cron/reviewer_mentorship_network_rebuild.php:35:reviewer_id,
/home/shquier/easyconf.net/easychair/app/cron/reviewer_mentorship_network_rebuild.php:75:        mentor_reviewer_id,
/home/shquier/easyconf.net/easychair/app/cron/reviewer_mentorship_network_rebuild.php:76:        mentee_reviewer_id,
/home/shquier/easyconf.net/easychair/app/cron/reviewer_mentorship_network_rebuild.php:87:        $mentor['reviewer_id'],
/home/shquier/easyconf.net/easychair/app/cron/reviewer_mentorship_network_rebuild.php:88:        $m['reviewer_id'],
/home/shquier/easyconf.net/easychair/app/cron/review_reminders.php:26:ra.reviewer_id,
/home/shquier/easyconf.net/easychair/app/cron/review_reminders.php:49:FROM review_assignments ra
/home/shquier/easyconf.net/easychair/app/cron/review_reminders.php:52:ON u.id=ra.reviewer_id
/home/shquier/easyconf.net/easychair/app/cron/review_reminders.php:117:        FROM review_assignment_reminders
/home/shquier/easyconf.net/easychair/app/cron/review_reminders.php:178:        $r['reviewer_id'],
/home/shquier/easyconf.net/easychair/app/cron/review_reminders.php:190:        INSERT INTO review_assignment_reminders
/home/shquier/easyconf.net/easychair/app/cron/reviewer_certification_promotions_rebuild.php:19:reviewer_id,
/home/shquier/easyconf.net/easychair/app/cron/reviewer_certification_promotions_rebuild.php:68:        reviewer_id,
/home/shquier/easyconf.net/easychair/app/cron/reviewer_certification_promotions_rebuild.php:80:        $r['reviewer_id'],
/home/shquier/easyconf.net/easychair/app/cron/reviewer_risk_rebuild.php:29:    (int)$r['reviewer_id'];
/home/shquier/easyconf.net/easychair/app/cron/reviewer_risk_rebuild.php:49:        FROM review_assignments
/home/shquier/easyconf.net/easychair/app/cron/reviewer_risk_rebuild.php:50:        WHERE reviewer_id=".$reviewerId."
/home/shquier/easyconf.net/easychair/app/cron/reviewer_risk_rebuild.php:58:        FROM review_assignments
/home/shquier/easyconf.net/easychair/app/cron/reviewer_risk_rebuild.php:59:        WHERE reviewer_id=".$reviewerId."
/home/shquier/easyconf.net/easychair/app/cron/reviewer_risk_rebuild.php:112:        reviewer_id,
/home/shquier/easyconf.net/easychair/app/cron/reviewer_succession_plans_rebuild.php:19:reviewer_id,
/home/shquier/easyconf.net/easychair/app/cron/reviewer_succession_plans_rebuild.php:112:        reviewer_id,
/home/shquier/easyconf.net/easychair/app/cron/reviewer_succession_plans_rebuild.php:123:        $r['reviewer_id'],
/home/shquier/easyconf.net/easychair/app/cron/reviewer_reward_intelligence_rebuild.php:19:t.reviewer_id,
/home/shquier/easyconf.net/easychair/app/cron/reviewer_reward_intelligence_rebuild.php:25:ON t.reviewer_id=r.reviewer_id
/home/shquier/easyconf.net/easychair/app/cron/reviewer_reward_intelligence_rebuild.php:80:        reviewer_id,
/home/shquier/easyconf.net/easychair/app/cron/reviewer_reward_intelligence_rebuild.php:91:        $r['reviewer_id'],
/home/shquier/easyconf.net/easychair/app/cron/reviewer_capacity_forecast.php:22:reviewer_id,
/home/shquier/easyconf.net/easychair/app/cron/reviewer_capacity_forecast.php:25:FROM review_assignments
/home/shquier/easyconf.net/easychair/app/cron/reviewer_capacity_forecast.php:33:reviewer_id,
/home/shquier/easyconf.net/easychair/app/cron/reviewer_capacity_forecast.php:70:        reviewer_id,
/home/shquier/easyconf.net/easychair/app/cron/reviewer_capacity_forecast.php:83:        $r['reviewer_id'],
/home/shquier/easyconf.net/easychair/app/cron/reviewer_performance_rebuild.php:22:reviewer_id,
/home/shquier/easyconf.net/easychair/app/cron/reviewer_performance_rebuild.php:45:FROM review_assignments
/home/shquier/easyconf.net/easychair/app/cron/reviewer_performance_rebuild.php:48:reviewer_id,
/home/shquier/easyconf.net/easychair/app/cron/reviewer_performance_rebuild.php:116:        reviewer_id,
/home/shquier/easyconf.net/easychair/app/cron/reviewer_performance_rebuild.php:143:        $r['reviewer_id'],
/home/shquier/easyconf.net/easychair/app/cron/reviewer_recommendation_explanations_rebuild.php:76:        reviewer_id,
/home/shquier/easyconf.net/easychair/app/cron/reviewer_recommendation_explanations_rebuild.php:86:        $r['reviewer_id'],
/home/shquier/easyconf.net/easychair/app/cron/reviewer_academy_programs_rebuild.php:19:reviewer_id,
/home/shquier/easyconf.net/easychair/app/cron/reviewer_academy_programs_rebuild.php:105:        reviewer_id,
/home/shquier/easyconf.net/easychair/app/cron/reviewer_academy_programs_rebuild.php:117:        $r['reviewer_id'],
/home/shquier/easyconf.net/easychair/app/cron/reviewer_reputation_network_rebuild.php:19:reviewer_id,
/home/shquier/easyconf.net/easychair/app/cron/reviewer_reputation_network_rebuild.php:70:        reviewer_id,
/home/shquier/easyconf.net/easychair/app/cron/reviewer_reputation_network_rebuild.php:83:        $r['reviewer_id'],
/home/shquier/easyconf.net/easychair/app/cron/reviewer_retention_intelligence_rebuild.php:19:reviewer_id,
/home/shquier/easyconf.net/easychair/app/cron/reviewer_retention_intelligence_rebuild.php:74:        reviewer_id,
/home/shquier/easyconf.net/easychair/app/cron/reviewer_retention_intelligence_rebuild.php:87:        $r['reviewer_id'],
/home/shquier/easyconf.net/easychair/app/cron/reviewer_talent_management_rebuild.php:19:reviewer_id,
/home/shquier/easyconf.net/easychair/app/cron/reviewer_talent_management_rebuild.php:70:        reviewer_id,
/home/shquier/easyconf.net/easychair/app/cron/reviewer_talent_management_rebuild.php:83:        $r['reviewer_id'],
/home/shquier/easyconf.net/easychair/app/cron/track_intelligence_rebuild.php:42:        FROM review_assignments ra
/home/shquier/easyconf.net/easychair/app/cron/track_intelligence_rebuild.php:51:        FROM review_assignments ra
/home/shquier/easyconf.net/easychair/app/cron/track_intelligence_rebuild.php:60:        SELECT COUNT(DISTINCT ra.reviewer_id)
/home/shquier/easyconf.net/easychair/app/cron/track_intelligence_rebuild.php:61:        FROM review_assignments ra
/home/shquier/easyconf.net/easychair/app/cron/reviewer_global_experts_rebuild.php:19:reviewer_id,
/home/shquier/easyconf.net/easychair/app/cron/reviewer_global_experts_rebuild.php:71:        reviewer_id,
/home/shquier/easyconf.net/easychair/app/cron/reviewer_global_experts_rebuild.php:84:        $r['reviewer_id'],
/home/shquier/easyconf.net/easychair/app/cron/reviewer_digital_twins_rebuild.php:19:reviewer_id,
/home/shquier/easyconf.net/easychair/app/cron/reviewer_digital_twins_rebuild.php:76:        reviewer_id,
/home/shquier/easyconf.net/easychair/app/cron/reviewer_digital_twins_rebuild.php:91:        $r['reviewer_id'],
/home/shquier/easyconf.net/easychair/app/cron/reviewer_network_rebuild.php:30:reviewer_id,
/home/shquier/easyconf.net/easychair/app/cron/reviewer_network_rebuild.php:33:FROM review_assignments
/home/shquier/easyconf.net/easychair/app/cron/reviewer_network_rebuild.php:34:GROUP BY reviewer_id,conference_id
/home/shquier/easyconf.net/easychair/app/cron/reviewer_network_rebuild.php:39:    $rid=(int)$r['reviewer_id'];
/home/shquier/easyconf.net/easychair/app/cron/reviewer_network_rebuild.php:46:        WHERE reviewer_id=".$rid."
/home/shquier/easyconf.net/easychair/app/cron/reviewer_network_rebuild.php:75:        reviewer_id,
/home/shquier/easyconf.net/easychair/app/cron/reviewer_network_rebuild.php:100:            reviewer_id,
/home/shquier/easyconf.net/easychair/app/cron/reviewer_network_rebuild.php:123:            reviewer_id,
/home/shquier/easyconf.net/easychair/app/cron/review_deadline_prediction_rebuild.php:23:ra.reviewer_id,
/home/shquier/easyconf.net/easychair/app/cron/review_deadline_prediction_rebuild.php:32:FROM review_assignments ra
/home/shquier/easyconf.net/easychair/app/cron/review_deadline_prediction_rebuild.php:34:ON rp.reviewer_id=ra.reviewer_id
/home/shquier/easyconf.net/easychair/app/cron/review_deadline_prediction_rebuild.php:81:        reviewer_id,
/home/shquier/easyconf.net/easychair/app/cron/review_deadline_prediction_rebuild.php:93:        $r['reviewer_id'],
/home/shquier/easyconf.net/easychair/app/cron/reviewer_leadership_succession_ai_rebuild.php:19:reviewer_id,
/home/shquier/easyconf.net/easychair/app/cron/reviewer_leadership_succession_ai_rebuild.php:74:        reviewer_id,
/home/shquier/easyconf.net/easychair/app/cron/reviewer_leadership_succession_ai_rebuild.php:87:        $r['reviewer_id'],
/home/shquier/easyconf.net/easychair/app/cron/reviewer_workload_rebuild.php:22:reviewer_id,
/home/shquier/easyconf.net/easychair/app/cron/reviewer_workload_rebuild.php:24:FROM review_assignments
/home/shquier/easyconf.net/easychair/app/cron/reviewer_workload_rebuild.php:33:    (int)$r['reviewer_id'];
/home/shquier/easyconf.net/easychair/app/cron/reviewer_workload_rebuild.php:38:        FROM review_assignments
/home/shquier/easyconf.net/easychair/app/cron/reviewer_workload_rebuild.php:39:        WHERE reviewer_id=".$rid."
/home/shquier/easyconf.net/easychair/app/cron/reviewer_workload_rebuild.php:83:            reviewer_id,
/home/shquier/easyconf.net/easychair/app/cron/review_escalation_rebuild.php:30:        SELECT reviewer_id
/home/shquier/easyconf.net/easychair/app/cron/review_escalation_rebuild.php:42:        reviewer_id,
/home/shquier/easyconf.net/easychair/app/cron/review_escalation_rebuild.php:45:        replacement_reviewer_id
/home/shquier/easyconf.net/easychair/app/cron/review_escalation_rebuild.php:54:        $r['reviewer_id'],
/home/shquier/easyconf.net/easychair/app/cron/reviewer_exchange_rebuild.php:19:reviewer_id,
/home/shquier/easyconf.net/easychair/app/cron/reviewer_exchange_rebuild.php:64:            reviewer_id,
/home/shquier/easyconf.net/easychair/app/cron/reviewer_exchange_rebuild.php:76:            $r['reviewer_id'],
/home/shquier/easyconf.net/easychair/app/cron/reviewer_lifetime_achievement_rebuild.php:19:reviewer_id,
/home/shquier/easyconf.net/easychair/app/cron/reviewer_lifetime_achievement_rebuild.php:22:GROUP BY reviewer_id
/home/shquier/easyconf.net/easychair/app/cron/reviewer_lifetime_achievement_rebuild.php:57:        reviewer_id,
/home/shquier/easyconf.net/easychair/app/cron/reviewer_lifetime_achievement_rebuild.php:69:        $r['reviewer_id'],
/home/shquier/easyconf.net/easychair/app/cron/reviewer_risk_notifications.php:27:ON u.id=rrf.reviewer_id
/home/shquier/easyconf.net/easychair/app/cron/reviewer_risk_notifications.php:64:        $r['reviewer_id'],
/home/shquier/easyconf.net/easychair/app/models/AnalyticsModel.php:77:        if ($this->tableExists('review_assignments') && $this->columnExists('review_assignments', 'status')) {
/home/shquier/easyconf.net/easychair/app/models/AnalyticsModel.php:78:            $stats['reviews_completed'] = $this->safeCount("SELECT COUNT(*) FROM review_assignments WHERE status = 'completed'");
/home/shquier/easyconf.net/easychair/app/models/AnalyticsModel.php:79:            $stats['reviews_pending'] = $this->safeCount("SELECT COUNT(*) FROM review_assignments WHERE status IN ('assigned','accepted','overdue')");
/home/shquier/easyconf.net/easychair/app/models/OperationsModel.php:265:            FROM review_assignments ra
/home/shquier/easyconf.net/easychair/app/models/OperationsModel.php:267:            WHERE ra.reviewer_id = :reviewer_id
/home/shquier/easyconf.net/easychair/app/models/OperationsModel.php:272:            ':reviewer_id' => $reviewerId,
/home/shquier/easyconf.net/easychair/app/models/DashboardAnalyticsModel.php:17:        $stats['reviews'] = (int) $this->db->query("SELECT COUNT(*) FROM review_assignments")->fetchColumn();
/home/shquier/easyconf.net/easychair/app/models/DashboardAnalyticsModel.php:61:            LEFT JOIN review_assignments ra ON ra.reviewer_id = u.id
/home/shquier/easyconf.net/easychair/app/models/ReviewerAnalyticsModel.php:23:            LEFT JOIN review_assignments ra ON ra.reviewer_id = u.id
/home/shquier/easyconf.net/easychair/app/models/ReviewerAnalyticsModel.php:24:            LEFT JOIN reviews r ON r.review_assignment_id = ra.id
/home/shquier/easyconf.net/easychair/app/models/Review.php:41:            FROM review_assignments ra
/home/shquier/easyconf.net/easychair/app/models/Review.php:42:            INNER JOIN users u ON u.id = ra.reviewer_id
/home/shquier/easyconf.net/easychair/app/models/Review.php:43:            LEFT JOIN reviewer_ratings rr ON rr.review_assignment_id = ra.id
/home/shquier/easyconf.net/easychair/app/models/Review.php:57:            FROM review_assignments ra
/home/shquier/easyconf.net/easychair/app/models/Review.php:60:            WHERE ra.reviewer_id = :reviewer_id
/home/shquier/easyconf.net/easychair/app/models/Review.php:63:        $stmt->execute([':reviewer_id' => $reviewerId]);
/home/shquier/easyconf.net/easychair/app/models/Review.php:74:            FROM review_assignments ra
/home/shquier/easyconf.net/easychair/app/models/Review.php:77:            LEFT JOIN users u ON u.id = ra.reviewer_id
/home/shquier/easyconf.net/easychair/app/models/Review.php:89:            FROM review_assignments
/home/shquier/easyconf.net/easychair/app/models/Review.php:91:              AND reviewer_id = :reviewer_id
/home/shquier/easyconf.net/easychair/app/models/Review.php:96:            ':reviewer_id' => $reviewerId,
/home/shquier/easyconf.net/easychair/app/models/Review.php:101:    public function assignReviewer(array $data): int
/home/shquier/easyconf.net/easychair/app/models/Review.php:104:            INSERT INTO review_assignments (
/home/shquier/easyconf.net/easychair/app/models/Review.php:105:                submission_id, reviewer_id, assigned_by, due_date, status, created_at
/home/shquier/easyconf.net/easychair/app/models/Review.php:107:                :submission_id, :reviewer_id, :assigned_by, :due_date, :status, NOW()
/home/shquier/easyconf.net/easychair/app/models/Review.php:112:            ':reviewer_id' => $data['reviewer_id'],
/home/shquier/easyconf.net/easychair/app/models/Review.php:124:                review_assignment_id, overall_score, comments_to_author, comments_to_editor,
/home/shquier/easyconf.net/easychair/app/models/Review.php:127:                :review_assignment_id, :overall_score, :comments_to_author, :comments_to_editor,
/home/shquier/easyconf.net/easychair/app/models/Review.php:138:            ':review_assignment_id' => $assignmentId,
/home/shquier/easyconf.net/easychair/app/models/Review.php:145:        $stmt = $this->db->prepare("UPDATE review_assignments SET status = 'completed' WHERE id = :id");
/home/shquier/easyconf.net/easychair/app/models/Review.php:152:            INSERT INTO review_files (review_assignment_id, file_path, original_filename, uploaded_by)
/home/shquier/easyconf.net/easychair/app/models/Review.php:153:            VALUES (:review_assignment_id, :file_path, :original_filename, :uploaded_by)
/home/shquier/easyconf.net/easychair/app/models/Review.php:156:            ':review_assignment_id' => $assignmentId,
/home/shquier/easyconf.net/easychair/app/models/Review.php:165:        $stmt = $this->db->prepare("SELECT * FROM review_files WHERE review_assignment_id = :id ORDER BY id DESC");
/home/shquier/easyconf.net/easychair/app/models/Review.php:173:            INSERT INTO reviewer_ratings (review_assignment_id, reviewer_id, rated_by, rating_score, rating_notes)
/home/shquier/easyconf.net/easychair/app/models/Review.php:174:            VALUES (:review_assignment_id, :reviewer_id, :rated_by, :rating_score, :rating_notes)
/home/shquier/easyconf.net/easychair/app/models/Review.php:176:                reviewer_id = VALUES(reviewer_id),
/home/shquier/easyconf.net/easychair/app/models/Review.php:182:            ':review_assignment_id' => $assignmentId,
/home/shquier/easyconf.net/easychair/app/models/Review.php:183:            ':reviewer_id' => $reviewerId,
/home/shquier/easyconf.net/easychair/app/models/DecisionModel.php:98:            FROM review_assignments ra
/home/shquier/easyconf.net/easychair/app/models/DecisionModel.php:99:            LEFT JOIN reviews r ON r.review_assignment_id = ra.id
