| 1 |
1.42 ms |
SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.application_type AS application_type_3, t0.declined_at AS declined_at_4, t0.approved_at AS approved_at_5, t0.created_at AS created_at_6, t0.submitted_at AS submitted_at_7, t0.enquiry_source AS enquiry_source_8, t0.callback_url AS callback_url_9, t0.final_declaration AS final_declaration_10, t0.error AS error_11, t0.submitter_ip_address AS submitter_ip_address_12, t0.initial_disclosure_document_url AS initial_disclosure_document_url_13, t0.privacy_policy_url AS privacy_policy_url_14, t0.information_notice_url AS information_notice_url_15, t0.terms_and_conditions_url AS terms_and_conditions_url_16, t0.brand_phone AS brand_phone_17, t0.brand_email AS brand_email_18, t0.brand_open_hours AS brand_open_hours_19, t0.external_brand_id AS external_brand_id_20, t0.brand_logo_url AS brand_logo_url_21, t0.external_order_id AS external_order_id_22, t0.rci_proposal_id AS rci_proposal_id_23, t0.rci_proposal_status AS rci_proposal_status_24, t0.contact_consents_sms AS contact_consents_sms_25, t0.contact_consents_email AS contact_consents_email_26, t0.contact_consents_post AS contact_consents_post_27, t0.contact_consents_telephone AS contact_consents_telephone_28, t0.eula_consents_initial_disclosure_document AS eula_consents_initial_disclosure_document_29, t0.eula_consents_information_notice AS eula_consents_information_notice_30, t0.eula_consents_terms_and_conditions AS eula_consents_terms_and_conditions_31, t0.eula_consents_privacy_policy AS eula_consents_privacy_policy_32, t0.private_individual_id AS private_individual_id_33, t34.prefix_title AS prefix_title_35, t34.first_name AS first_name_36, t34.middle_name AS middle_name_37, t34.surname AS surname_38, t34.birthday AS birthday_39, t34.nationality AS nationality_40, t34.number_of_financial_dependants AS number_of_financial_dependants_41, t34.marital_status AS marital_status_42, t34.driving_licence_number AS driving_licence_number_43, t34.gender AS gender_44, t34.driving_license_issue_date AS driving_license_issue_date_45, t34.driving_license_expiry_date AS driving_license_expiry_date_46, t34.previous_surname AS previous_surname_47, t34.id AS id_48, t34.comments AS comments_49, t34.additional_info_health_corners AS additional_info_health_corners_50, t34.employment_id AS employment_id_51, t34.financial_id AS financial_id_52, t34.contact_id AS contact_id_53, t34.address_id AS address_id_54, t0.company_id AS company_id_55, t56.id AS id_57, t56.company_name AS company_name_58, t56.trading_name AS trading_name_59, t56.registration_number AS registration_number_60, t56.vat_registered AS vat_registered_61, t56.vat_number AS vat_number_62, t56.comments AS comments_63, t56.company_fleet_fleet_size AS company_fleet_fleet_size_64, t56.company_fleet_fleet_size_last6_months AS company_fleet_fleet_size_last6_months_65, t56.company_fleet_commercial_fleet_size AS company_fleet_commercial_fleet_size_66, t56.company_fleet_commercial_fleet_size_last6_months AS company_fleet_commercial_fleet_size_last6_months_67, t56.address_id AS address_id_68, t56.contact_id AS contact_id_69, t56.bank_details_id AS bank_details_id_70, t0.partnership_id AS partnership_id_71, t72.id AS id_73, t72.trading_name AS trading_name_74, t72.comments AS comments_75, t72.partnership_fleet_fleet_size AS partnership_fleet_fleet_size_76, t72.partnership_fleet_fleet_size_last6_months AS partnership_fleet_fleet_size_last6_months_77, t72.partnership_fleet_commercial_fleet_size AS partnership_fleet_commercial_fleet_size_78, t72.partnership_fleet_commercial_fleet_size_last6_months AS partnership_fleet_commercial_fleet_size_last6_months_79, t72.address_id AS address_id_80, t72.contact_id AS contact_id_81, t72.bank_details_id AS bank_details_id_82, t0.sole_trader_id AS sole_trader_id_83, t84.prefix_title AS prefix_title_85, t84.first_name AS first_name_86, t84.middle_name AS middle_name_87, t84.surname AS surname_88, t84.birthday AS birthday_89, t84.nationality AS nationality_90, t84.number_of_financial_dependants AS number_of_financial_dependants_91, t84.marital_status AS marital_status_92, t84.driving_licence_number AS driving_licence_number_93, t84.gender AS gender_94, t84.driving_license_issue_date AS driving_license_issue_date_95, t84.driving_license_expiry_date AS driving_license_expiry_date_96, t84.previous_surname AS previous_surname_97, t84.id AS id_98, t84.trading_name AS trading_name_99, t84.nature_of_business AS nature_of_business_100, t84.trading_since AS trading_since_101, t84.comments AS comments_102, t84.additional_info_health_corners AS additional_info_health_corners_103, t84.trading_address_id AS trading_address_id_104, t84.financial_id AS financial_id_105, t84.employment_id AS employment_id_106, t84.address_id AS address_id_107, t84.contact_id AS contact_id_108, t0.vehicle_id AS vehicle_id_109, t110.id AS id_111, t110.cap_id AS cap_id_112, t110.cap_code AS cap_code_113, t110.type AS type_114, t110.manufacturer_name AS manufacturer_name_115, t110.model_name AS model_name_116, t110.model_short_name AS model_short_name_117, t110.model_year AS model_year_118, t110.deal_type AS deal_type_119, t110.vehicle_name AS vehicle_name_120, t110.contract_length AS contract_length_121, t110.monthly_rate AS monthly_rate_122, t110.maintenance_monthly_rate AS maintenance_monthly_rate_123, t110.initial_payment AS initial_payment_124, t110.includes_vat AS includes_vat_125, t110.annual_mileage AS annual_mileage_126, t110.processing_fee AS processing_fee_127, t110.dealership_code AS dealership_code_128, t110.product_code AS product_code_129, t110.dealer_discount AS dealer_discount_130, t110.gross_yearly_road_tax AS gross_yearly_road_tax_131, t110.government_adjustment AS government_adjustment_132, t110.color_id AS color_id_133, t110.trim_id AS trim_id_134 FROM application t0 LEFT JOIN private_individual t34 ON t0.private_individual_id = t34.id LEFT JOIN company t56 ON t0.company_id = t56.id LEFT JOIN partnership t72 ON t0.partnership_id = t72.id LEFT JOIN sole_trader t84 ON t0.sole_trader_id = t84.id LEFT JOIN vehicle t110 ON t0.vehicle_id = t110.id WHERE t0.uuid = ? LIMIT 1
Parameters: [
b"\x1F\eòÔ¸ f”‹bãÞn†û¦"
]
SELECT
t0.id AS id_1,
t0.uuid AS uuid_2,
t0.application_type AS application_type_3,
t0.declined_at AS declined_at_4,
t0.approved_at AS approved_at_5,
t0.created_at AS created_at_6,
t0.submitted_at AS submitted_at_7,
t0.enquiry_source AS enquiry_source_8,
t0.callback_url AS callback_url_9,
t0.final_declaration AS final_declaration_10,
t0.error AS error_11,
t0.submitter_ip_address AS submitter_ip_address_12,
t0.initial_disclosure_document_url AS initial_disclosure_document_url_13,
t0.privacy_policy_url AS privacy_policy_url_14,
t0.information_notice_url AS information_notice_url_15,
t0.terms_and_conditions_url AS terms_and_conditions_url_16,
t0.brand_phone AS brand_phone_17,
t0.brand_email AS brand_email_18,
t0.brand_open_hours AS brand_open_hours_19,
t0.external_brand_id AS external_brand_id_20,
t0.brand_logo_url AS brand_logo_url_21,
t0.external_order_id AS external_order_id_22,
t0.rci_proposal_id AS rci_proposal_id_23,
t0.rci_proposal_status AS rci_proposal_status_24,
t0.contact_consents_sms AS contact_consents_sms_25,
t0.contact_consents_email AS contact_consents_email_26,
t0.contact_consents_post AS contact_consents_post_27,
t0.contact_consents_telephone AS contact_consents_telephone_28,
t0.eula_consents_initial_disclosure_document AS eula_consents_initial_disclosure_document_29,
t0.eula_consents_information_notice AS eula_consents_information_notice_30,
t0.eula_consents_terms_and_conditions AS eula_consents_terms_and_conditions_31,
t0.eula_consents_privacy_policy AS eula_consents_privacy_policy_32,
t0.private_individual_id AS private_individual_id_33,
t34.prefix_title AS prefix_title_35,
t34.first_name AS first_name_36,
t34.middle_name AS middle_name_37,
t34.surname AS surname_38,
t34.birthday AS birthday_39,
t34.nationality AS nationality_40,
t34.number_of_financial_dependants AS number_of_financial_dependants_41,
t34.marital_status AS marital_status_42,
t34.driving_licence_number AS driving_licence_number_43,
t34.gender AS gender_44,
t34.driving_license_issue_date AS driving_license_issue_date_45,
t34.driving_license_expiry_date AS driving_license_expiry_date_46,
t34.previous_surname AS previous_surname_47,
t34.id AS id_48,
t34.comments AS comments_49,
t34.additional_info_health_corners AS additional_info_health_corners_50,
t34.employment_id AS employment_id_51,
t34.financial_id AS financial_id_52,
t34.contact_id AS contact_id_53,
t34.address_id AS address_id_54,
t0.company_id AS company_id_55,
t56.id AS id_57,
t56.company_name AS company_name_58,
t56.trading_name AS trading_name_59,
t56.registration_number AS registration_number_60,
t56.vat_registered AS vat_registered_61,
t56.vat_number AS vat_number_62,
t56.comments AS comments_63,
t56.company_fleet_fleet_size AS company_fleet_fleet_size_64,
t56.company_fleet_fleet_size_last6_months AS company_fleet_fleet_size_last6_months_65,
t56.company_fleet_commercial_fleet_size AS company_fleet_commercial_fleet_size_66,
t56.company_fleet_commercial_fleet_size_last6_months AS company_fleet_commercial_fleet_size_last6_months_67,
t56.address_id AS address_id_68,
t56.contact_id AS contact_id_69,
t56.bank_details_id AS bank_details_id_70,
t0.partnership_id AS partnership_id_71,
t72.id AS id_73,
t72.trading_name AS trading_name_74,
t72.comments AS comments_75,
t72.partnership_fleet_fleet_size AS partnership_fleet_fleet_size_76,
t72.partnership_fleet_fleet_size_last6_months AS partnership_fleet_fleet_size_last6_months_77,
t72.partnership_fleet_commercial_fleet_size AS partnership_fleet_commercial_fleet_size_78,
t72.partnership_fleet_commercial_fleet_size_last6_months AS partnership_fleet_commercial_fleet_size_last6_months_79,
t72.address_id AS address_id_80,
t72.contact_id AS contact_id_81,
t72.bank_details_id AS bank_details_id_82,
t0.sole_trader_id AS sole_trader_id_83,
t84.prefix_title AS prefix_title_85,
t84.first_name AS first_name_86,
t84.middle_name AS middle_name_87,
t84.surname AS surname_88,
t84.birthday AS birthday_89,
t84.nationality AS nationality_90,
t84.number_of_financial_dependants AS number_of_financial_dependants_91,
t84.marital_status AS marital_status_92,
t84.driving_licence_number AS driving_licence_number_93,
t84.gender AS gender_94,
t84.driving_license_issue_date AS driving_license_issue_date_95,
t84.driving_license_expiry_date AS driving_license_expiry_date_96,
t84.previous_surname AS previous_surname_97,
t84.id AS id_98,
t84.trading_name AS trading_name_99,
t84.nature_of_business AS nature_of_business_100,
t84.trading_since AS trading_since_101,
t84.comments AS comments_102,
t84.additional_info_health_corners AS additional_info_health_corners_103,
t84.trading_address_id AS trading_address_id_104,
t84.financial_id AS financial_id_105,
t84.employment_id AS employment_id_106,
t84.address_id AS address_id_107,
t84.contact_id AS contact_id_108,
t0.vehicle_id AS vehicle_id_109,
t110.id AS id_111,
t110.cap_id AS cap_id_112,
t110.cap_code AS cap_code_113,
t110.type AS type_114,
t110.manufacturer_name AS manufacturer_name_115,
t110.model_name AS model_name_116,
t110.model_short_name AS model_short_name_117,
t110.model_year AS model_year_118,
t110.deal_type AS deal_type_119,
t110.vehicle_name AS vehicle_name_120,
t110.contract_length AS contract_length_121,
t110.monthly_rate AS monthly_rate_122,
t110.maintenance_monthly_rate AS maintenance_monthly_rate_123,
t110.initial_payment AS initial_payment_124,
t110.includes_vat AS includes_vat_125,
t110.annual_mileage AS annual_mileage_126,
t110.processing_fee AS processing_fee_127,
t110.dealership_code AS dealership_code_128,
t110.product_code AS product_code_129,
t110.dealer_discount AS dealer_discount_130,
t110.gross_yearly_road_tax AS gross_yearly_road_tax_131,
t110.government_adjustment AS government_adjustment_132,
t110.color_id AS color_id_133,
t110.trim_id AS trim_id_134
FROM
application t0
LEFT JOIN private_individual t34 ON t0.private_individual_id = t34.id
LEFT JOIN company t56 ON t0.company_id = t56.id
LEFT JOIN partnership t72 ON t0.partnership_id = t72.id
LEFT JOIN sole_trader t84 ON t0.sole_trader_id = t84.id
LEFT JOIN vehicle t110 ON t0.vehicle_id = t110.id
WHERE
t0.uuid = ?
LIMIT
1
SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.application_type AS application_type_3, t0.declined_at AS declined_at_4, t0.approved_at AS approved_at_5, t0.created_at AS created_at_6, t0.submitted_at AS submitted_at_7, t0.enquiry_source AS enquiry_source_8, t0.callback_url AS callback_url_9, t0.final_declaration AS final_declaration_10, t0.error AS error_11, t0.submitter_ip_address AS submitter_ip_address_12, t0.initial_disclosure_document_url AS initial_disclosure_document_url_13, t0.privacy_policy_url AS privacy_policy_url_14, t0.information_notice_url AS information_notice_url_15, t0.terms_and_conditions_url AS terms_and_conditions_url_16, t0.brand_phone AS brand_phone_17, t0.brand_email AS brand_email_18, t0.brand_open_hours AS brand_open_hours_19, t0.external_brand_id AS external_brand_id_20, t0.brand_logo_url AS brand_logo_url_21, t0.external_order_id AS external_order_id_22, t0.rci_proposal_id AS rci_proposal_id_23, t0.rci_proposal_status AS rci_proposal_status_24, t0.contact_consents_sms AS contact_consents_sms_25, t0.contact_consents_email AS contact_consents_email_26, t0.contact_consents_post AS contact_consents_post_27, t0.contact_consents_telephone AS contact_consents_telephone_28, t0.eula_consents_initial_disclosure_document AS eula_consents_initial_disclosure_document_29, t0.eula_consents_information_notice AS eula_consents_information_notice_30, t0.eula_consents_terms_and_conditions AS eula_consents_terms_and_conditions_31, t0.eula_consents_privacy_policy AS eula_consents_privacy_policy_32, t0.private_individual_id AS private_individual_id_33, t34.prefix_title AS prefix_title_35, t34.first_name AS first_name_36, t34.middle_name AS middle_name_37, t34.surname AS surname_38, t34.birthday AS birthday_39, t34.nationality AS nationality_40, t34.number_of_financial_dependants AS number_of_financial_dependants_41, t34.marital_status AS marital_status_42, t34.driving_licence_number AS driving_licence_number_43, t34.gender AS gender_44, t34.driving_license_issue_date AS driving_license_issue_date_45, t34.driving_license_expiry_date AS driving_license_expiry_date_46, t34.previous_surname AS previous_surname_47, t34.id AS id_48, t34.comments AS comments_49, t34.additional_info_health_corners AS additional_info_health_corners_50, t34.employment_id AS employment_id_51, t34.financial_id AS financial_id_52, t34.contact_id AS contact_id_53, t34.address_id AS address_id_54, t0.company_id AS company_id_55, t56.id AS id_57, t56.company_name AS company_name_58, t56.trading_name AS trading_name_59, t56.registration_number AS registration_number_60, t56.vat_registered AS vat_registered_61, t56.vat_number AS vat_number_62, t56.comments AS comments_63, t56.company_fleet_fleet_size AS company_fleet_fleet_size_64, t56.company_fleet_fleet_size_last6_months AS company_fleet_fleet_size_last6_months_65, t56.company_fleet_commercial_fleet_size AS company_fleet_commercial_fleet_size_66, t56.company_fleet_commercial_fleet_size_last6_months AS company_fleet_commercial_fleet_size_last6_months_67, t56.address_id AS address_id_68, t56.contact_id AS contact_id_69, t56.bank_details_id AS bank_details_id_70, t0.partnership_id AS partnership_id_71, t72.id AS id_73, t72.trading_name AS trading_name_74, t72.comments AS comments_75, t72.partnership_fleet_fleet_size AS partnership_fleet_fleet_size_76, t72.partnership_fleet_fleet_size_last6_months AS partnership_fleet_fleet_size_last6_months_77, t72.partnership_fleet_commercial_fleet_size AS partnership_fleet_commercial_fleet_size_78, t72.partnership_fleet_commercial_fleet_size_last6_months AS partnership_fleet_commercial_fleet_size_last6_months_79, t72.address_id AS address_id_80, t72.contact_id AS contact_id_81, t72.bank_details_id AS bank_details_id_82, t0.sole_trader_id AS sole_trader_id_83, t84.prefix_title AS prefix_title_85, t84.first_name AS first_name_86, t84.middle_name AS middle_name_87, t84.surname AS surname_88, t84.birthday AS birthday_89, t84.nationality AS nationality_90, t84.number_of_financial_dependants AS number_of_financial_dependants_91, t84.marital_status AS marital_status_92, t84.driving_licence_number AS driving_licence_number_93, t84.gender AS gender_94, t84.driving_license_issue_date AS driving_license_issue_date_95, t84.driving_license_expiry_date AS driving_license_expiry_date_96, t84.previous_surname AS previous_surname_97, t84.id AS id_98, t84.trading_name AS trading_name_99, t84.nature_of_business AS nature_of_business_100, t84.trading_since AS trading_since_101, t84.comments AS comments_102, t84.additional_info_health_corners AS additional_info_health_corners_103, t84.trading_address_id AS trading_address_id_104, t84.financial_id AS financial_id_105, t84.employment_id AS employment_id_106, t84.address_id AS address_id_107, t84.contact_id AS contact_id_108, t0.vehicle_id AS vehicle_id_109, t110.id AS id_111, t110.cap_id AS cap_id_112, t110.cap_code AS cap_code_113, t110.type AS type_114, t110.manufacturer_name AS manufacturer_name_115, t110.model_name AS model_name_116, t110.model_short_name AS model_short_name_117, t110.model_year AS model_year_118, t110.deal_type AS deal_type_119, t110.vehicle_name AS vehicle_name_120, t110.contract_length AS contract_length_121, t110.monthly_rate AS monthly_rate_122, t110.maintenance_monthly_rate AS maintenance_monthly_rate_123, t110.initial_payment AS initial_payment_124, t110.includes_vat AS includes_vat_125, t110.annual_mileage AS annual_mileage_126, t110.processing_fee AS processing_fee_127, t110.dealership_code AS dealership_code_128, t110.product_code AS product_code_129, t110.dealer_discount AS dealer_discount_130, t110.gross_yearly_road_tax AS gross_yearly_road_tax_131, t110.government_adjustment AS government_adjustment_132, t110.color_id AS color_id_133, t110.trim_id AS trim_id_134 FROM application t0 LEFT JOIN private_individual t34 ON t0.private_individual_id = t34.id LEFT JOIN company t56 ON t0.company_id = t56.id LEFT JOIN partnership t72 ON t0.partnership_id = t72.id LEFT JOIN sole_trader t84 ON t0.sole_trader_id = t84.id LEFT JOIN vehicle t110 ON t0.vehicle_id = t110.id WHERE t0.uuid = 0x1F1BF2D4B8A066948B62E3DE6E86FBA6 LIMIT 1;
|