Symfony Profiler

[
  "route" => "moderator_learners"
  "route_parameters" => [
    "_route" => "moderator_learners"
    "_controller" => "App\Controller\StudentController::learners"
  ]
  "request_uri" => "https://dev.centr.sariato.ru/moderator/learners"
  "method" => "GET"
]

[
  "firewall_name" => "main"
  "authenticators" => 1
]

[
  "firewall_name" => "main"
  "authenticator" => "App\Security\Authenticator"
]

[
  "firewall_name" => "main"
  "authenticator" => "App\Security\Authenticator"
]

[
  "key" => "_security_main"
  "token_class" => "Symfony\Component\Security\Http\Authenticator\Token\PostAuthenticationToken"
]

[
  "params" => [
    "use_savepoints" => true
    "driver" => "pdo_mysql"
    "idle_connection_ttl" => 600
    "host" => "127.0.0.1"
    "port" => 3306
    "user" => "db"
    "password" => "<redacted>"
    "driverOptions" => []
    "defaultTableOptions" => [
      "collation" => "utf8mb4_unicode_ci"
    ]
    "dbname" => "centr_dev"
    "serverVersion" => "10.6.22-MariaDB"
    "charset" => "utf8mb4"
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.username AS username_2, t0.roles AS roles_3, t0.password AS password_4, t0.first_name AS first_name_5, t0.last_name AS last_name_6, t0.telegram_user_id AS telegram_user_id_7, t0.telegram_phone AS telegram_phone_8, t0.sort_id AS sort_id_9, t0.status AS status_10, t0.person_id AS person_id_11, t0.settings_id AS settings_id_12, t13.id AS id_14, t13.candidate_decline_comments AS candidate_decline_comments_15, t13.candidate_recommendations AS candidate_recommendations_16, t13.user_id AS user_id_17, t18.id AS id_19, t18.show_reviewer_recommendations_tip AS show_reviewer_recommendations_tip_20, t18.show_calendar_events_period_tip AS show_calendar_events_period_tip_21, t18.user_id AS user_id_22 FROM user t0 LEFT JOIN reviewer_settings t13 ON t13.user_id = t0.id LEFT JOIN tip_settings t18 ON t18.user_id = t0.id WHERE t0.id = ?"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => 1
  ]
]

[
  "provider" => "Symfony\Bridge\Doctrine\Security\User\EntityUserProvider"
  "username" => "admin"
]

[
  "sql" => "SELECT p0_.id AS id_0, p0_.first_name AS first_name_1, p0_.last_name AS last_name_2, p0_.phone AS phone_3, p0_.email AS email_4, p0_.comment AS comment_5, p0_.last_name2 AS last_name2_6, p0_.telegram_user_id AS telegram_user_id_7, p0_.can_send_telegram_campaigns AS can_send_telegram_campaigns_8, p0_.is_student AS is_student_9, p0_.is_subscriber AS is_subscriber_10, p0_.surname AS surname_11, p0_.created_at AS created_at_12, p0_.emails AS emails_13, p0_.birthday AS birthday_14, p0_.status AS status_15, p0_.is_unsubscribed AS is_unsubscribed_16, p0_.tg_channel_add_error_date AS tg_channel_add_error_date_17, p0_.tg_channel_add_response AS tg_channel_add_response_18, p0_.student_id AS student_id_19, p0_.city_id AS city_id_20, p0_.image_id AS image_id_21, p0_.message_receiver_id AS message_receiver_id_22, p0_.job_id AS job_id_23 FROM person p0_ LEFT JOIN student s1_ ON p0_.student_id = s1_.id WHERE (s1_.status IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) OR s1_.id IS NULL) AND p0_.status IN (?) ORDER BY p0_.last_name ASC"
  "params" => [
    1 => "active"
    2 => "international_group"
    3 => "restricted"
    4 => "doubt"
    5 => "quarantine"
    6 => "subscriber_non_active"
    7 => "subscriber"
    8 => "subscriber_ripening"
    9 => "subscriber_preparing_student"
    10 => "leaved"
    11 => "black_list"
    12 => "active"
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 2
    5 => 2
    6 => 2
    7 => 2
    8 => 2
    9 => 2
    10 => 2
    11 => 2
    12 => 2
  ]
]

[
  "sql" => "SELECT p0_.id AS id_0, c1_.id AS id_1, MIN(c2_.id) AS sclr_2 FROM candidate c2_ LEFT JOIN person p0_ ON c2_.person_id = p0_.id LEFT JOIN calendar_event c1_ ON c2_.calendar_event_id = c1_.id WHERE c2_.status NOT IN (?, ?, ?, ?) GROUP BY p0_.id, c1_.id"
  "params" => [
    1 => "deleted"
    2 => "draft"
    3 => "leaved"
    4 => "refused"
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 2
  ]
]

[
  "sql" => "SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.start_date AS start_date_2, c0_.end_date AS end_date_3, c0_.price AS price_4, c0_.from_level AS from_level_5, c0_.earn_level AS earn_level_6, c0_.start_time AS start_time_7, c0_.end_time AS end_time_8, c0_.type AS type_9, c0_.is_candidate_review_required AS is_candidate_review_required_10, c0_.telegram_channel_url AS telegram_channel_url_11, c0_.telegram_channel_id AS telegram_channel_id_12, c0_.event_dates_approximate AS event_dates_approximate_13, c0_.status AS status_14, c0_.to_level AS to_level_15, c0_.require_student_status AS require_student_status_16, c0_.connecting_event_for_accountant AS connecting_event_for_accountant_17, c0_.is_telegram_channel_configurated AS is_telegram_channel_configurated_18, c0_.created_at AS created_at_19, c0_.updated_at AS updated_at_20, c0_.payment_requisites_id AS payment_requisites_id_21, c0_.connecting_calendar_event_id AS connecting_calendar_event_id_22, c0_.kind_id AS kind_id_23 FROM calendar_event c0_ ORDER BY c0_.start_date DESC"
]

[
  "sql" => "SELECT c0_.id AS id_0, c0_.status AS status_1, c0_.created_at AS created_at_2, c0_.viewer_comment AS viewer_comment_3, c0_.approved_at AS approved_at_4, c0_.comment AS comment_5, c0_.payment_deferment AS payment_deferment_6, c0_.recommendations AS recommendations_7, c0_.updated_at AS updated_at_8, c0_.review_approve_comment AS review_approve_comment_9, c0_.access_by_receipt AS access_by_receipt_10, c0_.decline_comment AS decline_comment_11, c0_.leaved_at AS leaved_at_12, c0_.registration_type AS registration_type_13, c0_.author_id AS author_id_14, c0_.person_id AS person_id_15, c0_.calendar_event_id AS calendar_event_id_16, c0_.image_id AS image_id_17, c0_.selected_author_id AS selected_author_id_18, c0_.curator_id AS curator_id_19, c0_.invoice_id AS invoice_id_20 FROM candidate c0_ INNER JOIN calendar_event c1_ ON c0_.calendar_event_id = c1_.id WHERE c0_.person_id = ? AND c1_.earn_level IS NOT NULL AND c1_.earn_level >= 0 AND c0_.status IN (?) AND c1_.end_date <= ? ORDER BY c1_.start_date DESC LIMIT 1"
  "params" => [
    1 => 2
    2 => "approved"
    3 => "2026-08-16 00:00:00"
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "SELECT c0_.id AS id_0, c0_.status AS status_1, c0_.created_at AS created_at_2, c0_.viewer_comment AS viewer_comment_3, c0_.approved_at AS approved_at_4, c0_.comment AS comment_5, c0_.payment_deferment AS payment_deferment_6, c0_.recommendations AS recommendations_7, c0_.updated_at AS updated_at_8, c0_.review_approve_comment AS review_approve_comment_9, c0_.access_by_receipt AS access_by_receipt_10, c0_.decline_comment AS decline_comment_11, c0_.leaved_at AS leaved_at_12, c0_.registration_type AS registration_type_13, c0_.author_id AS author_id_14, c0_.person_id AS person_id_15, c0_.calendar_event_id AS calendar_event_id_16, c0_.image_id AS image_id_17, c0_.selected_author_id AS selected_author_id_18, c0_.curator_id AS curator_id_19, c0_.invoice_id AS invoice_id_20 FROM candidate c0_ INNER JOIN calendar_event c1_ ON c0_.calendar_event_id = c1_.id WHERE c0_.person_id = ? AND c1_.earn_level IS NOT NULL AND c1_.earn_level >= 0 AND c0_.status IN (?) AND c1_.end_date <= ? ORDER BY c1_.start_date DESC LIMIT 1"
  "params" => [
    1 => 778
    2 => "approved"
    3 => "2026-08-16 00:00:00"
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "SELECT c0_.id AS id_0, c0_.status AS status_1, c0_.created_at AS created_at_2, c0_.viewer_comment AS viewer_comment_3, c0_.approved_at AS approved_at_4, c0_.comment AS comment_5, c0_.payment_deferment AS payment_deferment_6, c0_.recommendations AS recommendations_7, c0_.updated_at AS updated_at_8, c0_.review_approve_comment AS review_approve_comment_9, c0_.access_by_receipt AS access_by_receipt_10, c0_.decline_comment AS decline_comment_11, c0_.leaved_at AS leaved_at_12, c0_.registration_type AS registration_type_13, c0_.author_id AS author_id_14, c0_.person_id AS person_id_15, c0_.calendar_event_id AS calendar_event_id_16, c0_.image_id AS image_id_17, c0_.selected_author_id AS selected_author_id_18, c0_.curator_id AS curator_id_19, c0_.invoice_id AS invoice_id_20 FROM candidate c0_ INNER JOIN calendar_event c1_ ON c0_.calendar_event_id = c1_.id WHERE c0_.person_id = ? AND c1_.earn_level IS NOT NULL AND c1_.earn_level >= 0 AND c0_.status IN (?) AND c1_.end_date <= ? ORDER BY c1_.start_date DESC LIMIT 1"
  "params" => [
    1 => 799
    2 => "approved"
    3 => "2026-08-16 00:00:00"
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "SELECT c0_.id AS id_0, c0_.status AS status_1, c0_.created_at AS created_at_2, c0_.viewer_comment AS viewer_comment_3, c0_.approved_at AS approved_at_4, c0_.comment AS comment_5, c0_.payment_deferment AS payment_deferment_6, c0_.recommendations AS recommendations_7, c0_.updated_at AS updated_at_8, c0_.review_approve_comment AS review_approve_comment_9, c0_.access_by_receipt AS access_by_receipt_10, c0_.decline_comment AS decline_comment_11, c0_.leaved_at AS leaved_at_12, c0_.registration_type AS registration_type_13, c0_.author_id AS author_id_14, c0_.person_id AS person_id_15, c0_.calendar_event_id AS calendar_event_id_16, c0_.image_id AS image_id_17, c0_.selected_author_id AS selected_author_id_18, c0_.curator_id AS curator_id_19, c0_.invoice_id AS invoice_id_20 FROM candidate c0_ INNER JOIN calendar_event c1_ ON c0_.calendar_event_id = c1_.id WHERE c0_.person_id = ? AND c1_.earn_level IS NOT NULL AND c1_.earn_level >= 0 AND c0_.status IN (?) AND c1_.end_date <= ? ORDER BY c1_.start_date DESC LIMIT 1"
  "params" => [
    1 => 3
    2 => "approved"
    3 => "2026-08-16 00:00:00"
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "SELECT c0_.id AS id_0, c0_.status AS status_1, c0_.created_at AS created_at_2, c0_.viewer_comment AS viewer_comment_3, c0_.approved_at AS approved_at_4, c0_.comment AS comment_5, c0_.payment_deferment AS payment_deferment_6, c0_.recommendations AS recommendations_7, c0_.updated_at AS updated_at_8, c0_.review_approve_comment AS review_approve_comment_9, c0_.access_by_receipt AS access_by_receipt_10, c0_.decline_comment AS decline_comment_11, c0_.leaved_at AS leaved_at_12, c0_.registration_type AS registration_type_13, c0_.author_id AS author_id_14, c0_.person_id AS person_id_15, c0_.calendar_event_id AS calendar_event_id_16, c0_.image_id AS image_id_17, c0_.selected_author_id AS selected_author_id_18, c0_.curator_id AS curator_id_19, c0_.invoice_id AS invoice_id_20 FROM candidate c0_ INNER JOIN calendar_event c1_ ON c0_.calendar_event_id = c1_.id WHERE c0_.person_id = ? AND c1_.earn_level IS NOT NULL AND c1_.earn_level >= 0 AND c0_.status IN (?) AND c1_.end_date <= ? ORDER BY c1_.start_date DESC LIMIT 1"
  "params" => [
    1 => 4
    2 => "approved"
    3 => "2026-08-16 00:00:00"
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "SELECT c0_.id AS id_0, c0_.status AS status_1, c0_.created_at AS created_at_2, c0_.viewer_comment AS viewer_comment_3, c0_.approved_at AS approved_at_4, c0_.comment AS comment_5, c0_.payment_deferment AS payment_deferment_6, c0_.recommendations AS recommendations_7, c0_.updated_at AS updated_at_8, c0_.review_approve_comment AS review_approve_comment_9, c0_.access_by_receipt AS access_by_receipt_10, c0_.decline_comment AS decline_comment_11, c0_.leaved_at AS leaved_at_12, c0_.registration_type AS registration_type_13, c0_.author_id AS author_id_14, c0_.person_id AS person_id_15, c0_.calendar_event_id AS calendar_event_id_16, c0_.image_id AS image_id_17, c0_.selected_author_id AS selected_author_id_18, c0_.curator_id AS curator_id_19, c0_.invoice_id AS invoice_id_20 FROM candidate c0_ INNER JOIN calendar_event c1_ ON c0_.calendar_event_id = c1_.id WHERE c0_.person_id = ? AND c1_.earn_level IS NOT NULL AND c1_.earn_level >= 0 AND c0_.status IN (?) AND c1_.end_date <= ? ORDER BY c1_.start_date DESC LIMIT 1"
  "params" => [
    1 => 1119
    2 => "approved"
    3 => "2026-08-16 00:00:00"
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "SELECT c0_.id AS id_0, c0_.status AS status_1, c0_.created_at AS created_at_2, c0_.viewer_comment AS viewer_comment_3, c0_.approved_at AS approved_at_4, c0_.comment AS comment_5, c0_.payment_deferment AS payment_deferment_6, c0_.recommendations AS recommendations_7, c0_.updated_at AS updated_at_8, c0_.review_approve_comment AS review_approve_comment_9, c0_.access_by_receipt AS access_by_receipt_10, c0_.decline_comment AS decline_comment_11, c0_.leaved_at AS leaved_at_12, c0_.registration_type AS registration_type_13, c0_.author_id AS author_id_14, c0_.person_id AS person_id_15, c0_.calendar_event_id AS calendar_event_id_16, c0_.image_id AS image_id_17, c0_.selected_author_id AS selected_author_id_18, c0_.curator_id AS curator_id_19, c0_.invoice_id AS invoice_id_20 FROM candidate c0_ INNER JOIN calendar_event c1_ ON c0_.calendar_event_id = c1_.id WHERE c0_.person_id = ? AND c1_.earn_level IS NOT NULL AND c1_.earn_level >= 0 AND c0_.status IN (?) AND c1_.end_date <= ? ORDER BY c1_.start_date DESC LIMIT 1"
  "params" => [
    1 => 5
    2 => "approved"
    3 => "2026-08-16 00:00:00"
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "SELECT c0_.id AS id_0, c0_.status AS status_1, c0_.created_at AS created_at_2, c0_.viewer_comment AS viewer_comment_3, c0_.approved_at AS approved_at_4, c0_.comment AS comment_5, c0_.payment_deferment AS payment_deferment_6, c0_.recommendations AS recommendations_7, c0_.updated_at AS updated_at_8, c0_.review_approve_comment AS review_approve_comment_9, c0_.access_by_receipt AS access_by_receipt_10, c0_.decline_comment AS decline_comment_11, c0_.leaved_at AS leaved_at_12, c0_.registration_type AS registration_type_13, c0_.author_id AS author_id_14, c0_.person_id AS person_id_15, c0_.calendar_event_id AS calendar_event_id_16, c0_.image_id AS image_id_17, c0_.selected_author_id AS selected_author_id_18, c0_.curator_id AS curator_id_19, c0_.invoice_id AS invoice_id_20 FROM candidate c0_ INNER JOIN calendar_event c1_ ON c0_.calendar_event_id = c1_.id WHERE c0_.person_id = ? AND c1_.earn_level IS NOT NULL AND c1_.earn_level >= 0 AND c0_.status IN (?) AND c1_.end_date <= ? ORDER BY c1_.start_date DESC LIMIT 1"
  "params" => [
    1 => 1347
    2 => "approved"
    3 => "2026-08-16 00:00:00"
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "SELECT c0_.id AS id_0, c0_.status AS status_1, c0_.created_at AS created_at_2, c0_.viewer_comment AS viewer_comment_3, c0_.approved_at AS approved_at_4, c0_.comment AS comment_5, c0_.payment_deferment AS payment_deferment_6, c0_.recommendations AS recommendations_7, c0_.updated_at AS updated_at_8, c0_.review_approve_comment AS review_approve_comment_9, c0_.access_by_receipt AS access_by_receipt_10, c0_.decline_comment AS decline_comment_11, c0_.leaved_at AS leaved_at_12, c0_.registration_type AS registration_type_13, c0_.author_id AS author_id_14, c0_.person_id AS person_id_15, c0_.calendar_event_id AS calendar_event_id_16, c0_.image_id AS image_id_17, c0_.selected_author_id AS selected_author_id_18, c0_.curator_id AS curator_id_19, c0_.invoice_id AS invoice_id_20 FROM candidate c0_ INNER JOIN calendar_event c1_ ON c0_.calendar_event_id = c1_.id WHERE c0_.person_id = ? AND c1_.earn_level IS NOT NULL AND c1_.earn_level >= 0 AND c0_.status IN (?) AND c1_.end_date <= ? ORDER BY c1_.start_date DESC LIMIT 1"
  "params" => [
    1 => 1221
    2 => "approved"
    3 => "2026-08-16 00:00:00"
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "SELECT c0_.id AS id_0, c0_.status AS status_1, c0_.created_at AS created_at_2, c0_.viewer_comment AS viewer_comment_3, c0_.approved_at AS approved_at_4, c0_.comment AS comment_5, c0_.payment_deferment AS payment_deferment_6, c0_.recommendations AS recommendations_7, c0_.updated_at AS updated_at_8, c0_.review_approve_comment AS review_approve_comment_9, c0_.access_by_receipt AS access_by_receipt_10, c0_.decline_comment AS decline_comment_11, c0_.leaved_at AS leaved_at_12, c0_.registration_type AS registration_type_13, c0_.author_id AS author_id_14, c0_.person_id AS person_id_15, c0_.calendar_event_id AS calendar_event_id_16, c0_.image_id AS image_id_17, c0_.selected_author_id AS selected_author_id_18, c0_.curator_id AS curator_id_19, c0_.invoice_id AS invoice_id_20 FROM candidate c0_ INNER JOIN calendar_event c1_ ON c0_.calendar_event_id = c1_.id WHERE c0_.person_id = ? AND c1_.earn_level IS NOT NULL AND c1_.earn_level >= 0 AND c0_.status IN (?) AND c1_.end_date <= ? ORDER BY c1_.start_date DESC LIMIT 1"
  "params" => [
    1 => 6
    2 => "approved"
    3 => "2026-08-16 00:00:00"
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "SELECT c0_.id AS id_0, c0_.status AS status_1, c0_.created_at AS created_at_2, c0_.viewer_comment AS viewer_comment_3, c0_.approved_at AS approved_at_4, c0_.comment AS comment_5, c0_.payment_deferment AS payment_deferment_6, c0_.recommendations AS recommendations_7, c0_.updated_at AS updated_at_8, c0_.review_approve_comment AS review_approve_comment_9, c0_.access_by_receipt AS access_by_receipt_10, c0_.decline_comment AS decline_comment_11, c0_.leaved_at AS leaved_at_12, c0_.registration_type AS registration_type_13, c0_.author_id AS author_id_14, c0_.person_id AS person_id_15, c0_.calendar_event_id AS calendar_event_id_16, c0_.image_id AS image_id_17, c0_.selected_author_id AS selected_author_id_18, c0_.curator_id AS curator_id_19, c0_.invoice_id AS invoice_id_20 FROM candidate c0_ INNER JOIN calendar_event c1_ ON c0_.calendar_event_id = c1_.id WHERE c0_.person_id = ? AND c1_.earn_level IS NOT NULL AND c1_.earn_level >= 0 AND c0_.status IN (?) AND c1_.end_date <= ? ORDER BY c1_.start_date DESC LIMIT 1"
  "params" => [
    1 => 7
    2 => "approved"
    3 => "2026-08-16 00:00:00"
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "SELECT c0_.id AS id_0, c0_.status AS status_1, c0_.created_at AS created_at_2, c0_.viewer_comment AS viewer_comment_3, c0_.approved_at AS approved_at_4, c0_.comment AS comment_5, c0_.payment_deferment AS payment_deferment_6, c0_.recommendations AS recommendations_7, c0_.updated_at AS updated_at_8, c0_.review_approve_comment AS review_approve_comment_9, c0_.access_by_receipt AS access_by_receipt_10, c0_.decline_comment AS decline_comment_11, c0_.leaved_at AS leaved_at_12, c0_.registration_type AS registration_type_13, c0_.author_id AS author_id_14, c0_.person_id AS person_id_15, c0_.calendar_event_id AS calendar_event_id_16, c0_.image_id AS image_id_17, c0_.selected_author_id AS selected_author_id_18, c0_.curator_id AS curator_id_19, c0_.invoice_id AS invoice_id_20 FROM candidate c0_ INNER JOIN calendar_event c1_ ON c0_.calendar_event_id = c1_.id WHERE c0_.person_id = ? AND c1_.earn_level IS NOT NULL AND c1_.earn_level >= 0 AND c0_.status IN (?) AND c1_.end_date <= ? ORDER BY c1_.start_date DESC LIMIT 1"
  "params" => [
    1 => 774
    2 => "approved"
    3 => "2026-08-16 00:00:00"
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "SELECT c0_.id AS id_0, c0_.status AS status_1, c0_.created_at AS created_at_2, c0_.viewer_comment AS viewer_comment_3, c0_.approved_at AS approved_at_4, c0_.comment AS comment_5, c0_.payment_deferment AS payment_deferment_6, c0_.recommendations AS recommendations_7, c0_.updated_at AS updated_at_8, c0_.review_approve_comment AS review_approve_comment_9, c0_.access_by_receipt AS access_by_receipt_10, c0_.decline_comment AS decline_comment_11, c0_.leaved_at AS leaved_at_12, c0_.registration_type AS registration_type_13, c0_.author_id AS author_id_14, c0_.person_id AS person_id_15, c0_.calendar_event_id AS calendar_event_id_16, c0_.image_id AS image_id_17, c0_.selected_author_id AS selected_author_id_18, c0_.curator_id AS curator_id_19, c0_.invoice_id AS invoice_id_20 FROM candidate c0_ INNER JOIN calendar_event c1_ ON c0_.calendar_event_id = c1_.id WHERE c0_.person_id = ? AND c1_.earn_level IS NOT NULL AND c1_.earn_level >= 0 AND c0_.status IN (?) AND c1_.end_date <= ? ORDER BY c1_.start_date DESC LIMIT 1"
  "params" => [
    1 => 8
    2 => "approved"
    3 => "2026-08-16 00:00:00"
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "SELECT c0_.id AS id_0, c0_.status AS status_1, c0_.created_at AS created_at_2, c0_.viewer_comment AS viewer_comment_3, c0_.approved_at AS approved_at_4, c0_.comment AS comment_5, c0_.payment_deferment AS payment_deferment_6, c0_.recommendations AS recommendations_7, c0_.updated_at AS updated_at_8, c0_.review_approve_comment AS review_approve_comment_9, c0_.access_by_receipt AS access_by_receipt_10, c0_.decline_comment AS decline_comment_11, c0_.leaved_at AS leaved_at_12, c0_.registration_type AS registration_type_13, c0_.author_id AS author_id_14, c0_.person_id AS person_id_15, c0_.calendar_event_id AS calendar_event_id_16, c0_.image_id AS image_id_17, c0_.selected_author_id AS selected_author_id_18, c0_.curator_id AS curator_id_19, c0_.invoice_id AS invoice_id_20 FROM candidate c0_ INNER JOIN calendar_event c1_ ON c0_.calendar_event_id = c1_.id WHERE c0_.person_id = ? AND c1_.earn_level IS NOT NULL AND c1_.earn_level >= 0 AND c0_.status IN (?) AND c1_.end_date <= ? ORDER BY c1_.start_date DESC LIMIT 1"
  "params" => [
    1 => 813
    2 => "approved"
    3 => "2026-08-16 00:00:00"
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "SELECT c0_.id AS id_0, c0_.status AS status_1, c0_.created_at AS created_at_2, c0_.viewer_comment AS viewer_comment_3, c0_.approved_at AS approved_at_4, c0_.comment AS comment_5, c0_.payment_deferment AS payment_deferment_6, c0_.recommendations AS recommendations_7, c0_.updated_at AS updated_at_8, c0_.review_approve_comment AS review_approve_comment_9, c0_.access_by_receipt AS access_by_receipt_10, c0_.decline_comment AS decline_comment_11, c0_.leaved_at AS leaved_at_12, c0_.registration_type AS registration_type_13, c0_.author_id AS author_id_14, c0_.person_id AS person_id_15, c0_.calendar_event_id AS calendar_event_id_16, c0_.image_id AS image_id_17, c0_.selected_author_id AS selected_author_id_18, c0_.curator_id AS curator_id_19, c0_.invoice_id AS invoice_id_20 FROM candidate c0_ INNER JOIN calendar_event c1_ ON c0_.calendar_event_id = c1_.id WHERE c0_.person_id = ? AND c1_.earn_level IS NOT NULL AND c1_.earn_level >= 0 AND c0_.status IN (?) AND c1_.end_date <= ? ORDER BY c1_.start_date DESC LIMIT 1"
  "params" => [
    1 => 1328
    2 => "approved"
    3 => "2026-08-16 00:00:00"
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "SELECT c0_.id AS id_0, c0_.status AS status_1, c0_.created_at AS created_at_2, c0_.viewer_comment AS viewer_comment_3, c0_.approved_at AS approved_at_4, c0_.comment AS comment_5, c0_.payment_deferment AS payment_deferment_6, c0_.recommendations AS recommendations_7, c0_.updated_at AS updated_at_8, c0_.review_approve_comment AS review_approve_comment_9, c0_.access_by_receipt AS access_by_receipt_10, c0_.decline_comment AS decline_comment_11, c0_.leaved_at AS leaved_at_12, c0_.registration_type AS registration_type_13, c0_.author_id AS author_id_14, c0_.person_id AS person_id_15, c0_.calendar_event_id AS calendar_event_id_16, c0_.image_id AS image_id_17, c0_.selected_author_id AS selected_author_id_18, c0_.curator_id AS curator_id_19, c0_.invoice_id AS invoice_id_20 FROM candidate c0_ INNER JOIN calendar_event c1_ ON c0_.calendar_event_id = c1_.id WHERE c0_.person_id = ? AND c1_.earn_level IS NOT NULL AND c1_.earn_level >= 0 AND c0_.status IN (?) AND c1_.end_date <= ? ORDER BY c1_.start_date DESC LIMIT 1"
  "params" => [
    1 => 818
    2 => "approved"
    3 => "2026-08-16 00:00:00"
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "SELECT c0_.id AS id_0, c0_.status AS status_1, c0_.created_at AS created_at_2, c0_.viewer_comment AS viewer_comment_3, c0_.approved_at AS approved_at_4, c0_.comment AS comment_5, c0_.payment_deferment AS payment_deferment_6, c0_.recommendations AS recommendations_7, c0_.updated_at AS updated_at_8, c0_.review_approve_comment AS review_approve_comment_9, c0_.access_by_receipt AS access_by_receipt_10, c0_.decline_comment AS decline_comment_11, c0_.leaved_at AS leaved_at_12, c0_.registration_type AS registration_type_13, c0_.author_id AS author_id_14, c0_.person_id AS person_id_15, c0_.calendar_event_id AS calendar_event_id_16, c0_.image_id AS image_id_17, c0_.selected_author_id AS selected_author_id_18, c0_.curator_id AS curator_id_19, c0_.invoice_id AS invoice_id_20 FROM candidate c0_ INNER JOIN calendar_event c1_ ON c0_.calendar_event_id = c1_.id WHERE c0_.person_id = ? AND c1_.earn_level IS NOT NULL AND c1_.earn_level >= 0 AND c0_.status IN (?) AND c1_.end_date <= ? ORDER BY c1_.start_date DESC LIMIT 1"
  "params" => [
    1 => 819
    2 => "approved"
    3 => "2026-08-16 00:00:00"
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "SELECT c0_.id AS id_0, c0_.status AS status_1, c0_.created_at AS created_at_2, c0_.viewer_comment AS viewer_comment_3, c0_.approved_at AS approved_at_4, c0_.comment AS comment_5, c0_.payment_deferment AS payment_deferment_6, c0_.recommendations AS recommendations_7, c0_.updated_at AS updated_at_8, c0_.review_approve_comment AS review_approve_comment_9, c0_.access_by_receipt AS access_by_receipt_10, c0_.decline_comment AS decline_comment_11, c0_.leaved_at AS leaved_at_12, c0_.registration_type AS registration_type_13, c0_.author_id AS author_id_14, c0_.person_id AS person_id_15, c0_.calendar_event_id AS calendar_event_id_16, c0_.image_id AS image_id_17, c0_.selected_author_id AS selected_author_id_18, c0_.curator_id AS curator_id_19, c0_.invoice_id AS invoice_id_20 FROM candidate c0_ INNER JOIN calendar_event c1_ ON c0_.calendar_event_id = c1_.id WHERE c0_.person_id = ? AND c1_.earn_level IS NOT NULL AND c1_.earn_level >= 0 AND c0_.status IN (?) AND c1_.end_date <= ? ORDER BY c1_.start_date DESC LIMIT 1"
  "params" => [
    1 => 9
    2 => "approved"
    3 => "2026-08-16 00:00:00"
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "SELECT c0_.id AS id_0, c0_.status AS status_1, c0_.created_at AS created_at_2, c0_.viewer_comment AS viewer_comment_3, c0_.approved_at AS approved_at_4, c0_.comment AS comment_5, c0_.payment_deferment AS payment_deferment_6, c0_.recommendations AS recommendations_7, c0_.updated_at AS updated_at_8, c0_.review_approve_comment AS review_approve_comment_9, c0_.access_by_receipt AS access_by_receipt_10, c0_.decline_comment AS decline_comment_11, c0_.leaved_at AS leaved_at_12, c0_.registration_type AS registration_type_13, c0_.author_id AS author_id_14, c0_.person_id AS person_id_15, c0_.calendar_event_id AS calendar_event_id_16, c0_.image_id AS image_id_17, c0_.selected_author_id AS selected_author_id_18, c0_.curator_id AS curator_id_19, c0_.invoice_id AS invoice_id_20 FROM candidate c0_ INNER JOIN calendar_event c1_ ON c0_.calendar_event_id = c1_.id WHERE c0_.person_id = ? AND c1_.earn_level IS NOT NULL AND c1_.earn_level >= 0 AND c0_.status IN (?) AND c1_.end_date <= ? ORDER BY c1_.start_date DESC LIMIT 1"
  "params" => [
    1 => 10
    2 => "approved"
    3 => "2026-08-16 00:00:00"
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "SELECT c0_.id AS id_0, c0_.status AS status_1, c0_.created_at AS created_at_2, c0_.viewer_comment AS viewer_comment_3, c0_.approved_at AS approved_at_4, c0_.comment AS comment_5, c0_.payment_deferment AS payment_deferment_6, c0_.recommendations AS recommendations_7, c0_.updated_at AS updated_at_8, c0_.review_approve_comment AS review_approve_comment_9, c0_.access_by_receipt AS access_by_receipt_10, c0_.decline_comment AS decline_comment_11, c0_.leaved_at AS leaved_at_12, c0_.registration_type AS registration_type_13, c0_.author_id AS author_id_14, c0_.person_id AS person_id_15, c0_.calendar_event_id AS calendar_event_id_16, c0_.image_id AS image_id_17, c0_.selected_author_id AS selected_author_id_18, c0_.curator_id AS curator_id_19, c0_.invoice_id AS invoice_id_20 FROM candidate c0_ INNER JOIN calendar_event c1_ ON c0_.calendar_event_id = c1_.id WHERE c0_.person_id = ? AND c1_.earn_level IS NOT NULL AND c1_.earn_level >= 0 AND c0_.status IN (?) AND c1_.end_date <= ? ORDER BY c1_.start_date DESC LIMIT 1"
  "params" => [
    1 => 11
    2 => "approved"
    3 => "2026-08-16 00:00:00"
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "SELECT c0_.id AS id_0, c0_.status AS status_1, c0_.created_at AS created_at_2, c0_.viewer_comment AS viewer_comment_3, c0_.approved_at AS approved_at_4, c0_.comment AS comment_5, c0_.payment_deferment AS payment_deferment_6, c0_.recommendations AS recommendations_7, c0_.updated_at AS updated_at_8, c0_.review_approve_comment AS review_approve_comment_9, c0_.access_by_receipt AS access_by_receipt_10, c0_.decline_comment AS decline_comment_11, c0_.leaved_at AS leaved_at_12, c0_.registration_type AS registration_type_13, c0_.author_id AS author_id_14, c0_.person_id AS person_id_15, c0_.calendar_event_id AS calendar_event_id_16, c0_.image_id AS image_id_17, c0_.selected_author_id AS selected_author_id_18, c0_.curator_id AS curator_id_19, c0_.invoice_id AS invoice_id_20 FROM candidate c0_ INNER JOIN calendar_event c1_ ON c0_.calendar_event_id = c1_.id WHERE c0_.person_id = ? AND c1_.earn_level IS NOT NULL AND c1_.earn_level >= 0 AND c0_.status IN (?) AND c1_.end_date <= ? ORDER BY c1_.start_date DESC LIMIT 1"
  "params" => [
    1 => 820
    2 => "approved"
    3 => "2026-08-16 00:00:00"
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "SELECT c0_.id AS id_0, c0_.status AS status_1, c0_.created_at AS created_at_2, c0_.viewer_comment AS viewer_comment_3, c0_.approved_at AS approved_at_4, c0_.comment AS comment_5, c0_.payment_deferment AS payment_deferment_6, c0_.recommendations AS recommendations_7, c0_.updated_at AS updated_at_8, c0_.review_approve_comment AS review_approve_comment_9, c0_.access_by_receipt AS access_by_receipt_10, c0_.decline_comment AS decline_comment_11, c0_.leaved_at AS leaved_at_12, c0_.registration_type AS registration_type_13, c0_.author_id AS author_id_14, c0_.person_id AS person_id_15, c0_.calendar_event_id AS calendar_event_id_16, c0_.image_id AS image_id_17, c0_.selected_author_id AS selected_author_id_18, c0_.curator_id AS curator_id_19, c0_.invoice_id AS invoice_id_20 FROM candidate c0_ INNER JOIN calendar_event c1_ ON c0_.calendar_event_id = c1_.id WHERE c0_.person_id = ? AND c1_.earn_level IS NOT NULL AND c1_.earn_level >= 0 AND c0_.status IN (?) AND c1_.end_date <= ? ORDER BY c1_.start_date DESC LIMIT 1"
  "params" => [
    1 => 12
    2 => "approved"
    3 => "2026-08-16 00:00:00"
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "SELECT c0_.id AS id_0, c0_.status AS status_1, c0_.created_at AS created_at_2, c0_.viewer_comment AS viewer_comment_3, c0_.approved_at AS approved_at_4, c0_.comment AS comment_5, c0_.payment_deferment AS payment_deferment_6, c0_.recommendations AS recommendations_7, c0_.updated_at AS updated_at_8, c0_.review_approve_comment AS review_approve_comment_9, c0_.access_by_receipt AS access_by_receipt_10, c0_.decline_comment AS decline_comment_11, c0_.leaved_at AS leaved_at_12, c0_.registration_type AS registration_type_13, c0_.author_id AS author_id_14, c0_.person_id AS person_id_15, c0_.calendar_event_id AS calendar_event_id_16, c0_.image_id AS image_id_17, c0_.selected_author_id AS selected_author_id_18, c0_.curator_id AS curator_id_19, c0_.invoice_id AS invoice_id_20 FROM candidate c0_ INNER JOIN calendar_event c1_ ON c0_.calendar_event_id = c1_.id WHERE c0_.person_id = ? AND c1_.earn_level IS NOT NULL AND c1_.earn_level >= 0 AND c0_.status IN (?) AND c1_.end_date <= ? ORDER BY c1_.start_date DESC LIMIT 1"
  "params" => [
    1 => 13
    2 => "approved"
    3 => "2026-08-16 00:00:00"
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "SELECT c0_.id AS id_0, c0_.status AS status_1, c0_.created_at AS created_at_2, c0_.viewer_comment AS viewer_comment_3, c0_.approved_at AS approved_at_4, c0_.comment AS comment_5, c0_.payment_deferment AS payment_deferment_6, c0_.recommendations AS recommendations_7, c0_.updated_at AS updated_at_8, c0_.review_approve_comment AS review_approve_comment_9, c0_.access_by_receipt AS access_by_receipt_10, c0_.decline_comment AS decline_comment_11, c0_.leaved_at AS leaved_at_12, c0_.registration_type AS registration_type_13, c0_.author_id AS author_id_14, c0_.person_id AS person_id_15, c0_.calendar_event_id AS calendar_event_id_16, c0_.image_id AS image_id_17, c0_.selected_author_id AS selected_author_id_18, c0_.curator_id AS curator_id_19, c0_.invoice_id AS invoice_id_20 FROM candidate c0_ INNER JOIN calendar_event c1_ ON c0_.calendar_event_id = c1_.id WHERE c0_.person_id = ? AND c1_.earn_level IS NOT NULL AND c1_.earn_level >= 0 AND c0_.status IN (?) AND c1_.end_date <= ? ORDER BY c1_.start_date DESC LIMIT 1"
  "params" => [
    1 => 821
    2 => "approved"
    3 => "2026-08-16 00:00:00"
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "SELECT c0_.id AS id_0, c0_.status AS status_1, c0_.created_at AS created_at_2, c0_.viewer_comment AS viewer_comment_3, c0_.approved_at AS approved_at_4, c0_.comment AS comment_5, c0_.payment_deferment AS payment_deferment_6, c0_.recommendations AS recommendations_7, c0_.updated_at AS updated_at_8, c0_.review_approve_comment AS review_approve_comment_9, c0_.access_by_receipt AS access_by_receipt_10, c0_.decline_comment AS decline_comment_11, c0_.leaved_at AS leaved_at_12, c0_.registration_type AS registration_type_13, c0_.author_id AS author_id_14, c0_.person_id AS person_id_15, c0_.calendar_event_id AS calendar_event_id_16, c0_.image_id AS image_id_17, c0_.selected_author_id AS selected_author_id_18, c0_.curator_id AS curator_id_19, c0_.invoice_id AS invoice_id_20 FROM candidate c0_ INNER JOIN calendar_event c1_ ON c0_.calendar_event_id = c1_.id WHERE c0_.person_id = ? AND c1_.earn_level IS NOT NULL AND c1_.earn_level >= 0 AND c0_.status IN (?) AND c1_.end_date <= ? ORDER BY c1_.start_date DESC LIMIT 1"
  "params" => [
    1 => 14
    2 => "approved"
    3 => "2026-08-16 00:00:00"
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "SELECT c0_.id AS id_0, c0_.status AS status_1, c0_.created_at AS created_at_2, c0_.viewer_comment AS viewer_comment_3, c0_.approved_at AS approved_at_4, c0_.comment AS comment_5, c0_.payment_deferment AS payment_deferment_6, c0_.recommendations AS recommendations_7, c0_.updated_at AS updated_at_8, c0_.review_approve_comment AS review_approve_comment_9, c0_.access_by_receipt AS access_by_receipt_10, c0_.decline_comment AS decline_comment_11, c0_.leaved_at AS leaved_at_12, c0_.registration_type AS registration_type_13, c0_.author_id AS author_id_14, c0_.person_id AS person_id_15, c0_.calendar_event_id AS calendar_event_id_16, c0_.image_id AS image_id_17, c0_.selected_author_id AS selected_author_id_18, c0_.curator_id AS curator_id_19, c0_.invoice_id AS invoice_id_20 FROM candidate c0_ INNER JOIN calendar_event c1_ ON c0_.calendar_event_id = c1_.id WHERE c0_.person_id = ? AND c1_.earn_level IS NOT NULL AND c1_.earn_level >= 0 AND c0_.status IN (?) AND c1_.end_date <= ? ORDER BY c1_.start_date DESC LIMIT 1"
  "params" => [
    1 => 15
    2 => "approved"
    3 => "2026-08-16 00:00:00"
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "SELECT c0_.id AS id_0, c0_.status AS status_1, c0_.created_at AS created_at_2, c0_.viewer_comment AS viewer_comment_3, c0_.approved_at AS approved_at_4, c0_.comment AS comment_5, c0_.payment_deferment AS payment_deferment_6, c0_.recommendations AS recommendations_7, c0_.updated_at AS updated_at_8, c0_.review_approve_comment AS review_approve_comment_9, c0_.access_by_receipt AS access_by_receipt_10, c0_.decline_comment AS decline_comment_11, c0_.leaved_at AS leaved_at_12, c0_.registration_type AS registration_type_13, c0_.author_id AS author_id_14, c0_.person_id AS person_id_15, c0_.calendar_event_id AS calendar_event_id_16, c0_.image_id AS image_id_17, c0_.selected_author_id AS selected_author_id_18, c0_.curator_id AS curator_id_19, c0_.invoice_id AS invoice_id_20 FROM candidate c0_ INNER JOIN calendar_event c1_ ON c0_.calendar_event_id = c1_.id WHERE c0_.person_id = ? AND c1_.earn_level IS NOT NULL AND c1_.earn_level >= 0 AND c0_.status IN (?) AND c1_.end_date <= ? ORDER BY c1_.start_date DESC LIMIT 1"
  "params" => [
    1 => 16
    2 => "approved"
    3 => "2026-08-16 00:00:00"
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "SELECT c0_.id AS id_0, c0_.status AS status_1, c0_.created_at AS created_at_2, c0_.viewer_comment AS viewer_comment_3, c0_.approved_at AS approved_at_4, c0_.comment AS comment_5, c0_.payment_deferment AS payment_deferment_6, c0_.recommendations AS recommendations_7, c0_.updated_at AS updated_at_8, c0_.review_approve_comment AS review_approve_comment_9, c0_.access_by_receipt AS access_by_receipt_10, c0_.decline_comment AS decline_comment_11, c0_.leaved_at AS leaved_at_12, c0_.registration_type AS registration_type_13, c0_.author_id AS author_id_14, c0_.person_id AS person_id_15, c0_.calendar_event_id AS calendar_event_id_16, c0_.image_id AS image_id_17, c0_.selected_author_id AS selected_author_id_18, c0_.curator_id AS curator_id_19, c0_.invoice_id AS invoice_id_20 FROM candidate c0_ INNER JOIN calendar_event c1_ ON c0_.calendar_event_id = c1_.id WHERE c0_.person_id = ? AND c1_.earn_level IS NOT NULL AND c1_.earn_level >= 0 AND c0_.status IN (?) AND c1_.end_date <= ? ORDER BY c1_.start_date DESC LIMIT 1"
  "params" => [
    1 => 1140
    2 => "approved"
    3 => "2026-08-16 00:00:00"
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "SELECT c0_.id AS id_0, c0_.status AS status_1, c0_.created_at AS created_at_2, c0_.viewer_comment AS viewer_comment_3, c0_.approved_at AS approved_at_4, c0_.comment AS comment_5, c0_.payment_deferment AS payment_deferment_6, c0_.recommendations AS recommendations_7, c0_.updated_at AS updated_at_8, c0_.review_approve_comment AS review_approve_comment_9, c0_.access_by_receipt AS access_by_receipt_10, c0_.decline_comment AS decline_comment_11, c0_.leaved_at AS leaved_at_12, c0_.registration_type AS registration_type_13, c0_.author_id AS author_id_14, c0_.person_id AS person_id_15, c0_.calendar_event_id AS calendar_event_id_16, c0_.image_id AS image_id_17, c0_.selected_author_id AS selected_author_id_18, c0_.curator_id AS curator_id_19, c0_.invoice_id AS invoice_id_20 FROM candidate c0_ INNER JOIN calendar_event c1_ ON c0_.calendar_event_id = c1_.id WHERE c0_.person_id = ? AND c1_.earn_level IS NOT NULL AND c1_.earn_level >= 0 AND c0_.status IN (?) AND c1_.end_date <= ? ORDER BY c1_.start_date DESC LIMIT 1"
  "params" => [
    1 => 823
    2 => "approved"
    3 => "2026-08-16 00:00:00"
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "SELECT c0_.id AS id_0, c0_.status AS status_1, c0_.created_at AS created_at_2, c0_.viewer_comment AS viewer_comment_3, c0_.approved_at AS approved_at_4, c0_.comment AS comment_5, c0_.payment_deferment AS payment_deferment_6, c0_.recommendations AS recommendations_7, c0_.updated_at AS updated_at_8, c0_.review_approve_comment AS review_approve_comment_9, c0_.access_by_receipt AS access_by_receipt_10, c0_.decline_comment AS decline_comment_11, c0_.leaved_at AS leaved_at_12, c0_.registration_type AS registration_type_13, c0_.author_id AS author_id_14, c0_.person_id AS person_id_15, c0_.calendar_event_id AS calendar_event_id_16, c0_.image_id AS image_id_17, c0_.selected_author_id AS selected_author_id_18, c0_.curator_id AS curator_id_19, c0_.invoice_id AS invoice_id_20 FROM candidate c0_ INNER JOIN calendar_event c1_ ON c0_.calendar_event_id = c1_.id WHERE c0_.person_id = ? AND c1_.earn_level IS NOT NULL AND c1_.earn_level >= 0 AND c0_.status IN (?) AND c1_.end_date <= ? ORDER BY c1_.start_date DESC LIMIT 1"
  "params" => [
    1 => 17
    2 => "approved"
    3 => "2026-08-16 00:00:00"
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "SELECT c0_.id AS id_0, c0_.status AS status_1, c0_.created_at AS created_at_2, c0_.viewer_comment AS viewer_comment_3, c0_.approved_at AS approved_at_4, c0_.comment AS comment_5, c0_.payment_deferment AS payment_deferment_6, c0_.recommendations AS recommendations_7, c0_.updated_at AS updated_at_8, c0_.review_approve_comment AS review_approve_comment_9, c0_.access_by_receipt AS access_by_receipt_10, c0_.decline_comment AS decline_comment_11, c0_.leaved_at AS leaved_at_12, c0_.registration_type AS registration_type_13, c0_.author_id AS author_id_14, c0_.person_id AS person_id_15, c0_.calendar_event_id AS calendar_event_id_16, c0_.image_id AS image_id_17, c0_.selected_author_id AS selected_author_id_18, c0_.curator_id AS curator_id_19, c0_.invoice_id AS invoice_id_20 FROM candidate c0_ INNER JOIN calendar_event c1_ ON c0_.calendar_event_id = c1_.id WHERE c0_.person_id = ? AND c1_.earn_level IS NOT NULL AND c1_.earn_level >= 0 AND c0_.status IN (?) AND c1_.end_date <= ? ORDER BY c1_.start_date DESC LIMIT 1"
  "params" => [
    1 => 18
    2 => "approved"
    3 => "2026-08-16 00:00:00"
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "SELECT c0_.id AS id_0, c0_.status AS status_1, c0_.created_at AS created_at_2, c0_.viewer_comment AS viewer_comment_3, c0_.approved_at AS approved_at_4, c0_.comment AS comment_5, c0_.payment_deferment AS payment_deferment_6, c0_.recommendations AS recommendations_7, c0_.updated_at AS updated_at_8, c0_.review_approve_comment AS review_approve_comment_9, c0_.access_by_receipt AS access_by_receipt_10, c0_.decline_comment AS decline_comment_11, c0_.leaved_at AS leaved_at_12, c0_.registration_type AS registration_type_13, c0_.author_id AS author_id_14, c0_.person_id AS person_id_15, c0_.calendar_event_id AS calendar_event_id_16, c0_.image_id AS image_id_17, c0_.selected_author_id AS selected_author_id_18, c0_.curator_id AS curator_id_19, c0_.invoice_id AS invoice_id_20 FROM candidate c0_ INNER JOIN calendar_event c1_ ON c0_.calendar_event_id = c1_.id WHERE c0_.person_id = ? AND c1_.earn_level IS NOT NULL AND c1_.earn_level >= 0 AND c0_.status IN (?) AND c1_.end_date <= ? ORDER BY c1_.start_date DESC LIMIT 1"
  "params" => [
    1 => 824
    2 => "approved"
    3 => "2026-08-16 00:00:00"
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "SELECT c0_.id AS id_0, c0_.status AS status_1, c0_.created_at AS created_at_2, c0_.viewer_comment AS viewer_comment_3, c0_.approved_at AS approved_at_4, c0_.comment AS comment_5, c0_.payment_deferment AS payment_deferment_6, c0_.recommendations AS recommendations_7, c0_.updated_at AS updated_at_8, c0_.review_approve_comment AS review_approve_comment_9, c0_.access_by_receipt AS access_by_receipt_10, c0_.decline_comment AS decline_comment_11, c0_.leaved_at AS leaved_at_12, c0_.registration_type AS registration_type_13, c0_.author_id AS author_id_14, c0_.person_id AS person_id_15, c0_.calendar_event_id AS calendar_event_id_16, c0_.image_id AS image_id_17, c0_.selected_author_id AS selected_author_id_18, c0_.curator_id AS curator_id_19, c0_.invoice_id AS invoice_id_20 FROM candidate c0_ INNER JOIN calendar_event c1_ ON c0_.calendar_event_id = c1_.id WHERE c0_.person_id = ? AND c1_.earn_level IS NOT NULL AND c1_.earn_level >= 0 AND c0_.status IN (?) AND c1_.end_date <= ? ORDER BY c1_.start_date DESC LIMIT 1"
  "params" => [
    1 => 1279
    2 => "approved"
    3 => "2026-08-16 00:00:00"
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "SELECT c0_.id AS id_0, c0_.status AS status_1, c0_.created_at AS created_at_2, c0_.viewer_comment AS viewer_comment_3, c0_.approved_at AS approved_at_4, c0_.comment AS comment_5, c0_.payment_deferment AS payment_deferment_6, c0_.recommendations AS recommendations_7, c0_.updated_at AS updated_at_8, c0_.review_approve_comment AS review_approve_comment_9, c0_.access_by_receipt AS access_by_receipt_10, c0_.decline_comment AS decline_comment_11, c0_.leaved_at AS leaved_at_12, c0_.registration_type AS registration_type_13, c0_.author_id AS author_id_14, c0_.person_id AS person_id_15, c0_.calendar_event_id AS calendar_event_id_16, c0_.image_id AS image_id_17, c0_.selected_author_id AS selected_author_id_18, c0_.curator_id AS curator_id_19, c0_.invoice_id AS invoice_id_20 FROM candidate c0_ INNER JOIN calendar_event c1_ ON c0_.calendar_event_id = c1_.id WHERE c0_.person_id = ? AND c1_.earn_level IS NOT NULL AND c1_.earn_level >= 0 AND c0_.status IN (?) AND c1_.end_date <= ? ORDER BY c1_.start_date DESC LIMIT 1"
  "params" => [
    1 => 825
    2 => "approved"
    3 => "2026-08-16 00:00:00"
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "SELECT c0_.id AS id_0, c0_.status AS status_1, c0_.created_at AS created_at_2, c0_.viewer_comment AS viewer_comment_3, c0_.approved_at AS approved_at_4, c0_.comment AS comment_5, c0_.payment_deferment AS payment_deferment_6, c0_.recommendations AS recommendations_7, c0_.updated_at AS updated_at_8, c0_.review_approve_comment AS review_approve_comment_9, c0_.access_by_receipt AS access_by_receipt_10, c0_.decline_comment AS decline_comment_11, c0_.leaved_at AS leaved_at_12, c0_.registration_type AS registration_type_13, c0_.author_id AS author_id_14, c0_.person_id AS person_id_15, c0_.calendar_event_id AS calendar_event_id_16, c0_.image_id AS image_id_17, c0_.selected_author_id AS selected_author_id_18, c0_.curator_id AS curator_id_19, c0_.invoice_id AS invoice_id_20 FROM candidate c0_ INNER JOIN calendar_event c1_ ON c0_.calendar_event_id = c1_.id WHERE c0_.person_id = ? AND c1_.earn_level IS NOT NULL AND c1_.earn_level >= 0 AND c0_.status IN (?) AND c1_.end_date <= ? ORDER BY c1_.start_date DESC LIMIT 1"
  "params" => [
    1 => 19
    2 => "approved"
    3 => "2026-08-16 00:00:00"
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "SELECT c0_.id AS id_0, c0_.status AS status_1, c0_.created_at AS created_at_2, c0_.viewer_comment AS viewer_comment_3, c0_.approved_at AS approved_at_4, c0_.comment AS comment_5, c0_.payment_deferment AS payment_deferment_6, c0_.recommendations AS recommendations_7, c0_.updated_at AS updated_at_8, c0_.review_approve_comment AS review_approve_comment_9, c0_.access_by_receipt AS access_by_receipt_10, c0_.decline_comment AS decline_comment_11, c0_.leaved_at AS leaved_at_12, c0_.registration_type AS registration_type_13, c0_.author_id AS author_id_14, c0_.person_id AS person_id_15, c0_.calendar_event_id AS calendar_event_id_16, c0_.image_id AS image_id_17, c0_.selected_author_id AS selected_author_id_18, c0_.curator_id AS curator_id_19, c0_.invoice_id AS invoice_id_20 FROM candidate c0_ INNER JOIN calendar_event c1_ ON c0_.calendar_event_id = c1_.id WHERE c0_.person_id = ? AND c1_.earn_level IS NOT NULL AND c1_.earn_level >= 0 AND c0_.status IN (?) AND c1_.end_date <= ? ORDER BY c1_.start_date DESC LIMIT 1"
  "params" => [
    1 => 826
    2 => "approved"
    3 => "2026-08-16 00:00:00"
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "SELECT c0_.id AS id_0, c0_.status AS status_1, c0_.created_at AS created_at_2, c0_.viewer_comment AS viewer_comment_3, c0_.approved_at AS approved_at_4, c0_.comment AS comment_5, c0_.payment_deferment AS payment_deferment_6, c0_.recommendations AS recommendations_7, c0_.updated_at AS updated_at_8, c0_.review_approve_comment AS review_approve_comment_9, c0_.access_by_receipt AS access_by_receipt_10, c0_.decline_comment AS decline_comment_11, c0_.leaved_at AS leaved_at_12, c0_.registration_type AS registration_type_13, c0_.author_id AS author_id_14, c0_.person_id AS person_id_15, c0_.calendar_event_id AS calendar_event_id_16, c0_.image_id AS image_id_17, c0_.selected_author_id AS selected_author_id_18, c0_.curator_id AS curator_id_19, c0_.invoice_id AS invoice_id_20 FROM candidate c0_ INNER JOIN calendar_event c1_ ON c0_.calendar_event_id = c1_.id WHERE c0_.person_id = ? AND c1_.earn_level IS NOT NULL AND c1_.earn_level >= 0 AND c0_.status IN (?) AND c1_.end_date <= ? ORDER BY c1_.start_date DESC LIMIT 1"
  "params" => [
    1 => 827
    2 => "approved"
    3 => "2026-08-16 00:00:00"
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "SELECT c0_.id AS id_0, c0_.status AS status_1, c0_.created_at AS created_at_2, c0_.viewer_comment AS viewer_comment_3, c0_.approved_at AS approved_at_4, c0_.comment AS comment_5, c0_.payment_deferment AS payment_deferment_6, c0_.recommendations AS recommendations_7, c0_.updated_at AS updated_at_8, c0_.review_approve_comment AS review_approve_comment_9, c0_.access_by_receipt AS access_by_receipt_10, c0_.decline_comment AS decline_comment_11, c0_.leaved_at AS leaved_at_12, c0_.registration_type AS registration_type_13, c0_.author_id AS author_id_14, c0_.person_id AS person_id_15, c0_.calendar_event_id AS calendar_event_id_16, c0_.image_id AS image_id_17, c0_.selected_author_id AS selected_author_id_18, c0_.curator_id AS curator_id_19, c0_.invoice_id AS invoice_id_20 FROM candidate c0_ INNER JOIN calendar_event c1_ ON c0_.calendar_event_id = c1_.id WHERE c0_.person_id = ? AND c1_.earn_level IS NOT NULL AND c1_.earn_level >= 0 AND c0_.status IN (?) AND c1_.end_date <= ? ORDER BY c1_.start_date DESC LIMIT 1"
  "params" => [
    1 => 1277
    2 => "approved"
    3 => "2026-08-16 00:00:00"
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "SELECT c0_.id AS id_0, c0_.status AS status_1, c0_.created_at AS created_at_2, c0_.viewer_comment AS viewer_comment_3, c0_.approved_at AS approved_at_4, c0_.comment AS comment_5, c0_.payment_deferment AS payment_deferment_6, c0_.recommendations AS recommendations_7, c0_.updated_at AS updated_at_8, c0_.review_approve_comment AS review_approve_comment_9, c0_.access_by_receipt AS access_by_receipt_10, c0_.decline_comment AS decline_comment_11, c0_.leaved_at AS leaved_at_12, c0_.registration_type AS registration_type_13, c0_.author_id AS author_id_14, c0_.person_id AS person_id_15, c0_.calendar_event_id AS calendar_event_id_16, c0_.image_id AS image_id_17, c0_.selected_author_id AS selected_author_id_18, c0_.curator_id AS curator_id_19, c0_.invoice_id AS invoice_id_20 FROM candidate c0_ INNER JOIN calendar_event c1_ ON c0_.calendar_event_id = c1_.id WHERE c0_.person_id = ? AND c1_.earn_level IS NOT NULL AND c1_.earn_level >= 0 AND c0_.status IN (?) AND c1_.end_date <= ? ORDER BY c1_.start_date DESC LIMIT 1"
  "params" => [
    1 => 1094
    2 => "approved"
    3 => "2026-08-16 00:00:00"
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "SELECT c0_.id AS id_0, c0_.status AS status_1, c0_.created_at AS created_at_2, c0_.viewer_comment AS viewer_comment_3, c0_.approved_at AS approved_at_4, c0_.comment AS comment_5, c0_.payment_deferment AS payment_deferment_6, c0_.recommendations AS recommendations_7, c0_.updated_at AS updated_at_8, c0_.review_approve_comment AS review_approve_comment_9, c0_.access_by_receipt AS access_by_receipt_10, c0_.decline_comment AS decline_comment_11, c0_.leaved_at AS leaved_at_12, c0_.registration_type AS registration_type_13, c0_.author_id AS author_id_14, c0_.person_id AS person_id_15, c0_.calendar_event_id AS calendar_event_id_16, c0_.image_id AS image_id_17, c0_.selected_author_id AS selected_author_id_18, c0_.curator_id AS curator_id_19, c0_.invoice_id AS invoice_id_20 FROM candidate c0_ INNER JOIN calendar_event c1_ ON c0_.calendar_event_id = c1_.id WHERE c0_.person_id = ? AND c1_.earn_level IS NOT NULL AND c1_.earn_level >= 0 AND c0_.status IN (?) AND c1_.end_date <= ? ORDER BY c1_.start_date DESC LIMIT 1"
  "params" => [
    1 => 1152
    2 => "approved"
    3 => "2026-08-16 00:00:00"
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "SELECT c0_.id AS id_0, c0_.status AS status_1, c0_.created_at AS created_at_2, c0_.viewer_comment AS viewer_comment_3, c0_.approved_at AS approved_at_4, c0_.comment AS comment_5, c0_.payment_deferment AS payment_deferment_6, c0_.recommendations AS recommendations_7, c0_.updated_at AS updated_at_8, c0_.review_approve_comment AS review_approve_comment_9, c0_.access_by_receipt AS access_by_receipt_10, c0_.decline_comment AS decline_comment_11, c0_.leaved_at AS leaved_at_12, c0_.registration_type AS registration_type_13, c0_.author_id AS author_id_14, c0_.person_id AS person_id_15, c0_.calendar_event_id AS calendar_event_id_16, c0_.image_id AS image_id_17, c0_.selected_author_id AS selected_author_id_18, c0_.curator_id AS curator_id_19, c0_.invoice_id AS invoice_id_20 FROM candidate c0_ INNER JOIN calendar_event c1_ ON c0_.calendar_event_id = c1_.id WHERE c0_.person_id = ? AND c1_.earn_level IS NOT NULL AND c1_.earn_level >= 0 AND c0_.status IN (?) AND c1_.end_date <= ? ORDER BY c1_.start_date DESC LIMIT 1"
  "params" => [
    1 => 828
    2 => "approved"
    3 => "2026-08-16 00:00:00"
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "SELECT c0_.id AS id_0, c0_.status AS status_1, c0_.created_at AS created_at_2, c0_.viewer_comment AS viewer_comment_3, c0_.approved_at AS approved_at_4, c0_.comment AS comment_5, c0_.payment_deferment AS payment_deferment_6, c0_.recommendations AS recommendations_7, c0_.updated_at AS updated_at_8, c0_.review_approve_comment AS review_approve_comment_9, c0_.access_by_receipt AS access_by_receipt_10, c0_.decline_comment AS decline_comment_11, c0_.leaved_at AS leaved_at_12, c0_.registration_type AS registration_type_13, c0_.author_id AS author_id_14, c0_.person_id AS person_id_15, c0_.calendar_event_id AS calendar_event_id_16, c0_.image_id AS image_id_17, c0_.selected_author_id AS selected_author_id_18, c0_.curator_id AS curator_id_19, c0_.invoice_id AS invoice_id_20 FROM candidate c0_ INNER JOIN calendar_event c1_ ON c0_.calendar_event_id = c1_.id WHERE c0_.person_id = ? AND c1_.earn_level IS NOT NULL AND c1_.earn_level >= 0 AND c0_.status IN (?) AND c1_.end_date <= ? ORDER BY c1_.start_date DESC LIMIT 1"
  "params" => [
    1 => 789
    2 => "approved"
    3 => "2026-08-16 00:00:00"
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "SELECT c0_.id AS id_0, c0_.status AS status_1, c0_.created_at AS created_at_2, c0_.viewer_comment AS viewer_comment_3, c0_.approved_at AS approved_at_4, c0_.comment AS comment_5, c0_.payment_deferment AS payment_deferment_6, c0_.recommendations AS recommendations_7, c0_.updated_at AS updated_at_8, c0_.review_approve_comment AS review_approve_comment_9, c0_.access_by_receipt AS access_by_receipt_10, c0_.decline_comment AS decline_comment_11, c0_.leaved_at AS leaved_at_12, c0_.registration_type AS registration_type_13, c0_.author_id AS author_id_14, c0_.person_id AS person_id_15, c0_.calendar_event_id AS calendar_event_id_16, c0_.image_id AS image_id_17, c0_.selected_author_id AS selected_author_id_18, c0_.curator_id AS curator_id_19, c0_.invoice_id AS invoice_id_20 FROM candidate c0_ INNER JOIN calendar_event c1_ ON c0_.calendar_event_id = c1_.id WHERE c0_.person_id = ? AND c1_.earn_level IS NOT NULL AND c1_.earn_level >= 0 AND c0_.status IN (?) AND c1_.end_date <= ? ORDER BY c1_.start_date DESC LIMIT 1"
  "params" => [
    1 => 1231
    2 => "approved"
    3 => "2026-08-16 00:00:00"
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "SELECT c0_.id AS id_0, c0_.status AS status_1, c0_.created_at AS created_at_2, c0_.viewer_comment AS viewer_comment_3, c0_.approved_at AS approved_at_4, c0_.comment AS comment_5, c0_.payment_deferment AS payment_deferment_6, c0_.recommendations AS recommendations_7, c0_.updated_at AS updated_at_8, c0_.review_approve_comment AS review_approve_comment_9, c0_.access_by_receipt AS access_by_receipt_10, c0_.decline_comment AS decline_comment_11, c0_.leaved_at AS leaved_at_12, c0_.registration_type AS registration_type_13, c0_.author_id AS author_id_14, c0_.person_id AS person_id_15, c0_.calendar_event_id AS calendar_event_id_16, c0_.image_id AS image_id_17, c0_.selected_author_id AS selected_author_id_18, c0_.curator_id AS curator_id_19, c0_.invoice_id AS invoice_id_20 FROM candidate c0_ INNER JOIN calendar_event c1_ ON c0_.calendar_event_id = c1_.id WHERE c0_.person_id = ? AND c1_.earn_level IS NOT NULL AND c1_.earn_level >= 0 AND c0_.status IN (?) AND c1_.end_date <= ? ORDER BY c1_.start_date DESC LIMIT 1"
  "params" => [
    1 => 1317
    2 => "approved"
    3 => "2026-08-16 00:00:00"
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "SELECT c0_.id AS id_0, c0_.status AS status_1, c0_.created_at AS created_at_2, c0_.viewer_comment AS viewer_comment_3, c0_.approved_at AS approved_at_4, c0_.comment AS comment_5, c0_.payment_deferment AS payment_deferment_6, c0_.recommendations AS recommendations_7, c0_.updated_at AS updated_at_8, c0_.review_approve_comment AS review_approve_comment_9, c0_.access_by_receipt AS access_by_receipt_10, c0_.decline_comment AS decline_comment_11, c0_.leaved_at AS leaved_at_12, c0_.registration_type AS registration_type_13, c0_.author_id AS author_id_14, c0_.person_id AS person_id_15, c0_.calendar_event_id AS calendar_event_id_16, c0_.image_id AS image_id_17, c0_.selected_author_id AS selected_author_id_18, c0_.curator_id AS curator_id_19, c0_.invoice_id AS invoice_id_20 FROM candidate c0_ INNER JOIN calendar_event c1_ ON c0_.calendar_event_id = c1_.id WHERE c0_.person_id = ? AND c1_.earn_level IS NOT NULL AND c1_.earn_level >= 0 AND c0_.status IN (?) AND c1_.end_date <= ? ORDER BY c1_.start_date DESC LIMIT 1"
  "params" => [
    1 => 20
    2 => "approved"
    3 => "2026-08-16 00:00:00"
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "SELECT c0_.id AS id_0, c0_.status AS status_1, c0_.created_at AS created_at_2, c0_.viewer_comment AS viewer_comment_3, c0_.approved_at AS approved_at_4, c0_.comment AS comment_5, c0_.payment_deferment AS payment_deferment_6, c0_.recommendations AS recommendations_7, c0_.updated_at AS updated_at_8, c0_.review_approve_comment AS review_approve_comment_9, c0_.access_by_receipt AS access_by_receipt_10, c0_.decline_comment AS decline_comment_11, c0_.leaved_at AS leaved_at_12, c0_.registration_type AS registration_type_13, c0_.author_id AS author_id_14, c0_.person_id AS person_id_15, c0_.calendar_event_id AS calendar_event_id_16, c0_.image_id AS image_id_17, c0_.selected_author_id AS selected_author_id_18, c0_.curator_id AS curator_id_19, c0_.invoice_id AS invoice_id_20 FROM candidate c0_ INNER JOIN calendar_event c1_ ON c0_.calendar_event_id = c1_.id WHERE c0_.person_id = ? AND c1_.earn_level IS NOT NULL AND c1_.earn_level >= 0 AND c0_.status IN (?) AND c1_.end_date <= ? ORDER BY c1_.start_date DESC LIMIT 1"
  "params" => [
    1 => 21
    2 => "approved"
    3 => "2026-08-16 00:00:00"
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "SELECT c0_.id AS id_0, c0_.status AS status_1, c0_.created_at AS created_at_2, c0_.viewer_comment AS viewer_comment_3, c0_.approved_at AS approved_at_4, c0_.comment AS comment_5, c0_.payment_deferment AS payment_deferment_6, c0_.recommendations AS recommendations_7, c0_.updated_at AS updated_at_8, c0_.review_approve_comment AS review_approve_comment_9, c0_.access_by_receipt AS access_by_receipt_10, c0_.decline_comment AS decline_comment_11, c0_.leaved_at AS leaved_at_12, c0_.registration_type AS registration_type_13, c0_.author_id AS author_id_14, c0_.person_id AS person_id_15, c0_.calendar_event_id AS calendar_event_id_16, c0_.image_id AS image_id_17, c0_.selected_author_id AS selected_author_id_18, c0_.curator_id AS curator_id_19, c0_.invoice_id AS invoice_id_20 FROM candidate c0_ INNER JOIN calendar_event c1_ ON c0_.calendar_event_id = c1_.id WHERE c0_.person_id = ? AND c1_.earn_level IS NOT NULL AND c1_.earn_level >= 0 AND c0_.status IN (?) AND c1_.end_date <= ? ORDER BY c1_.start_date DESC LIMIT 1"
  "params" => [
    1 => 22
    2 => "approved"
    3 => "2026-08-16 00:00:00"
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "SELECT c0_.id AS id_0, c0_.status AS status_1, c0_.created_at AS created_at_2, c0_.viewer_comment AS viewer_comment_3, c0_.approved_at AS approved_at_4, c0_.comment AS comment_5, c0_.payment_deferment AS payment_deferment_6, c0_.recommendations AS recommendations_7, c0_.updated_at AS updated_at_8, c0_.review_approve_comment AS review_approve_comment_9, c0_.access_by_receipt AS access_by_receipt_10, c0_.decline_comment AS decline_comment_11, c0_.leaved_at AS leaved_at_12, c0_.registration_type AS registration_type_13, c0_.author_id AS author_id_14, c0_.person_id AS person_id_15, c0_.calendar_event_id AS calendar_event_id_16, c0_.image_id AS image_id_17, c0_.selected_author_id AS selected_author_id_18, c0_.curator_id AS curator_id_19, c0_.invoice_id AS invoice_id_20 FROM candidate c0_ INNER JOIN calendar_event c1_ ON c0_.calendar_event_id = c1_.id WHERE c0_.person_id = ? AND c1_.earn_level IS NOT NULL AND c1_.earn_level >= 0 AND c0_.status IN (?) AND c1_.end_date <= ? ORDER BY c1_.start_date DESC LIMIT 1"
  "params" => [
    1 => 23
    2 => "approved"
    3 => "2026-08-16 00:00:00"
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "SELECT c0_.id AS id_0, c0_.status AS status_1, c0_.created_at AS created_at_2, c0_.viewer_comment AS viewer_comment_3, c0_.approved_at AS approved_at_4, c0_.comment AS comment_5, c0_.payment_deferment AS payment_deferment_6, c0_.recommendations AS recommendations_7, c0_.updated_at AS updated_at_8, c0_.review_approve_comment AS review_approve_comment_9, c0_.access_by_receipt AS access_by_receipt_10, c0_.decline_comment AS decline_comment_11, c0_.leaved_at AS leaved_at_12, c0_.registration_type AS registration_type_13, c0_.author_id AS author_id_14, c0_.person_id AS person_id_15, c0_.calendar_event_id AS calendar_event_id_16, c0_.image_id AS image_id_17, c0_.selected_author_id AS selected_author_id_18, c0_.curator_id AS curator_id_19, c0_.invoice_id AS invoice_id_20 FROM candidate c0_ INNER JOIN calendar_event c1_ ON c0_.calendar_event_id = c1_.id WHERE c0_.person_id = ? AND c1_.earn_level IS NOT NULL AND c1_.earn_level >= 0 AND c0_.status IN (?) AND c1_.end_date <= ? ORDER BY c1_.start_date DESC LIMIT 1"
  "params" => [
    1 => 1340
    2 => "approved"
    3 => "2026-08-16 00:00:00"
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "SELECT c0_.id AS id_0, c0_.status AS status_1, c0_.created_at AS created_at_2, c0_.viewer_comment AS viewer_comment_3, c0_.approved_at AS approved_at_4, c0_.comment AS comment_5, c0_.payment_deferment AS payment_deferment_6, c0_.recommendations AS recommendations_7, c0_.updated_at AS updated_at_8, c0_.review_approve_comment AS review_approve_comment_9, c0_.access_by_receipt AS access_by_receipt_10, c0_.decline_comment AS decline_comment_11, c0_.leaved_at AS leaved_at_12, c0_.registration_type AS registration_type_13, c0_.author_id AS author_id_14, c0_.person_id AS person_id_15, c0_.calendar_event_id AS calendar_event_id_16, c0_.image_id AS image_id_17, c0_.selected_author_id AS selected_author_id_18, c0_.curator_id AS curator_id_19, c0_.invoice_id AS invoice_id_20 FROM candidate c0_ INNER JOIN calendar_event c1_ ON c0_.calendar_event_id = c1_.id WHERE c0_.person_id = ? AND c1_.earn_level IS NOT NULL AND c1_.earn_level >= 0 AND c0_.status IN (?) AND c1_.end_date <= ? ORDER BY c1_.start_date DESC LIMIT 1"
  "params" => [
    1 => 1197
    2 => "approved"
    3 => "2026-08-16 00:00:00"
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "SELECT c0_.id AS id_0, c0_.status AS status_1, c0_.created_at AS created_at_2, c0_.viewer_comment AS viewer_comment_3, c0_.approved_at AS approved_at_4, c0_.comment AS comment_5, c0_.payment_deferment AS payment_deferment_6, c0_.recommendations AS recommendations_7, c0_.updated_at AS updated_at_8, c0_.review_approve_comment AS review_approve_comment_9, c0_.access_by_receipt AS access_by_receipt_10, c0_.decline_comment AS decline_comment_11, c0_.leaved_at AS leaved_at_12, c0_.registration_type AS registration_type_13, c0_.author_id AS author_id_14, c0_.person_id AS person_id_15, c0_.calendar_event_id AS calendar_event_id_16, c0_.image_id AS image_id_17, c0_.selected_author_id AS selected_author_id_18, c0_.curator_id AS curator_id_19, c0_.invoice_id AS invoice_id_20 FROM candidate c0_ INNER JOIN calendar_event c1_ ON c0_.calendar_event_id = c1_.id WHERE c0_.person_id = ? AND c1_.earn_level IS NOT NULL AND c1_.earn_level >= 0 AND c0_.status IN (?) AND c1_.end_date <= ? ORDER BY c1_.start_date DESC LIMIT 1"
  "params" => [
    1 => 1237
    2 => "approved"
    3 => "2026-08-16 00:00:00"
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "SELECT c0_.id AS id_0, c0_.status AS status_1, c0_.created_at AS created_at_2, c0_.viewer_comment AS viewer_comment_3, c0_.approved_at AS approved_at_4, c0_.comment AS comment_5, c0_.payment_deferment AS payment_deferment_6, c0_.recommendations AS recommendations_7, c0_.updated_at AS updated_at_8, c0_.review_approve_comment AS review_approve_comment_9, c0_.access_by_receipt AS access_by_receipt_10, c0_.decline_comment AS decline_comment_11, c0_.leaved_at AS leaved_at_12, c0_.registration_type AS registration_type_13, c0_.author_id AS author_id_14, c0_.person_id AS person_id_15, c0_.calendar_event_id AS calendar_event_id_16, c0_.image_id AS image_id_17, c0_.selected_author_id AS selected_author_id_18, c0_.curator_id AS curator_id_19, c0_.invoice_id AS invoice_id_20 FROM candidate c0_ INNER JOIN calendar_event c1_ ON c0_.calendar_event_id = c1_.id WHERE c0_.person_id = ? AND c1_.earn_level IS NOT NULL AND c1_.earn_level >= 0 AND c0_.status IN (?) AND c1_.end_date <= ? ORDER BY c1_.start_date DESC LIMIT 1"
  "params" => [
    1 => 829
    2 => "approved"
    3 => "2026-08-16 00:00:00"
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "SELECT c0_.id AS id_0, c0_.status AS status_1, c0_.created_at AS created_at_2, c0_.viewer_comment AS viewer_comment_3, c0_.approved_at AS approved_at_4, c0_.comment AS comment_5, c0_.payment_deferment AS payment_deferment_6, c0_.recommendations AS recommendations_7, c0_.updated_at AS updated_at_8, c0_.review_approve_comment AS review_approve_comment_9, c0_.access_by_receipt AS access_by_receipt_10, c0_.decline_comment AS decline_comment_11, c0_.leaved_at AS leaved_at_12, c0_.registration_type AS registration_type_13, c0_.author_id AS author_id_14, c0_.person_id AS person_id_15, c0_.calendar_event_id AS calendar_event_id_16, c0_.image_id AS image_id_17, c0_.selected_author_id AS selected_author_id_18, c0_.curator_id AS curator_id_19, c0_.invoice_id AS invoice_id_20 FROM candidate c0_ INNER JOIN calendar_event c1_ ON c0_.calendar_event_id = c1_.id WHERE c0_.person_id = ? AND c1_.earn_level IS NOT NULL AND c1_.earn_level >= 0 AND c0_.status IN (?) AND c1_.end_date <= ? ORDER BY c1_.start_date DESC LIMIT 1"
  "params" => [
    1 => 24
    2 => "approved"
    3 => "2026-08-16 00:00:00"
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "SELECT c0_.id AS id_0, c0_.status AS status_1, c0_.created_at AS created_at_2, c0_.viewer_comment AS viewer_comment_3, c0_.approved_at AS approved_at_4, c0_.comment AS comment_5, c0_.payment_deferment AS payment_deferment_6, c0_.recommendations AS recommendations_7, c0_.updated_at AS updated_at_8, c0_.review_approve_comment AS review_approve_comment_9, c0_.access_by_receipt AS access_by_receipt_10, c0_.decline_comment AS decline_comment_11, c0_.leaved_at AS leaved_at_12, c0_.registration_type AS registration_type_13, c0_.author_id AS author_id_14, c0_.person_id AS person_id_15, c0_.calendar_event_id AS calendar_event_id_16, c0_.image_id AS image_id_17, c0_.selected_author_id AS selected_author_id_18, c0_.curator_id AS curator_id_19, c0_.invoice_id AS invoice_id_20 FROM candidate c0_ INNER JOIN calendar_event c1_ ON c0_.calendar_event_id = c1_.id WHERE c0_.person_id = ? AND c1_.earn_level IS NOT NULL AND c1_.earn_level >= 0 AND c0_.status IN (?) AND c1_.end_date <= ? ORDER BY c1_.start_date DESC LIMIT 1"
  "params" => [
    1 => 25
    2 => "approved"
    3 => "2026-08-16 00:00:00"
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "SELECT c0_.id AS id_0, c0_.status AS status_1, c0_.created_at AS created_at_2, c0_.viewer_comment AS viewer_comment_3, c0_.approved_at AS approved_at_4, c0_.comment AS comment_5, c0_.payment_deferment AS payment_deferment_6, c0_.recommendations AS recommendations_7, c0_.updated_at AS updated_at_8, c0_.review_approve_comment AS review_approve_comment_9, c0_.access_by_receipt AS access_by_receipt_10, c0_.decline_comment AS decline_comment_11, c0_.leaved_at AS leaved_at_12, c0_.registration_type AS registration_type_13, c0_.author_id AS author_id_14, c0_.person_id AS person_id_15, c0_.calendar_event_id AS calendar_event_id_16, c0_.image_id AS image_id_17, c0_.selected_author_id AS selected_author_id_18, c0_.curator_id AS curator_id_19, c0_.invoice_id AS invoice_id_20 FROM candidate c0_ INNER JOIN calendar_event c1_ ON c0_.calendar_event_id = c1_.id WHERE c0_.person_id = ? AND c1_.earn_level IS NOT NULL AND c1_.earn_level >= 0 AND c0_.status IN (?) AND c1_.end_date <= ? ORDER BY c1_.start_date DESC LIMIT 1"
  "params" => [
    1 => 26
    2 => "approved"
    3 => "2026-08-16 00:00:00"
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "SELECT c0_.id AS id_0, c0_.status AS status_1, c0_.created_at AS created_at_2, c0_.viewer_comment AS viewer_comment_3, c0_.approved_at AS approved_at_4, c0_.comment AS comment_5, c0_.payment_deferment AS payment_deferment_6, c0_.recommendations AS recommendations_7, c0_.updated_at AS updated_at_8, c0_.review_approve_comment AS review_approve_comment_9, c0_.access_by_receipt AS access_by_receipt_10, c0_.decline_comment AS decline_comment_11, c0_.leaved_at AS leaved_at_12, c0_.registration_type AS registration_type_13, c0_.author_id AS author_id_14, c0_.person_id AS person_id_15, c0_.calendar_event_id AS calendar_event_id_16, c0_.image_id AS image_id_17, c0_.selected_author_id AS selected_author_id_18, c0_.curator_id AS curator_id_19, c0_.invoice_id AS invoice_id_20 FROM candidate c0_ INNER JOIN calendar_event c1_ ON c0_.calendar_event_id = c1_.id WHERE c0_.person_id = ? AND c1_.earn_level IS NOT NULL AND c1_.earn_level >= 0 AND c0_.status IN (?) AND c1_.end_date <= ? ORDER BY c1_.start_date DESC LIMIT 1"
  "params" => [
    1 => 27
    2 => "approved"
    3 => "2026-08-16 00:00:00"
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "SELECT c0_.id AS id_0, c0_.status AS status_1, c0_.created_at AS created_at_2, c0_.viewer_comment AS viewer_comment_3, c0_.approved_at AS approved_at_4, c0_.comment AS comment_5, c0_.payment_deferment AS payment_deferment_6, c0_.recommendations AS recommendations_7, c0_.updated_at AS updated_at_8, c0_.review_approve_comment AS review_approve_comment_9, c0_.access_by_receipt AS access_by_receipt_10, c0_.decline_comment AS decline_comment_11, c0_.leaved_at AS leaved_at_12, c0_.registration_type AS registration_type_13, c0_.author_id AS author_id_14, c0_.person_id AS person_id_15, c0_.calendar_event_id AS calendar_event_id_16, c0_.image_id AS image_id_17, c0_.selected_author_id AS selected_author_id_18, c0_.curator_id AS curator_id_19, c0_.invoice_id AS invoice_id_20 FROM candidate c0_ INNER JOIN calendar_event c1_ ON c0_.calendar_event_id = c1_.id WHERE c0_.person_id = ? AND c1_.earn_level IS NOT NULL AND c1_.earn_level >= 0 AND c0_.status IN (?) AND c1_.end_date <= ? ORDER BY c1_.start_date DESC LIMIT 1"
  "params" => [
    1 => 28
    2 => "approved"
    3 => "2026-08-16 00:00:00"
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "SELECT c0_.id AS id_0, c0_.status AS status_1, c0_.created_at AS created_at_2, c0_.viewer_comment AS viewer_comment_3, c0_.approved_at AS approved_at_4, c0_.comment AS comment_5, c0_.payment_deferment AS payment_deferment_6, c0_.recommendations AS recommendations_7, c0_.updated_at AS updated_at_8, c0_.review_approve_comment AS review_approve_comment_9, c0_.access_by_receipt AS access_by_receipt_10, c0_.decline_comment AS decline_comment_11, c0_.leaved_at AS leaved_at_12, c0_.registration_type AS registration_type_13, c0_.author_id AS author_id_14, c0_.person_id AS person_id_15, c0_.calendar_event_id AS calendar_event_id_16, c0_.image_id AS image_id_17, c0_.selected_author_id AS selected_author_id_18, c0_.curator_id AS curator_id_19, c0_.invoice_id AS invoice_id_20 FROM candidate c0_ INNER JOIN calendar_event c1_ ON c0_.calendar_event_id = c1_.id WHERE c0_.person_id = ? AND c1_.earn_level IS NOT NULL AND c1_.earn_level >= 0 AND c0_.status IN (?) AND c1_.end_date <= ? ORDER BY c1_.start_date DESC LIMIT 1"
  "params" => [
    1 => 29
    2 => "approved"
    3 => "2026-08-16 00:00:00"
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "SELECT c0_.id AS id_0, c0_.status AS status_1, c0_.created_at AS created_at_2, c0_.viewer_comment AS viewer_comment_3, c0_.approved_at AS approved_at_4, c0_.comment AS comment_5, c0_.payment_deferment AS payment_deferment_6, c0_.recommendations AS recommendations_7, c0_.updated_at AS updated_at_8, c0_.review_approve_comment AS review_approve_comment_9, c0_.access_by_receipt AS access_by_receipt_10, c0_.decline_comment AS decline_comment_11, c0_.leaved_at AS leaved_at_12, c0_.registration_type AS registration_type_13, c0_.author_id AS author_id_14, c0_.person_id AS person_id_15, c0_.calendar_event_id AS calendar_event_id_16, c0_.image_id AS image_id_17, c0_.selected_author_id AS selected_author_id_18, c0_.curator_id AS curator_id_19, c0_.invoice_id AS invoice_id_20 FROM candidate c0_ INNER JOIN calendar_event c1_ ON c0_.calendar_event_id = c1_.id WHERE c0_.person_id = ? AND c1_.earn_level IS NOT NULL AND c1_.earn_level >= 0 AND c0_.status IN (?) AND c1_.end_date <= ? ORDER BY c1_.start_date DESC LIMIT 1"
  "params" => [
    1 => 830
    2 => "approved"
    3 => "2026-08-16 00:00:00"
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "SELECT c0_.id AS id_0, c0_.status AS status_1, c0_.created_at AS created_at_2, c0_.viewer_comment AS viewer_comment_3, c0_.approved_at AS approved_at_4, c0_.comment AS comment_5, c0_.payment_deferment AS payment_deferment_6, c0_.recommendations AS recommendations_7, c0_.updated_at AS updated_at_8, c0_.review_approve_comment AS review_approve_comment_9, c0_.access_by_receipt AS access_by_receipt_10, c0_.decline_comment AS decline_comment_11, c0_.leaved_at AS leaved_at_12, c0_.registration_type AS registration_type_13, c0_.author_id AS author_id_14, c0_.person_id AS person_id_15, c0_.calendar_event_id AS calendar_event_id_16, c0_.image_id AS image_id_17, c0_.selected_author_id AS selected_author_id_18, c0_.curator_id AS curator_id_19, c0_.invoice_id AS invoice_id_20 FROM candidate c0_ INNER JOIN calendar_event c1_ ON c0_.calendar_event_id = c1_.id WHERE c0_.person_id = ? AND c1_.earn_level IS NOT NULL AND c1_.earn_level >= 0 AND c0_.status IN (?) AND c1_.end_date <= ? ORDER BY c1_.start_date DESC LIMIT 1"
  "params" => [
    1 => 30
    2 => "approved"
    3 => "2026-08-16 00:00:00"
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "SELECT c0_.id AS id_0, c0_.status AS status_1, c0_.created_at AS created_at_2, c0_.viewer_comment AS viewer_comment_3, c0_.approved_at AS approved_at_4, c0_.comment AS comment_5, c0_.payment_deferment AS payment_deferment_6, c0_.recommendations AS recommendations_7, c0_.updated_at AS updated_at_8, c0_.review_approve_comment AS review_approve_comment_9, c0_.access_by_receipt AS access_by_receipt_10, c0_.decline_comment AS decline_comment_11, c0_.leaved_at AS leaved_at_12, c0_.registration_type AS registration_type_13, c0_.author_id AS author_id_14, c0_.person_id AS person_id_15, c0_.calendar_event_id AS calendar_event_id_16, c0_.image_id AS image_id_17, c0_.selected_author_id AS selected_author_id_18, c0_.curator_id AS curator_id_19, c0_.invoice_id AS invoice_id_20 FROM candidate c0_ INNER JOIN calendar_event c1_ ON c0_.calendar_event_id = c1_.id WHERE c0_.person_id = ? AND c1_.earn_level IS NOT NULL AND c1_.earn_level >= 0 AND c0_.status IN (?) AND c1_.end_date <= ? ORDER BY c1_.start_date DESC LIMIT 1"
  "params" => [
    1 => 1272
    2 => "approved"
    3 => "2026-08-16 00:00:00"
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "SELECT c0_.id AS id_0, c0_.status AS status_1, c0_.created_at AS created_at_2, c0_.viewer_comment AS viewer_comment_3, c0_.approved_at AS approved_at_4, c0_.comment AS comment_5, c0_.payment_deferment AS payment_deferment_6, c0_.recommendations AS recommendations_7, c0_.updated_at AS updated_at_8, c0_.review_approve_comment AS review_approve_comment_9, c0_.access_by_receipt AS access_by_receipt_10, c0_.decline_comment AS decline_comment_11, c0_.leaved_at AS leaved_at_12, c0_.registration_type AS registration_type_13, c0_.author_id AS author_id_14, c0_.person_id AS person_id_15, c0_.calendar_event_id AS calendar_event_id_16, c0_.image_id AS image_id_17, c0_.selected_author_id AS selected_author_id_18, c0_.curator_id AS curator_id_19, c0_.invoice_id AS invoice_id_20 FROM candidate c0_ INNER JOIN calendar_event c1_ ON c0_.calendar_event_id = c1_.id WHERE c0_.person_id = ? AND c1_.earn_level IS NOT NULL AND c1_.earn_level >= 0 AND c0_.status IN (?) AND c1_.end_date <= ? ORDER BY c1_.start_date DESC LIMIT 1"
  "params" => [
    1 => 31
    2 => "approved"
    3 => "2026-08-16 00:00:00"
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "SELECT c0_.id AS id_0, c0_.status AS status_1, c0_.created_at AS created_at_2, c0_.viewer_comment AS viewer_comment_3, c0_.approved_at AS approved_at_4, c0_.comment AS comment_5, c0_.payment_deferment AS payment_deferment_6, c0_.recommendations AS recommendations_7, c0_.updated_at AS updated_at_8, c0_.review_approve_comment AS review_approve_comment_9, c0_.access_by_receipt AS access_by_receipt_10, c0_.decline_comment AS decline_comment_11, c0_.leaved_at AS leaved_at_12, c0_.registration_type AS registration_type_13, c0_.author_id AS author_id_14, c0_.person_id AS person_id_15, c0_.calendar_event_id AS calendar_event_id_16, c0_.image_id AS image_id_17, c0_.selected_author_id AS selected_author_id_18, c0_.curator_id AS curator_id_19, c0_.invoice_id AS invoice_id_20 FROM candidate c0_ INNER JOIN calendar_event c1_ ON c0_.calendar_event_id = c1_.id WHERE c0_.person_id = ? AND c1_.earn_level IS NOT NULL AND c1_.earn_level >= 0 AND c0_.status IN (?) AND c1_.end_date <= ? ORDER BY c1_.start_date DESC LIMIT 1"
  "params" => [
    1 => 1333
    2 => "approved"
    3 => "2026-08-16 00:00:00"
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "SELECT c0_.id AS id_0, c0_.status AS status_1, c0_.created_at AS created_at_2, c0_.viewer_comment AS viewer_comment_3, c0_.approved_at AS approved_at_4, c0_.comment AS comment_5, c0_.payment_deferment AS payment_deferment_6, c0_.recommendations AS recommendations_7, c0_.updated_at AS updated_at_8, c0_.review_approve_comment AS review_approve_comment_9, c0_.access_by_receipt AS access_by_receipt_10, c0_.decline_comment AS decline_comment_11, c0_.leaved_at AS leaved_at_12, c0_.registration_type AS registration_type_13, c0_.author_id AS author_id_14, c0_.person_id AS person_id_15, c0_.calendar_event_id AS calendar_event_id_16, c0_.image_id AS image_id_17, c0_.selected_author_id AS selected_author_id_18, c0_.curator_id AS curator_id_19, c0_.invoice_id AS invoice_id_20 FROM candidate c0_ INNER JOIN calendar_event c1_ ON c0_.calendar_event_id = c1_.id WHERE c0_.person_id = ? AND c1_.earn_level IS NOT NULL AND c1_.earn_level >= 0 AND c0_.status IN (?) AND c1_.end_date <= ? ORDER BY c1_.start_date DESC LIMIT 1"
  "params" => [
    1 => 32
    2 => "approved"
    3 => "2026-08-16 00:00:00"
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "SELECT c0_.id AS id_0, c0_.status AS status_1, c0_.created_at AS created_at_2, c0_.viewer_comment AS viewer_comment_3, c0_.approved_at AS approved_at_4, c0_.comment AS comment_5, c0_.payment_deferment AS payment_deferment_6, c0_.recommendations AS recommendations_7, c0_.updated_at AS updated_at_8, c0_.review_approve_comment AS review_approve_comment_9, c0_.access_by_receipt AS access_by_receipt_10, c0_.decline_comment AS decline_comment_11, c0_.leaved_at AS leaved_at_12, c0_.registration_type AS registration_type_13, c0_.author_id AS author_id_14, c0_.person_id AS person_id_15, c0_.calendar_event_id AS calendar_event_id_16, c0_.image_id AS image_id_17, c0_.selected_author_id AS selected_author_id_18, c0_.curator_id AS curator_id_19, c0_.invoice_id AS invoice_id_20 FROM candidate c0_ INNER JOIN calendar_event c1_ ON c0_.calendar_event_id = c1_.id WHERE c0_.person_id = ? AND c1_.earn_level IS NOT NULL AND c1_.earn_level >= 0 AND c0_.status IN (?) AND c1_.end_date <= ? ORDER BY c1_.start_date DESC LIMIT 1"
  "params" => [
    1 => 33
    2 => "approved"
    3 => "2026-08-16 00:00:00"
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "SELECT c0_.id AS id_0, c0_.status AS status_1, c0_.created_at AS created_at_2, c0_.viewer_comment AS viewer_comment_3, c0_.approved_at AS approved_at_4, c0_.comment AS comment_5, c0_.payment_deferment AS payment_deferment_6, c0_.recommendations AS recommendations_7, c0_.updated_at AS updated_at_8, c0_.review_approve_comment AS review_approve_comment_9, c0_.access_by_receipt AS access_by_receipt_10, c0_.decline_comment AS decline_comment_11, c0_.leaved_at AS leaved_at_12, c0_.registration_type AS registration_type_13, c0_.author_id AS author_id_14, c0_.person_id AS person_id_15, c0_.calendar_event_id AS calendar_event_id_16, c0_.image_id AS image_id_17, c0_.selected_author_id AS selected_author_id_18, c0_.curator_id AS curator_id_19, c0_.invoice_id AS invoice_id_20 FROM candidate c0_ INNER JOIN calendar_event c1_ ON c0_.calendar_event_id = c1_.id WHERE c0_.person_id = ? AND c1_.earn_level IS NOT NULL AND c1_.earn_level >= 0 AND c0_.status IN (?) AND c1_.end_date <= ? ORDER BY c1_.start_date DESC LIMIT 1"
  "params" => [
    1 => 34
    2 => "approved"
    3 => "2026-08-16 00:00:00"
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "SELECT c0_.id AS id_0, c0_.status AS status_1, c0_.created_at AS created_at_2, c0_.viewer_comment AS viewer_comment_3, c0_.approved_at AS approved_at_4, c0_.comment AS comment_5, c0_.payment_deferment AS payment_deferment_6, c0_.recommendations AS recommendations_7, c0_.updated_at AS updated_at_8, c0_.review_approve_comment AS review_approve_comment_9, c0_.access_by_receipt AS access_by_receipt_10, c0_.decline_comment AS decline_comment_11, c0_.leaved_at AS leaved_at_12, c0_.registration_type AS registration_type_13, c0_.author_id AS author_id_14, c0_.person_id AS person_id_15, c0_.calendar_event_id AS calendar_event_id_16, c0_.image_id AS image_id_17, c0_.selected_author_id AS selected_author_id_18, c0_.curator_id AS curator_id_19, c0_.invoice_id AS invoice_id_20 FROM candidate c0_ INNER JOIN calendar_event c1_ ON c0_.calendar_event_id = c1_.id WHERE c0_.person_id = ? AND c1_.earn_level IS NOT NULL AND c1_.earn_level >= 0 AND c0_.status IN (?) AND c1_.end_date <= ? ORDER BY c1_.start_date DESC LIMIT 1"
  "params" => [
    1 => 35
    2 => "approved"
    3 => "2026-08-16 00:00:00"
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "SELECT c0_.id AS id_0, c0_.status AS status_1, c0_.created_at AS created_at_2, c0_.viewer_comment AS viewer_comment_3, c0_.approved_at AS approved_at_4, c0_.comment AS comment_5, c0_.payment_deferment AS payment_deferment_6, c0_.recommendations AS recommendations_7, c0_.updated_at AS updated_at_8, c0_.review_approve_comment AS review_approve_comment_9, c0_.access_by_receipt AS access_by_receipt_10, c0_.decline_comment AS decline_comment_11, c0_.leaved_at AS leaved_at_12, c0_.registration_type AS registration_type_13, c0_.author_id AS author_id_14, c0_.person_id AS person_id_15, c0_.calendar_event_id AS calendar_event_id_16, c0_.image_id AS image_id_17, c0_.selected_author_id AS selected_author_id_18, c0_.curator_id AS curator_id_19, c0_.invoice_id AS invoice_id_20 FROM candidate c0_ INNER JOIN calendar_event c1_ ON c0_.calendar_event_id = c1_.id WHERE c0_.person_id = ? AND c1_.earn_level IS NOT NULL AND c1_.earn_level >= 0 AND c0_.status IN (?) AND c1_.end_date <= ? ORDER BY c1_.start_date DESC LIMIT 1"
  "params" => [
    1 => 831
    2 => "approved"
    3 => "2026-08-16 00:00:00"
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "SELECT c0_.id AS id_0, c0_.status AS status_1, c0_.created_at AS created_at_2, c0_.viewer_comment AS viewer_comment_3, c0_.approved_at AS approved_at_4, c0_.comment AS comment_5, c0_.payment_deferment AS payment_deferment_6, c0_.recommendations AS recommendations_7, c0_.updated_at AS updated_at_8, c0_.review_approve_comment AS review_approve_comment_9, c0_.access_by_receipt AS access_by_receipt_10, c0_.decline_comment AS decline_comment_11, c0_.leaved_at AS leaved_at_12, c0_.registration_type AS registration_type_13, c0_.author_id AS author_id_14, c0_.person_id AS person_id_15, c0_.calendar_event_id AS calendar_event_id_16, c0_.image_id AS image_id_17, c0_.selected_author_id AS selected_author_id_18, c0_.curator_id AS curator_id_19, c0_.invoice_id AS invoice_id_20 FROM candidate c0_ INNER JOIN calendar_event c1_ ON c0_.calendar_event_id = c1_.id WHERE c0_.person_id = ? AND c1_.earn_level IS NOT NULL AND c1_.earn_level >= 0 AND c0_.status IN (?) AND c1_.end_date <= ? ORDER BY c1_.start_date DESC LIMIT 1"
  "params" => [
    1 => 36
    2 => "approved"
    3 => "2026-08-16 00:00:00"
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "SELECT c0_.id AS id_0, c0_.status AS status_1, c0_.created_at AS created_at_2, c0_.viewer_comment AS viewer_comment_3, c0_.approved_at AS approved_at_4, c0_.comment AS comment_5, c0_.payment_deferment AS payment_deferment_6, c0_.recommendations AS recommendations_7, c0_.updated_at AS updated_at_8, c0_.review_approve_comment AS review_approve_comment_9, c0_.access_by_receipt AS access_by_receipt_10, c0_.decline_comment AS decline_comment_11, c0_.leaved_at AS leaved_at_12, c0_.registration_type AS registration_type_13, c0_.author_id AS author_id_14, c0_.person_id AS person_id_15, c0_.calendar_event_id AS calendar_event_id_16, c0_.image_id AS image_id_17, c0_.selected_author_id AS selected_author_id_18, c0_.curator_id AS curator_id_19, c0_.invoice_id AS invoice_id_20 FROM candidate c0_ INNER JOIN calendar_event c1_ ON c0_.calendar_event_id = c1_.id WHERE c0_.person_id = ? AND c1_.earn_level IS NOT NULL AND c1_.earn_level >= 0 AND c0_.status IN (?) AND c1_.end_date <= ? ORDER BY c1_.start_date DESC LIMIT 1"
  "params" => [
    1 => 37
    2 => "approved"
    3 => "2026-08-16 00:00:00"
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "SELECT c0_.id AS id_0, c0_.status AS status_1, c0_.created_at AS created_at_2, c0_.viewer_comment AS viewer_comment_3, c0_.approved_at AS approved_at_4, c0_.comment AS comment_5, c0_.payment_deferment AS payment_deferment_6, c0_.recommendations AS recommendations_7, c0_.updated_at AS updated_at_8, c0_.review_approve_comment AS review_approve_comment_9, c0_.access_by_receipt AS access_by_receipt_10, c0_.decline_comment AS decline_comment_11, c0_.leaved_at AS leaved_at_12, c0_.registration_type AS registration_type_13, c0_.author_id AS author_id_14, c0_.person_id AS person_id_15, c0_.calendar_event_id AS calendar_event_id_16, c0_.image_id AS image_id_17, c0_.selected_author_id AS selected_author_id_18, c0_.curator_id AS curator_id_19, c0_.invoice_id AS invoice_id_20 FROM candidate c0_ INNER JOIN calendar_event c1_ ON c0_.calendar_event_id = c1_.id WHERE c0_.person_id = ? AND c1_.earn_level IS NOT NULL AND c1_.earn_level >= 0 AND c0_.status IN (?) AND c1_.end_date <= ? ORDER BY c1_.start_date DESC LIMIT 1"
  "params" => [
    1 => 832
    2 => "approved"
    3 => "2026-08-16 00:00:00"
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "SELECT c0_.id AS id_0, c0_.status AS status_1, c0_.created_at AS created_at_2, c0_.viewer_comment AS viewer_comment_3, c0_.approved_at AS approved_at_4, c0_.comment AS comment_5, c0_.payment_deferment AS payment_deferment_6, c0_.recommendations AS recommendations_7, c0_.updated_at AS updated_at_8, c0_.review_approve_comment AS review_approve_comment_9, c0_.access_by_receipt AS access_by_receipt_10, c0_.decline_comment AS decline_comment_11, c0_.leaved_at AS leaved_at_12, c0_.registration_type AS registration_type_13, c0_.author_id AS author_id_14, c0_.person_id AS person_id_15, c0_.calendar_event_id AS calendar_event_id_16, c0_.image_id AS image_id_17, c0_.selected_author_id AS selected_author_id_18, c0_.curator_id AS curator_id_19, c0_.invoice_id AS invoice_id_20 FROM candidate c0_ INNER JOIN calendar_event c1_ ON c0_.calendar_event_id = c1_.id WHERE c0_.person_id = ? AND c1_.earn_level IS NOT NULL AND c1_.earn_level >= 0 AND c0_.status IN (?) AND c1_.end_date <= ? ORDER BY c1_.start_date DESC LIMIT 1"
  "params" => [
    1 => 1219
    2 => "approved"
    3 => "2026-08-16 00:00:00"
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "SELECT c0_.id AS id_0, c0_.status AS status_1, c0_.created_at AS created_at_2, c0_.viewer_comment AS viewer_comment_3, c0_.approved_at AS approved_at_4, c0_.comment AS comment_5, c0_.payment_deferment AS payment_deferment_6, c0_.recommendations AS recommendations_7, c0_.updated_at AS updated_at_8, c0_.review_approve_comment AS review_approve_comment_9, c0_.access_by_receipt AS access_by_receipt_10, c0_.decline_comment AS decline_comment_11, c0_.leaved_at AS leaved_at_12, c0_.registration_type AS registration_type_13, c0_.author_id AS author_id_14, c0_.person_id AS person_id_15, c0_.calendar_event_id AS calendar_event_id_16, c0_.image_id AS image_id_17, c0_.selected_author_id AS selected_author_id_18, c0_.curator_id AS curator_id_19, c0_.invoice_id AS invoice_id_20 FROM candidate c0_ INNER JOIN calendar_event c1_ ON c0_.calendar_event_id = c1_.id WHERE c0_.person_id = ? AND c1_.earn_level IS NOT NULL AND c1_.earn_level >= 0 AND c0_.status IN (?) AND c1_.end_date <= ? ORDER BY c1_.start_date DESC LIMIT 1"
  "params" => [
    1 => 1189
    2 => "approved"
    3 => "2026-08-16 00:00:00"
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "SELECT c0_.id AS id_0, c0_.status AS status_1, c0_.created_at AS created_at_2, c0_.viewer_comment AS viewer_comment_3, c0_.approved_at AS approved_at_4, c0_.comment AS comment_5, c0_.payment_deferment AS payment_deferment_6, c0_.recommendations AS recommendations_7, c0_.updated_at AS updated_at_8, c0_.review_approve_comment AS review_approve_comment_9, c0_.access_by_receipt AS access_by_receipt_10, c0_.decline_comment AS decline_comment_11, c0_.leaved_at AS leaved_at_12, c0_.registration_type AS registration_type_13, c0_.author_id AS author_id_14, c0_.person_id AS person_id_15, c0_.calendar_event_id AS calendar_event_id_16, c0_.image_id AS image_id_17, c0_.selected_author_id AS selected_author_id_18, c0_.curator_id AS curator_id_19, c0_.invoice_id AS invoice_id_20 FROM candidate c0_ INNER JOIN calendar_event c1_ ON c0_.calendar_event_id = c1_.id WHERE c0_.person_id = ? AND c1_.earn_level IS NOT NULL AND c1_.earn_level >= 0 AND c0_.status IN (?) AND c1_.end_date <= ? ORDER BY c1_.start_date DESC LIMIT 1"
  "params" => [
    1 => 38
    2 => "approved"
    3 => "2026-08-16 00:00:00"
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "SELECT c0_.id AS id_0, c0_.status AS status_1, c0_.created_at AS created_at_2, c0_.viewer_comment AS viewer_comment_3, c0_.approved_at AS approved_at_4, c0_.comment AS comment_5, c0_.payment_deferment AS payment_deferment_6, c0_.recommendations AS recommendations_7, c0_.updated_at AS updated_at_8, c0_.review_approve_comment AS review_approve_comment_9, c0_.access_by_receipt AS access_by_receipt_10, c0_.decline_comment AS decline_comment_11, c0_.leaved_at AS leaved_at_12, c0_.registration_type AS registration_type_13, c0_.author_id AS author_id_14, c0_.person_id AS person_id_15, c0_.calendar_event_id AS calendar_event_id_16, c0_.image_id AS image_id_17, c0_.selected_author_id AS selected_author_id_18, c0_.curator_id AS curator_id_19, c0_.invoice_id AS invoice_id_20 FROM candidate c0_ INNER JOIN calendar_event c1_ ON c0_.calendar_event_id = c1_.id WHERE c0_.person_id = ? AND c1_.earn_level IS NOT NULL AND c1_.earn_level >= 0 AND c0_.status IN (?) AND c1_.end_date <= ? ORDER BY c1_.start_date DESC LIMIT 1"
  "params" => [
    1 => 39
    2 => "approved"
    3 => "2026-08-16 00:00:00"
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "SELECT c0_.id AS id_0, c0_.status AS status_1, c0_.created_at AS created_at_2, c0_.viewer_comment AS viewer_comment_3, c0_.approved_at AS approved_at_4, c0_.comment AS comment_5, c0_.payment_deferment AS payment_deferment_6, c0_.recommendations AS recommendations_7, c0_.updated_at AS updated_at_8, c0_.review_approve_comment AS review_approve_comment_9, c0_.access_by_receipt AS access_by_receipt_10, c0_.decline_comment AS decline_comment_11, c0_.leaved_at AS leaved_at_12, c0_.registration_type AS registration_type_13, c0_.author_id AS author_id_14, c0_.person_id AS person_id_15, c0_.calendar_event_id AS calendar_event_id_16, c0_.image_id AS image_id_17, c0_.selected_author_id AS selected_author_id_18, c0_.curator_id AS curator_id_19, c0_.invoice_id AS invoice_id_20 FROM candidate c0_ INNER JOIN calendar_event c1_ ON c0_.calendar_event_id = c1_.id WHERE c0_.person_id = ? AND c1_.earn_level IS NOT NULL AND c1_.earn_level >= 0 AND c0_.status IN (?) AND c1_.end_date <= ? ORDER BY c1_.start_date DESC LIMIT 1"
  "params" => [
    1 => 40
    2 => "approved"
    3 => "2026-08-16 00:00:00"
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "SELECT c0_.id AS id_0, c0_.status AS status_1, c0_.created_at AS created_at_2, c0_.viewer_comment AS viewer_comment_3, c0_.approved_at AS approved_at_4, c0_.comment AS comment_5, c0_.payment_deferment AS payment_deferment_6, c0_.recommendations AS recommendations_7, c0_.updated_at AS updated_at_8, c0_.review_approve_comment AS review_approve_comment_9, c0_.access_by_receipt AS access_by_receipt_10, c0_.decline_comment AS decline_comment_11, c0_.leaved_at AS leaved_at_12, c0_.registration_type AS registration_type_13, c0_.author_id AS author_id_14, c0_.person_id AS person_id_15, c0_.calendar_event_id AS calendar_event_id_16, c0_.image_id AS image_id_17, c0_.selected_author_id AS selected_author_id_18, c0_.curator_id AS curator_id_19, c0_.invoice_id AS invoice_id_20 FROM candidate c0_ INNER JOIN calendar_event c1_ ON c0_.calendar_event_id = c1_.id WHERE c0_.person_id = ? AND c1_.earn_level IS NOT NULL AND c1_.earn_level >= 0 AND c0_.status IN (?) AND c1_.end_date <= ? ORDER BY c1_.start_date DESC LIMIT 1"
  "params" => [
    1 => 41
    2 => "approved"
    3 => "2026-08-16 00:00:00"
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "SELECT c0_.id AS id_0, c0_.status AS status_1, c0_.created_at AS created_at_2, c0_.viewer_comment AS viewer_comment_3, c0_.approved_at AS approved_at_4, c0_.comment AS comment_5, c0_.payment_deferment AS payment_deferment_6, c0_.recommendations AS recommendations_7, c0_.updated_at AS updated_at_8, c0_.review_approve_comment AS review_approve_comment_9, c0_.access_by_receipt AS access_by_receipt_10, c0_.decline_comment AS decline_comment_11, c0_.leaved_at AS leaved_at_12, c0_.registration_type AS registration_type_13, c0_.author_id AS author_id_14, c0_.person_id AS person_id_15, c0_.calendar_event_id AS calendar_event_id_16, c0_.image_id AS image_id_17, c0_.selected_author_id AS selected_author_id_18, c0_.curator_id AS curator_id_19, c0_.invoice_id AS invoice_id_20 FROM candidate c0_ INNER JOIN calendar_event c1_ ON c0_.calendar_event_id = c1_.id WHERE c0_.person_id = ? AND c1_.earn_level IS NOT NULL AND c1_.earn_level >= 0 AND c0_.status IN (?) AND c1_.end_date <= ? ORDER BY c1_.start_date DESC LIMIT 1"
  "params" => [
    1 => 42
    2 => "approved"
    3 => "2026-08-16 00:00:00"
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "SELECT c0_.id AS id_0, c0_.status AS status_1, c0_.created_at AS created_at_2, c0_.viewer_comment AS viewer_comment_3, c0_.approved_at AS approved_at_4, c0_.comment AS comment_5, c0_.payment_deferment AS payment_deferment_6, c0_.recommendations AS recommendations_7, c0_.updated_at AS updated_at_8, c0_.review_approve_comment AS review_approve_comment_9, c0_.access_by_receipt AS access_by_receipt_10, c0_.decline_comment AS decline_comment_11, c0_.leaved_at AS leaved_at_12, c0_.registration_type AS registration_type_13, c0_.author_id AS author_id_14, c0_.person_id AS person_id_15, c0_.calendar_event_id AS calendar_event_id_16, c0_.image_id AS image_id_17, c0_.selected_author_id AS selected_author_id_18, c0_.curator_id AS curator_id_19, c0_.invoice_id AS invoice_id_20 FROM candidate c0_ INNER JOIN calendar_event c1_ ON c0_.calendar_event_id = c1_.id WHERE c0_.person_id = ? AND c1_.earn_level IS NOT NULL AND c1_.earn_level >= 0 AND c0_.status IN (?) AND c1_.end_date <= ? ORDER BY c1_.start_date DESC LIMIT 1"
  "params" => [
    1 => 43
    2 => "approved"
    3 => "2026-08-16 00:00:00"
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "SELECT c0_.id AS id_0, c0_.status AS status_1, c0_.created_at AS created_at_2, c0_.viewer_comment AS viewer_comment_3, c0_.approved_at AS approved_at_4, c0_.comment AS comment_5, c0_.payment_deferment AS payment_deferment_6, c0_.recommendations AS recommendations_7, c0_.updated_at AS updated_at_8, c0_.review_approve_comment AS review_approve_comment_9, c0_.access_by_receipt AS access_by_receipt_10, c0_.decline_comment AS decline_comment_11, c0_.leaved_at AS leaved_at_12, c0_.registration_type AS registration_type_13, c0_.author_id AS author_id_14, c0_.person_id AS person_id_15, c0_.calendar_event_id AS calendar_event_id_16, c0_.image_id AS image_id_17, c0_.selected_author_id AS selected_author_id_18, c0_.curator_id AS curator_id_19, c0_.invoice_id AS invoice_id_20 FROM candidate c0_ INNER JOIN calendar_event c1_ ON c0_.calendar_event_id = c1_.id WHERE c0_.person_id = ? AND c1_.earn_level IS NOT NULL AND c1_.earn_level >= 0 AND c0_.status IN (?) AND c1_.end_date <= ? ORDER BY c1_.start_date DESC LIMIT 1"
  "params" => [
    1 => 44
    2 => "approved"
    3 => "2026-08-16 00:00:00"
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "SELECT c0_.id AS id_0, c0_.status AS status_1, c0_.created_at AS created_at_2, c0_.viewer_comment AS viewer_comment_3, c0_.approved_at AS approved_at_4, c0_.comment AS comment_5, c0_.payment_deferment AS payment_deferment_6, c0_.recommendations AS recommendations_7, c0_.updated_at AS updated_at_8, c0_.review_approve_comment AS review_approve_comment_9, c0_.access_by_receipt AS access_by_receipt_10, c0_.decline_comment AS decline_comment_11, c0_.leaved_at AS leaved_at_12, c0_.registration_type AS registration_type_13, c0_.author_id AS author_id_14, c0_.person_id AS person_id_15, c0_.calendar_event_id AS calendar_event_id_16, c0_.image_id AS image_id_17, c0_.selected_author_id AS selected_author_id_18, c0_.curator_id AS curator_id_19, c0_.invoice_id AS invoice_id_20 FROM candidate c0_ INNER JOIN calendar_event c1_ ON c0_.calendar_event_id = c1_.id WHERE c0_.person_id = ? AND c1_.earn_level IS NOT NULL AND c1_.earn_level >= 0 AND c0_.status IN (?) AND c1_.end_date <= ? ORDER BY c1_.start_date DESC LIMIT 1"
  "params" => [
    1 => 1130
    2 => "approved"
    3 => "2026-08-16 00:00:00"
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "SELECT c0_.id AS id_0, c0_.status AS status_1, c0_.created_at AS created_at_2, c0_.viewer_comment AS viewer_comment_3, c0_.approved_at AS approved_at_4, c0_.comment AS comment_5, c0_.payment_deferment AS payment_deferment_6, c0_.recommendations AS recommendations_7, c0_.updated_at AS updated_at_8, c0_.review_approve_comment AS review_approve_comment_9, c0_.access_by_receipt AS access_by_receipt_10, c0_.decline_comment AS decline_comment_11, c0_.leaved_at AS leaved_at_12, c0_.registration_type AS registration_type_13, c0_.author_id AS author_id_14, c0_.person_id AS person_id_15, c0_.calendar_event_id AS calendar_event_id_16, c0_.image_id AS image_id_17, c0_.selected_author_id AS selected_author_id_18, c0_.curator_id AS curator_id_19, c0_.invoice_id AS invoice_id_20 FROM candidate c0_ INNER JOIN calendar_event c1_ ON c0_.calendar_event_id = c1_.id WHERE c0_.person_id = ? AND c1_.earn_level IS NOT NULL AND c1_.earn_level >= 0 AND c0_.status IN (?) AND c1_.end_date <= ? ORDER BY c1_.start_date DESC LIMIT 1"
  "params" => [
    1 => 833
    2 => "approved"
    3 => "2026-08-16 00:00:00"
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "SELECT c0_.id AS id_0, c0_.status AS status_1, c0_.created_at AS created_at_2, c0_.viewer_comment AS viewer_comment_3, c0_.approved_at AS approved_at_4, c0_.comment AS comment_5, c0_.payment_deferment AS payment_deferment_6, c0_.recommendations AS recommendations_7, c0_.updated_at AS updated_at_8, c0_.review_approve_comment AS review_approve_comment_9, c0_.access_by_receipt AS access_by_receipt_10, c0_.decline_comment AS decline_comment_11, c0_.leaved_at AS leaved_at_12, c0_.registration_type AS registration_type_13, c0_.author_id AS author_id_14, c0_.person_id AS person_id_15, c0_.calendar_event_id AS calendar_event_id_16, c0_.image_id AS image_id_17, c0_.selected_author_id AS selected_author_id_18, c0_.curator_id AS curator_id_19, c0_.invoice_id AS invoice_id_20 FROM candidate c0_ INNER JOIN calendar_event c1_ ON c0_.calendar_event_id = c1_.id WHERE c0_.person_id = ? AND c1_.earn_level IS NOT NULL AND c1_.earn_level >= 0 AND c0_.status IN (?) AND c1_.end_date <= ? ORDER BY c1_.start_date DESC LIMIT 1"
  "params" => [
    1 => 1128
    2 => "approved"
    3 => "2026-08-16 00:00:00"
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "SELECT c0_.id AS id_0, c0_.status AS status_1, c0_.created_at AS created_at_2, c0_.viewer_comment AS viewer_comment_3, c0_.approved_at AS approved_at_4, c0_.comment AS comment_5, c0_.payment_deferment AS payment_deferment_6, c0_.recommendations AS recommendations_7, c0_.updated_at AS updated_at_8, c0_.review_approve_comment AS review_approve_comment_9, c0_.access_by_receipt AS access_by_receipt_10, c0_.decline_comment AS decline_comment_11, c0_.leaved_at AS leaved_at_12, c0_.registration_type AS registration_type_13, c0_.author_id AS author_id_14, c0_.person_id AS person_id_15, c0_.calendar_event_id AS calendar_event_id_16, c0_.image_id AS image_id_17, c0_.selected_author_id AS selected_author_id_18, c0_.curator_id AS curator_id_19, c0_.invoice_id AS invoice_id_20 FROM candidate c0_ INNER JOIN calendar_event c1_ ON c0_.calendar_event_id = c1_.id WHERE c0_.person_id = ? AND c1_.earn_level IS NOT NULL AND c1_.earn_level >= 0 AND c0_.status IN (?) AND c1_.end_date <= ? ORDER BY c1_.start_date DESC LIMIT 1"
  "params" => [
    1 => 1358
    2 => "approved"
    3 => "2026-08-16 00:00:00"
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "SELECT c0_.id AS id_0, c0_.status AS status_1, c0_.created_at AS created_at_2, c0_.viewer_comment AS viewer_comment_3, c0_.approved_at AS approved_at_4, c0_.comment AS comment_5, c0_.payment_deferment AS payment_deferment_6, c0_.recommendations AS recommendations_7, c0_.updated_at AS updated_at_8, c0_.review_approve_comment AS review_approve_comment_9, c0_.access_by_receipt AS access_by_receipt_10, c0_.decline_comment AS decline_comment_11, c0_.leaved_at AS leaved_at_12, c0_.registration_type AS registration_type_13, c0_.author_id AS author_id_14, c0_.person_id AS person_id_15, c0_.calendar_event_id AS calendar_event_id_16, c0_.image_id AS image_id_17, c0_.selected_author_id AS selected_author_id_18, c0_.curator_id AS curator_id_19, c0_.invoice_id AS invoice_id_20 FROM candidate c0_ INNER JOIN calendar_event c1_ ON c0_.calendar_event_id = c1_.id WHERE c0_.person_id = ? AND c1_.earn_level IS NOT NULL AND c1_.earn_level >= 0 AND c0_.status IN (?) AND c1_.end_date <= ? ORDER BY c1_.start_date DESC LIMIT 1"
  "params" => [
    1 => 834
    2 => "approved"
    3 => "2026-08-16 00:00:00"
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "SELECT c0_.id AS id_0, c0_.status AS status_1, c0_.created_at AS created_at_2, c0_.viewer_comment AS viewer_comment_3, c0_.approved_at AS approved_at_4, c0_.comment AS comment_5, c0_.payment_deferment AS payment_deferment_6, c0_.recommendations AS recommendations_7, c0_.updated_at AS updated_at_8, c0_.review_approve_comment AS review_approve_comment_9, c0_.access_by_receipt AS access_by_receipt_10, c0_.decline_comment AS decline_comment_11, c0_.leaved_at AS leaved_at_12, c0_.registration_type AS registration_type_13, c0_.author_id AS author_id_14, c0_.person_id AS person_id_15, c0_.calendar_event_id AS calendar_event_id_16, c0_.image_id AS image_id_17, c0_.selected_author_id AS selected_author_id_18, c0_.curator_id AS curator_id_19, c0_.invoice_id AS invoice_id_20 FROM candidate c0_ INNER JOIN calendar_event c1_ ON c0_.calendar_event_id = c1_.id WHERE c0_.person_id = ? AND c1_.earn_level IS NOT NULL AND c1_.earn_level >= 0 AND c0_.status IN (?) AND c1_.end_date <= ? ORDER BY c1_.start_date DESC LIMIT 1"
  "params" => [
    1 => 1101
    2 => "approved"
    3 => "2026-08-16 00:00:00"
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "SELECT c0_.id AS id_0, c0_.status AS status_1, c0_.created_at AS created_at_2, c0_.viewer_comment AS viewer_comment_3, c0_.approved_at AS approved_at_4, c0_.comment AS comment_5, c0_.payment_deferment AS payment_deferment_6, c0_.recommendations AS recommendations_7, c0_.updated_at AS updated_at_8, c0_.review_approve_comment AS review_approve_comment_9, c0_.access_by_receipt AS access_by_receipt_10, c0_.decline_comment AS decline_comment_11, c0_.leaved_at AS leaved_at_12, c0_.registration_type AS registration_type_13, c0_.author_id AS author_id_14, c0_.person_id AS person_id_15, c0_.calendar_event_id AS calendar_event_id_16, c0_.image_id AS image_id_17, c0_.selected_author_id AS selected_author_id_18, c0_.curator_id AS curator_id_19, c0_.invoice_id AS invoice_id_20 FROM candidate c0_ INNER JOIN calendar_event c1_ ON c0_.calendar_event_id = c1_.id WHERE c0_.person_id = ? AND c1_.earn_level IS NOT NULL AND c1_.earn_level >= 0 AND c0_.status IN (?) AND c1_.end_date <= ? ORDER BY c1_.start_date DESC LIMIT 1"
  "params" => [
    1 => 45
    2 => "approved"
    3 => "2026-08-16 00:00:00"
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "SELECT c0_.id AS id_0, c0_.status AS status_1, c0_.created_at AS created_at_2, c0_.viewer_comment AS viewer_comment_3, c0_.approved_at AS approved_at_4, c0_.comment AS comment_5, c0_.payment_deferment AS payment_deferment_6, c0_.recommendations AS recommendations_7, c0_.updated_at AS updated_at_8, c0_.review_approve_comment AS review_approve_comment_9, c0_.access_by_receipt AS access_by_receipt_10, c0_.decline_comment AS decline_comment_11, c0_.leaved_at AS leaved_at_12, c0_.registration_type AS registration_type_13, c0_.author_id AS author_id_14, c0_.person_id AS person_id_15, c0_.calendar_event_id AS calendar_event_id_16, c0_.image_id AS image_id_17, c0_.selected_author_id AS selected_author_id_18, c0_.curator_id AS curator_id_19, c0_.invoice_id AS invoice_id_20 FROM candidate c0_ INNER JOIN calendar_event c1_ ON c0_.calendar_event_id = c1_.id WHERE c0_.person_id = ? AND c1_.earn_level IS NOT NULL AND c1_.earn_level >= 0 AND c0_.status IN (?) AND c1_.end_date <= ? ORDER BY c1_.start_date DESC LIMIT 1"
  "params" => [
    1 => 1150
    2 => "approved"
    3 => "2026-08-16 00:00:00"
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "SELECT c0_.id AS id_0, c0_.status AS status_1, c0_.created_at AS created_at_2, c0_.viewer_comment AS viewer_comment_3, c0_.approved_at AS approved_at_4, c0_.comment AS comment_5, c0_.payment_deferment AS payment_deferment_6, c0_.recommendations AS recommendations_7, c0_.updated_at AS updated_at_8, c0_.review_approve_comment AS review_approve_comment_9, c0_.access_by_receipt AS access_by_receipt_10, c0_.decline_comment AS decline_comment_11, c0_.leaved_at AS leaved_at_12, c0_.registration_type AS registration_type_13, c0_.author_id AS author_id_14, c0_.person_id AS person_id_15, c0_.calendar_event_id AS calendar_event_id_16, c0_.image_id AS image_id_17, c0_.selected_author_id AS selected_author_id_18, c0_.curator_id AS curator_id_19, c0_.invoice_id AS invoice_id_20 FROM candidate c0_ INNER JOIN calendar_event c1_ ON c0_.calendar_event_id = c1_.id WHERE c0_.person_id = ? AND c1_.earn_level IS NOT NULL AND c1_.earn_level >= 0 AND c0_.status IN (?) AND c1_.end_date <= ? ORDER BY c1_.start_date DESC LIMIT 1"
  "params" => [
    1 => 46
    2 => "approved"
    3 => "2026-08-16 00:00:00"
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "SELECT c0_.id AS id_0, c0_.status AS status_1, c0_.created_at AS created_at_2, c0_.viewer_comment AS viewer_comment_3, c0_.approved_at AS approved_at_4, c0_.comment AS comment_5, c0_.payment_deferment AS payment_deferment_6, c0_.recommendations AS recommendations_7, c0_.updated_at AS updated_at_8, c0_.review_approve_comment AS review_approve_comment_9, c0_.access_by_receipt AS access_by_receipt_10, c0_.decline_comment AS decline_comment_11, c0_.leaved_at AS leaved_at_12, c0_.registration_type AS registration_type_13, c0_.author_id AS author_id_14, c0_.person_id AS person_id_15, c0_.calendar_event_id AS calendar_event_id_16, c0_.image_id AS image_id_17, c0_.selected_author_id AS selected_author_id_18, c0_.curator_id AS curator_id_19, c0_.invoice_id AS invoice_id_20 FROM candidate c0_ INNER JOIN calendar_event c1_ ON c0_.calendar_event_id = c1_.id WHERE c0_.person_id = ? AND c1_.earn_level IS NOT NULL AND c1_.earn_level >= 0 AND c0_.status IN (?) AND c1_.end_date <= ? ORDER BY c1_.start_date DESC LIMIT 1"
  "params" => [
    1 => 47
    2 => "approved"
    3 => "2026-08-16 00:00:00"
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "SELECT c0_.id AS id_0, c0_.status AS status_1, c0_.created_at AS created_at_2, c0_.viewer_comment AS viewer_comment_3, c0_.approved_at AS approved_at_4, c0_.comment AS comment_5, c0_.payment_deferment AS payment_deferment_6, c0_.recommendations AS recommendations_7, c0_.updated_at AS updated_at_8, c0_.review_approve_comment AS review_approve_comment_9, c0_.access_by_receipt AS access_by_receipt_10, c0_.decline_comment AS decline_comment_11, c0_.leaved_at AS leaved_at_12, c0_.registration_type AS registration_type_13, c0_.author_id AS author_id_14, c0_.person_id AS person_id_15, c0_.calendar_event_id AS calendar_event_id_16, c0_.image_id AS image_id_17, c0_.selected_author_id AS selected_author_id_18, c0_.curator_id AS curator_id_19, c0_.invoice_id AS invoice_id_20 FROM candidate c0_ INNER JOIN calendar_event c1_ ON c0_.calendar_event_id = c1_.id WHERE c0_.person_id = ? AND c1_.earn_level IS NOT NULL AND c1_.earn_level >= 0 AND c0_.status IN (?) AND c1_.end_date <= ? ORDER BY c1_.start_date DESC LIMIT 1"
  "params" => [
    1 => 48
    2 => "approved"
    3 => "2026-08-16 00:00:00"
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "SELECT c0_.id AS id_0, c0_.status AS status_1, c0_.created_at AS created_at_2, c0_.viewer_comment AS viewer_comment_3, c0_.approved_at AS approved_at_4, c0_.comment AS comment_5, c0_.payment_deferment AS payment_deferment_6, c0_.recommendations AS recommendations_7, c0_.updated_at AS updated_at_8, c0_.review_approve_comment AS review_approve_comment_9, c0_.access_by_receipt AS access_by_receipt_10, c0_.decline_comment AS decline_comment_11, c0_.leaved_at AS leaved_at_12, c0_.registration_type AS registration_type_13, c0_.author_id AS author_id_14, c0_.person_id AS person_id_15, c0_.calendar_event_id AS calendar_event_id_16, c0_.image_id AS image_id_17, c0_.selected_author_id AS selected_author_id_18, c0_.curator_id AS curator_id_19, c0_.invoice_id AS invoice_id_20 FROM candidate c0_ INNER JOIN calendar_event c1_ ON c0_.calendar_event_id = c1_.id WHERE c0_.person_id = ? AND c1_.earn_level IS NOT NULL AND c1_.earn_level >= 0 AND c0_.status IN (?) AND c1_.end_date <= ? ORDER BY c1_.start_date DESC LIMIT 1"
  "params" => [
    1 => 835
    2 => "approved"
    3 => "2026-08-16 00:00:00"
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "SELECT c0_.id AS id_0, c0_.status AS status_1, c0_.created_at AS created_at_2, c0_.viewer_comment AS viewer_comment_3, c0_.approved_at AS approved_at_4, c0_.comment AS comment_5, c0_.payment_deferment AS payment_deferment_6, c0_.recommendations AS recommendations_7, c0_.updated_at AS updated_at_8, c0_.review_approve_comment AS review_approve_comment_9, c0_.access_by_receipt AS access_by_receipt_10, c0_.decline_comment AS decline_comment_11, c0_.leaved_at AS leaved_at_12, c0_.registration_type AS registration_type_13, c0_.author_id AS author_id_14, c0_.person_id AS person_id_15, c0_.calendar_event_id AS calendar_event_id_16, c0_.image_id AS image_id_17, c0_.selected_author_id AS selected_author_id_18, c0_.curator_id AS curator_id_19, c0_.invoice_id AS invoice_id_20 FROM candidate c0_ INNER JOIN calendar_event c1_ ON c0_.calendar_event_id = c1_.id WHERE c0_.person_id = ? AND c1_.earn_level IS NOT NULL AND c1_.earn_level >= 0 AND c0_.status IN (?) AND c1_.end_date <= ? ORDER BY c1_.start_date DESC LIMIT 1"
  "params" => [
    1 => 836
    2 => "approved"
    3 => "2026-08-16 00:00:00"
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "SELECT c0_.id AS id_0, c0_.status AS status_1, c0_.created_at AS created_at_2, c0_.viewer_comment AS viewer_comment_3, c0_.approved_at AS approved_at_4, c0_.comment AS comment_5, c0_.payment_deferment AS payment_deferment_6, c0_.recommendations AS recommendations_7, c0_.updated_at AS updated_at_8, c0_.review_approve_comment AS review_approve_comment_9, c0_.access_by_receipt AS access_by_receipt_10, c0_.decline_comment AS decline_comment_11, c0_.leaved_at AS leaved_at_12, c0_.registration_type AS registration_type_13, c0_.author_id AS author_id_14, c0_.person_id AS person_id_15, c0_.calendar_event_id AS calendar_event_id_16, c0_.image_id AS image_id_17, c0_.selected_author_id AS selected_author_id_18, c0_.curator_id AS curator_id_19, c0_.invoice_id AS invoice_id_20 FROM candidate c0_ INNER JOIN calendar_event c1_ ON c0_.calendar_event_id = c1_.id WHERE c0_.person_id = ? AND c1_.earn_level IS NOT NULL AND c1_.earn_level >= 0 AND c0_.status IN (?) AND c1_.end_date <= ? ORDER BY c1_.start_date DESC LIMIT 1"
  "params" => [
    1 => 1306
    2 => "approved"
    3 => "2026-08-16 00:00:00"
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "SELECT c0_.id AS id_0, c0_.status AS status_1, c0_.created_at AS created_at_2, c0_.viewer_comment AS viewer_comment_3, c0_.approved_at AS approved_at_4, c0_.comment AS comment_5, c0_.payment_deferment AS payment_deferment_6, c0_.recommendations AS recommendations_7, c0_.updated_at AS updated_at_8, c0_.review_approve_comment AS review_approve_comment_9, c0_.access_by_receipt AS access_by_receipt_10, c0_.decline_comment AS decline_comment_11, c0_.leaved_at AS leaved_at_12, c0_.registration_type AS registration_type_13, c0_.author_id AS author_id_14, c0_.person_id AS person_id_15, c0_.calendar_event_id AS calendar_event_id_16, c0_.image_id AS image_id_17, c0_.selected_author_id AS selected_author_id_18, c0_.curator_id AS curator_id_19, c0_.invoice_id AS invoice_id_20 FROM candidate c0_ INNER JOIN calendar_event c1_ ON c0_.calendar_event_id = c1_.id WHERE c0_.person_id = ? AND c1_.earn_level IS NOT NULL AND c1_.earn_level >= 0 AND c0_.status IN (?) AND c1_.end_date <= ? ORDER BY c1_.start_date DESC LIMIT 1"
  "params" => [
    1 => 1196
    2 => "approved"
    3 => "2026-08-16 00:00:00"
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "SELECT c0_.id AS id_0, c0_.status AS status_1, c0_.created_at AS created_at_2, c0_.viewer_comment AS viewer_comment_3, c0_.approved_at AS approved_at_4, c0_.comment AS comment_5, c0_.payment_deferment AS payment_deferment_6, c0_.recommendations AS recommendations_7, c0_.updated_at AS updated_at_8, c0_.review_approve_comment AS review_approve_comment_9, c0_.access_by_receipt AS access_by_receipt_10, c0_.decline_comment AS decline_comment_11, c0_.leaved_at AS leaved_at_12, c0_.registration_type AS registration_type_13, c0_.author_id AS author_id_14, c0_.person_id AS person_id_15, c0_.calendar_event_id AS calendar_event_id_16, c0_.image_id AS image_id_17, c0_.selected_author_id AS selected_author_id_18, c0_.curator_id AS curator_id_19, c0_.invoice_id AS invoice_id_20 FROM candidate c0_ INNER JOIN calendar_event c1_ ON c0_.calendar_event_id = c1_.id WHERE c0_.person_id = ? AND c1_.earn_level IS NOT NULL AND c1_.earn_level >= 0 AND c0_.status IN (?) AND c1_.end_date <= ? ORDER BY c1_.start_date DESC LIMIT 1"
  "params" => [
    1 => 837
    2 => "approved"
    3 => "2026-08-16 00:00:00"
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "SELECT c0_.id AS id_0, c0_.status AS status_1, c0_.created_at AS created_at_2, c0_.viewer_comment AS viewer_comment_3, c0_.approved_at AS approved_at_4, c0_.comment AS comment_5, c0_.payment_deferment AS payment_deferment_6, c0_.recommendations AS recommendations_7, c0_.updated_at AS updated_at_8, c0_.review_approve_comment AS review_approve_comment_9, c0_.access_by_receipt AS access_by_receipt_10, c0_.decline_comment AS decline_comment_11, c0_.leaved_at AS leaved_at_12, c0_.registration_type AS registration_type_13, c0_.author_id AS author_id_14, c0_.person_id AS person_id_15, c0_.calendar_event_id AS calendar_event_id_16, c0_.image_id AS image_id_17, c0_.selected_author_id AS selected_author_id_18, c0_.curator_id AS curator_id_19, c0_.invoice_id AS invoice_id_20 FROM candidate c0_ INNER JOIN calendar_event c1_ ON c0_.calendar_event_id = c1_.id WHERE c0_.person_id = ? AND c1_.earn_level IS NOT NULL AND c1_.earn_level >= 0 AND c0_.status IN (?) AND c1_.end_date <= ? ORDER BY c1_.start_date DESC LIMIT 1"
  "params" => [
    1 => 49
    2 => "approved"
    3 => "2026-08-16 00:00:00"
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "SELECT c0_.id AS id_0, c0_.status AS status_1, c0_.created_at AS created_at_2, c0_.viewer_comment AS viewer_comment_3, c0_.approved_at AS approved_at_4, c0_.comment AS comment_5, c0_.payment_deferment AS payment_deferment_6, c0_.recommendations AS recommendations_7, c0_.updated_at AS updated_at_8, c0_.review_approve_comment AS review_approve_comment_9, c0_.access_by_receipt AS access_by_receipt_10, c0_.decline_comment AS decline_comment_11, c0_.leaved_at AS leaved_at_12, c0_.registration_type AS registration_type_13, c0_.author_id AS author_id_14, c0_.person_id AS person_id_15, c0_.calendar_event_id AS calendar_event_id_16, c0_.image_id AS image_id_17, c0_.selected_author_id AS selected_author_id_18, c0_.curator_id AS curator_id_19, c0_.invoice_id AS invoice_id_20 FROM candidate c0_ INNER JOIN calendar_event c1_ ON c0_.calendar_event_id = c1_.id WHERE c0_.person_id = ? AND c1_.earn_level IS NOT NULL AND c1_.earn_level >= 0 AND c0_.status IN (?) AND c1_.end_date <= ? ORDER BY c1_.start_date DESC LIMIT 1"
  "params" => [
    1 => 1214
    2 => "approved"
    3 => "2026-08-16 00:00:00"
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "SELECT c0_.id AS id_0, c0_.status AS status_1, c0_.created_at AS created_at_2, c0_.viewer_comment AS viewer_comment_3, c0_.approved_at AS approved_at_4, c0_.comment AS comment_5, c0_.payment_deferment AS payment_deferment_6, c0_.recommendations AS recommendations_7, c0_.updated_at AS updated_at_8, c0_.review_approve_comment AS review_approve_comment_9, c0_.access_by_receipt AS access_by_receipt_10, c0_.decline_comment AS decline_comment_11, c0_.leaved_at AS leaved_at_12, c0_.registration_type AS registration_type_13, c0_.author_id AS author_id_14, c0_.person_id AS person_id_15, c0_.calendar_event_id AS calendar_event_id_16, c0_.image_id AS image_id_17, c0_.selected_author_id AS selected_author_id_18, c0_.curator_id AS curator_id_19, c0_.invoice_id AS invoice_id_20 FROM candidate c0_ INNER JOIN calendar_event c1_ ON c0_.calendar_event_id = c1_.id WHERE c0_.person_id = ? AND c1_.earn_level IS NOT NULL AND c1_.earn_level >= 0 AND c0_.status IN (?) AND c1_.end_date <= ? ORDER BY c1_.start_date DESC LIMIT 1"
  "params" => [
    1 => 50
    2 => "approved"
    3 => "2026-08-16 00:00:00"
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "SELECT c0_.id AS id_0, c0_.status AS status_1, c0_.created_at AS created_at_2, c0_.viewer_comment AS viewer_comment_3, c0_.approved_at AS approved_at_4, c0_.comment AS comment_5, c0_.payment_deferment AS payment_deferment_6, c0_.recommendations AS recommendations_7, c0_.updated_at AS updated_at_8, c0_.review_approve_comment AS review_approve_comment_9, c0_.access_by_receipt AS access_by_receipt_10, c0_.decline_comment AS decline_comment_11, c0_.leaved_at AS leaved_at_12, c0_.registration_type AS registration_type_13, c0_.author_id AS author_id_14, c0_.person_id AS person_id_15, c0_.calendar_event_id AS calendar_event_id_16, c0_.image_id AS image_id_17, c0_.selected_author_id AS selected_author_id_18, c0_.curator_id AS curator_id_19, c0_.invoice_id AS invoice_id_20 FROM candidate c0_ INNER JOIN calendar_event c1_ ON c0_.calendar_event_id = c1_.id WHERE c0_.person_id = ? AND c1_.earn_level IS NOT NULL AND c1_.earn_level >= 0 AND c0_.status IN (?) AND c1_.end_date <= ? ORDER BY c1_.start_date DESC LIMIT 1"
  "params" => [
    1 => 51
    2 => "approved"
    3 => "2026-08-16 00:00:00"
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "SELECT c0_.id AS id_0, c0_.status AS status_1, c0_.created_at AS created_at_2, c0_.viewer_comment AS viewer_comment_3, c0_.approved_at AS approved_at_4, c0_.comment AS comment_5, c0_.payment_deferment AS payment_deferment_6, c0_.recommendations AS recommendations_7, c0_.updated_at AS updated_at_8, c0_.review_approve_comment AS review_approve_comment_9, c0_.access_by_receipt AS access_by_receipt_10, c0_.decline_comment AS decline_comment_11, c0_.leaved_at AS leaved_at_12, c0_.registration_type AS registration_type_13, c0_.author_id AS author_id_14, c0_.person_id AS person_id_15, c0_.calendar_event_id AS calendar_event_id_16, c0_.image_id AS image_id_17, c0_.selected_author_id AS selected_author_id_18, c0_.curator_id AS curator_id_19, c0_.invoice_id AS invoice_id_20 FROM candidate c0_ INNER JOIN calendar_event c1_ ON c0_.calendar_event_id = c1_.id WHERE c0_.person_id = ? AND c1_.earn_level IS NOT NULL AND c1_.earn_level >= 0 AND c0_.status IN (?) AND c1_.end_date <= ? ORDER BY c1_.start_date DESC LIMIT 1"
  "params" => [
    1 => 52
    2 => "approved"
    3 => "2026-08-16 00:00:00"
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "SELECT c0_.id AS id_0, c0_.status AS status_1, c0_.created_at AS created_at_2, c0_.viewer_comment AS viewer_comment_3, c0_.approved_at AS approved_at_4, c0_.comment AS comment_5, c0_.payment_deferment AS payment_deferment_6, c0_.recommendations AS recommendations_7, c0_.updated_at AS updated_at_8, c0_.review_approve_comment AS review_approve_comment_9, c0_.access_by_receipt AS access_by_receipt_10, c0_.decline_comment AS decline_comment_11, c0_.leaved_at AS leaved_at_12, c0_.registration_type AS registration_type_13, c0_.author_id AS author_id_14, c0_.person_id AS person_id_15, c0_.calendar_event_id AS calendar_event_id_16, c0_.image_id AS image_id_17, c0_.selected_author_id AS selected_author_id_18, c0_.curator_id AS curator_id_19, c0_.invoice_id AS invoice_id_20 FROM candidate c0_ INNER JOIN calendar_event c1_ ON c0_.calendar_event_id = c1_.id WHERE c0_.person_id = ? AND c1_.earn_level IS NOT NULL AND c1_.earn_level >= 0 AND c0_.status IN (?) AND c1_.end_date <= ? ORDER BY c1_.start_date DESC LIMIT 1"
  "params" => [
    1 => 53
    2 => "approved"
    3 => "2026-08-16 00:00:00"
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "SELECT c0_.id AS id_0, c0_.status AS status_1, c0_.created_at AS created_at_2, c0_.viewer_comment AS viewer_comment_3, c0_.approved_at AS approved_at_4, c0_.comment AS comment_5, c0_.payment_deferment AS payment_deferment_6, c0_.recommendations AS recommendations_7, c0_.updated_at AS updated_at_8, c0_.review_approve_comment AS review_approve_comment_9, c0_.access_by_receipt AS access_by_receipt_10, c0_.decline_comment AS decline_comment_11, c0_.leaved_at AS leaved_at_12, c0_.registration_type AS registration_type_13, c0_.author_id AS author_id_14, c0_.person_id AS person_id_15, c0_.calendar_event_id AS calendar_event_id_16, c0_.image_id AS image_id_17, c0_.selected_author_id AS selected_author_id_18, c0_.curator_id AS curator_id_19, c0_.invoice_id AS invoice_id_20 FROM candidate c0_ INNER JOIN calendar_event c1_ ON c0_.calendar_event_id = c1_.id WHERE c0_.person_id = ? AND c1_.earn_level IS NOT NULL AND c1_.earn_level >= 0 AND c0_.status IN (?) AND c1_.end_date <= ? ORDER BY c1_.start_date DESC LIMIT 1"
  "params" => [
    1 => 54
    2 => "approved"
    3 => "2026-08-16 00:00:00"
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "SELECT c0_.id AS id_0, c0_.status AS status_1, c0_.created_at AS created_at_2, c0_.viewer_comment AS viewer_comment_3, c0_.approved_at AS approved_at_4, c0_.comment AS comment_5, c0_.payment_deferment AS payment_deferment_6, c0_.recommendations AS recommendations_7, c0_.updated_at AS updated_at_8, c0_.review_approve_comment AS review_approve_comment_9, c0_.access_by_receipt AS access_by_receipt_10, c0_.decline_comment AS decline_comment_11, c0_.leaved_at AS leaved_at_12, c0_.registration_type AS registration_type_13, c0_.author_id AS author_id_14, c0_.person_id AS person_id_15, c0_.calendar_event_id AS calendar_event_id_16, c0_.image_id AS image_id_17, c0_.selected_author_id AS selected_author_id_18, c0_.curator_id AS curator_id_19, c0_.invoice_id AS invoice_id_20 FROM candidate c0_ INNER JOIN calendar_event c1_ ON c0_.calendar_event_id = c1_.id WHERE c0_.person_id = ? AND c1_.earn_level IS NOT NULL AND c1_.earn_level >= 0 AND c0_.status IN (?) AND c1_.end_date <= ? ORDER BY c1_.start_date DESC LIMIT 1"
  "params" => [
    1 => 1350
    2 => "approved"
    3 => "2026-08-16 00:00:00"
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "SELECT c0_.id AS id_0, c0_.status AS status_1, c0_.created_at AS created_at_2, c0_.viewer_comment AS viewer_comment_3, c0_.approved_at AS approved_at_4, c0_.comment AS comment_5, c0_.payment_deferment AS payment_deferment_6, c0_.recommendations AS recommendations_7, c0_.updated_at AS updated_at_8, c0_.review_approve_comment AS review_approve_comment_9, c0_.access_by_receipt AS access_by_receipt_10, c0_.decline_comment AS decline_comment_11, c0_.leaved_at AS leaved_at_12, c0_.registration_type AS registration_type_13, c0_.author_id AS author_id_14, c0_.person_id AS person_id_15, c0_.calendar_event_id AS calendar_event_id_16, c0_.image_id AS image_id_17, c0_.selected_author_id AS selected_author_id_18, c0_.curator_id AS curator_id_19, c0_.invoice_id AS invoice_id_20 FROM candidate c0_ INNER JOIN calendar_event c1_ ON c0_.calendar_event_id = c1_.id WHERE c0_.person_id = ? AND c1_.earn_level IS NOT NULL AND c1_.earn_level >= 0 AND c0_.status IN (?) AND c1_.end_date <= ? ORDER BY c1_.start_date DESC LIMIT 1"
  "params" => [
    1 => 838
    2 => "approved"
    3 => "2026-08-16 00:00:00"
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "SELECT c0_.id AS id_0, c0_.status AS status_1, c0_.created_at AS created_at_2, c0_.viewer_comment AS viewer_comment_3, c0_.approved_at AS approved_at_4, c0_.comment AS comment_5, c0_.payment_deferment AS payment_deferment_6, c0_.recommendations AS recommendations_7, c0_.updated_at AS updated_at_8, c0_.review_approve_comment AS review_approve_comment_9, c0_.access_by_receipt AS access_by_receipt_10, c0_.decline_comment AS decline_comment_11, c0_.leaved_at AS leaved_at_12, c0_.registration_type AS registration_type_13, c0_.author_id AS author_id_14, c0_.person_id AS person_id_15, c0_.calendar_event_id AS calendar_event_id_16, c0_.image_id AS image_id_17, c0_.selected_author_id AS selected_author_id_18, c0_.curator_id AS curator_id_19, c0_.invoice_id AS invoice_id_20 FROM candidate c0_ INNER JOIN calendar_event c1_ ON c0_.calendar_event_id = c1_.id WHERE c0_.person_id = ? AND c1_.earn_level IS NOT NULL AND c1_.earn_level >= 0 AND c0_.status IN (?) AND c1_.end_date <= ? ORDER BY c1_.start_date DESC LIMIT 1"
  "params" => [
    1 => 55
    2 => "approved"
    3 => "2026-08-16 00:00:00"
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "SELECT c0_.id AS id_0, c0_.status AS status_1, c0_.created_at AS created_at_2, c0_.viewer_comment AS viewer_comment_3, c0_.approved_at AS approved_at_4, c0_.comment AS comment_5, c0_.payment_deferment AS payment_deferment_6, c0_.recommendations AS recommendations_7, c0_.updated_at AS updated_at_8, c0_.review_approve_comment AS review_approve_comment_9, c0_.access_by_receipt AS access_by_receipt_10, c0_.decline_comment AS decline_comment_11, c0_.leaved_at AS leaved_at_12, c0_.registration_type AS registration_type_13, c0_.author_id AS author_id_14, c0_.person_id AS person_id_15, c0_.calendar_event_id AS calendar_event_id_16, c0_.image_id AS image_id_17, c0_.selected_author_id AS selected_author_id_18, c0_.curator_id AS curator_id_19, c0_.invoice_id AS invoice_id_20 FROM candidate c0_ INNER JOIN calendar_event c1_ ON c0_.calendar_event_id = c1_.id WHERE c0_.person_id = ? AND c1_.earn_level IS NOT NULL AND c1_.earn_level >= 0 AND c0_.status IN (?) AND c1_.end_date <= ? ORDER BY c1_.start_date DESC LIMIT 1"
  "params" => [
    1 => 839
    2 => "approved"
    3 => "2026-08-16 00:00:00"
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "SELECT c0_.id AS id_0, c0_.status AS status_1, c0_.created_at AS created_at_2, c0_.viewer_comment AS viewer_comment_3, c0_.approved_at AS approved_at_4, c0_.comment AS comment_5, c0_.payment_deferment AS payment_deferment_6, c0_.recommendations AS recommendations_7, c0_.updated_at AS updated_at_8, c0_.review_approve_comment AS review_approve_comment_9, c0_.access_by_receipt AS access_by_receipt_10, c0_.decline_comment AS decline_comment_11, c0_.leaved_at AS leaved_at_12, c0_.registration_type AS registration_type_13, c0_.author_id AS author_id_14, c0_.person_id AS person_id_15, c0_.calendar_event_id AS calendar_event_id_16, c0_.image_id AS image_id_17, c0_.selected_author_id AS selected_author_id_18, c0_.curator_id AS curator_id_19, c0_.invoice_id AS invoice_id_20 FROM candidate c0_ INNER JOIN calendar_event c1_ ON c0_.calendar_event_id = c1_.id WHERE c0_.person_id = ? AND c1_.earn_level IS NOT NULL AND c1_.earn_level >= 0 AND c0_.status IN (?) AND c1_.end_date <= ? ORDER BY c1_.start_date DESC LIMIT 1"
  "params" => [
    1 => 56
    2 => "approved"
    3 => "2026-08-16 00:00:00"
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "SELECT c0_.id AS id_0, c0_.status AS status_1, c0_.created_at AS created_at_2, c0_.viewer_comment AS viewer_comment_3, c0_.approved_at AS approved_at_4, c0_.comment AS comment_5, c0_.payment_deferment AS payment_deferment_6, c0_.recommendations AS recommendations_7, c0_.updated_at AS updated_at_8, c0_.review_approve_comment AS review_approve_comment_9, c0_.access_by_receipt AS access_by_receipt_10, c0_.decline_comment AS decline_comment_11, c0_.leaved_at AS leaved_at_12, c0_.registration_type AS registration_type_13, c0_.author_id AS author_id_14, c0_.person_id AS person_id_15, c0_.calendar_event_id AS calendar_event_id_16, c0_.image_id AS image_id_17, c0_.selected_author_id AS selected_author_id_18, c0_.curator_id AS curator_id_19, c0_.invoice_id AS invoice_id_20 FROM candidate c0_ INNER JOIN calendar_event c1_ ON c0_.calendar_event_id = c1_.id WHERE c0_.person_id = ? AND c1_.earn_level IS NOT NULL AND c1_.earn_level >= 0 AND c0_.status IN (?) AND c1_.end_date <= ? ORDER BY c1_.start_date DESC LIMIT 1"
  "params" => [
    1 => 57
    2 => "approved"
    3 => "2026-08-16 00:00:00"
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "SELECT c0_.id AS id_0, c0_.status AS status_1, c0_.created_at AS created_at_2, c0_.viewer_comment AS viewer_comment_3, c0_.approved_at AS approved_at_4, c0_.comment AS comment_5, c0_.payment_deferment AS payment_deferment_6, c0_.recommendations AS recommendations_7, c0_.updated_at AS updated_at_8, c0_.review_approve_comment AS review_approve_comment_9, c0_.access_by_receipt AS access_by_receipt_10, c0_.decline_comment AS decline_comment_11, c0_.leaved_at AS leaved_at_12, c0_.registration_type AS registration_type_13, c0_.author_id AS author_id_14, c0_.person_id AS person_id_15, c0_.calendar_event_id AS calendar_event_id_16, c0_.image_id AS image_id_17, c0_.selected_author_id AS selected_author_id_18, c0_.curator_id AS curator_id_19, c0_.invoice_id AS invoice_id_20 FROM candidate c0_ INNER JOIN calendar_event c1_ ON c0_.calendar_event_id = c1_.id WHERE c0_.person_id = ? AND c1_.earn_level IS NOT NULL AND c1_.earn_level >= 0 AND c0_.status IN (?) AND c1_.end_date <= ? ORDER BY c1_.start_date DESC LIMIT 1"
  "params" => [
    1 => 1238
    2 => "approved"
    3 => "2026-08-16 00:00:00"
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "SELECT c0_.id AS id_0, c0_.status AS status_1, c0_.created_at AS created_at_2, c0_.viewer_comment AS viewer_comment_3, c0_.approved_at AS approved_at_4, c0_.comment AS comment_5, c0_.payment_deferment AS payment_deferment_6, c0_.recommendations AS recommendations_7, c0_.updated_at AS updated_at_8, c0_.review_approve_comment AS review_approve_comment_9, c0_.access_by_receipt AS access_by_receipt_10, c0_.decline_comment AS decline_comment_11, c0_.leaved_at AS leaved_at_12, c0_.registration_type AS registration_type_13, c0_.author_id AS author_id_14, c0_.person_id AS person_id_15, c0_.calendar_event_id AS calendar_event_id_16, c0_.image_id AS image_id_17, c0_.selected_author_id AS selected_author_id_18, c0_.curator_id AS curator_id_19, c0_.invoice_id AS invoice_id_20 FROM candidate c0_ INNER JOIN calendar_event c1_ ON c0_.calendar_event_id = c1_.id WHERE c0_.person_id = ? AND c1_.earn_level IS NOT NULL AND c1_.earn_level >= 0 AND c0_.status IN (?) AND c1_.end_date <= ? ORDER BY c1_.start_date DESC LIMIT 1"
  "params" => [
    1 => 840
    2 => "approved"
    3 => "2026-08-16 00:00:00"
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "SELECT c0_.id AS id_0, c0_.status AS status_1, c0_.created_at AS created_at_2, c0_.viewer_comment AS viewer_comment_3, c0_.approved_at AS approved_at_4, c0_.comment AS comment_5, c0_.payment_deferment AS payment_deferment_6, c0_.recommendations AS recommendations_7, c0_.updated_at AS updated_at_8, c0_.review_approve_comment AS review_approve_comment_9, c0_.access_by_receipt AS access_by_receipt_10, c0_.decline_comment AS decline_comment_11, c0_.leaved_at AS leaved_at_12, c0_.registration_type AS registration_type_13, c0_.author_id AS author_id_14, c0_.person_id AS person_id_15, c0_.calendar_event_id AS calendar_event_id_16, c0_.image_id AS image_id_17, c0_.selected_author_id AS selected_author_id_18, c0_.curator_id AS curator_id_19, c0_.invoice_id AS invoice_id_20 FROM candidate c0_ INNER JOIN calendar_event c1_ ON c0_.calendar_event_id = c1_.id WHERE c0_.person_id = ? AND c1_.earn_level IS NOT NULL AND c1_.earn_level >= 0 AND c0_.status IN (?) AND c1_.end_date <= ? ORDER BY c1_.start_date DESC LIMIT 1"
  "params" => [
    1 => 58
    2 => "approved"
    3 => "2026-08-16 00:00:00"
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "SELECT c0_.id AS id_0, c0_.status AS status_1, c0_.created_at AS created_at_2, c0_.viewer_comment AS viewer_comment_3, c0_.approved_at AS approved_at_4, c0_.comment AS comment_5, c0_.payment_deferment AS payment_deferment_6, c0_.recommendations AS recommendations_7, c0_.updated_at AS updated_at_8, c0_.review_approve_comment AS review_approve_comment_9, c0_.access_by_receipt AS access_by_receipt_10, c0_.decline_comment AS decline_comment_11, c0_.leaved_at AS leaved_at_12, c0_.registration_type AS registration_type_13, c0_.author_id AS author_id_14, c0_.person_id AS person_id_15, c0_.calendar_event_id AS calendar_event_id_16, c0_.image_id AS image_id_17, c0_.selected_author_id AS selected_author_id_18, c0_.curator_id AS curator_id_19, c0_.invoice_id AS invoice_id_20 FROM candidate c0_ INNER JOIN calendar_event c1_ ON c0_.calendar_event_id = c1_.id WHERE c0_.person_id = ? AND c1_.earn_level IS NOT NULL AND c1_.earn_level >= 0 AND c0_.status IN (?) AND c1_.end_date <= ? ORDER BY c1_.start_date DESC LIMIT 1"
  "params" => [
    1 => 59
    2 => "approved"
    3 => "2026-08-16 00:00:00"
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "SELECT c0_.id AS id_0, c0_.status AS status_1, c0_.created_at AS created_at_2, c0_.viewer_comment AS viewer_comment_3, c0_.approved_at AS approved_at_4, c0_.comment AS comment_5, c0_.payment_deferment AS payment_deferment_6, c0_.recommendations AS recommendations_7, c0_.updated_at AS updated_at_8, c0_.review_approve_comment AS review_approve_comment_9, c0_.access_by_receipt AS access_by_receipt_10, c0_.decline_comment AS decline_comment_11, c0_.leaved_at AS leaved_at_12, c0_.registration_type AS registration_type_13, c0_.author_id AS author_id_14, c0_.person_id AS person_id_15, c0_.calendar_event_id AS calendar_event_id_16, c0_.image_id AS image_id_17, c0_.selected_author_id AS selected_author_id_18, c0_.curator_id AS curator_id_19, c0_.invoice_id AS invoice_id_20 FROM candidate c0_ INNER JOIN calendar_event c1_ ON c0_.calendar_event_id = c1_.id WHERE c0_.person_id = ? AND c1_.earn_level IS NOT NULL AND c1_.earn_level >= 0 AND c0_.status IN (?) AND c1_.end_date <= ? ORDER BY c1_.start_date DESC LIMIT 1"
  "params" => [
    1 => 61
    2 => "approved"
    3 => "2026-08-16 00:00:00"
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "SELECT c0_.id AS id_0, c0_.status AS status_1, c0_.created_at AS created_at_2, c0_.viewer_comment AS viewer_comment_3, c0_.approved_at AS approved_at_4, c0_.comment AS comment_5, c0_.payment_deferment AS payment_deferment_6, c0_.recommendations AS recommendations_7, c0_.updated_at AS updated_at_8, c0_.review_approve_comment AS review_approve_comment_9, c0_.access_by_receipt AS access_by_receipt_10, c0_.decline_comment AS decline_comment_11, c0_.leaved_at AS leaved_at_12, c0_.registration_type AS registration_type_13, c0_.author_id AS author_id_14, c0_.person_id AS person_id_15, c0_.calendar_event_id AS calendar_event_id_16, c0_.image_id AS image_id_17, c0_.selected_author_id AS selected_author_id_18, c0_.curator_id AS curator_id_19, c0_.invoice_id AS invoice_id_20 FROM candidate c0_ INNER JOIN calendar_event c1_ ON c0_.calendar_event_id = c1_.id WHERE c0_.person_id = ? AND c1_.earn_level IS NOT NULL AND c1_.earn_level >= 0 AND c0_.status IN (?) AND c1_.end_date <= ? ORDER BY c1_.start_date DESC LIMIT 1"
  "params" => [
    1 => 62
    2 => "approved"
    3 => "2026-08-16 00:00:00"
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "SELECT c0_.id AS id_0, c0_.status AS status_1, c0_.created_at AS created_at_2, c0_.viewer_comment AS viewer_comment_3, c0_.approved_at AS approved_at_4, c0_.comment AS comment_5, c0_.payment_deferment AS payment_deferment_6, c0_.recommendations AS recommendations_7, c0_.updated_at AS updated_at_8, c0_.review_approve_comment AS review_approve_comment_9, c0_.access_by_receipt AS access_by_receipt_10, c0_.decline_comment AS decline_comment_11, c0_.leaved_at AS leaved_at_12, c0_.registration_type AS registration_type_13, c0_.author_id AS author_id_14, c0_.person_id AS person_id_15, c0_.calendar_event_id AS calendar_event_id_16, c0_.image_id AS image_id_17, c0_.selected_author_id AS selected_author_id_18, c0_.curator_id AS curator_id_19, c0_.invoice_id AS invoice_id_20 FROM candidate c0_ INNER JOIN calendar_event c1_ ON c0_.calendar_event_id = c1_.id WHERE c0_.person_id = ? AND c1_.earn_level IS NOT NULL AND c1_.earn_level >= 0 AND c0_.status IN (?) AND c1_.end_date <= ? ORDER BY c1_.start_date DESC LIMIT 1"
  "params" => [
    1 => 63
    2 => "approved"
    3 => "2026-08-16 00:00:00"
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "SELECT c0_.id AS id_0, c0_.status AS status_1, c0_.created_at AS created_at_2, c0_.viewer_comment AS viewer_comment_3, c0_.approved_at AS approved_at_4, c0_.comment AS comment_5, c0_.payment_deferment AS payment_deferment_6, c0_.recommendations AS recommendations_7, c0_.updated_at AS updated_at_8, c0_.review_approve_comment AS review_approve_comment_9, c0_.access_by_receipt AS access_by_receipt_10, c0_.decline_comment AS decline_comment_11, c0_.leaved_at AS leaved_at_12, c0_.registration_type AS registration_type_13, c0_.author_id AS author_id_14, c0_.person_id AS person_id_15, c0_.calendar_event_id AS calendar_event_id_16, c0_.image_id AS image_id_17, c0_.selected_author_id AS selected_author_id_18, c0_.curator_id AS curator_id_19, c0_.invoice_id AS invoice_id_20 FROM candidate c0_ INNER JOIN calendar_event c1_ ON c0_.calendar_event_id = c1_.id WHERE c0_.person_id = ? AND c1_.earn_level IS NOT NULL AND c1_.earn_level >= 0 AND c0_.status IN (?) AND c1_.end_date <= ? ORDER BY c1_.start_date DESC LIMIT 1"
  "params" => [
    1 => 841
    2 => "approved"
    3 => "2026-08-16 00:00:00"
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "SELECT c0_.id AS id_0, c0_.status AS status_1, c0_.created_at AS created_at_2, c0_.viewer_comment AS viewer_comment_3, c0_.approved_at AS approved_at_4, c0_.comment AS comment_5, c0_.payment_deferment AS payment_deferment_6, c0_.recommendations AS recommendations_7, c0_.updated_at AS updated_at_8, c0_.review_approve_comment AS review_approve_comment_9, c0_.access_by_receipt AS access_by_receipt_10, c0_.decline_comment AS decline_comment_11, c0_.leaved_at AS leaved_at_12, c0_.registration_type AS registration_type_13, c0_.author_id AS author_id_14, c0_.person_id AS person_id_15, c0_.calendar_event_id AS calendar_event_id_16, c0_.image_id AS image_id_17, c0_.selected_author_id AS selected_author_id_18, c0_.curator_id AS curator_id_19, c0_.invoice_id AS invoice_id_20 FROM candidate c0_ INNER JOIN calendar_event c1_ ON c0_.calendar_event_id = c1_.id WHERE c0_.person_id = ? AND c1_.earn_level IS NOT NULL AND c1_.earn_level >= 0 AND c0_.status IN (?) AND c1_.end_date <= ? ORDER BY c1_.start_date DESC LIMIT 1"
  "params" => [
    1 => 842
    2 => "approved"
    3 => "2026-08-16 00:00:00"
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "SELECT c0_.id AS id_0, c0_.status AS status_1, c0_.created_at AS created_at_2, c0_.viewer_comment AS viewer_comment_3, c0_.approved_at AS approved_at_4, c0_.comment AS comment_5, c0_.payment_deferment AS payment_deferment_6, c0_.recommendations AS recommendations_7, c0_.updated_at AS updated_at_8, c0_.review_approve_comment AS review_approve_comment_9, c0_.access_by_receipt AS access_by_receipt_10, c0_.decline_comment AS decline_comment_11, c0_.leaved_at AS leaved_at_12, c0_.registration_type AS registration_type_13, c0_.author_id AS author_id_14, c0_.person_id AS person_id_15, c0_.calendar_event_id AS calendar_event_id_16, c0_.image_id AS image_id_17, c0_.selected_author_id AS selected_author_id_18, c0_.curator_id AS curator_id_19, c0_.invoice_id AS invoice_id_20 FROM candidate c0_ INNER JOIN calendar_event c1_ ON c0_.calendar_event_id = c1_.id WHERE c0_.person_id = ? AND c1_.earn_level IS NOT NULL AND c1_.earn_level >= 0 AND c0_.status IN (?) AND c1_.end_date <= ? ORDER BY c1_.start_date DESC LIMIT 1"
  "params" => [
    1 => 64
    2 => "approved"
    3 => "2026-08-16 00:00:00"
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "SELECT c0_.id AS id_0, c0_.status AS status_1, c0_.created_at AS created_at_2, c0_.viewer_comment AS viewer_comment_3, c0_.approved_at AS approved_at_4, c0_.comment AS comment_5, c0_.payment_deferment AS payment_deferment_6, c0_.recommendations AS recommendations_7, c0_.updated_at AS updated_at_8, c0_.review_approve_comment AS review_approve_comment_9, c0_.access_by_receipt AS access_by_receipt_10, c0_.decline_comment AS decline_comment_11, c0_.leaved_at AS leaved_at_12, c0_.registration_type AS registration_type_13, c0_.author_id AS author_id_14, c0_.person_id AS person_id_15, c0_.calendar_event_id AS calendar_event_id_16, c0_.image_id AS image_id_17, c0_.selected_author_id AS selected_author_id_18, c0_.curator_id AS curator_id_19, c0_.invoice_id AS invoice_id_20 FROM candidate c0_ INNER JOIN calendar_event c1_ ON c0_.calendar_event_id = c1_.id WHERE c0_.person_id = ? AND c1_.earn_level IS NOT NULL AND c1_.earn_level >= 0 AND c0_.status IN (?) AND c1_.end_date <= ? ORDER BY c1_.start_date DESC LIMIT 1"
  "params" => [
    1 => 65
    2 => "approved"
    3 => "2026-08-16 00:00:00"
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "SELECT c0_.id AS id_0, c0_.status AS status_1, c0_.created_at AS created_at_2, c0_.viewer_comment AS viewer_comment_3, c0_.approved_at AS approved_at_4, c0_.comment AS comment_5, c0_.payment_deferment AS payment_deferment_6, c0_.recommendations AS recommendations_7, c0_.updated_at AS updated_at_8, c0_.review_approve_comment AS review_approve_comment_9, c0_.access_by_receipt AS access_by_receipt_10, c0_.decline_comment AS decline_comment_11, c0_.leaved_at AS leaved_at_12, c0_.registration_type AS registration_type_13, c0_.author_id AS author_id_14, c0_.person_id AS person_id_15, c0_.calendar_event_id AS calendar_event_id_16, c0_.image_id AS image_id_17, c0_.selected_author_id AS selected_author_id_18, c0_.curator_id AS curator_id_19, c0_.invoice_id AS invoice_id_20 FROM candidate c0_ INNER JOIN calendar_event c1_ ON c0_.calendar_event_id = c1_.id WHERE c0_.person_id = ? AND c1_.earn_level IS NOT NULL AND c1_.earn_level >= 0 AND c0_.status IN (?) AND c1_.end_date <= ? ORDER BY c1_.start_date DESC LIMIT 1"
  "params" => [
    1 => 66
    2 => "approved"
    3 => "2026-08-16 00:00:00"
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "SELECT c0_.id AS id_0, c0_.status AS status_1, c0_.created_at AS created_at_2, c0_.viewer_comment AS viewer_comment_3, c0_.approved_at AS approved_at_4, c0_.comment AS comment_5, c0_.payment_deferment AS payment_deferment_6, c0_.recommendations AS recommendations_7, c0_.updated_at AS updated_at_8, c0_.review_approve_comment AS review_approve_comment_9, c0_.access_by_receipt AS access_by_receipt_10, c0_.decline_comment AS decline_comment_11, c0_.leaved_at AS leaved_at_12, c0_.registration_type AS registration_type_13, c0_.author_id AS author_id_14, c0_.person_id AS person_id_15, c0_.calendar_event_id AS calendar_event_id_16, c0_.image_id AS image_id_17, c0_.selected_author_id AS selected_author_id_18, c0_.curator_id AS curator_id_19, c0_.invoice_id AS invoice_id_20 FROM candidate c0_ INNER JOIN calendar_event c1_ ON c0_.calendar_event_id = c1_.id WHERE c0_.person_id = ? AND c1_.earn_level IS NOT NULL AND c1_.earn_level >= 0 AND c0_.status IN (?) AND c1_.end_date <= ? ORDER BY c1_.start_date DESC LIMIT 1"
  "params" => [
    1 => 67
    2 => "approved"
    3 => "2026-08-16 00:00:00"
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "SELECT c0_.id AS id_0, c0_.status AS status_1, c0_.created_at AS created_at_2, c0_.viewer_comment AS viewer_comment_3, c0_.approved_at AS approved_at_4, c0_.comment AS comment_5, c0_.payment_deferment AS payment_deferment_6, c0_.recommendations AS recommendations_7, c0_.updated_at AS updated_at_8, c0_.review_approve_comment AS review_approve_comment_9, c0_.access_by_receipt AS access_by_receipt_10, c0_.decline_comment AS decline_comment_11, c0_.leaved_at AS leaved_at_12, c0_.registration_type AS registration_type_13, c0_.author_id AS author_id_14, c0_.person_id AS person_id_15, c0_.calendar_event_id AS calendar_event_id_16, c0_.image_id AS image_id_17, c0_.selected_author_id AS selected_author_id_18, c0_.curator_id AS curator_id_19, c0_.invoice_id AS invoice_id_20 FROM candidate c0_ INNER JOIN calendar_event c1_ ON c0_.calendar_event_id = c1_.id WHERE c0_.person_id = ? AND c1_.earn_level IS NOT NULL AND c1_.earn_level >= 0 AND c0_.status IN (?) AND c1_.end_date <= ? ORDER BY c1_.start_date DESC LIMIT 1"
  "params" => [
    1 => 68
    2 => "approved"
    3 => "2026-08-16 00:00:00"
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "SELECT c0_.id AS id_0, c0_.status AS status_1, c0_.created_at AS created_at_2, c0_.viewer_comment AS viewer_comment_3, c0_.approved_at AS approved_at_4, c0_.comment AS comment_5, c0_.payment_deferment AS payment_deferment_6, c0_.recommendations AS recommendations_7, c0_.updated_at AS updated_at_8, c0_.review_approve_comment AS review_approve_comment_9, c0_.access_by_receipt AS access_by_receipt_10, c0_.decline_comment AS decline_comment_11, c0_.leaved_at AS leaved_at_12, c0_.registration_type AS registration_type_13, c0_.author_id AS author_id_14, c0_.person_id AS person_id_15, c0_.calendar_event_id AS calendar_event_id_16, c0_.image_id AS image_id_17, c0_.selected_author_id AS selected_author_id_18, c0_.curator_id AS curator_id_19, c0_.invoice_id AS invoice_id_20 FROM candidate c0_ INNER JOIN calendar_event c1_ ON c0_.calendar_event_id = c1_.id WHERE c0_.person_id = ? AND c1_.earn_level IS NOT NULL AND c1_.earn_level >= 0 AND c0_.status IN (?) AND c1_.end_date <= ? ORDER BY c1_.start_date DESC LIMIT 1"
  "params" => [
    1 => 843
    2 => "approved"
    3 => "2026-08-16 00:00:00"
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "SELECT c0_.id AS id_0, c0_.status AS status_1, c0_.created_at AS created_at_2, c0_.viewer_comment AS viewer_comment_3, c0_.approved_at AS approved_at_4, c0_.comment AS comment_5, c0_.payment_deferment AS payment_deferment_6, c0_.recommendations AS recommendations_7, c0_.updated_at AS updated_at_8, c0_.review_approve_comment AS review_approve_comment_9, c0_.access_by_receipt AS access_by_receipt_10, c0_.decline_comment AS decline_comment_11, c0_.leaved_at AS leaved_at_12, c0_.registration_type AS registration_type_13, c0_.author_id AS author_id_14, c0_.person_id AS person_id_15, c0_.calendar_event_id AS calendar_event_id_16, c0_.image_id AS image_id_17, c0_.selected_author_id AS selected_author_id_18, c0_.curator_id AS curator_id_19, c0_.invoice_id AS invoice_id_20 FROM candidate c0_ INNER JOIN calendar_event c1_ ON c0_.calendar_event_id = c1_.id WHERE c0_.person_id = ? AND c1_.earn_level IS NOT NULL AND c1_.earn_level >= 0 AND c0_.status IN (?) AND c1_.end_date <= ? ORDER BY c1_.start_date DESC LIMIT 1"
  "params" => [
    1 => 69
    2 => "approved"
    3 => "2026-08-16 00:00:00"
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 2
  ]
]