Symfony Profiler

SELECT
  tl_acqpa_ins_certificate.*,
  j1.`id` AS inspector__id,
  j1.`tstamp` AS inspector__tstamp,
  j1.`created_at` AS inspector__created_at,
  j1.`lastname` AS inspector__lastname,
  j1.`firstname` AS inspector__firstname,
  j1.`gender` AS inspector__gender,
  j1.`acqpa_number` AS inspector__acqpa_number,
  j1.`frosio_number` AS inspector__frosio_number,
  j1.`accredible_url` AS inspector__accredible_url,
  j1.`first_certification_date` AS inspector__first_certification_date,
  j1.`candidate` AS inspector__candidate,
  j1.`accept_personal_data_share` AS inspector__accept_personal_data_share,
  j1.`api_company_appear_by_inspector` AS inspector__api_company_appear_by_inspector,
  j1.`api_company_email_for_agreement` AS inspector__api_company_email_for_agreement,
  j1.`api_company_email_for_agreement_date_sent` AS inspector__api_company_email_for_agreement_date_sent,
  j1.`api_company_appear_by_acqpa_status` AS inspector__api_company_appear_by_acqpa_status,
  j1.`api_company_appear_by_acqpa_date` AS inspector__api_company_appear_by_acqpa_date,
  j1.`alias` AS inspector__alias,
  j1.`date_of_birth` AS inspector__date_of_birth,
  j1.`place_of_birth` AS inspector__place_of_birth,
  j1.`country_of_birth` AS inspector__country_of_birth,
  j1.`company_none` AS inspector__company_none,
  j1.`company_independant` AS inspector__company_independant,
  j1.`company_siret` AS inspector__company_siret,
  j1.`company_name` AS inspector__company_name,
  j1.`company_street` AS inspector__company_street,
  j1.`company_street_2` AS inspector__company_street_2,
  j1.`company_postal` AS inspector__company_postal,
  j1.`company_city` AS inspector__company_city,
  j1.`company_country` AS inspector__company_country,
  j1.`company_email` AS inspector__company_email,
  j1.`company_phone` AS inspector__company_phone,
  j1.`company_contact_firstname` AS inspector__company_contact_firstname,
  j1.`company_contact_lastname` AS inspector__company_contact_lastname,
  j1.`company_contact_email` AS inspector__company_contact_email,
  j1.`company_contact_phone` AS inspector__company_contact_phone,
  j1.`phone` AS inspector__phone,
  j1.`email` AS inspector__email,
  j1.`identity_picture` AS inspector__identity_picture,
  j1.`identity_picture_validation_status` AS inspector__identity_picture_validation_status,
  j1.`identity_picture_validation_date` AS inspector__identity_picture_validation_date,
  j1.`identity_picture_validation_comment` AS inspector__identity_picture_validation_comment,
  j1.`identity_piece_recto` AS inspector__identity_piece_recto,
  j1.`identity_piece_recto_type` AS inspector__identity_piece_recto_type,
  j1.`identity_piece_recto_validation_status` AS inspector__identity_piece_recto_validation_status,
  j1.`identity_piece_recto_validation_date` AS inspector__identity_piece_recto_validation_date,
  j1.`identity_piece_recto_validation_comment` AS inspector__identity_piece_recto_validation_comment,
  j1.`identity_piece_verso` AS inspector__identity_piece_verso,
  j1.`identity_piece_verso_type` AS inspector__identity_piece_verso_type,
  j1.`identity_piece_verso_validation_status` AS inspector__identity_piece_verso_validation_status,
  j1.`identity_piece_verso_validation_date` AS inspector__identity_piece_verso_validation_date,
  j1.`identity_piece_verso_validation_comment` AS inspector__identity_piece_verso_validation_comment,
  j1.`cv` AS inspector__cv,
  j1.`details` AS inspector__details,
  j1.`street` AS inspector__street,
  j1.`street_2` AS inspector__street_2,
  j1.`postal` AS inspector__postal,
  j1.`city` AS inspector__city,
  j1.`state` AS inspector__state,
  j1.`country` AS inspector__country,
  j1.`invoice_same_as_company` AS inspector__invoice_same_as_company,
  j1.`invoice_siret` AS inspector__invoice_siret,
  j1.`invoice_company` AS inspector__invoice_company,
  j1.`invoice_street` AS inspector__invoice_street,
  j1.`invoice_street_2` AS inspector__invoice_street_2,
  j1.`invoice_postal` AS inspector__invoice_postal,
  j1.`invoice_city` AS inspector__invoice_city,
  j1.`invoice_country` AS inspector__invoice_country,
  j1.`invoice_email` AS inspector__invoice_email,
  j1.`invoice_phone` AS inspector__invoice_phone,
  j1.`invoice_lastname` AS inspector__invoice_lastname,
  j1.`invoice_firstname` AS inspector__invoice_firstname,
  j1.`archived` AS inspector__archived,
  j1.`archived_at` AS inspector__archived_at,
  j1.`alias_deduplication` AS inspector__alias_deduplication,
  j1.`v1_imported` AS inspector__v1_imported,
  j1.`v1_id` AS inspector__v1_id,
  j1.`v1_source` AS inspector__v1_source,
  j1.`v1_details` AS inspector__v1_details,
  j2.`id` AS original_certificate__id,
  j2.`tstamp` AS original_certificate__tstamp,
  j2.`created_at` AS original_certificate__created_at,
  j2.`inspector` AS original_certificate__inspector,
  j2.`number` AS original_certificate__number,
  j2.`status` AS original_certificate__status,
  j2.`date_cci` AS original_certificate__date_cci,
  j2.`obtained_date` AS original_certificate__obtained_date,
  j2.`validity_date_end` AS original_certificate__validity_date_end,
  j2.`revoked_at` AS original_certificate__revoked_at,
  j2.`revoked_reason` AS original_certificate__revoked_reason,
  j2.`inspector_firstname` AS original_certificate__inspector_firstname,
  j2.`inspector_lastname` AS original_certificate__inspector_lastname,
  j2.`inspector_date_of_birth` AS original_certificate__inspector_date_of_birth,
  j2.`inspector_acqpa_number` AS original_certificate__inspector_acqpa_number,
  j2.`exam_type` AS original_certificate__exam_type,
  j2.`exam_cycle` AS original_certificate__exam_cycle,
  j2.`exam_level` AS original_certificate__exam_level,
  j2.`exam_level_level` AS original_certificate__exam_level_level,
  j2.`token` AS original_certificate__token,
  j2.`file` AS original_certificate__file,
  j2.`sent_to_inspector` AS original_certificate__sent_to_inspector,
  j2.`sent_to_inspector_date` AS original_certificate__sent_to_inspector_date,
  j2.`sent_to_acqpa` AS original_certificate__sent_to_acqpa,
  j2.`sent_to_acqpa_date` AS original_certificate__sent_to_acqpa_date,
  j2.`reminder_6_month_sent` AS original_certificate__reminder_6_month_sent,
  j2.`reminder_6_month_sent_date` AS original_certificate__reminder_6_month_sent_date,
  j2.`reminder_3_month_sent` AS original_certificate__reminder_3_month_sent,
  j2.`reminder_3_month_sent_date` AS original_certificate__reminder_3_month_sent_date,
  j2.`reminder_1_month_sent` AS original_certificate__reminder_1_month_sent,
  j2.`reminder_1_month_sent_date` AS original_certificate__reminder_1_month_sent_date,
  j2.`reminder_0_day_sent` AS original_certificate__reminder_0_day_sent,
  j2.`reminder_0_day_sent_date` AS original_certificate__reminder_0_day_sent_date,
  j2.`original_certificate` AS original_certificate__original_certificate,
  j2.`original_certificate_obtained_date` AS original_certificate__original_certificate_obtained_date,
  j2.`registration` AS original_certificate__registration,
  j2.`registration_reference` AS original_certificate__registration_reference,
  j2.`registration_renewal_no` AS original_certificate__registration_renewal_no,
  j2.`replaced` AS original_certificate__replaced,
  j2.`replaced_by` AS original_certificate__replaced_by,
  j2.`replaced_date` AS original_certificate__replaced_date,
  j2.`replaced_user` AS original_certificate__replaced_user,
  j2.`replaced_reason` AS original_certificate__replaced_reason,
  j2.`merged` AS original_certificate__merged,
  j2.`merged_to` AS original_certificate__merged_to,
  j2.`merged_date` AS original_certificate__merged_date,
  j2.`merged_user` AS original_certificate__merged_user,
  j2.`merged_reason` AS original_certificate__merged_reason,
  j2.`first_edition` AS original_certificate__first_edition,
  j2.`v1_imported` AS original_certificate__v1_imported,
  j2.`v1_id` AS original_certificate__v1_id,
  j2.`v1_source` AS original_certificate__v1_source,
  j2.`v1_details` AS original_certificate__v1_details,
  j2.`v1_comment` AS original_certificate__v1_comment,
  j3.`id` AS registration__id,
  j3.`tstamp` AS registration__tstamp,
  j3.`created_at` AS registration__created_at,
  j3.`inspector` AS registration__inspector,
  j3.`certificate` AS registration__certificate,
  j3.`exam_cycle` AS registration__exam_cycle,
  j3.`member` AS registration__member,
  j3.`registration_source` AS registration__registration_source,
  j3.`status` AS registration__status,
  j3.`status_date` AS registration__status_date,
  j3.`frosio_folder_sent_date` AS registration__frosio_folder_sent_date,
  j3.`reference` AS registration__reference,
  j3.`lastname` AS registration__lastname,
  j3.`firstname` AS registration__firstname,
  j3.`gender` AS registration__gender,
  j3.`date_of_birth` AS registration__date_of_birth,
  j3.`place_of_birth` AS registration__place_of_birth,
  j3.`country_of_birth` AS registration__country_of_birth,
  j3.`phone` AS registration__phone,
  j3.`email` AS registration__email,
  j3.`company_none` AS registration__company_none,
  j3.`company_independant` AS registration__company_independant,
  j3.`company_siret` AS registration__company_siret,
  j3.`company_name` AS registration__company_name,
  j3.`company_street` AS registration__company_street,
  j3.`company_street_2` AS registration__company_street_2,
  j3.`company_postal` AS registration__company_postal,
  j3.`company_city` AS registration__company_city,
  j3.`company_country` AS registration__company_country,
  j3.`company_email` AS registration__company_email,
  j3.`company_phone` AS registration__company_phone,
  j3.`company_contact_firstname` AS registration__company_contact_firstname,
  j3.`company_contact_lastname` AS registration__company_contact_lastname,
  j3.`company_contact_email` AS registration__company_contact_email,
  j3.`company_contact_phone` AS registration__company_contact_phone,
  j3.`company_signatory_position` AS registration__company_signatory_position,
  j3.`company_signatory_firstname` AS registration__company_signatory_firstname,
  j3.`company_signatory_lastname` AS registration__company_signatory_lastname,
  j3.`company_signatory_email` AS registration__company_signatory_email,
  j3.`company_signatory_phone` AS registration__company_signatory_phone,
  j3.`identity_picture` AS registration__identity_picture,
  j3.`identity_picture_validation_status` AS registration__identity_picture_validation_status,
  j3.`identity_picture_validation_date` AS registration__identity_picture_validation_date,
  j3.`identity_picture_validation_comment` AS registration__identity_picture_validation_comment,
  j3.`identity_piece_recto` AS registration__identity_piece_recto,
  j3.`identity_piece_recto_type` AS registration__identity_piece_recto_type,
  j3.`identity_piece_recto_validation_status` AS registration__identity_piece_recto_validation_status,
  j3.`identity_piece_recto_validation_date` AS registration__identity_piece_recto_validation_date,
  j3.`identity_piece_recto_validation_comment` AS registration__identity_piece_recto_validation_comment,
  j3.`identity_piece_verso` AS registration__identity_piece_verso,
  j3.`identity_piece_verso_type` AS registration__identity_piece_verso_type,
  j3.`identity_piece_verso_validation_status` AS registration__identity_piece_verso_validation_status,
  j3.`identity_piece_verso_validation_date` AS registration__identity_piece_verso_validation_date,
  j3.`identity_piece_verso_validation_comment` AS registration__identity_piece_verso_validation_comment,
  j3.`cv` AS registration__cv,
  j3.`details` AS registration__details,
  j3.`street` AS registration__street,
  j3.`street_2` AS registration__street_2,
  j3.`postal` AS registration__postal,
  j3.`city` AS registration__city,
  j3.`state` AS registration__state,
  j3.`country` AS registration__country,
  j3.`archived` AS registration__archived,
  j3.`archived_at` AS registration__archived_at,
  j3.`exam_level` AS registration__exam_level,
  j3.`exam_level_given` AS registration__exam_level_given,
  j3.`exam_level_given_reason` AS registration__exam_level_given_reason,
  j3.`type` AS registration__type,
  j3.`renewal_no` AS registration__renewal_no,
  j3.`redo_changes` AS registration__redo_changes,
  j3.`redo_attempt_no` AS registration__redo_attempt_no,
  j3.`exam_session` AS registration__exam_session,
  j3.`exam_session_choice` AS registration__exam_session_choice,
  j3.`exam_session_given` AS registration__exam_session_given,
  j3.`exam_session_formation_choice` AS registration__exam_session_formation_choice,
  j3.`exam_custom_dates` AS registration__exam_custom_dates,
  j3.`exam_theorical_do` AS registration__exam_theorical_do,
  j3.`exam_theorical_review` AS registration__exam_theorical_review,
  j3.`exam_theorical_date_start` AS registration__exam_theorical_date_start,
  j3.`exam_theorical_date_end` AS registration__exam_theorical_date_end,
  j3.`exam_practical_do` AS registration__exam_practical_do,
  j3.`exam_practical_review` AS registration__exam_practical_review,
  j3.`exam_practical_date_start` AS registration__exam_practical_date_start,
  j3.`exam_practical_date_end` AS registration__exam_practical_date_end,
  j3.`exam_training_mandatory` AS registration__exam_training_mandatory,
  j3.`exam_theorical_mark_minimal` AS registration__exam_theorical_mark_minimal,
  j3.`exam_theorical_mark_maximal` AS registration__exam_theorical_mark_maximal,
  j3.`exam_practical_mark_minimal` AS registration__exam_practical_mark_minimal,
  j3.`exam_practical_mark_maximal` AS registration__exam_practical_mark_maximal,
  j3.`exam_theorical_convocation_sent` AS registration__exam_theorical_convocation_sent,
  j3.`exam_theorical_convocation_sent_date` AS registration__exam_theorical_convocation_sent_date,
  j3.`exam_practical_convocation_sent` AS registration__exam_practical_convocation_sent,
  j3.`exam_practical_convocation_sent_date` AS registration__exam_practical_convocation_sent_date,
  j3.`invoice_same_as_company` AS registration__invoice_same_as_company,
  j3.`invoice_phone` AS registration__invoice_phone,
  j3.`invoice_siret` AS registration__invoice_siret,
  j3.`invoice_company` AS registration__invoice_company,
  j3.`invoice_street` AS registration__invoice_street,
  j3.`invoice_street_2` AS registration__invoice_street_2,
  j3.`invoice_postal` AS registration__invoice_postal,
  j3.`invoice_city` AS registration__invoice_city,
  j3.`invoice_country` AS registration__invoice_country,
  j3.`invoice_address_choice` AS registration__invoice_address_choice,
  j3.`invoice_email` AS registration__invoice_email,
  j3.`invoice_lastname` AS registration__invoice_lastname,
  j3.`invoice_firstname` AS registration__invoice_firstname,
  j3.`comment_additionnal` AS registration__comment_additionnal,
  j3.`certify_data_exact` AS registration__certify_data_exact,
  j3.`accept_special_regulations` AS registration__accept_special_regulations,
  j3.`accept_no_reputation_harm_acqpa` AS registration__accept_no_reputation_harm_acqpa,
  j3.`accept_to_pay` AS registration__accept_to_pay,
  j3.`has_complaints` AS registration__has_complaints,
  j3.`has_abusive_usage` AS registration__has_abusive_usage,
  j3.`accept_personal_data_share` AS registration__accept_personal_data_share,
  j3.`api_company_appear_by_inspector` AS registration__api_company_appear_by_inspector,
  j3.`api_company_email_for_agreement` AS registration__api_company_email_for_agreement,
  j3.`api_company_email_for_agreement_date_sent` AS registration__api_company_email_for_agreement_date_sent,
  j3.`signature_inspector` AS registration__signature_inspector,
  j3.`signature_inspector_checkbox` AS registration__signature_inspector_checkbox,
  j3.`signature_inspector_date` AS registration__signature_inspector_date,
  j3.`signature_company` AS registration__signature_company,
  j3.`signature_company_checkbox` AS registration__signature_company_checkbox,
  j3.`signature_company_date` AS registration__signature_company_date,
  j3.`signature_company_siret` AS registration__signature_company_siret,
  j3.`signature_company_lastname` AS registration__signature_company_lastname,
  j3.`signature_company_firstname` AS registration__signature_company_firstname,
  j3.`signature_company_position` AS registration__signature_company_position,
  j3.`signature_company_service` AS registration__signature_company_service,
  j3.`signature_company_email` AS registration__signature_company_email,
  j3.`signature_company_phone` AS registration__signature_company_phone,
  j3.`signature_company_comments` AS registration__signature_company_comments,
  j3.`exam_theorical_set` AS registration__exam_theorical_set,
  j3.`result_exam_theorical_mark` AS registration__result_exam_theorical_mark,
  j3.`result_exam_theorical_mark_double_correction` AS registration__result_exam_theorical_mark_double_correction,
  j3.`result_exam_theorical_status` AS registration__result_exam_theorical_status,
  j3.`result_exam_theorical_status_date` AS registration__result_exam_theorical_status_date,
  j3.`result_exam_theorical_validity_date_end` AS registration__result_exam_theorical_validity_date_end,
  j3.`result_exam_practical_mark` AS registration__result_exam_practical_mark,
  j3.`result_exam_practical_mark_double_correction` AS registration__result_exam_practical_mark_double_correction,
  j3.`result_exam_practical_status` AS registration__result_exam_practical_status,
  j3.`result_exam_practical_status_date` AS registration__result_exam_practical_status_date,
  j3.`result_exam_practical_validity_date_end` AS registration__result_exam_practical_validity_date_end,
  j3.`result_exam_mock` AS registration__result_exam_mock,
  j3.`duration_week` AS registration__duration_week,
  j3.`duration_month` AS registration__duration_month,
  j3.`payment_done` AS registration__payment_done,
  j3.`payment_date` AS registration__payment_date,
  j4.`id` AS replaced_by__id,
  j4.`tstamp` AS replaced_by__tstamp,
  j4.`created_at` AS replaced_by__created_at,
  j4.`inspector` AS replaced_by__inspector,
  j4.`number` AS replaced_by__number,
  j4.`status` AS replaced_by__status,
  j4.`date_cci` AS replaced_by__date_cci,
  j4.`obtained_date` AS replaced_by__obtained_date,
  j4.`validity_date_end` AS replaced_by__validity_date_end,
  j4.`revoked_at` AS replaced_by__revoked_at,
  j4.`revoked_reason` AS replaced_by__revoked_reason,
  j4.`inspector_firstname` AS replaced_by__inspector_firstname,
  j4.`inspector_lastname` AS replaced_by__inspector_lastname,
  j4.`inspector_date_of_birth` AS replaced_by__inspector_date_of_birth,
  j4.`inspector_acqpa_number` AS replaced_by__inspector_acqpa_number,
  j4.`exam_type` AS replaced_by__exam_type,
  j4.`exam_cycle` AS replaced_by__exam_cycle,
  j4.`exam_level` AS replaced_by__exam_level,
  j4.`exam_level_level` AS replaced_by__exam_level_level,
  j4.`token` AS replaced_by__token,
  j4.`file` AS replaced_by__file,
  j4.`sent_to_inspector` AS replaced_by__sent_to_inspector,
  j4.`sent_to_inspector_date` AS replaced_by__sent_to_inspector_date,
  j4.`sent_to_acqpa` AS replaced_by__sent_to_acqpa,
  j4.`sent_to_acqpa_date` AS replaced_by__sent_to_acqpa_date,
  j4.`reminder_6_month_sent` AS replaced_by__reminder_6_month_sent,
  j4.`reminder_6_month_sent_date` AS replaced_by__reminder_6_month_sent_date,
  j4.`reminder_3_month_sent` AS replaced_by__reminder_3_month_sent,
  j4.`reminder_3_month_sent_date` AS replaced_by__reminder_3_month_sent_date,
  j4.`reminder_1_month_sent` AS replaced_by__reminder_1_month_sent,
  j4.`reminder_1_month_sent_date` AS replaced_by__reminder_1_month_sent_date,
  j4.`reminder_0_day_sent` AS replaced_by__reminder_0_day_sent,
  j4.`reminder_0_day_sent_date` AS replaced_by__reminder_0_day_sent_date,
  j4.`original_certificate` AS replaced_by__original_certificate,
  j4.`original_certificate_obtained_date` AS replaced_by__original_certificate_obtained_date,
  j4.`registration` AS replaced_by__registration,
  j4.`registration_reference` AS replaced_by__registration_reference,
  j4.`registration_renewal_no` AS replaced_by__registration_renewal_no,
  j4.`replaced` AS replaced_by__replaced,
  j4.`replaced_by` AS replaced_by__replaced_by,
  j4.`replaced_date` AS replaced_by__replaced_date,
  j4.`replaced_user` AS replaced_by__replaced_user,
  j4.`replaced_reason` AS replaced_by__replaced_reason,
  j4.`merged` AS replaced_by__merged,
  j4.`merged_to` AS replaced_by__merged_to,
  j4.`merged_date` AS replaced_by__merged_date,
  j4.`merged_user` AS replaced_by__merged_user,
  j4.`merged_reason` AS replaced_by__merged_reason,
  j4.`first_edition` AS replaced_by__first_edition,
  j4.`v1_imported` AS replaced_by__v1_imported,
  j4.`v1_id` AS replaced_by__v1_id,
  j4.`v1_source` AS replaced_by__v1_source,
  j4.`v1_details` AS replaced_by__v1_details,
  j4.`v1_comment` AS replaced_by__v1_comment,
  j5.`id` AS replaced_user__id,
  j5.`tstamp` AS replaced_user__tstamp,
  j5.`username` AS replaced_user__username,
  j5.`name` AS replaced_user__name,
  j5.`email` AS replaced_user__email,
  j5.`language` AS replaced_user__language,
  j5.`backendTheme` AS replaced_user__backendTheme,
  j5.`uploader` AS replaced_user__uploader,
  j5.`showHelp` AS replaced_user__showHelp,
  j5.`thumbnails` AS replaced_user__thumbnails,
  j5.`useRTE` AS replaced_user__useRTE,
  j5.`useCE` AS replaced_user__useCE,
  j5.`doNotCollapse` AS replaced_user__doNotCollapse,
  j5.`password` AS replaced_user__password,
  j5.`pwChange` AS replaced_user__pwChange,
  j5.`admin` AS replaced_user__admin,
  j5.`groups` AS replaced_user__groups,
  j5.`inherit` AS replaced_user__inherit,
  j5.`modules` AS replaced_user__modules,
  j5.`themes` AS replaced_user__themes,
  j5.`elements` AS replaced_user__elements,
  j5.`fields` AS replaced_user__fields,
  j5.`frontendModules` AS replaced_user__frontendModules,
  j5.`pagemounts` AS replaced_user__pagemounts,
  j5.`alpty` AS replaced_user__alpty,
  j5.`filemounts` AS replaced_user__filemounts,
  j5.`fop` AS replaced_user__fop,
  j5.`imageSizes` AS replaced_user__imageSizes,
  j5.`forms` AS replaced_user__forms,
  j5.`formp` AS replaced_user__formp,
  j5.`amg` AS replaced_user__amg,
  j5.`disable` AS replaced_user__disable,
  j5.`start` AS replaced_user__start,
  j5.`stop` AS replaced_user__stop,
  j5.`session` AS replaced_user__session,
  j5.`dateAdded` AS replaced_user__dateAdded,
  j5.`secret` AS replaced_user__secret,
  j5.`useTwoFactor` AS replaced_user__useTwoFactor,
  j5.`lastLogin` AS replaced_user__lastLogin,
  j5.`currentLogin` AS replaced_user__currentLogin,
  j5.`backupCodes` AS replaced_user__backupCodes,
  j5.`trustedTokenVersion` AS replaced_user__trustedTokenVersion,
  j5.`faqs` AS replaced_user__faqs,
  j5.`faqp` AS replaced_user__faqp,
  j5.`news` AS replaced_user__news,
  j5.`newp` AS replaced_user__newp,
  j5.`calendars` AS replaced_user__calendars,
  j5.`calendarp` AS replaced_user__calendarp,
  j5.`calendarfeeds` AS replaced_user__calendarfeeds,
  j5.`calendarfeedp` AS replaced_user__calendarfeedp,
  j5.`newsletters` AS replaced_user__newsletters,
  j5.`newsletterp` AS replaced_user__newsletterp,
  j5.`pageLanguageLabels` AS replaced_user__pageLanguageLabels,
  j6.`id` AS merged_to__id,
  j6.`tstamp` AS merged_to__tstamp,
  j6.`created_at` AS merged_to__created_at,
  j6.`inspector` AS merged_to__inspector,
  j6.`number` AS merged_to__number,
  j6.`status` AS merged_to__status,
  j6.`date_cci` AS merged_to__date_cci,
  j6.`obtained_date` AS merged_to__obtained_date,
  j6.`validity_date_end` AS merged_to__validity_date_end,
  j6.`revoked_at` AS merged_to__revoked_at,
  j6.`revoked_reason` AS merged_to__revoked_reason,
  j6.`inspector_firstname` AS merged_to__inspector_firstname,
  j6.`inspector_lastname` AS merged_to__inspector_lastname,
  j6.`inspector_date_of_birth` AS merged_to__inspector_date_of_birth,
  j6.`inspector_acqpa_number` AS merged_to__inspector_acqpa_number,
  j6.`exam_type` AS merged_to__exam_type,
  j6.`exam_cycle` AS merged_to__exam_cycle,
  j6.`exam_level` AS merged_to__exam_level,
  j6.`exam_level_level` AS merged_to__exam_level_level,
  j6.`token` AS merged_to__token,
  j6.`file` AS merged_to__file,
  j6.`sent_to_inspector` AS merged_to__sent_to_inspector,
  j6.`sent_to_inspector_date` AS merged_to__sent_to_inspector_date,
  j6.`sent_to_acqpa` AS merged_to__sent_to_acqpa,
  j6.`sent_to_acqpa_date` AS merged_to__sent_to_acqpa_date,
  j6.`reminder_6_month_sent` AS merged_to__reminder_6_month_sent,
  j6.`reminder_6_month_sent_date` AS merged_to__reminder_6_month_sent_date,
  j6.`reminder_3_month_sent` AS merged_to__reminder_3_month_sent,
  j6.`reminder_3_month_sent_date` AS merged_to__reminder_3_month_sent_date,
  j6.`reminder_1_month_sent` AS merged_to__reminder_1_month_sent,
  j6.`reminder_1_month_sent_date` AS merged_to__reminder_1_month_sent_date,
  j6.`reminder_0_day_sent` AS merged_to__reminder_0_day_sent,
  j6.`reminder_0_day_sent_date` AS merged_to__reminder_0_day_sent_date,
  j6.`original_certificate` AS merged_to__original_certificate,
  j6.`original_certificate_obtained_date` AS merged_to__original_certificate_obtained_date,
  j6.`registration` AS merged_to__registration,
  j6.`registration_reference` AS merged_to__registration_reference,
  j6.`registration_renewal_no` AS merged_to__registration_renewal_no,
  j6.`replaced` AS merged_to__replaced,
  j6.`replaced_by` AS merged_to__replaced_by,
  j6.`replaced_date` AS merged_to__replaced_date,
  j6.`replaced_user` AS merged_to__replaced_user,
  j6.`replaced_reason` AS merged_to__replaced_reason,
  j6.`merged` AS merged_to__merged,
  j6.`merged_to` AS merged_to__merged_to,
  j6.`merged_date` AS merged_to__merged_date,
  j6.`merged_user` AS merged_to__merged_user,
  j6.`merged_reason` AS merged_to__merged_reason,
  j6.`first_edition` AS merged_to__first_edition,
  j6.`v1_imported` AS merged_to__v1_imported,
  j6.`v1_id` AS merged_to__v1_id,
  j6.`v1_source` AS merged_to__v1_source,
  j6.`v1_details` AS merged_to__v1_details,
  j6.`v1_comment` AS merged_to__v1_comment,
  j7.`id` AS merged_user__id,
  j7.`tstamp` AS merged_user__tstamp,
  j7.`username` AS merged_user__username,
  j7.`name` AS merged_user__name,
  j7.`email` AS merged_user__email,
  j7.`language` AS merged_user__language,
  j7.`backendTheme` AS merged_user__backendTheme,
  j7.`uploader` AS merged_user__uploader,
  j7.`showHelp` AS merged_user__showHelp,
  j7.`thumbnails` AS merged_user__thumbnails,
  j7.`useRTE` AS merged_user__useRTE,
  j7.`useCE` AS merged_user__useCE,
  j7.`doNotCollapse` AS merged_user__doNotCollapse,
  j7.`password` AS merged_user__password,
  j7.`pwChange` AS merged_user__pwChange,
  j7.`admin` AS merged_user__admin,
  j7.`groups` AS merged_user__groups,
  j7.`inherit` AS merged_user__inherit,
  j7.`modules` AS merged_user__modules,
  j7.`themes` AS merged_user__themes,
  j7.`elements` AS merged_user__elements,
  j7.`fields` AS merged_user__fields,
  j7.`frontendModules` AS merged_user__frontendModules,
  j7.`pagemounts` AS merged_user__pagemounts,
  j7.`alpty` AS merged_user__alpty,
  j7.`filemounts` AS merged_user__filemounts,
  j7.`fop` AS merged_user__fop,
  j7.`imageSizes` AS merged_user__imageSizes,
  j7.`forms` AS merged_user__forms,
  j7.`formp` AS merged_user__formp,
  j7.`amg` AS merged_user__amg,
  j7.`disable` AS merged_user__disable,
  j7.`start` AS merged_user__start,
  j7.`stop` AS merged_user__stop,
  j7.`session` AS merged_user__session,
  j7.`dateAdded` AS merged_user__dateAdded,
  j7.`secret` AS merged_user__secret,
  j7.`useTwoFactor` AS merged_user__useTwoFactor,
  j7.`lastLogin` AS merged_user__lastLogin,
  j7.`currentLogin` AS merged_user__currentLogin,
  j7.`backupCodes` AS merged_user__backupCodes,
  j7.`trustedTokenVersion` AS merged_user__trustedTokenVersion,
  j7.`faqs` AS merged_user__faqs,
  j7.`faqp` AS merged_user__faqp,
  j7.`news` AS merged_user__news,
  j7.`newp` AS merged_user__newp,
  j7.`calendars` AS merged_user__calendars,
  j7.`calendarp` AS merged_user__calendarp,
  j7.`calendarfeeds` AS merged_user__calendarfeeds,
  j7.`calendarfeedp` AS merged_user__calendarfeedp,
  j7.`newsletters` AS merged_user__newsletters,
  j7.`newsletterp` AS merged_user__newsletterp,
  j7.`pageLanguageLabels` AS merged_user__pageLanguageLabels
FROM
  tl_acqpa_ins_certificate
  LEFT JOIN tl_acqpa_ins_inspector j1 ON tl_acqpa_ins_certificate.`inspector` = j1.id
  LEFT JOIN tl_acqpa_ins_certificate j2 ON tl_acqpa_ins_certificate.`original_certificate` = j2.id
  LEFT JOIN tl_acqpa_ins_registration j3 ON tl_acqpa_ins_certificate.`registration` = j3.id
  LEFT JOIN tl_acqpa_ins_certificate j4 ON tl_acqpa_ins_certificate.`replaced_by` = j4.id
  LEFT JOIN tl_user j5 ON tl_acqpa_ins_certificate.`replaced_user` = j5.id
  LEFT JOIN tl_acqpa_ins_certificate j6 ON tl_acqpa_ins_certificate.`merged_to` = j6.id
  LEFT JOIN tl_user j7 ON tl_acqpa_ins_certificate.`merged_user` = j7.id
WHERE
  (
    tl_acqpa_ins_certificate.number LIKE '/%'
  )
  AND (
    tl_acqpa_ins_certificate.obtained_date <= UNIX_TIMESTAMP(
      CURRENT_TIMESTAMP()
    )
    AND tl_acqpa_ins_certificate.validity_date_end >= UNIX_TIMESTAMP(
      CURRENT_TIMESTAMP()
    )
    AND (
      tl_acqpa_ins_certificate.revoked_at IS NULL
      OR tl_acqpa_ins_certificate.revoked_at >= UNIX_TIMESTAMP(
        CURRENT_TIMESTAMP()
      )
      OR LENGTH(
        tl_acqpa_ins_certificate.revoked_at
      ) = 0
    )
  )
ORDER BY
  tl_acqpa_ins_certificate.created_at ASC
LIMIT
  0, 1

SELECT tl_acqpa_ins_certificate.*, j1.`id` AS inspector__id, j1.`tstamp` AS inspector__tstamp, j1.`created_at` AS inspector__created_at, j1.`lastname` AS inspector__lastname, j1.`firstname` AS inspector__firstname, j1.`gender` AS inspector__gender, j1.`acqpa_number` AS inspector__acqpa_number, j1.`frosio_number` AS inspector__frosio_number, j1.`accredible_url` AS inspector__accredible_url, j1.`first_certification_date` AS inspector__first_certification_date, j1.`candidate` AS inspector__candidate, j1.`accept_personal_data_share` AS inspector__accept_personal_data_share, j1.`api_company_appear_by_inspector` AS inspector__api_company_appear_by_inspector, j1.`api_company_email_for_agreement` AS inspector__api_company_email_for_agreement, j1.`api_company_email_for_agreement_date_sent` AS inspector__api_company_email_for_agreement_date_sent, j1.`api_company_appear_by_acqpa_status` AS inspector__api_company_appear_by_acqpa_status, j1.`api_company_appear_by_acqpa_date` AS inspector__api_company_appear_by_acqpa_date, j1.`alias` AS inspector__alias, j1.`date_of_birth` AS inspector__date_of_birth, j1.`place_of_birth` AS inspector__place_of_birth, j1.`country_of_birth` AS inspector__country_of_birth, j1.`company_none` AS inspector__company_none, j1.`company_independant` AS inspector__company_independant, j1.`company_siret` AS inspector__company_siret, j1.`company_name` AS inspector__company_name, j1.`company_street` AS inspector__company_street, j1.`company_street_2` AS inspector__company_street_2, j1.`company_postal` AS inspector__company_postal, j1.`company_city` AS inspector__company_city, j1.`company_country` AS inspector__company_country, j1.`company_email` AS inspector__company_email, j1.`company_phone` AS inspector__company_phone, j1.`company_contact_firstname` AS inspector__company_contact_firstname, j1.`company_contact_lastname` AS inspector__company_contact_lastname, j1.`company_contact_email` AS inspector__company_contact_email, j1.`company_contact_phone` AS inspector__company_contact_phone, j1.`phone` AS inspector__phone, j1.`email` AS inspector__email, j1.`identity_picture` AS inspector__identity_picture, j1.`identity_picture_validation_status` AS inspector__identity_picture_validation_status, j1.`identity_picture_validation_date` AS inspector__identity_picture_validation_date, j1.`identity_picture_validation_comment` AS inspector__identity_picture_validation_comment, j1.`identity_piece_recto` AS inspector__identity_piece_recto, j1.`identity_piece_recto_type` AS inspector__identity_piece_recto_type, j1.`identity_piece_recto_validation_status` AS inspector__identity_piece_recto_validation_status, j1.`identity_piece_recto_validation_date` AS inspector__identity_piece_recto_validation_date, j1.`identity_piece_recto_validation_comment` AS inspector__identity_piece_recto_validation_comment, j1.`identity_piece_verso` AS inspector__identity_piece_verso, j1.`identity_piece_verso_type` AS inspector__identity_piece_verso_type, j1.`identity_piece_verso_validation_status` AS inspector__identity_piece_verso_validation_status, j1.`identity_piece_verso_validation_date` AS inspector__identity_piece_verso_validation_date, j1.`identity_piece_verso_validation_comment` AS inspector__identity_piece_verso_validation_comment, j1.`cv` AS inspector__cv, j1.`details` AS inspector__details, j1.`street` AS inspector__street, j1.`street_2` AS inspector__street_2, j1.`postal` AS inspector__postal, j1.`city` AS inspector__city, j1.`state` AS inspector__state, j1.`country` AS inspector__country, j1.`invoice_same_as_company` AS inspector__invoice_same_as_company, j1.`invoice_siret` AS inspector__invoice_siret, j1.`invoice_company` AS inspector__invoice_company, j1.`invoice_street` AS inspector__invoice_street, j1.`invoice_street_2` AS inspector__invoice_street_2, j1.`invoice_postal` AS inspector__invoice_postal, j1.`invoice_city` AS inspector__invoice_city, j1.`invoice_country` AS inspector__invoice_country, j1.`invoice_email` AS inspector__invoice_email, j1.`invoice_phone` AS inspector__invoice_phone, j1.`invoice_lastname` AS inspector__invoice_lastname, j1.`invoice_firstname` AS inspector__invoice_firstname, j1.`archived` AS inspector__archived, j1.`archived_at` AS inspector__archived_at, j1.`alias_deduplication` AS inspector__alias_deduplication, j1.`v1_imported` AS inspector__v1_imported, j1.`v1_id` AS inspector__v1_id, j1.`v1_source` AS inspector__v1_source, j1.`v1_details` AS inspector__v1_details, j2.`id` AS original_certificate__id, j2.`tstamp` AS original_certificate__tstamp, j2.`created_at` AS original_certificate__created_at, j2.`inspector` AS original_certificate__inspector, j2.`number` AS original_certificate__number, j2.`status` AS original_certificate__status, j2.`date_cci` AS original_certificate__date_cci, j2.`obtained_date` AS original_certificate__obtained_date, j2.`validity_date_end` AS original_certificate__validity_date_end, j2.`revoked_at` AS original_certificate__revoked_at, j2.`revoked_reason` AS original_certificate__revoked_reason, j2.`inspector_firstname` AS original_certificate__inspector_firstname, j2.`inspector_lastname` AS original_certificate__inspector_lastname, j2.`inspector_date_of_birth` AS original_certificate__inspector_date_of_birth, j2.`inspector_acqpa_number` AS original_certificate__inspector_acqpa_number, j2.`exam_type` AS original_certificate__exam_type, j2.`exam_cycle` AS original_certificate__exam_cycle, j2.`exam_level` AS original_certificate__exam_level, j2.`exam_level_level` AS original_certificate__exam_level_level, j2.`token` AS original_certificate__token, j2.`file` AS original_certificate__file, j2.`sent_to_inspector` AS original_certificate__sent_to_inspector, j2.`sent_to_inspector_date` AS original_certificate__sent_to_inspector_date, j2.`sent_to_acqpa` AS original_certificate__sent_to_acqpa, j2.`sent_to_acqpa_date` AS original_certificate__sent_to_acqpa_date, j2.`reminder_6_month_sent` AS original_certificate__reminder_6_month_sent, j2.`reminder_6_month_sent_date` AS original_certificate__reminder_6_month_sent_date, j2.`reminder_3_month_sent` AS original_certificate__reminder_3_month_sent, j2.`reminder_3_month_sent_date` AS original_certificate__reminder_3_month_sent_date, j2.`reminder_1_month_sent` AS original_certificate__reminder_1_month_sent, j2.`reminder_1_month_sent_date` AS original_certificate__reminder_1_month_sent_date, j2.`reminder_0_day_sent` AS original_certificate__reminder_0_day_sent, j2.`reminder_0_day_sent_date` AS original_certificate__reminder_0_day_sent_date, j2.`original_certificate` AS original_certificate__original_certificate, j2.`original_certificate_obtained_date` AS original_certificate__original_certificate_obtained_date, j2.`registration` AS original_certificate__registration, j2.`registration_reference` AS original_certificate__registration_reference, j2.`registration_renewal_no` AS original_certificate__registration_renewal_no, j2.`replaced` AS original_certificate__replaced, j2.`replaced_by` AS original_certificate__replaced_by, j2.`replaced_date` AS original_certificate__replaced_date, j2.`replaced_user` AS original_certificate__replaced_user, j2.`replaced_reason` AS original_certificate__replaced_reason, j2.`merged` AS original_certificate__merged, j2.`merged_to` AS original_certificate__merged_to, j2.`merged_date` AS original_certificate__merged_date, j2.`merged_user` AS original_certificate__merged_user, j2.`merged_reason` AS original_certificate__merged_reason, j2.`first_edition` AS original_certificate__first_edition, j2.`v1_imported` AS original_certificate__v1_imported, j2.`v1_id` AS original_certificate__v1_id, j2.`v1_source` AS original_certificate__v1_source, j2.`v1_details` AS original_certificate__v1_details, j2.`v1_comment` AS original_certificate__v1_comment, j3.`id` AS registration__id, j3.`tstamp` AS registration__tstamp, j3.`created_at` AS registration__created_at, j3.`inspector` AS registration__inspector, j3.`certificate` AS registration__certificate, j3.`exam_cycle` AS registration__exam_cycle, j3.`member` AS registration__member, j3.`registration_source` AS registration__registration_source, j3.`status` AS registration__status, j3.`status_date` AS registration__status_date, j3.`frosio_folder_sent_date` AS registration__frosio_folder_sent_date, j3.`reference` AS registration__reference, j3.`lastname` AS registration__lastname, j3.`firstname` AS registration__firstname, j3.`gender` AS registration__gender, j3.`date_of_birth` AS registration__date_of_birth, j3.`place_of_birth` AS registration__place_of_birth, j3.`country_of_birth` AS registration__country_of_birth, j3.`phone` AS registration__phone, j3.`email` AS registration__email, j3.`company_none` AS registration__company_none, j3.`company_independant` AS registration__company_independant, j3.`company_siret` AS registration__company_siret, j3.`company_name` AS registration__company_name, j3.`company_street` AS registration__company_street, j3.`company_street_2` AS registration__company_street_2, j3.`company_postal` AS registration__company_postal, j3.`company_city` AS registration__company_city, j3.`company_country` AS registration__company_country, j3.`company_email` AS registration__company_email, j3.`company_phone` AS registration__company_phone, j3.`company_contact_firstname` AS registration__company_contact_firstname, j3.`company_contact_lastname` AS registration__company_contact_lastname, j3.`company_contact_email` AS registration__company_contact_email, j3.`company_contact_phone` AS registration__company_contact_phone, j3.`company_signatory_position` AS registration__company_signatory_position, j3.`company_signatory_firstname` AS registration__company_signatory_firstname, j3.`company_signatory_lastname` AS registration__company_signatory_lastname, j3.`company_signatory_email` AS registration__company_signatory_email, j3.`company_signatory_phone` AS registration__company_signatory_phone, j3.`identity_picture` AS registration__identity_picture, j3.`identity_picture_validation_status` AS registration__identity_picture_validation_status, j3.`identity_picture_validation_date` AS registration__identity_picture_validation_date, j3.`identity_picture_validation_comment` AS registration__identity_picture_validation_comment, j3.`identity_piece_recto` AS registration__identity_piece_recto, j3.`identity_piece_recto_type` AS registration__identity_piece_recto_type, j3.`identity_piece_recto_validation_status` AS registration__identity_piece_recto_validation_status, j3.`identity_piece_recto_validation_date` AS registration__identity_piece_recto_validation_date, j3.`identity_piece_recto_validation_comment` AS registration__identity_piece_recto_validation_comment, j3.`identity_piece_verso` AS registration__identity_piece_verso, j3.`identity_piece_verso_type` AS registration__identity_piece_verso_type, j3.`identity_piece_verso_validation_status` AS registration__identity_piece_verso_validation_status, j3.`identity_piece_verso_validation_date` AS registration__identity_piece_verso_validation_date, j3.`identity_piece_verso_validation_comment` AS registration__identity_piece_verso_validation_comment, j3.`cv` AS registration__cv, j3.`details` AS registration__details, j3.`street` AS registration__street, j3.`street_2` AS registration__street_2, j3.`postal` AS registration__postal, j3.`city` AS registration__city, j3.`state` AS registration__state, j3.`country` AS registration__country, j3.`archived` AS registration__archived, j3.`archived_at` AS registration__archived_at, j3.`exam_level` AS registration__exam_level, j3.`exam_level_given` AS registration__exam_level_given, j3.`exam_level_given_reason` AS registration__exam_level_given_reason, j3.`type` AS registration__type, j3.`renewal_no` AS registration__renewal_no, j3.`redo_changes` AS registration__redo_changes, j3.`redo_attempt_no` AS registration__redo_attempt_no, j3.`exam_session` AS registration__exam_session, j3.`exam_session_choice` AS registration__exam_session_choice, j3.`exam_session_given` AS registration__exam_session_given, j3.`exam_session_formation_choice` AS registration__exam_session_formation_choice, j3.`exam_custom_dates` AS registration__exam_custom_dates, j3.`exam_theorical_do` AS registration__exam_theorical_do, j3.`exam_theorical_review` AS registration__exam_theorical_review, j3.`exam_theorical_date_start` AS registration__exam_theorical_date_start, j3.`exam_theorical_date_end` AS registration__exam_theorical_date_end, j3.`exam_practical_do` AS registration__exam_practical_do, j3.`exam_practical_review` AS registration__exam_practical_review, j3.`exam_practical_date_start` AS registration__exam_practical_date_start, j3.`exam_practical_date_end` AS registration__exam_practical_date_end, j3.`exam_training_mandatory` AS registration__exam_training_mandatory, j3.`exam_theorical_mark_minimal` AS registration__exam_theorical_mark_minimal, j3.`exam_theorical_mark_maximal` AS registration__exam_theorical_mark_maximal, j3.`exam_practical_mark_minimal` AS registration__exam_practical_mark_minimal, j3.`exam_practical_mark_maximal` AS registration__exam_practical_mark_maximal, j3.`exam_theorical_convocation_sent` AS registration__exam_theorical_convocation_sent, j3.`exam_theorical_convocation_sent_date` AS registration__exam_theorical_convocation_sent_date, j3.`exam_practical_convocation_sent` AS registration__exam_practical_convocation_sent, j3.`exam_practical_convocation_sent_date` AS registration__exam_practical_convocation_sent_date, j3.`invoice_same_as_company` AS registration__invoice_same_as_company, j3.`invoice_phone` AS registration__invoice_phone, j3.`invoice_siret` AS registration__invoice_siret, j3.`invoice_company` AS registration__invoice_company, j3.`invoice_street` AS registration__invoice_street, j3.`invoice_street_2` AS registration__invoice_street_2, j3.`invoice_postal` AS registration__invoice_postal, j3.`invoice_city` AS registration__invoice_city, j3.`invoice_country` AS registration__invoice_country, j3.`invoice_address_choice` AS registration__invoice_address_choice, j3.`invoice_email` AS registration__invoice_email, j3.`invoice_lastname` AS registration__invoice_lastname, j3.`invoice_firstname` AS registration__invoice_firstname, j3.`comment_additionnal` AS registration__comment_additionnal, j3.`certify_data_exact` AS registration__certify_data_exact, j3.`accept_special_regulations` AS registration__accept_special_regulations, j3.`accept_no_reputation_harm_acqpa` AS registration__accept_no_reputation_harm_acqpa, j3.`accept_to_pay` AS registration__accept_to_pay, j3.`has_complaints` AS registration__has_complaints, j3.`has_abusive_usage` AS registration__has_abusive_usage, j3.`accept_personal_data_share` AS registration__accept_personal_data_share, j3.`api_company_appear_by_inspector` AS registration__api_company_appear_by_inspector, j3.`api_company_email_for_agreement` AS registration__api_company_email_for_agreement, j3.`api_company_email_for_agreement_date_sent` AS registration__api_company_email_for_agreement_date_sent, j3.`signature_inspector` AS registration__signature_inspector, j3.`signature_inspector_checkbox` AS registration__signature_inspector_checkbox, j3.`signature_inspector_date` AS registration__signature_inspector_date, j3.`signature_company` AS registration__signature_company, j3.`signature_company_checkbox` AS registration__signature_company_checkbox, j3.`signature_company_date` AS registration__signature_company_date, j3.`signature_company_siret` AS registration__signature_company_siret, j3.`signature_company_lastname` AS registration__signature_company_lastname, j3.`signature_company_firstname` AS registration__signature_company_firstname, j3.`signature_company_position` AS registration__signature_company_position, j3.`signature_company_service` AS registration__signature_company_service, j3.`signature_company_email` AS registration__signature_company_email, j3.`signature_company_phone` AS registration__signature_company_phone, j3.`signature_company_comments` AS registration__signature_company_comments, j3.`exam_theorical_set` AS registration__exam_theorical_set, j3.`result_exam_theorical_mark` AS registration__result_exam_theorical_mark, j3.`result_exam_theorical_mark_double_correction` AS registration__result_exam_theorical_mark_double_correction, j3.`result_exam_theorical_status` AS registration__result_exam_theorical_status, j3.`result_exam_theorical_status_date` AS registration__result_exam_theorical_status_date, j3.`result_exam_theorical_validity_date_end` AS registration__result_exam_theorical_validity_date_end, j3.`result_exam_practical_mark` AS registration__result_exam_practical_mark, j3.`result_exam_practical_mark_double_correction` AS registration__result_exam_practical_mark_double_correction, j3.`result_exam_practical_status` AS registration__result_exam_practical_status, j3.`result_exam_practical_status_date` AS registration__result_exam_practical_status_date, j3.`result_exam_practical_validity_date_end` AS registration__result_exam_practical_validity_date_end, j3.`result_exam_mock` AS registration__result_exam_mock, j3.`duration_week` AS registration__duration_week, j3.`duration_month` AS registration__duration_month, j3.`payment_done` AS registration__payment_done, j3.`payment_date` AS registration__payment_date, j4.`id` AS replaced_by__id, j4.`tstamp` AS replaced_by__tstamp, j4.`created_at` AS replaced_by__created_at, j4.`inspector` AS replaced_by__inspector, j4.`number` AS replaced_by__number, j4.`status` AS replaced_by__status, j4.`date_cci` AS replaced_by__date_cci, j4.`obtained_date` AS replaced_by__obtained_date, j4.`validity_date_end` AS replaced_by__validity_date_end, j4.`revoked_at` AS replaced_by__revoked_at, j4.`revoked_reason` AS replaced_by__revoked_reason, j4.`inspector_firstname` AS replaced_by__inspector_firstname, j4.`inspector_lastname` AS replaced_by__inspector_lastname, j4.`inspector_date_of_birth` AS replaced_by__inspector_date_of_birth, j4.`inspector_acqpa_number` AS replaced_by__inspector_acqpa_number, j4.`exam_type` AS replaced_by__exam_type, j4.`exam_cycle` AS replaced_by__exam_cycle, j4.`exam_level` AS replaced_by__exam_level, j4.`exam_level_level` AS replaced_by__exam_level_level, j4.`token` AS replaced_by__token, j4.`file` AS replaced_by__file, j4.`sent_to_inspector` AS replaced_by__sent_to_inspector, j4.`sent_to_inspector_date` AS replaced_by__sent_to_inspector_date, j4.`sent_to_acqpa` AS replaced_by__sent_to_acqpa, j4.`sent_to_acqpa_date` AS replaced_by__sent_to_acqpa_date, j4.`reminder_6_month_sent` AS replaced_by__reminder_6_month_sent, j4.`reminder_6_month_sent_date` AS replaced_by__reminder_6_month_sent_date, j4.`reminder_3_month_sent` AS replaced_by__reminder_3_month_sent, j4.`reminder_3_month_sent_date` AS replaced_by__reminder_3_month_sent_date, j4.`reminder_1_month_sent` AS replaced_by__reminder_1_month_sent, j4.`reminder_1_month_sent_date` AS replaced_by__reminder_1_month_sent_date, j4.`reminder_0_day_sent` AS replaced_by__reminder_0_day_sent, j4.`reminder_0_day_sent_date` AS replaced_by__reminder_0_day_sent_date, j4.`original_certificate` AS replaced_by__original_certificate, j4.`original_certificate_obtained_date` AS replaced_by__original_certificate_obtained_date, j4.`registration` AS replaced_by__registration, j4.`registration_reference` AS replaced_by__registration_reference, j4.`registration_renewal_no` AS replaced_by__registration_renewal_no, j4.`replaced` AS replaced_by__replaced, j4.`replaced_by` AS replaced_by__replaced_by, j4.`replaced_date` AS replaced_by__replaced_date, j4.`replaced_user` AS replaced_by__replaced_user, j4.`replaced_reason` AS replaced_by__replaced_reason, j4.`merged` AS replaced_by__merged, j4.`merged_to` AS replaced_by__merged_to, j4.`merged_date` AS replaced_by__merged_date, j4.`merged_user` AS replaced_by__merged_user, j4.`merged_reason` AS replaced_by__merged_reason, j4.`first_edition` AS replaced_by__first_edition, j4.`v1_imported` AS replaced_by__v1_imported, j4.`v1_id` AS replaced_by__v1_id, j4.`v1_source` AS replaced_by__v1_source, j4.`v1_details` AS replaced_by__v1_details, j4.`v1_comment` AS replaced_by__v1_comment, j5.`id` AS replaced_user__id, j5.`tstamp` AS replaced_user__tstamp, j5.`username` AS replaced_user__username, j5.`name` AS replaced_user__name, j5.`email` AS replaced_user__email, j5.`language` AS replaced_user__language, j5.`backendTheme` AS replaced_user__backendTheme, j5.`uploader` AS replaced_user__uploader, j5.`showHelp` AS replaced_user__showHelp, j5.`thumbnails` AS replaced_user__thumbnails, j5.`useRTE` AS replaced_user__useRTE, j5.`useCE` AS replaced_user__useCE, j5.`doNotCollapse` AS replaced_user__doNotCollapse, j5.`password` AS replaced_user__password, j5.`pwChange` AS replaced_user__pwChange, j5.`admin` AS replaced_user__admin, j5.`groups` AS replaced_user__groups, j5.`inherit` AS replaced_user__inherit, j5.`modules` AS replaced_user__modules, j5.`themes` AS replaced_user__themes, j5.`elements` AS replaced_user__elements, j5.`fields` AS replaced_user__fields, j5.`frontendModules` AS replaced_user__frontendModules, j5.`pagemounts` AS replaced_user__pagemounts, j5.`alpty` AS replaced_user__alpty, j5.`filemounts` AS replaced_user__filemounts, j5.`fop` AS replaced_user__fop, j5.`imageSizes` AS replaced_user__imageSizes, j5.`forms` AS replaced_user__forms, j5.`formp` AS replaced_user__formp, j5.`amg` AS replaced_user__amg, j5.`disable` AS replaced_user__disable, j5.`start` AS replaced_user__start, j5.`stop` AS replaced_user__stop, j5.`session` AS replaced_user__session, j5.`dateAdded` AS replaced_user__dateAdded, j5.`secret` AS replaced_user__secret, j5.`useTwoFactor` AS replaced_user__useTwoFactor, j5.`lastLogin` AS replaced_user__lastLogin, j5.`currentLogin` AS replaced_user__currentLogin, j5.`backupCodes` AS replaced_user__backupCodes, j5.`trustedTokenVersion` AS replaced_user__trustedTokenVersion, j5.`faqs` AS replaced_user__faqs, j5.`faqp` AS replaced_user__faqp, j5.`news` AS replaced_user__news, j5.`newp` AS replaced_user__newp, j5.`calendars` AS replaced_user__calendars, j5.`calendarp` AS replaced_user__calendarp, j5.`calendarfeeds` AS replaced_user__calendarfeeds, j5.`calendarfeedp` AS replaced_user__calendarfeedp, j5.`newsletters` AS replaced_user__newsletters, j5.`newsletterp` AS replaced_user__newsletterp, j5.`pageLanguageLabels` AS replaced_user__pageLanguageLabels, j6.`id` AS merged_to__id, j6.`tstamp` AS merged_to__tstamp, j6.`created_at` AS merged_to__created_at, j6.`inspector` AS merged_to__inspector, j6.`number` AS merged_to__number, j6.`status` AS merged_to__status, j6.`date_cci` AS merged_to__date_cci, j6.`obtained_date` AS merged_to__obtained_date, j6.`validity_date_end` AS merged_to__validity_date_end, j6.`revoked_at` AS merged_to__revoked_at, j6.`revoked_reason` AS merged_to__revoked_reason, j6.`inspector_firstname` AS merged_to__inspector_firstname, j6.`inspector_lastname` AS merged_to__inspector_lastname, j6.`inspector_date_of_birth` AS merged_to__inspector_date_of_birth, j6.`inspector_acqpa_number` AS merged_to__inspector_acqpa_number, j6.`exam_type` AS merged_to__exam_type, j6.`exam_cycle` AS merged_to__exam_cycle, j6.`exam_level` AS merged_to__exam_level, j6.`exam_level_level` AS merged_to__exam_level_level, j6.`token` AS merged_to__token, j6.`file` AS merged_to__file, j6.`sent_to_inspector` AS merged_to__sent_to_inspector, j6.`sent_to_inspector_date` AS merged_to__sent_to_inspector_date, j6.`sent_to_acqpa` AS merged_to__sent_to_acqpa, j6.`sent_to_acqpa_date` AS merged_to__sent_to_acqpa_date, j6.`reminder_6_month_sent` AS merged_to__reminder_6_month_sent, j6.`reminder_6_month_sent_date` AS merged_to__reminder_6_month_sent_date, j6.`reminder_3_month_sent` AS merged_to__reminder_3_month_sent, j6.`reminder_3_month_sent_date` AS merged_to__reminder_3_month_sent_date, j6.`reminder_1_month_sent` AS merged_to__reminder_1_month_sent, j6.`reminder_1_month_sent_date` AS merged_to__reminder_1_month_sent_date, j6.`reminder_0_day_sent` AS merged_to__reminder_0_day_sent, j6.`reminder_0_day_sent_date` AS merged_to__reminder_0_day_sent_date, j6.`original_certificate` AS merged_to__original_certificate, j6.`original_certificate_obtained_date` AS merged_to__original_certificate_obtained_date, j6.`registration` AS merged_to__registration, j6.`registration_reference` AS merged_to__registration_reference, j6.`registration_renewal_no` AS merged_to__registration_renewal_no, j6.`replaced` AS merged_to__replaced, j6.`replaced_by` AS merged_to__replaced_by, j6.`replaced_date` AS merged_to__replaced_date, j6.`replaced_user` AS merged_to__replaced_user, j6.`replaced_reason` AS merged_to__replaced_reason, j6.`merged` AS merged_to__merged, j6.`merged_to` AS merged_to__merged_to, j6.`merged_date` AS merged_to__merged_date, j6.`merged_user` AS merged_to__merged_user, j6.`merged_reason` AS merged_to__merged_reason, j6.`first_edition` AS merged_to__first_edition, j6.`v1_imported` AS merged_to__v1_imported, j6.`v1_id` AS merged_to__v1_id, j6.`v1_source` AS merged_to__v1_source, j6.`v1_details` AS merged_to__v1_details, j6.`v1_comment` AS merged_to__v1_comment, j7.`id` AS merged_user__id, j7.`tstamp` AS merged_user__tstamp, j7.`username` AS merged_user__username, j7.`name` AS merged_user__name, j7.`email` AS merged_user__email, j7.`language` AS merged_user__language, j7.`backendTheme` AS merged_user__backendTheme, j7.`uploader` AS merged_user__uploader, j7.`showHelp` AS merged_user__showHelp, j7.`thumbnails` AS merged_user__thumbnails, j7.`useRTE` AS merged_user__useRTE, j7.`useCE` AS merged_user__useCE, j7.`doNotCollapse` AS merged_user__doNotCollapse, j7.`password` AS merged_user__password, j7.`pwChange` AS merged_user__pwChange, j7.`admin` AS merged_user__admin, j7.`groups` AS merged_user__groups, j7.`inherit` AS merged_user__inherit, j7.`modules` AS merged_user__modules, j7.`themes` AS merged_user__themes, j7.`elements` AS merged_user__elements, j7.`fields` AS merged_user__fields, j7.`frontendModules` AS merged_user__frontendModules, j7.`pagemounts` AS merged_user__pagemounts, j7.`alpty` AS merged_user__alpty, j7.`filemounts` AS merged_user__filemounts, j7.`fop` AS merged_user__fop, j7.`imageSizes` AS merged_user__imageSizes, j7.`forms` AS merged_user__forms, j7.`formp` AS merged_user__formp, j7.`amg` AS merged_user__amg, j7.`disable` AS merged_user__disable, j7.`start` AS merged_user__start, j7.`stop` AS merged_user__stop, j7.`session` AS merged_user__session, j7.`dateAdded` AS merged_user__dateAdded, j7.`secret` AS merged_user__secret, j7.`useTwoFactor` AS merged_user__useTwoFactor, j7.`lastLogin` AS merged_user__lastLogin, j7.`currentLogin` AS merged_user__currentLogin, j7.`backupCodes` AS merged_user__backupCodes, j7.`trustedTokenVersion` AS merged_user__trustedTokenVersion, j7.`faqs` AS merged_user__faqs, j7.`faqp` AS merged_user__faqp, j7.`news` AS merged_user__news, j7.`newp` AS merged_user__newp, j7.`calendars` AS merged_user__calendars, j7.`calendarp` AS merged_user__calendarp, j7.`calendarfeeds` AS merged_user__calendarfeeds, j7.`calendarfeedp` AS merged_user__calendarfeedp, j7.`newsletters` AS merged_user__newsletters, j7.`newsletterp` AS merged_user__newsletterp, j7.`pageLanguageLabels` AS merged_user__pageLanguageLabels FROM tl_acqpa_ins_certificate  LEFT JOIN tl_acqpa_ins_inspector j1 ON tl_acqpa_ins_certificate.`inspector`=j1.id  LEFT JOIN tl_acqpa_ins_certificate j2 ON tl_acqpa_ins_certificate.`original_certificate`=j2.id  LEFT JOIN tl_acqpa_ins_registration j3 ON tl_acqpa_ins_certificate.`registration`=j3.id  LEFT JOIN tl_acqpa_ins_certificate j4 ON tl_acqpa_ins_certificate.`replaced_by`=j4.id  LEFT JOIN tl_user j5 ON tl_acqpa_ins_certificate.`replaced_user`=j5.id  LEFT JOIN tl_acqpa_ins_certificate j6 ON tl_acqpa_ins_certificate.`merged_to`=j6.id  LEFT JOIN tl_user j7 ON tl_acqpa_ins_certificate.`merged_user`=j7.id WHERE (
                        tl_acqpa_ins_certificate.number LIKE '/%'
                    ) AND (
                        tl_acqpa_ins_certificate.obtained_date <= UNIX_TIMESTAMP(CURRENT_TIMESTAMP())
                    AND
                        tl_acqpa_ins_certificate.validity_date_end >= UNIX_TIMESTAMP(CURRENT_TIMESTAMP())
                    AND (
                            tl_acqpa_ins_certificate.revoked_at IS NULL
                        OR
                            tl_acqpa_ins_certificate.revoked_at >= UNIX_TIMESTAMP(CURRENT_TIMESTAMP())
                        OR
                            LENGTH(tl_acqpa_ins_certificate.revoked_at) = 0
                        )
                    ) ORDER BY tl_acqpa_ins_certificate.created_at ASC LIMIT 0,1;