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.settings_id AS settings_id_11, t12.id AS id_13, t12.candidate_decline_comments AS candidate_decline_comments_14, t12.candidate_recommendations AS candidate_recommendations_15, t12.user_id AS user_id_16, t17.id AS id_18, t17.show_reviewer_recommendations_tip AS show_reviewer_recommendations_tip_19, t17.show_calendar_events_period_tip AS show_calendar_events_period_tip_20, t17.user_id AS user_id_21 FROM user t0 LEFT JOIN reviewer_settings t12 ON t12.user_id = t0.id LEFT JOIN tip_settings t17 ON t17.user_id = t0.id WHERE t0.id = ?"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => 1
  ]
]

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

[
  "event" => "debug.security.authorization.vote"
  "listener" => "Symfony\Bundle\SecurityBundle\EventListener\VoteListener::onVoterVote"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\DebugHandlersListener::configure"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\ValidateRequestListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\SessionListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\LocaleListener::setDefaultLocale"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\RouterListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\LocaleListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\LocaleAwareListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener::configureLogoutUrlGenerator"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener::onKernelRequest"
]

[
  "event" => "kernel.controller"
  "listener" => "Symfony\Bundle\FrameworkBundle\DataCollector\RouterDataCollector::onKernelController"
]

[
  "event" => "kernel.controller"
  "listener" => "Symfony\Component\HttpKernel\DataCollector\RequestDataCollector::onKernelController"
]

[
  "event" => "kernel.controller_arguments"
  "listener" => "Symfony\Component\HttpKernel\EventListener\ErrorListener::onControllerArguments"
]

[
  "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_.student_id AS student_id_16, p0_.city_id AS city_id_17, p0_.image_id AS image_id_18, p0_.message_receiver_id AS message_receiver_id_19, p0_.job_id AS job_id_20 FROM person p0_ LEFT JOIN student s1_ ON p0_.student_id = s1_.id WHERE (p0_.is_student = ? OR p0_.is_subscriber = ?) AND (s1_.status IN (?) OR s1_.id IS NULL) AND p0_.status IN (?) ORDER BY p0_.last_name ASC"
  "params" => [
    1 => 1
    2 => 1
    3 => "active"
    4 => "active"
  ]
  "types" => [
    1 => 5
    2 => 5
    3 => 2
    4 => 2
  ]
]

[
  "sql" => "SELECT s0_.id AS id_0, c1_.id AS id_1, MIN(c2_.id) AS sclr_2 FROM student s0_ LEFT JOIN person p3_ ON s0_.id = p3_.student_id LEFT JOIN candidate c2_ ON (c2_.person_id = p3_.id) LEFT JOIN calendar_event c1_ ON c2_.calendar_event_id = c1_.id GROUP BY s0_.id, c1_.id"
]

[
  "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_.payment_requisites_id AS payment_requisites_id_17, c0_.connecting_calendar_event_id AS connecting_calendar_event_id_18, c0_.kind_id AS kind_id_19 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_.author_id AS author_id_13, c0_.person_id AS person_id_14, c0_.calendar_event_id AS calendar_event_id_15, c0_.image_id AS image_id_16, c0_.selected_author_id AS selected_author_id_17, c0_.curator_id AS curator_id_18, c0_.invoice_id AS invoice_id_19 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-05-02 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_.author_id AS author_id_13, c0_.person_id AS person_id_14, c0_.calendar_event_id AS calendar_event_id_15, c0_.image_id AS image_id_16, c0_.selected_author_id AS selected_author_id_17, c0_.curator_id AS curator_id_18, c0_.invoice_id AS invoice_id_19 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-05-02 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_.author_id AS author_id_13, c0_.person_id AS person_id_14, c0_.calendar_event_id AS calendar_event_id_15, c0_.image_id AS image_id_16, c0_.selected_author_id AS selected_author_id_17, c0_.curator_id AS curator_id_18, c0_.invoice_id AS invoice_id_19 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-05-02 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_.author_id AS author_id_13, c0_.person_id AS person_id_14, c0_.calendar_event_id AS calendar_event_id_15, c0_.image_id AS image_id_16, c0_.selected_author_id AS selected_author_id_17, c0_.curator_id AS curator_id_18, c0_.invoice_id AS invoice_id_19 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-05-02 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_.author_id AS author_id_13, c0_.person_id AS person_id_14, c0_.calendar_event_id AS calendar_event_id_15, c0_.image_id AS image_id_16, c0_.selected_author_id AS selected_author_id_17, c0_.curator_id AS curator_id_18, c0_.invoice_id AS invoice_id_19 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-05-02 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_.author_id AS author_id_13, c0_.person_id AS person_id_14, c0_.calendar_event_id AS calendar_event_id_15, c0_.image_id AS image_id_16, c0_.selected_author_id AS selected_author_id_17, c0_.curator_id AS curator_id_18, c0_.invoice_id AS invoice_id_19 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-05-02 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_.author_id AS author_id_13, c0_.person_id AS person_id_14, c0_.calendar_event_id AS calendar_event_id_15, c0_.image_id AS image_id_16, c0_.selected_author_id AS selected_author_id_17, c0_.curator_id AS curator_id_18, c0_.invoice_id AS invoice_id_19 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-05-02 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_.author_id AS author_id_13, c0_.person_id AS person_id_14, c0_.calendar_event_id AS calendar_event_id_15, c0_.image_id AS image_id_16, c0_.selected_author_id AS selected_author_id_17, c0_.curator_id AS curator_id_18, c0_.invoice_id AS invoice_id_19 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-05-02 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_.author_id AS author_id_13, c0_.person_id AS person_id_14, c0_.calendar_event_id AS calendar_event_id_15, c0_.image_id AS image_id_16, c0_.selected_author_id AS selected_author_id_17, c0_.curator_id AS curator_id_18, c0_.invoice_id AS invoice_id_19 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-05-02 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_.author_id AS author_id_13, c0_.person_id AS person_id_14, c0_.calendar_event_id AS calendar_event_id_15, c0_.image_id AS image_id_16, c0_.selected_author_id AS selected_author_id_17, c0_.curator_id AS curator_id_18, c0_.invoice_id AS invoice_id_19 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-05-02 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_.author_id AS author_id_13, c0_.person_id AS person_id_14, c0_.calendar_event_id AS calendar_event_id_15, c0_.image_id AS image_id_16, c0_.selected_author_id AS selected_author_id_17, c0_.curator_id AS curator_id_18, c0_.invoice_id AS invoice_id_19 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-05-02 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_.author_id AS author_id_13, c0_.person_id AS person_id_14, c0_.calendar_event_id AS calendar_event_id_15, c0_.image_id AS image_id_16, c0_.selected_author_id AS selected_author_id_17, c0_.curator_id AS curator_id_18, c0_.invoice_id AS invoice_id_19 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-05-02 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_.author_id AS author_id_13, c0_.person_id AS person_id_14, c0_.calendar_event_id AS calendar_event_id_15, c0_.image_id AS image_id_16, c0_.selected_author_id AS selected_author_id_17, c0_.curator_id AS curator_id_18, c0_.invoice_id AS invoice_id_19 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-05-02 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_.author_id AS author_id_13, c0_.person_id AS person_id_14, c0_.calendar_event_id AS calendar_event_id_15, c0_.image_id AS image_id_16, c0_.selected_author_id AS selected_author_id_17, c0_.curator_id AS curator_id_18, c0_.invoice_id AS invoice_id_19 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-05-02 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_.author_id AS author_id_13, c0_.person_id AS person_id_14, c0_.calendar_event_id AS calendar_event_id_15, c0_.image_id AS image_id_16, c0_.selected_author_id AS selected_author_id_17, c0_.curator_id AS curator_id_18, c0_.invoice_id AS invoice_id_19 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-05-02 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_.author_id AS author_id_13, c0_.person_id AS person_id_14, c0_.calendar_event_id AS calendar_event_id_15, c0_.image_id AS image_id_16, c0_.selected_author_id AS selected_author_id_17, c0_.curator_id AS curator_id_18, c0_.invoice_id AS invoice_id_19 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-05-02 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_.author_id AS author_id_13, c0_.person_id AS person_id_14, c0_.calendar_event_id AS calendar_event_id_15, c0_.image_id AS image_id_16, c0_.selected_author_id AS selected_author_id_17, c0_.curator_id AS curator_id_18, c0_.invoice_id AS invoice_id_19 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-05-02 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_.author_id AS author_id_13, c0_.person_id AS person_id_14, c0_.calendar_event_id AS calendar_event_id_15, c0_.image_id AS image_id_16, c0_.selected_author_id AS selected_author_id_17, c0_.curator_id AS curator_id_18, c0_.invoice_id AS invoice_id_19 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-05-02 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_.author_id AS author_id_13, c0_.person_id AS person_id_14, c0_.calendar_event_id AS calendar_event_id_15, c0_.image_id AS image_id_16, c0_.selected_author_id AS selected_author_id_17, c0_.curator_id AS curator_id_18, c0_.invoice_id AS invoice_id_19 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-05-02 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_.author_id AS author_id_13, c0_.person_id AS person_id_14, c0_.calendar_event_id AS calendar_event_id_15, c0_.image_id AS image_id_16, c0_.selected_author_id AS selected_author_id_17, c0_.curator_id AS curator_id_18, c0_.invoice_id AS invoice_id_19 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-05-02 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_.author_id AS author_id_13, c0_.person_id AS person_id_14, c0_.calendar_event_id AS calendar_event_id_15, c0_.image_id AS image_id_16, c0_.selected_author_id AS selected_author_id_17, c0_.curator_id AS curator_id_18, c0_.invoice_id AS invoice_id_19 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-05-02 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_.author_id AS author_id_13, c0_.person_id AS person_id_14, c0_.calendar_event_id AS calendar_event_id_15, c0_.image_id AS image_id_16, c0_.selected_author_id AS selected_author_id_17, c0_.curator_id AS curator_id_18, c0_.invoice_id AS invoice_id_19 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-05-02 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_.author_id AS author_id_13, c0_.person_id AS person_id_14, c0_.calendar_event_id AS calendar_event_id_15, c0_.image_id AS image_id_16, c0_.selected_author_id AS selected_author_id_17, c0_.curator_id AS curator_id_18, c0_.invoice_id AS invoice_id_19 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-05-02 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_.author_id AS author_id_13, c0_.person_id AS person_id_14, c0_.calendar_event_id AS calendar_event_id_15, c0_.image_id AS image_id_16, c0_.selected_author_id AS selected_author_id_17, c0_.curator_id AS curator_id_18, c0_.invoice_id AS invoice_id_19 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-05-02 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_.author_id AS author_id_13, c0_.person_id AS person_id_14, c0_.calendar_event_id AS calendar_event_id_15, c0_.image_id AS image_id_16, c0_.selected_author_id AS selected_author_id_17, c0_.curator_id AS curator_id_18, c0_.invoice_id AS invoice_id_19 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-05-02 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_.author_id AS author_id_13, c0_.person_id AS person_id_14, c0_.calendar_event_id AS calendar_event_id_15, c0_.image_id AS image_id_16, c0_.selected_author_id AS selected_author_id_17, c0_.curator_id AS curator_id_18, c0_.invoice_id AS invoice_id_19 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-05-02 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_.author_id AS author_id_13, c0_.person_id AS person_id_14, c0_.calendar_event_id AS calendar_event_id_15, c0_.image_id AS image_id_16, c0_.selected_author_id AS selected_author_id_17, c0_.curator_id AS curator_id_18, c0_.invoice_id AS invoice_id_19 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-05-02 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_.author_id AS author_id_13, c0_.person_id AS person_id_14, c0_.calendar_event_id AS calendar_event_id_15, c0_.image_id AS image_id_16, c0_.selected_author_id AS selected_author_id_17, c0_.curator_id AS curator_id_18, c0_.invoice_id AS invoice_id_19 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-05-02 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_.author_id AS author_id_13, c0_.person_id AS person_id_14, c0_.calendar_event_id AS calendar_event_id_15, c0_.image_id AS image_id_16, c0_.selected_author_id AS selected_author_id_17, c0_.curator_id AS curator_id_18, c0_.invoice_id AS invoice_id_19 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-05-02 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_.author_id AS author_id_13, c0_.person_id AS person_id_14, c0_.calendar_event_id AS calendar_event_id_15, c0_.image_id AS image_id_16, c0_.selected_author_id AS selected_author_id_17, c0_.curator_id AS curator_id_18, c0_.invoice_id AS invoice_id_19 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-05-02 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_.author_id AS author_id_13, c0_.person_id AS person_id_14, c0_.calendar_event_id AS calendar_event_id_15, c0_.image_id AS image_id_16, c0_.selected_author_id AS selected_author_id_17, c0_.curator_id AS curator_id_18, c0_.invoice_id AS invoice_id_19 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-05-02 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_.author_id AS author_id_13, c0_.person_id AS person_id_14, c0_.calendar_event_id AS calendar_event_id_15, c0_.image_id AS image_id_16, c0_.selected_author_id AS selected_author_id_17, c0_.curator_id AS curator_id_18, c0_.invoice_id AS invoice_id_19 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-05-02 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_.author_id AS author_id_13, c0_.person_id AS person_id_14, c0_.calendar_event_id AS calendar_event_id_15, c0_.image_id AS image_id_16, c0_.selected_author_id AS selected_author_id_17, c0_.curator_id AS curator_id_18, c0_.invoice_id AS invoice_id_19 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-05-02 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_.author_id AS author_id_13, c0_.person_id AS person_id_14, c0_.calendar_event_id AS calendar_event_id_15, c0_.image_id AS image_id_16, c0_.selected_author_id AS selected_author_id_17, c0_.curator_id AS curator_id_18, c0_.invoice_id AS invoice_id_19 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-05-02 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_.author_id AS author_id_13, c0_.person_id AS person_id_14, c0_.calendar_event_id AS calendar_event_id_15, c0_.image_id AS image_id_16, c0_.selected_author_id AS selected_author_id_17, c0_.curator_id AS curator_id_18, c0_.invoice_id AS invoice_id_19 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-05-02 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_.author_id AS author_id_13, c0_.person_id AS person_id_14, c0_.calendar_event_id AS calendar_event_id_15, c0_.image_id AS image_id_16, c0_.selected_author_id AS selected_author_id_17, c0_.curator_id AS curator_id_18, c0_.invoice_id AS invoice_id_19 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-05-02 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_.author_id AS author_id_13, c0_.person_id AS person_id_14, c0_.calendar_event_id AS calendar_event_id_15, c0_.image_id AS image_id_16, c0_.selected_author_id AS selected_author_id_17, c0_.curator_id AS curator_id_18, c0_.invoice_id AS invoice_id_19 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-05-02 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_.author_id AS author_id_13, c0_.person_id AS person_id_14, c0_.calendar_event_id AS calendar_event_id_15, c0_.image_id AS image_id_16, c0_.selected_author_id AS selected_author_id_17, c0_.curator_id AS curator_id_18, c0_.invoice_id AS invoice_id_19 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-05-02 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_.author_id AS author_id_13, c0_.person_id AS person_id_14, c0_.calendar_event_id AS calendar_event_id_15, c0_.image_id AS image_id_16, c0_.selected_author_id AS selected_author_id_17, c0_.curator_id AS curator_id_18, c0_.invoice_id AS invoice_id_19 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-05-02 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_.author_id AS author_id_13, c0_.person_id AS person_id_14, c0_.calendar_event_id AS calendar_event_id_15, c0_.image_id AS image_id_16, c0_.selected_author_id AS selected_author_id_17, c0_.curator_id AS curator_id_18, c0_.invoice_id AS invoice_id_19 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-05-02 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_.author_id AS author_id_13, c0_.person_id AS person_id_14, c0_.calendar_event_id AS calendar_event_id_15, c0_.image_id AS image_id_16, c0_.selected_author_id AS selected_author_id_17, c0_.curator_id AS curator_id_18, c0_.invoice_id AS invoice_id_19 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-05-02 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_.author_id AS author_id_13, c0_.person_id AS person_id_14, c0_.calendar_event_id AS calendar_event_id_15, c0_.image_id AS image_id_16, c0_.selected_author_id AS selected_author_id_17, c0_.curator_id AS curator_id_18, c0_.invoice_id AS invoice_id_19 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-05-02 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_.author_id AS author_id_13, c0_.person_id AS person_id_14, c0_.calendar_event_id AS calendar_event_id_15, c0_.image_id AS image_id_16, c0_.selected_author_id AS selected_author_id_17, c0_.curator_id AS curator_id_18, c0_.invoice_id AS invoice_id_19 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-05-02 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_.author_id AS author_id_13, c0_.person_id AS person_id_14, c0_.calendar_event_id AS calendar_event_id_15, c0_.image_id AS image_id_16, c0_.selected_author_id AS selected_author_id_17, c0_.curator_id AS curator_id_18, c0_.invoice_id AS invoice_id_19 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-05-02 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_.author_id AS author_id_13, c0_.person_id AS person_id_14, c0_.calendar_event_id AS calendar_event_id_15, c0_.image_id AS image_id_16, c0_.selected_author_id AS selected_author_id_17, c0_.curator_id AS curator_id_18, c0_.invoice_id AS invoice_id_19 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-05-02 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_.author_id AS author_id_13, c0_.person_id AS person_id_14, c0_.calendar_event_id AS calendar_event_id_15, c0_.image_id AS image_id_16, c0_.selected_author_id AS selected_author_id_17, c0_.curator_id AS curator_id_18, c0_.invoice_id AS invoice_id_19 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-05-02 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_.author_id AS author_id_13, c0_.person_id AS person_id_14, c0_.calendar_event_id AS calendar_event_id_15, c0_.image_id AS image_id_16, c0_.selected_author_id AS selected_author_id_17, c0_.curator_id AS curator_id_18, c0_.invoice_id AS invoice_id_19 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-05-02 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_.author_id AS author_id_13, c0_.person_id AS person_id_14, c0_.calendar_event_id AS calendar_event_id_15, c0_.image_id AS image_id_16, c0_.selected_author_id AS selected_author_id_17, c0_.curator_id AS curator_id_18, c0_.invoice_id AS invoice_id_19 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-05-02 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_.author_id AS author_id_13, c0_.person_id AS person_id_14, c0_.calendar_event_id AS calendar_event_id_15, c0_.image_id AS image_id_16, c0_.selected_author_id AS selected_author_id_17, c0_.curator_id AS curator_id_18, c0_.invoice_id AS invoice_id_19 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-05-02 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_.author_id AS author_id_13, c0_.person_id AS person_id_14, c0_.calendar_event_id AS calendar_event_id_15, c0_.image_id AS image_id_16, c0_.selected_author_id AS selected_author_id_17, c0_.curator_id AS curator_id_18, c0_.invoice_id AS invoice_id_19 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-05-02 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_.author_id AS author_id_13, c0_.person_id AS person_id_14, c0_.calendar_event_id AS calendar_event_id_15, c0_.image_id AS image_id_16, c0_.selected_author_id AS selected_author_id_17, c0_.curator_id AS curator_id_18, c0_.invoice_id AS invoice_id_19 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-05-02 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_.author_id AS author_id_13, c0_.person_id AS person_id_14, c0_.calendar_event_id AS calendar_event_id_15, c0_.image_id AS image_id_16, c0_.selected_author_id AS selected_author_id_17, c0_.curator_id AS curator_id_18, c0_.invoice_id AS invoice_id_19 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-05-02 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_.author_id AS author_id_13, c0_.person_id AS person_id_14, c0_.calendar_event_id AS calendar_event_id_15, c0_.image_id AS image_id_16, c0_.selected_author_id AS selected_author_id_17, c0_.curator_id AS curator_id_18, c0_.invoice_id AS invoice_id_19 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-05-02 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_.author_id AS author_id_13, c0_.person_id AS person_id_14, c0_.calendar_event_id AS calendar_event_id_15, c0_.image_id AS image_id_16, c0_.selected_author_id AS selected_author_id_17, c0_.curator_id AS curator_id_18, c0_.invoice_id AS invoice_id_19 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-05-02 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_.author_id AS author_id_13, c0_.person_id AS person_id_14, c0_.calendar_event_id AS calendar_event_id_15, c0_.image_id AS image_id_16, c0_.selected_author_id AS selected_author_id_17, c0_.curator_id AS curator_id_18, c0_.invoice_id AS invoice_id_19 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-05-02 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_.author_id AS author_id_13, c0_.person_id AS person_id_14, c0_.calendar_event_id AS calendar_event_id_15, c0_.image_id AS image_id_16, c0_.selected_author_id AS selected_author_id_17, c0_.curator_id AS curator_id_18, c0_.invoice_id AS invoice_id_19 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-05-02 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_.author_id AS author_id_13, c0_.person_id AS person_id_14, c0_.calendar_event_id AS calendar_event_id_15, c0_.image_id AS image_id_16, c0_.selected_author_id AS selected_author_id_17, c0_.curator_id AS curator_id_18, c0_.invoice_id AS invoice_id_19 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-05-02 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_.author_id AS author_id_13, c0_.person_id AS person_id_14, c0_.calendar_event_id AS calendar_event_id_15, c0_.image_id AS image_id_16, c0_.selected_author_id AS selected_author_id_17, c0_.curator_id AS curator_id_18, c0_.invoice_id AS invoice_id_19 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-05-02 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_.author_id AS author_id_13, c0_.person_id AS person_id_14, c0_.calendar_event_id AS calendar_event_id_15, c0_.image_id AS image_id_16, c0_.selected_author_id AS selected_author_id_17, c0_.curator_id AS curator_id_18, c0_.invoice_id AS invoice_id_19 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-05-02 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_.author_id AS author_id_13, c0_.person_id AS person_id_14, c0_.calendar_event_id AS calendar_event_id_15, c0_.image_id AS image_id_16, c0_.selected_author_id AS selected_author_id_17, c0_.curator_id AS curator_id_18, c0_.invoice_id AS invoice_id_19 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-05-02 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_.author_id AS author_id_13, c0_.person_id AS person_id_14, c0_.calendar_event_id AS calendar_event_id_15, c0_.image_id AS image_id_16, c0_.selected_author_id AS selected_author_id_17, c0_.curator_id AS curator_id_18, c0_.invoice_id AS invoice_id_19 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-05-02 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_.author_id AS author_id_13, c0_.person_id AS person_id_14, c0_.calendar_event_id AS calendar_event_id_15, c0_.image_id AS image_id_16, c0_.selected_author_id AS selected_author_id_17, c0_.curator_id AS curator_id_18, c0_.invoice_id AS invoice_id_19 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-05-02 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_.author_id AS author_id_13, c0_.person_id AS person_id_14, c0_.calendar_event_id AS calendar_event_id_15, c0_.image_id AS image_id_16, c0_.selected_author_id AS selected_author_id_17, c0_.curator_id AS curator_id_18, c0_.invoice_id AS invoice_id_19 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-05-02 00:00:00"
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 2
  ]
]