| 1 |
5.96 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.address AS address_3, t0.city AS city_4, t0.website AS website_5, t0.email AS email_6, t0.phone AS phone_7, t0.ap_confirmation_interest AS ap_confirmation_interest_8, t0.ap_confirmation_paid_fees AS ap_confirmation_paid_fees_9, t0.ap_confirmation_start_implementation AS ap_confirmation_start_implementation_10, t0.ip_coordinator_training_certificate_id AS ip_coordinator_training_certificate_id_11, t0.ip_coordinator_completion_date AS ip_coordinator_completion_date_12, t0.ip_confirmation_course_successfully_taken AS ip_confirmation_course_successfully_taken_13, t0.ip_confirmation_implementing_framework AS ip_confirmation_implementing_framework_14, t0.sa_initial_listing_date AS sa_initial_listing_date_15, t0.sa_expiration_date AS sa_expiration_date_16, t0.sa_confirmation_framework_implemented AS sa_confirmation_framework_implemented_17, t0.sa_confirmation_declared_to_adhere AS sa_confirmation_declared_to_adhere_18, t0.sa_confirmation_completed_necessary_steps AS sa_confirmation_completed_necessary_steps_19, t0.tp_auditor_name AS tp_auditor_name_20, t0.tp_auditor_email AS tp_auditor_email_21, t0.tp_auditor_phone AS tp_auditor_phone_22, t0.tp_auditor_training_certificate_id AS tp_auditor_training_certificate_id_23, t0.tp_auditor_training_completion_date AS tp_auditor_training_completion_date_24, t0.tp_initial_listing_date AS tp_initial_listing_date_25, t0.tp_expiration_date AS tp_expiration_date_26, t0.tp_confirmation_framework_implemented AS tp_confirmation_framework_implemented_27, t0.tp_confirmation_declared_to_adhere AS tp_confirmation_declared_to_adhere_28, t0.tp_confirmation_completed_necessary_steps AS tp_confirmation_completed_necessary_steps_29, t0.tp_confirmation_course_successfully_taken AS tp_confirmation_course_successfully_taken_30, t0.tp_is_implementing_process AS tp_is_implementing_process_31, t0.registration_author_name AS registration_author_name_32, t0.registration_date AS registration_date_33, t0.organization_logo_name AS organization_logo_name_34, t0.ap_document_name AS ap_document_name_35, t0.ip_document_name AS ip_document_name_36, t0.ip_certificate_coordination_course_name AS ip_certificate_coordination_course_name_37, t0.sa_attestation_document_name AS sa_attestation_document_name_38, t0.sa_attestation_logo_name AS sa_attestation_logo_name_39, t0.tp_attestation_document_name AS tp_attestation_document_name_40, t0.tp_attestation_logo_name AS tp_attestation_logo_name_41, t0.created_at AS created_at_42, t0.updated_at AS updated_at_43, t0.stripe_customer_id AS stripe_customer_id_44, t0.certification_expiration_date AS certification_expiration_date_45, t0.subscription_expiration_date AS subscription_expiration_date_46, t0.country_id AS country_id_47, t0.organization_status_id AS organization_status_id_48, t0.implementation_type_id AS implementation_type_id_49, t0.registration_state_id AS registration_state_id_50 FROM organization t0 WHERE t0.registration_state_id = ?
SELECT
t0.id AS id_1,
t0.name AS name_2,
t0.address AS address_3,
t0.city AS city_4,
t0.website AS website_5,
t0.email AS email_6,
t0.phone AS phone_7,
t0.ap_confirmation_interest AS ap_confirmation_interest_8,
t0.ap_confirmation_paid_fees AS ap_confirmation_paid_fees_9,
t0.ap_confirmation_start_implementation AS ap_confirmation_start_implementation_10,
t0.ip_coordinator_training_certificate_id AS ip_coordinator_training_certificate_id_11,
t0.ip_coordinator_completion_date AS ip_coordinator_completion_date_12,
t0.ip_confirmation_course_successfully_taken AS ip_confirmation_course_successfully_taken_13,
t0.ip_confirmation_implementing_framework AS ip_confirmation_implementing_framework_14,
t0.sa_initial_listing_date AS sa_initial_listing_date_15,
t0.sa_expiration_date AS sa_expiration_date_16,
t0.sa_confirmation_framework_implemented AS sa_confirmation_framework_implemented_17,
t0.sa_confirmation_declared_to_adhere AS sa_confirmation_declared_to_adhere_18,
t0.sa_confirmation_completed_necessary_steps AS sa_confirmation_completed_necessary_steps_19,
t0.tp_auditor_name AS tp_auditor_name_20,
t0.tp_auditor_email AS tp_auditor_email_21,
t0.tp_auditor_phone AS tp_auditor_phone_22,
t0.tp_auditor_training_certificate_id AS tp_auditor_training_certificate_id_23,
t0.tp_auditor_training_completion_date AS tp_auditor_training_completion_date_24,
t0.tp_initial_listing_date AS tp_initial_listing_date_25,
t0.tp_expiration_date AS tp_expiration_date_26,
t0.tp_confirmation_framework_implemented AS tp_confirmation_framework_implemented_27,
t0.tp_confirmation_declared_to_adhere AS tp_confirmation_declared_to_adhere_28,
t0.tp_confirmation_completed_necessary_steps AS tp_confirmation_completed_necessary_steps_29,
t0.tp_confirmation_course_successfully_taken AS tp_confirmation_course_successfully_taken_30,
t0.tp_is_implementing_process AS tp_is_implementing_process_31,
t0.registration_author_name AS registration_author_name_32,
t0.registration_date AS registration_date_33,
t0.organization_logo_name AS organization_logo_name_34,
t0.ap_document_name AS ap_document_name_35,
t0.ip_document_name AS ip_document_name_36,
t0.ip_certificate_coordination_course_name AS ip_certificate_coordination_course_name_37,
t0.sa_attestation_document_name AS sa_attestation_document_name_38,
t0.sa_attestation_logo_name AS sa_attestation_logo_name_39,
t0.tp_attestation_document_name AS tp_attestation_document_name_40,
t0.tp_attestation_logo_name AS tp_attestation_logo_name_41,
t0.created_at AS created_at_42,
t0.updated_at AS updated_at_43,
t0.stripe_customer_id AS stripe_customer_id_44,
t0.certification_expiration_date AS certification_expiration_date_45,
t0.subscription_expiration_date AS subscription_expiration_date_46,
t0.country_id AS country_id_47,
t0.organization_status_id AS organization_status_id_48,
t0.implementation_type_id AS implementation_type_id_49,
t0.registration_state_id AS registration_state_id_50
FROM
organization t0
WHERE
t0.registration_state_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.address AS address_3, t0.city AS city_4, t0.website AS website_5, t0.email AS email_6, t0.phone AS phone_7, t0.ap_confirmation_interest AS ap_confirmation_interest_8, t0.ap_confirmation_paid_fees AS ap_confirmation_paid_fees_9, t0.ap_confirmation_start_implementation AS ap_confirmation_start_implementation_10, t0.ip_coordinator_training_certificate_id AS ip_coordinator_training_certificate_id_11, t0.ip_coordinator_completion_date AS ip_coordinator_completion_date_12, t0.ip_confirmation_course_successfully_taken AS ip_confirmation_course_successfully_taken_13, t0.ip_confirmation_implementing_framework AS ip_confirmation_implementing_framework_14, t0.sa_initial_listing_date AS sa_initial_listing_date_15, t0.sa_expiration_date AS sa_expiration_date_16, t0.sa_confirmation_framework_implemented AS sa_confirmation_framework_implemented_17, t0.sa_confirmation_declared_to_adhere AS sa_confirmation_declared_to_adhere_18, t0.sa_confirmation_completed_necessary_steps AS sa_confirmation_completed_necessary_steps_19, t0.tp_auditor_name AS tp_auditor_name_20, t0.tp_auditor_email AS tp_auditor_email_21, t0.tp_auditor_phone AS tp_auditor_phone_22, t0.tp_auditor_training_certificate_id AS tp_auditor_training_certificate_id_23, t0.tp_auditor_training_completion_date AS tp_auditor_training_completion_date_24, t0.tp_initial_listing_date AS tp_initial_listing_date_25, t0.tp_expiration_date AS tp_expiration_date_26, t0.tp_confirmation_framework_implemented AS tp_confirmation_framework_implemented_27, t0.tp_confirmation_declared_to_adhere AS tp_confirmation_declared_to_adhere_28, t0.tp_confirmation_completed_necessary_steps AS tp_confirmation_completed_necessary_steps_29, t0.tp_confirmation_course_successfully_taken AS tp_confirmation_course_successfully_taken_30, t0.tp_is_implementing_process AS tp_is_implementing_process_31, t0.registration_author_name AS registration_author_name_32, t0.registration_date AS registration_date_33, t0.organization_logo_name AS organization_logo_name_34, t0.ap_document_name AS ap_document_name_35, t0.ip_document_name AS ip_document_name_36, t0.ip_certificate_coordination_course_name AS ip_certificate_coordination_course_name_37, t0.sa_attestation_document_name AS sa_attestation_document_name_38, t0.sa_attestation_logo_name AS sa_attestation_logo_name_39, t0.tp_attestation_document_name AS tp_attestation_document_name_40, t0.tp_attestation_logo_name AS tp_attestation_logo_name_41, t0.created_at AS created_at_42, t0.updated_at AS updated_at_43, t0.stripe_customer_id AS stripe_customer_id_44, t0.certification_expiration_date AS certification_expiration_date_45, t0.subscription_expiration_date AS subscription_expiration_date_46, t0.country_id AS country_id_47, t0.organization_status_id AS organization_status_id_48, t0.implementation_type_id AS implementation_type_id_49, t0.registration_state_id AS registration_state_id_50 FROM organization t0 WHERE t0.registration_state_id = 2;
|