| 1 |
1.41 ms |
SELECT t0.applicant_id AS applicant_id_1, t0.sync_flag AS sync_flag_2, t0.ids_by_device AS ids_by_device_3, t0.schedule_available_flag AS schedule_available_flag_4, t0.device_id AS device_id_5, t0.device_id_locked_flag AS device_id_locked_flag_6, t0.lock_device_id_on_next_login_flag AS lock_device_id_on_next_login_flag_7, t0.username AS username_8, t0.email AS email_9, t0.o_auth_unique_id AS o_auth_unique_id_10, t0.o_auth_email AS o_auth_email_11, t0.fb_unique_id AS fb_unique_id_12, t0.li_unique_id AS li_unique_id_13, t0.google_unique_id AS google_unique_id_14, t0.fb_profile_link AS fb_profile_link_15, t0.fb_profile_id AS fb_profile_id_16, t0.ig_profile_link AS ig_profile_link_17, t0.ig_profile_id AS ig_profile_id_18, t0.li_profile_link AS li_profile_link_19, t0.li_profile_id AS li_profile_id_20, t0.user_suspended_app_ids AS user_suspended_app_ids_21, t0.user_app_ids AS user_app_ids_22, t0.user_types_by_app_ids AS user_types_by_app_ids_23, t0.password AS password_24, t0.temp_password AS temp_password_25, t0.salt AS salt_26, t0.email_verification_hash AS email_verification_hash_27, t0.phone_verification_hash AS phone_verification_hash_28, t0.trigger_reset_password AS trigger_reset_password_29, t0.otp_action_id AS otp_action_id_30, t0.otp AS otp_31, t0.otp_expire_ts AS otp_expire_ts_32, t0.forgot_password_token AS forgot_password_token_33, t0.forgot_password_token_expire_ts AS forgot_password_token_expire_ts_34, t0.is_email_verified AS is_email_verified_35, t0.is_phone_verified AS is_phone_verified_36, t0.is_banned AS is_banned_37, t0.ban_expires AS ban_expires_38, t0.strike_count AS strike_count_39, t0.strike_threshold AS strike_threshold_40, t0.account_status AS account_status_41, t0.student_level AS student_level_42, t0.job_applicant_level AS job_applicant_level_43, t0.consultant_level AS consultant_level_44, t0.nationality_country_id AS nationality_country_id_45, t0.current_country_id AS current_country_id_46, t0.user_id AS user_id_47, t0.firstname AS firstname_48, t0.lastname AS lastname_49, t0.image AS image_50, t0.is_img_legal AS is_img_legal_51, t0.nid AS nid_52, t0.dob AS dob_53, t0.sex AS sex_54, t0.father AS father_55, t0.mother AS mother_56, t0.spouse AS spouse_57, t0.child_1 AS child_1_58, t0.child_2 AS child_2_59, t0.blood AS blood_60, t0.phone AS phone_61, t0.official_phone AS official_phone_62, t0.phone_with_country_code AS phone_with_country_code_63, t0.phone_country_code AS phone_country_code_64, t0.curr_addr_state AS curr_addr_state_65, t0.curr_addr_city AS curr_addr_city_66, t0.curr_addr_zip AS curr_addr_zip_67, t0.curr_addr AS curr_addr_68, t0.curr_addr_lat AS curr_addr_lat_69, t0.curr_addr_lng AS curr_addr_lng_70, t0.perm_addr AS perm_addr_71, t0.emm_contact AS emm_contact_72, t0.skill AS skill_73, t0.preferred_topic_ids_as_consultant AS preferred_topic_ids_as_consultant_74, t0.preferred_topic_ids_as_student AS preferred_topic_ids_as_student_75, t0.preferred_country_ids_as_consultant AS preferred_country_ids_as_consultant_76, t0.preferred_country_ids_as_student AS preferred_country_ids_as_student_77, t0.joining_date AS joining_date_78, t0.emp_valid_till AS emp_valid_till_79, t0.emp_status AS emp_status_80, t0.emp_type AS emp_type_81, t0.emp_code AS emp_code_82, t0.emp_label AS emp_label_83, t0.tin AS tin_84, t0.tin_valid_till AS tin_valid_till_85, t0.med_ins AS med_ins_86, t0.med_ins_valid_till AS med_ins_valid_till_87, t0.docs AS docs_88, t0.inst1 AS inst1_89, t0.yr1 AS yr1_90, t0.dur1 AS dur1_91, t0.inst2 AS inst2_92, t0.yr2 AS yr2_93, t0.dur2 AS dur2_94, t0.inst3 AS inst3_95, t0.yr3 AS yr3_96, t0.dur3 AS dur3_97, t0.einst1 AS einst1_98, t0.eyr1 AS eyr1_99, t0.edeg1 AS edeg1_100, t0.einst2 AS einst2_101, t0.eyr2 AS eyr2_102, t0.edeg2 AS edeg2_103, t0.einst3 AS einst3_104, t0.eyr3 AS eyr3_105, t0.edeg3 AS edeg3_106, t0.tax_code AS tax_code_107, t0.allowed_working_hours_per_day AS allowed_working_hours_per_day_108, t0.allowed_working_hours_per_week AS allowed_working_hours_per_week_109, t0.allowed_working_hours_per_month AS allowed_working_hours_per_month_110, t0.allowed_working_hours_per_year AS allowed_working_hours_per_year_111, t0.allowed_earning_per_day AS allowed_earning_per_day_112, t0.allowed_earning_per_week AS allowed_earning_per_week_113, t0.allowed_earning_per_month AS allowed_earning_per_month_114, t0.allowed_earning_per_year AS allowed_earning_per_year_115, t0.revenue_percentage_per_session AS revenue_percentage_per_session_116, t0.transaction_acc_no AS transaction_acc_no_117, t0.transaction_acc_name AS transaction_acc_name_118, t0.bank_id AS bank_id_119, t0.bank_branch_code AS bank_branch_code_120, t0.bank_acc AS bank_acc_121, t0.bank_acc_name AS bank_acc_name_122, t0.bank_acc_type AS bank_acc_type_123, t0.bank_acc_valid_from AS bank_acc_valid_from_124, t0.bank_acc_valid_to AS bank_acc_valid_to_125, t0.routing_code AS routing_code_126, t0.swift_code AS swift_code_127, t0.mobile_wallet_no AS mobile_wallet_no_128, t0.mobile_wallet_type AS mobile_wallet_type_129, t0.ear1 AS ear1_130, t0.ear2 AS ear2_131, t0.ear3 AS ear3_132, t0.ear4 AS ear4_133, t0.ear5 AS ear5_134, t0.ear6 AS ear6_135, t0.eart AS eart_136, t0.ded1 AS ded1_137, t0.ded2 AS ded2_138, t0.ded3 AS ded3_139, t0.ded4 AS ded4_140, t0.dedt AS dedt_141, t0.payable AS payable_142, t0.hand_cash AS hand_cash_143, t0.bank_transfer AS bank_transfer_144, t0.sec_dep AS sec_dep_145, t0.sec_dep_span AS sec_dep_span_146, t0.sec_dep_rem_mon AS sec_dep_rem_mon_147, t0.sec_dep_rem_amount AS sec_dep_rem_amount_148, t0.sl_qty AS sl_qty_149, t0.sl_tkn AS sl_tkn_150, t0.sl_freq AS sl_freq_151, t0.ml_qty AS ml_qty_152, t0.ml_tkn AS ml_tkn_153, t0.ml_freq AS ml_freq_154, t0.el_qty AS el_qty_155, t0.el_tkn AS el_tkn_156, t0.el_freq AS el_freq_157, t0.cl_qty AS cl_qty_158, t0.cl_tkn AS cl_tkn_159, t0.cl_freq AS cl_freq_160, t0.levt AS levt_161, t0.weekly_holiday AS weekly_holiday_162, t0.files AS files_163, t0.supervisor AS supervisor_164, t0.dept AS dept_165, t0.desg AS desg_166, t0.branch AS branch_167, t0.division AS division_168, t0.application_text AS application_text_169, t0.current_employment AS current_employment_170, t0.emergency_contact_number AS emergency_contact_number_171, t0.postal_code AS postal_code_172, t0.country AS country_173, t0.education_data AS education_data_174, t0.work_experience_data AS work_experience_data_175, t0.certificate_data AS certificate_data_176, t0.languages_data AS languages_data_177, t0.important_comm_tags AS important_comm_tags_178, t0.is_consultant AS is_consultant_179, t0.is_featured AS is_featured_180, t0.featured_duration_end_ts AS featured_duration_end_ts_181, t0.is_moderator AS is_moderator_182, t0.is_admin AS is_admin_183, t0.admin_level AS admin_level_184, t0.is_retailer AS is_retailer_185, t0.retailer_level AS retailer_level_186, t0.is_student AS is_student_187, t0.preferred_consultancy_types_as_student AS preferred_consultancy_types_as_student_188, t0.preferred_consultancy_types_as_consultant AS preferred_consultancy_types_as_consultant_189, t0.online_status AS online_status_190, t0.assigned_sales_representative_id AS assigned_sales_representative_id_191, t0.lead_created_by_id AS lead_created_by_id_192, t0.is_temporary_entry AS is_temporary_entry_193, t0.lead_type AS lead_type_194, t0.lead_level AS lead_level_195, t0.immediate_follow_up_flag AS immediate_follow_up_flag_196, t0.pending_initial_communication AS pending_initial_communication_197, t0.last_online_ts AS last_online_ts_198, t0.courses_data AS courses_data_199, t0.video_link AS video_link_200, t0.account_balance AS account_balance_201, t0.session_count_balance AS session_count_balance_202, t0.total_session_used AS total_session_used_203, t0.total_consultancy_session_provided AS total_consultancy_session_provided_204, t0.total_individual_consultancy_session_provided AS total_individual_consultancy_session_provided_205, t0.default_currency_id AS default_currency_id_206, t0.default_language_id AS default_language_id_207, t0.country_id AS country_id_208, t0.following_consultant_ids AS following_consultant_ids_209, t0.following_topic_ids AS following_topic_ids_210, t0.viewed_topic_ids AS viewed_topic_ids_211, t0.viewed_consultant_ids AS viewed_consultant_ids_212, t0.following_event_ids AS following_event_ids_213, t0.attending_event_ids AS attending_event_ids_214, t0.skip_event_ids AS skip_event_ids_215, t0.rating AS rating_216, t0.applicant_specific_note AS applicant_specific_note_217, t0.promo_discount_percentage AS promo_discount_percentage_218, t0.promo_discount_balance_count AS promo_discount_balance_count_219, t0.code_as_referer AS code_as_referer_220, t0.referred_code AS referred_code_221, t0.is_referred_code_used AS is_referred_code_used_222, t0.promo_code_id AS promo_code_id_223, t0.max_discount_allowed AS max_discount_allowed_224, t0.claimed_promo_code_ids AS claimed_promo_code_ids_225, t0.referred_coins_earned AS referred_coins_earned_226, t0.referred_amount_earned AS referred_amount_earned_227, t0.rating_weight AS rating_weight_228, t0.rating_total AS rating_total_229, t0.rating_count AS rating_count_230, t0.preferred_consultancy_language_ids AS preferred_consultancy_language_ids_231, t0.preferred_consultancy_topic_country_ids AS preferred_consultancy_topic_country_ids_232, t0.preferred_consultancy_student_country_ids AS preferred_consultancy_student_country_ids_233, t0.preferred_schedule_data_for_getting_consultancy AS preferred_schedule_data_for_getting_consultancy_234, t0.preferred_schedule_data_for_providing_consultancy AS preferred_schedule_data_for_providing_consultancy_235, t0.selector AS selector_236, t0.apply_for_consultant AS apply_for_consultant_237, t0.apply_for_consultant_date AS apply_for_consultant_date_238, t0.consultant_application_feedback AS consultant_application_feedback_239, t0.apply_for_retailer AS apply_for_retailer_240, t0.apply_for_retailer_date AS apply_for_retailer_date_241, t0.doc_image AS doc_image_242, t0.document_list AS document_list_243, t0.document_list_by_topic_id AS document_list_by_topic_id_244, t0.document_list_by_session_id AS document_list_by_session_id_245, t0.work_experience_year AS work_experience_year_246, t0.description AS description_247, t0.summary_text AS summary_text_248, t0.professional_title AS professional_title_249, t0.work_experience_text AS work_experience_text_250, t0.profession_text AS profession_text_251, t0.education_text AS education_text_252, t0.education_major_text AS education_major_text_253, t0.highest_degree_achieved AS highest_degree_achieved_254, t0.target_education_degree AS target_education_degree_255, t0.target_education_major AS target_education_major_256, t0.lead_query_text AS lead_query_text_257, t0.university_text AS university_text_258, t0.experience_text AS experience_text_259, t0.skillstext AS skillstext_260, t0.interest AS interest_261, t0.speciality AS speciality_262, t0.last_settings_updated_ts AS last_settings_updated_ts_263, t0.created_at AS created_at_264, t0.actual_registration_at AS actual_registration_at_265, t0.updated_at AS updated_at_266 FROM entity_applicant_details t0 WHERE t0.applicant_id = ?
SELECT
t0.applicant_id AS applicant_id_1,
t0.sync_flag AS sync_flag_2,
t0.ids_by_device AS ids_by_device_3,
t0.schedule_available_flag AS schedule_available_flag_4,
t0.device_id AS device_id_5,
t0.device_id_locked_flag AS device_id_locked_flag_6,
t0.lock_device_id_on_next_login_flag AS lock_device_id_on_next_login_flag_7,
t0.username AS username_8,
t0.email AS email_9,
t0.o_auth_unique_id AS o_auth_unique_id_10,
t0.o_auth_email AS o_auth_email_11,
t0.fb_unique_id AS fb_unique_id_12,
t0.li_unique_id AS li_unique_id_13,
t0.google_unique_id AS google_unique_id_14,
t0.fb_profile_link AS fb_profile_link_15,
t0.fb_profile_id AS fb_profile_id_16,
t0.ig_profile_link AS ig_profile_link_17,
t0.ig_profile_id AS ig_profile_id_18,
t0.li_profile_link AS li_profile_link_19,
t0.li_profile_id AS li_profile_id_20,
t0.user_suspended_app_ids AS user_suspended_app_ids_21,
t0.user_app_ids AS user_app_ids_22,
t0.user_types_by_app_ids AS user_types_by_app_ids_23,
t0.password AS password_24,
t0.temp_password AS temp_password_25,
t0.salt AS salt_26,
t0.email_verification_hash AS email_verification_hash_27,
t0.phone_verification_hash AS phone_verification_hash_28,
t0.trigger_reset_password AS trigger_reset_password_29,
t0.otp_action_id AS otp_action_id_30,
t0.otp AS otp_31,
t0.otp_expire_ts AS otp_expire_ts_32,
t0.forgot_password_token AS forgot_password_token_33,
t0.forgot_password_token_expire_ts AS forgot_password_token_expire_ts_34,
t0.is_email_verified AS is_email_verified_35,
t0.is_phone_verified AS is_phone_verified_36,
t0.is_banned AS is_banned_37,
t0.ban_expires AS ban_expires_38,
t0.strike_count AS strike_count_39,
t0.strike_threshold AS strike_threshold_40,
t0.account_status AS account_status_41,
t0.student_level AS student_level_42,
t0.job_applicant_level AS job_applicant_level_43,
t0.consultant_level AS consultant_level_44,
t0.nationality_country_id AS nationality_country_id_45,
t0.current_country_id AS current_country_id_46,
t0.user_id AS user_id_47,
t0.firstname AS firstname_48,
t0.lastname AS lastname_49,
t0.image AS image_50,
t0.is_img_legal AS is_img_legal_51,
t0.nid AS nid_52,
t0.dob AS dob_53,
t0.sex AS sex_54,
t0.father AS father_55,
t0.mother AS mother_56,
t0.spouse AS spouse_57,
t0.child_1 AS child_1_58,
t0.child_2 AS child_2_59,
t0.blood AS blood_60,
t0.phone AS phone_61,
t0.official_phone AS official_phone_62,
t0.phone_with_country_code AS phone_with_country_code_63,
t0.phone_country_code AS phone_country_code_64,
t0.curr_addr_state AS curr_addr_state_65,
t0.curr_addr_city AS curr_addr_city_66,
t0.curr_addr_zip AS curr_addr_zip_67,
t0.curr_addr AS curr_addr_68,
t0.curr_addr_lat AS curr_addr_lat_69,
t0.curr_addr_lng AS curr_addr_lng_70,
t0.perm_addr AS perm_addr_71,
t0.emm_contact AS emm_contact_72,
t0.skill AS skill_73,
t0.preferred_topic_ids_as_consultant AS preferred_topic_ids_as_consultant_74,
t0.preferred_topic_ids_as_student AS preferred_topic_ids_as_student_75,
t0.preferred_country_ids_as_consultant AS preferred_country_ids_as_consultant_76,
t0.preferred_country_ids_as_student AS preferred_country_ids_as_student_77,
t0.joining_date AS joining_date_78,
t0.emp_valid_till AS emp_valid_till_79,
t0.emp_status AS emp_status_80,
t0.emp_type AS emp_type_81,
t0.emp_code AS emp_code_82,
t0.emp_label AS emp_label_83,
t0.tin AS tin_84,
t0.tin_valid_till AS tin_valid_till_85,
t0.med_ins AS med_ins_86,
t0.med_ins_valid_till AS med_ins_valid_till_87,
t0.docs AS docs_88,
t0.inst1 AS inst1_89,
t0.yr1 AS yr1_90,
t0.dur1 AS dur1_91,
t0.inst2 AS inst2_92,
t0.yr2 AS yr2_93,
t0.dur2 AS dur2_94,
t0.inst3 AS inst3_95,
t0.yr3 AS yr3_96,
t0.dur3 AS dur3_97,
t0.einst1 AS einst1_98,
t0.eyr1 AS eyr1_99,
t0.edeg1 AS edeg1_100,
t0.einst2 AS einst2_101,
t0.eyr2 AS eyr2_102,
t0.edeg2 AS edeg2_103,
t0.einst3 AS einst3_104,
t0.eyr3 AS eyr3_105,
t0.edeg3 AS edeg3_106,
t0.tax_code AS tax_code_107,
t0.allowed_working_hours_per_day AS allowed_working_hours_per_day_108,
t0.allowed_working_hours_per_week AS allowed_working_hours_per_week_109,
t0.allowed_working_hours_per_month AS allowed_working_hours_per_month_110,
t0.allowed_working_hours_per_year AS allowed_working_hours_per_year_111,
t0.allowed_earning_per_day AS allowed_earning_per_day_112,
t0.allowed_earning_per_week AS allowed_earning_per_week_113,
t0.allowed_earning_per_month AS allowed_earning_per_month_114,
t0.allowed_earning_per_year AS allowed_earning_per_year_115,
t0.revenue_percentage_per_session AS revenue_percentage_per_session_116,
t0.transaction_acc_no AS transaction_acc_no_117,
t0.transaction_acc_name AS transaction_acc_name_118,
t0.bank_id AS bank_id_119,
t0.bank_branch_code AS bank_branch_code_120,
t0.bank_acc AS bank_acc_121,
t0.bank_acc_name AS bank_acc_name_122,
t0.bank_acc_type AS bank_acc_type_123,
t0.bank_acc_valid_from AS bank_acc_valid_from_124,
t0.bank_acc_valid_to AS bank_acc_valid_to_125,
t0.routing_code AS routing_code_126,
t0.swift_code AS swift_code_127,
t0.mobile_wallet_no AS mobile_wallet_no_128,
t0.mobile_wallet_type AS mobile_wallet_type_129,
t0.ear1 AS ear1_130,
t0.ear2 AS ear2_131,
t0.ear3 AS ear3_132,
t0.ear4 AS ear4_133,
t0.ear5 AS ear5_134,
t0.ear6 AS ear6_135,
t0.eart AS eart_136,
t0.ded1 AS ded1_137,
t0.ded2 AS ded2_138,
t0.ded3 AS ded3_139,
t0.ded4 AS ded4_140,
t0.dedt AS dedt_141,
t0.payable AS payable_142,
t0.hand_cash AS hand_cash_143,
t0.bank_transfer AS bank_transfer_144,
t0.sec_dep AS sec_dep_145,
t0.sec_dep_span AS sec_dep_span_146,
t0.sec_dep_rem_mon AS sec_dep_rem_mon_147,
t0.sec_dep_rem_amount AS sec_dep_rem_amount_148,
t0.sl_qty AS sl_qty_149,
t0.sl_tkn AS sl_tkn_150,
t0.sl_freq AS sl_freq_151,
t0.ml_qty AS ml_qty_152,
t0.ml_tkn AS ml_tkn_153,
t0.ml_freq AS ml_freq_154,
t0.el_qty AS el_qty_155,
t0.el_tkn AS el_tkn_156,
t0.el_freq AS el_freq_157,
t0.cl_qty AS cl_qty_158,
t0.cl_tkn AS cl_tkn_159,
t0.cl_freq AS cl_freq_160,
t0.levt AS levt_161,
t0.weekly_holiday AS weekly_holiday_162,
t0.files AS files_163,
t0.supervisor AS supervisor_164,
t0.dept AS dept_165,
t0.desg AS desg_166,
t0.branch AS branch_167,
t0.division AS division_168,
t0.application_text AS application_text_169,
t0.current_employment AS current_employment_170,
t0.emergency_contact_number AS emergency_contact_number_171,
t0.postal_code AS postal_code_172,
t0.country AS country_173,
t0.education_data AS education_data_174,
t0.work_experience_data AS work_experience_data_175,
t0.certificate_data AS certificate_data_176,
t0.languages_data AS languages_data_177,
t0.important_comm_tags AS important_comm_tags_178,
t0.is_consultant AS is_consultant_179,
t0.is_featured AS is_featured_180,
t0.featured_duration_end_ts AS featured_duration_end_ts_181,
t0.is_moderator AS is_moderator_182,
t0.is_admin AS is_admin_183,
t0.admin_level AS admin_level_184,
t0.is_retailer AS is_retailer_185,
t0.retailer_level AS retailer_level_186,
t0.is_student AS is_student_187,
t0.preferred_consultancy_types_as_student AS preferred_consultancy_types_as_student_188,
t0.preferred_consultancy_types_as_consultant AS preferred_consultancy_types_as_consultant_189,
t0.online_status AS online_status_190,
t0.assigned_sales_representative_id AS assigned_sales_representative_id_191,
t0.lead_created_by_id AS lead_created_by_id_192,
t0.is_temporary_entry AS is_temporary_entry_193,
t0.lead_type AS lead_type_194,
t0.lead_level AS lead_level_195,
t0.immediate_follow_up_flag AS immediate_follow_up_flag_196,
t0.pending_initial_communication AS pending_initial_communication_197,
t0.last_online_ts AS last_online_ts_198,
t0.courses_data AS courses_data_199,
t0.video_link AS video_link_200,
t0.account_balance AS account_balance_201,
t0.session_count_balance AS session_count_balance_202,
t0.total_session_used AS total_session_used_203,
t0.total_consultancy_session_provided AS total_consultancy_session_provided_204,
t0.total_individual_consultancy_session_provided AS total_individual_consultancy_session_provided_205,
t0.default_currency_id AS default_currency_id_206,
t0.default_language_id AS default_language_id_207,
t0.country_id AS country_id_208,
t0.following_consultant_ids AS following_consultant_ids_209,
t0.following_topic_ids AS following_topic_ids_210,
t0.viewed_topic_ids AS viewed_topic_ids_211,
t0.viewed_consultant_ids AS viewed_consultant_ids_212,
t0.following_event_ids AS following_event_ids_213,
t0.attending_event_ids AS attending_event_ids_214,
t0.skip_event_ids AS skip_event_ids_215,
t0.rating AS rating_216,
t0.applicant_specific_note AS applicant_specific_note_217,
t0.promo_discount_percentage AS promo_discount_percentage_218,
t0.promo_discount_balance_count AS promo_discount_balance_count_219,
t0.code_as_referer AS code_as_referer_220,
t0.referred_code AS referred_code_221,
t0.is_referred_code_used AS is_referred_code_used_222,
t0.promo_code_id AS promo_code_id_223,
t0.max_discount_allowed AS max_discount_allowed_224,
t0.claimed_promo_code_ids AS claimed_promo_code_ids_225,
t0.referred_coins_earned AS referred_coins_earned_226,
t0.referred_amount_earned AS referred_amount_earned_227,
t0.rating_weight AS rating_weight_228,
t0.rating_total AS rating_total_229,
t0.rating_count AS rating_count_230,
t0.preferred_consultancy_language_ids AS preferred_consultancy_language_ids_231,
t0.preferred_consultancy_topic_country_ids AS preferred_consultancy_topic_country_ids_232,
t0.preferred_consultancy_student_country_ids AS preferred_consultancy_student_country_ids_233,
t0.preferred_schedule_data_for_getting_consultancy AS preferred_schedule_data_for_getting_consultancy_234,
t0.preferred_schedule_data_for_providing_consultancy AS preferred_schedule_data_for_providing_consultancy_235,
t0.selector AS selector_236,
t0.apply_for_consultant AS apply_for_consultant_237,
t0.apply_for_consultant_date AS apply_for_consultant_date_238,
t0.consultant_application_feedback AS consultant_application_feedback_239,
t0.apply_for_retailer AS apply_for_retailer_240,
t0.apply_for_retailer_date AS apply_for_retailer_date_241,
t0.doc_image AS doc_image_242,
t0.document_list AS document_list_243,
t0.document_list_by_topic_id AS document_list_by_topic_id_244,
t0.document_list_by_session_id AS document_list_by_session_id_245,
t0.work_experience_year AS work_experience_year_246,
t0.description AS description_247,
t0.summary_text AS summary_text_248,
t0.professional_title AS professional_title_249,
t0.work_experience_text AS work_experience_text_250,
t0.profession_text AS profession_text_251,
t0.education_text AS education_text_252,
t0.education_major_text AS education_major_text_253,
t0.highest_degree_achieved AS highest_degree_achieved_254,
t0.target_education_degree AS target_education_degree_255,
t0.target_education_major AS target_education_major_256,
t0.lead_query_text AS lead_query_text_257,
t0.university_text AS university_text_258,
t0.experience_text AS experience_text_259,
t0.skillstext AS skillstext_260,
t0.interest AS interest_261,
t0.speciality AS speciality_262,
t0.last_settings_updated_ts AS last_settings_updated_ts_263,
t0.created_at AS created_at_264,
t0.actual_registration_at AS actual_registration_at_265,
t0.updated_at AS updated_at_266
FROM
entity_applicant_details t0
WHERE
t0.applicant_id = ?
SELECT t0.applicant_id AS applicant_id_1, t0.sync_flag AS sync_flag_2, t0.ids_by_device AS ids_by_device_3, t0.schedule_available_flag AS schedule_available_flag_4, t0.device_id AS device_id_5, t0.device_id_locked_flag AS device_id_locked_flag_6, t0.lock_device_id_on_next_login_flag AS lock_device_id_on_next_login_flag_7, t0.username AS username_8, t0.email AS email_9, t0.o_auth_unique_id AS o_auth_unique_id_10, t0.o_auth_email AS o_auth_email_11, t0.fb_unique_id AS fb_unique_id_12, t0.li_unique_id AS li_unique_id_13, t0.google_unique_id AS google_unique_id_14, t0.fb_profile_link AS fb_profile_link_15, t0.fb_profile_id AS fb_profile_id_16, t0.ig_profile_link AS ig_profile_link_17, t0.ig_profile_id AS ig_profile_id_18, t0.li_profile_link AS li_profile_link_19, t0.li_profile_id AS li_profile_id_20, t0.user_suspended_app_ids AS user_suspended_app_ids_21, t0.user_app_ids AS user_app_ids_22, t0.user_types_by_app_ids AS user_types_by_app_ids_23, t0.password AS password_24, t0.temp_password AS temp_password_25, t0.salt AS salt_26, t0.email_verification_hash AS email_verification_hash_27, t0.phone_verification_hash AS phone_verification_hash_28, t0.trigger_reset_password AS trigger_reset_password_29, t0.otp_action_id AS otp_action_id_30, t0.otp AS otp_31, t0.otp_expire_ts AS otp_expire_ts_32, t0.forgot_password_token AS forgot_password_token_33, t0.forgot_password_token_expire_ts AS forgot_password_token_expire_ts_34, t0.is_email_verified AS is_email_verified_35, t0.is_phone_verified AS is_phone_verified_36, t0.is_banned AS is_banned_37, t0.ban_expires AS ban_expires_38, t0.strike_count AS strike_count_39, t0.strike_threshold AS strike_threshold_40, t0.account_status AS account_status_41, t0.student_level AS student_level_42, t0.job_applicant_level AS job_applicant_level_43, t0.consultant_level AS consultant_level_44, t0.nationality_country_id AS nationality_country_id_45, t0.current_country_id AS current_country_id_46, t0.user_id AS user_id_47, t0.firstname AS firstname_48, t0.lastname AS lastname_49, t0.image AS image_50, t0.is_img_legal AS is_img_legal_51, t0.nid AS nid_52, t0.dob AS dob_53, t0.sex AS sex_54, t0.father AS father_55, t0.mother AS mother_56, t0.spouse AS spouse_57, t0.child_1 AS child_1_58, t0.child_2 AS child_2_59, t0.blood AS blood_60, t0.phone AS phone_61, t0.official_phone AS official_phone_62, t0.phone_with_country_code AS phone_with_country_code_63, t0.phone_country_code AS phone_country_code_64, t0.curr_addr_state AS curr_addr_state_65, t0.curr_addr_city AS curr_addr_city_66, t0.curr_addr_zip AS curr_addr_zip_67, t0.curr_addr AS curr_addr_68, t0.curr_addr_lat AS curr_addr_lat_69, t0.curr_addr_lng AS curr_addr_lng_70, t0.perm_addr AS perm_addr_71, t0.emm_contact AS emm_contact_72, t0.skill AS skill_73, t0.preferred_topic_ids_as_consultant AS preferred_topic_ids_as_consultant_74, t0.preferred_topic_ids_as_student AS preferred_topic_ids_as_student_75, t0.preferred_country_ids_as_consultant AS preferred_country_ids_as_consultant_76, t0.preferred_country_ids_as_student AS preferred_country_ids_as_student_77, t0.joining_date AS joining_date_78, t0.emp_valid_till AS emp_valid_till_79, t0.emp_status AS emp_status_80, t0.emp_type AS emp_type_81, t0.emp_code AS emp_code_82, t0.emp_label AS emp_label_83, t0.tin AS tin_84, t0.tin_valid_till AS tin_valid_till_85, t0.med_ins AS med_ins_86, t0.med_ins_valid_till AS med_ins_valid_till_87, t0.docs AS docs_88, t0.inst1 AS inst1_89, t0.yr1 AS yr1_90, t0.dur1 AS dur1_91, t0.inst2 AS inst2_92, t0.yr2 AS yr2_93, t0.dur2 AS dur2_94, t0.inst3 AS inst3_95, t0.yr3 AS yr3_96, t0.dur3 AS dur3_97, t0.einst1 AS einst1_98, t0.eyr1 AS eyr1_99, t0.edeg1 AS edeg1_100, t0.einst2 AS einst2_101, t0.eyr2 AS eyr2_102, t0.edeg2 AS edeg2_103, t0.einst3 AS einst3_104, t0.eyr3 AS eyr3_105, t0.edeg3 AS edeg3_106, t0.tax_code AS tax_code_107, t0.allowed_working_hours_per_day AS allowed_working_hours_per_day_108, t0.allowed_working_hours_per_week AS allowed_working_hours_per_week_109, t0.allowed_working_hours_per_month AS allowed_working_hours_per_month_110, t0.allowed_working_hours_per_year AS allowed_working_hours_per_year_111, t0.allowed_earning_per_day AS allowed_earning_per_day_112, t0.allowed_earning_per_week AS allowed_earning_per_week_113, t0.allowed_earning_per_month AS allowed_earning_per_month_114, t0.allowed_earning_per_year AS allowed_earning_per_year_115, t0.revenue_percentage_per_session AS revenue_percentage_per_session_116, t0.transaction_acc_no AS transaction_acc_no_117, t0.transaction_acc_name AS transaction_acc_name_118, t0.bank_id AS bank_id_119, t0.bank_branch_code AS bank_branch_code_120, t0.bank_acc AS bank_acc_121, t0.bank_acc_name AS bank_acc_name_122, t0.bank_acc_type AS bank_acc_type_123, t0.bank_acc_valid_from AS bank_acc_valid_from_124, t0.bank_acc_valid_to AS bank_acc_valid_to_125, t0.routing_code AS routing_code_126, t0.swift_code AS swift_code_127, t0.mobile_wallet_no AS mobile_wallet_no_128, t0.mobile_wallet_type AS mobile_wallet_type_129, t0.ear1 AS ear1_130, t0.ear2 AS ear2_131, t0.ear3 AS ear3_132, t0.ear4 AS ear4_133, t0.ear5 AS ear5_134, t0.ear6 AS ear6_135, t0.eart AS eart_136, t0.ded1 AS ded1_137, t0.ded2 AS ded2_138, t0.ded3 AS ded3_139, t0.ded4 AS ded4_140, t0.dedt AS dedt_141, t0.payable AS payable_142, t0.hand_cash AS hand_cash_143, t0.bank_transfer AS bank_transfer_144, t0.sec_dep AS sec_dep_145, t0.sec_dep_span AS sec_dep_span_146, t0.sec_dep_rem_mon AS sec_dep_rem_mon_147, t0.sec_dep_rem_amount AS sec_dep_rem_amount_148, t0.sl_qty AS sl_qty_149, t0.sl_tkn AS sl_tkn_150, t0.sl_freq AS sl_freq_151, t0.ml_qty AS ml_qty_152, t0.ml_tkn AS ml_tkn_153, t0.ml_freq AS ml_freq_154, t0.el_qty AS el_qty_155, t0.el_tkn AS el_tkn_156, t0.el_freq AS el_freq_157, t0.cl_qty AS cl_qty_158, t0.cl_tkn AS cl_tkn_159, t0.cl_freq AS cl_freq_160, t0.levt AS levt_161, t0.weekly_holiday AS weekly_holiday_162, t0.files AS files_163, t0.supervisor AS supervisor_164, t0.dept AS dept_165, t0.desg AS desg_166, t0.branch AS branch_167, t0.division AS division_168, t0.application_text AS application_text_169, t0.current_employment AS current_employment_170, t0.emergency_contact_number AS emergency_contact_number_171, t0.postal_code AS postal_code_172, t0.country AS country_173, t0.education_data AS education_data_174, t0.work_experience_data AS work_experience_data_175, t0.certificate_data AS certificate_data_176, t0.languages_data AS languages_data_177, t0.important_comm_tags AS important_comm_tags_178, t0.is_consultant AS is_consultant_179, t0.is_featured AS is_featured_180, t0.featured_duration_end_ts AS featured_duration_end_ts_181, t0.is_moderator AS is_moderator_182, t0.is_admin AS is_admin_183, t0.admin_level AS admin_level_184, t0.is_retailer AS is_retailer_185, t0.retailer_level AS retailer_level_186, t0.is_student AS is_student_187, t0.preferred_consultancy_types_as_student AS preferred_consultancy_types_as_student_188, t0.preferred_consultancy_types_as_consultant AS preferred_consultancy_types_as_consultant_189, t0.online_status AS online_status_190, t0.assigned_sales_representative_id AS assigned_sales_representative_id_191, t0.lead_created_by_id AS lead_created_by_id_192, t0.is_temporary_entry AS is_temporary_entry_193, t0.lead_type AS lead_type_194, t0.lead_level AS lead_level_195, t0.immediate_follow_up_flag AS immediate_follow_up_flag_196, t0.pending_initial_communication AS pending_initial_communication_197, t0.last_online_ts AS last_online_ts_198, t0.courses_data AS courses_data_199, t0.video_link AS video_link_200, t0.account_balance AS account_balance_201, t0.session_count_balance AS session_count_balance_202, t0.total_session_used AS total_session_used_203, t0.total_consultancy_session_provided AS total_consultancy_session_provided_204, t0.total_individual_consultancy_session_provided AS total_individual_consultancy_session_provided_205, t0.default_currency_id AS default_currency_id_206, t0.default_language_id AS default_language_id_207, t0.country_id AS country_id_208, t0.following_consultant_ids AS following_consultant_ids_209, t0.following_topic_ids AS following_topic_ids_210, t0.viewed_topic_ids AS viewed_topic_ids_211, t0.viewed_consultant_ids AS viewed_consultant_ids_212, t0.following_event_ids AS following_event_ids_213, t0.attending_event_ids AS attending_event_ids_214, t0.skip_event_ids AS skip_event_ids_215, t0.rating AS rating_216, t0.applicant_specific_note AS applicant_specific_note_217, t0.promo_discount_percentage AS promo_discount_percentage_218, t0.promo_discount_balance_count AS promo_discount_balance_count_219, t0.code_as_referer AS code_as_referer_220, t0.referred_code AS referred_code_221, t0.is_referred_code_used AS is_referred_code_used_222, t0.promo_code_id AS promo_code_id_223, t0.max_discount_allowed AS max_discount_allowed_224, t0.claimed_promo_code_ids AS claimed_promo_code_ids_225, t0.referred_coins_earned AS referred_coins_earned_226, t0.referred_amount_earned AS referred_amount_earned_227, t0.rating_weight AS rating_weight_228, t0.rating_total AS rating_total_229, t0.rating_count AS rating_count_230, t0.preferred_consultancy_language_ids AS preferred_consultancy_language_ids_231, t0.preferred_consultancy_topic_country_ids AS preferred_consultancy_topic_country_ids_232, t0.preferred_consultancy_student_country_ids AS preferred_consultancy_student_country_ids_233, t0.preferred_schedule_data_for_getting_consultancy AS preferred_schedule_data_for_getting_consultancy_234, t0.preferred_schedule_data_for_providing_consultancy AS preferred_schedule_data_for_providing_consultancy_235, t0.selector AS selector_236, t0.apply_for_consultant AS apply_for_consultant_237, t0.apply_for_consultant_date AS apply_for_consultant_date_238, t0.consultant_application_feedback AS consultant_application_feedback_239, t0.apply_for_retailer AS apply_for_retailer_240, t0.apply_for_retailer_date AS apply_for_retailer_date_241, t0.doc_image AS doc_image_242, t0.document_list AS document_list_243, t0.document_list_by_topic_id AS document_list_by_topic_id_244, t0.document_list_by_session_id AS document_list_by_session_id_245, t0.work_experience_year AS work_experience_year_246, t0.description AS description_247, t0.summary_text AS summary_text_248, t0.professional_title AS professional_title_249, t0.work_experience_text AS work_experience_text_250, t0.profession_text AS profession_text_251, t0.education_text AS education_text_252, t0.education_major_text AS education_major_text_253, t0.highest_degree_achieved AS highest_degree_achieved_254, t0.target_education_degree AS target_education_degree_255, t0.target_education_major AS target_education_major_256, t0.lead_query_text AS lead_query_text_257, t0.university_text AS university_text_258, t0.experience_text AS experience_text_259, t0.skillstext AS skillstext_260, t0.interest AS interest_261, t0.speciality AS speciality_262, t0.last_settings_updated_ts AS last_settings_updated_ts_263, t0.created_at AS created_at_264, t0.actual_registration_at AS actual_registration_at_265, t0.updated_at AS updated_at_266 FROM entity_applicant_details t0 WHERE t0.applicant_id = '53';
|
| 2 |
1.24 ms |
SELECT c0_.id AS id_0, c0_.sync_flag AS sync_flag_1, c0_.name AS name_2, c0_.image AS image_3, c0_.app_id AS app_id_4, c0_.owner_id AS owner_id_5, c0_.stripe_customer_id AS stripe_customer_id_6, c0_.manage_user_ids AS manage_user_ids_7, c0_.post_dated_job_active AS post_dated_job_active_8, c0_.address AS address_9, c0_.shipping_address AS shipping_address_10, c0_.billing_address AS billing_address_11, c0_.motto AS motto_12, c0_.invoice_footer AS invoice_footer_13, c0_.general_footer AS general_footer_14, c0_.company_allowed AS company_allowed_15, c0_.company_allocated AS company_allocated_16, c0_.country_id AS country_id_17, c0_.locale AS locale_18, c0_.company_remaining AS company_remaining_19, c0_.user_allowed AS user_allowed_20, c0_.user_allocated AS user_allocated_21, c0_.user_remaining AS user_remaining_22, c0_.admin_user_allowed AS admin_user_allowed_23, c0_.admin_user_allocated AS admin_user_allocated_24, c0_.admin_user_remaining AS admin_user_remaining_25, c0_.contact_number AS contact_number_26, c0_.email AS email_27, c0_.db_name AS db_name_28, c0_.db_pass AS db_pass_29, c0_.db_user AS db_user_30, c0_.db_host AS db_host_31, c0_.company_group_hash AS company_group_hash_32, c0_.company_group_unique_code AS company_group_unique_code_33, c0_.enabled_module_id_list AS enabled_module_id_list_34, c0_.company_group_server_id AS company_group_server_id_35, c0_.company_group_server_hash AS company_group_server_hash_36, c0_.company_group_server_address AS company_group_server_address_37, c0_.company_group_server_port AS company_group_server_port_38, c0_.company_bin AS company_bin_39, c0_.company_tin AS company_tin_40, c0_.company_reg AS company_reg_41, c0_.company_tl AS company_tl_42, c0_.initiate_flag AS initiate_flag_43, c0_.current_server_id AS current_server_id_44, c0_.current_server_hash AS current_server_hash_45, c0_.current_server_address AS current_server_address_46, c0_.current_server_port AS current_server_port_47, c0_.usage_valid_upto_date AS usage_valid_upto_date_48, c0_.usage_valid_upto_date_ts AS usage_valid_upto_date_ts_49, c0_.company_group_server_domain_full_link AS company_group_server_domain_full_link_50, c0_.current_server_domain_full_link AS current_server_domain_full_link_51, c0_.company_group_billing_info AS company_group_billing_info_52, c0_.company_group_next_bill_date AS company_group_next_bill_date_53, c0_.company_group_next_bill_date_ts AS company_group_next_bill_date_ts_54, c0_.company_group_billing_frequency AS company_group_billing_frequency_55, c0_.cash AS cash_56, c0_.sales AS sales_57, c0_.expense AS expense_58, c0_.payable AS payable_59, c0_.net_worth AS net_worth_60, c0_.monthly_growth AS monthly_growth_61, c0_.active AS active_62, c0_.read_only_mode AS read_only_mode_63, c0_.company_status AS company_status_64, c0_.package_type AS package_type_65, c0_.subscription_expiry AS subscription_expiry_66, c0_.last_activity_at AS last_activity_at_67, c0_.current_subscription_package_id AS current_subscription_package_id_68, c0_.subscription_month AS subscription_month_69, c0_.billing_amount AS billing_amount_70, c0_.subscription_details AS subscription_details_71, c0_.company_type AS company_type_72, c0_.company_description AS company_description_73, c0_.skip_in_web_flag AS skip_in_web_flag_74, c0_.skip_in_app_flag AS skip_in_app_flag_75, c0_.schema_update_pending_flag AS schema_update_pending_flag_76, c0_.created_at AS created_at_77, c0_.updated_at AS updated_at_78 FROM company_group c0_ WHERE c0_.app_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters: [
473
488
489
491
492
493
494
495
496
497
9013
9051
9113
9128
9129
9130
9145
9174
9253
9255
9275
9287
9288
9289
9334
9370
9371
9372
9373
9374
9376
9377
9378
]
SELECT
c0_.id AS id_0,
c0_.sync_flag AS sync_flag_1,
c0_.name AS name_2,
c0_.image AS image_3,
c0_.app_id AS app_id_4,
c0_.owner_id AS owner_id_5,
c0_.stripe_customer_id AS stripe_customer_id_6,
c0_.manage_user_ids AS manage_user_ids_7,
c0_.post_dated_job_active AS post_dated_job_active_8,
c0_.address AS address_9,
c0_.shipping_address AS shipping_address_10,
c0_.billing_address AS billing_address_11,
c0_.motto AS motto_12,
c0_.invoice_footer AS invoice_footer_13,
c0_.general_footer AS general_footer_14,
c0_.company_allowed AS company_allowed_15,
c0_.company_allocated AS company_allocated_16,
c0_.country_id AS country_id_17,
c0_.locale AS locale_18,
c0_.company_remaining AS company_remaining_19,
c0_.user_allowed AS user_allowed_20,
c0_.user_allocated AS user_allocated_21,
c0_.user_remaining AS user_remaining_22,
c0_.admin_user_allowed AS admin_user_allowed_23,
c0_.admin_user_allocated AS admin_user_allocated_24,
c0_.admin_user_remaining AS admin_user_remaining_25,
c0_.contact_number AS contact_number_26,
c0_.email AS email_27,
c0_.db_name AS db_name_28,
c0_.db_pass AS db_pass_29,
c0_.db_user AS db_user_30,
c0_.db_host AS db_host_31,
c0_.company_group_hash AS company_group_hash_32,
c0_.company_group_unique_code AS company_group_unique_code_33,
c0_.enabled_module_id_list AS enabled_module_id_list_34,
c0_.company_group_server_id AS company_group_server_id_35,
c0_.company_group_server_hash AS company_group_server_hash_36,
c0_.company_group_server_address AS company_group_server_address_37,
c0_.company_group_server_port AS company_group_server_port_38,
c0_.company_bin AS company_bin_39,
c0_.company_tin AS company_tin_40,
c0_.company_reg AS company_reg_41,
c0_.company_tl AS company_tl_42,
c0_.initiate_flag AS initiate_flag_43,
c0_.current_server_id AS current_server_id_44,
c0_.current_server_hash AS current_server_hash_45,
c0_.current_server_address AS current_server_address_46,
c0_.current_server_port AS current_server_port_47,
c0_.usage_valid_upto_date AS usage_valid_upto_date_48,
c0_.usage_valid_upto_date_ts AS usage_valid_upto_date_ts_49,
c0_.company_group_server_domain_full_link AS company_group_server_domain_full_link_50,
c0_.current_server_domain_full_link AS current_server_domain_full_link_51,
c0_.company_group_billing_info AS company_group_billing_info_52,
c0_.company_group_next_bill_date AS company_group_next_bill_date_53,
c0_.company_group_next_bill_date_ts AS company_group_next_bill_date_ts_54,
c0_.company_group_billing_frequency AS company_group_billing_frequency_55,
c0_.cash AS cash_56,
c0_.sales AS sales_57,
c0_.expense AS expense_58,
c0_.payable AS payable_59,
c0_.net_worth AS net_worth_60,
c0_.monthly_growth AS monthly_growth_61,
c0_.active AS active_62,
c0_.read_only_mode AS read_only_mode_63,
c0_.company_status AS company_status_64,
c0_.package_type AS package_type_65,
c0_.subscription_expiry AS subscription_expiry_66,
c0_.last_activity_at AS last_activity_at_67,
c0_.current_subscription_package_id AS current_subscription_package_id_68,
c0_.subscription_month AS subscription_month_69,
c0_.billing_amount AS billing_amount_70,
c0_.subscription_details AS subscription_details_71,
c0_.company_type AS company_type_72,
c0_.company_description AS company_description_73,
c0_.skip_in_web_flag AS skip_in_web_flag_74,
c0_.skip_in_app_flag AS skip_in_app_flag_75,
c0_.schema_update_pending_flag AS schema_update_pending_flag_76,
c0_.created_at AS created_at_77,
c0_.updated_at AS updated_at_78
FROM
company_group c0_
WHERE
c0_.app_id IN (
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
?, ?
)
SELECT c0_.id AS id_0, c0_.sync_flag AS sync_flag_1, c0_.name AS name_2, c0_.image AS image_3, c0_.app_id AS app_id_4, c0_.owner_id AS owner_id_5, c0_.stripe_customer_id AS stripe_customer_id_6, c0_.manage_user_ids AS manage_user_ids_7, c0_.post_dated_job_active AS post_dated_job_active_8, c0_.address AS address_9, c0_.shipping_address AS shipping_address_10, c0_.billing_address AS billing_address_11, c0_.motto AS motto_12, c0_.invoice_footer AS invoice_footer_13, c0_.general_footer AS general_footer_14, c0_.company_allowed AS company_allowed_15, c0_.company_allocated AS company_allocated_16, c0_.country_id AS country_id_17, c0_.locale AS locale_18, c0_.company_remaining AS company_remaining_19, c0_.user_allowed AS user_allowed_20, c0_.user_allocated AS user_allocated_21, c0_.user_remaining AS user_remaining_22, c0_.admin_user_allowed AS admin_user_allowed_23, c0_.admin_user_allocated AS admin_user_allocated_24, c0_.admin_user_remaining AS admin_user_remaining_25, c0_.contact_number AS contact_number_26, c0_.email AS email_27, c0_.db_name AS db_name_28, c0_.db_pass AS db_pass_29, c0_.db_user AS db_user_30, c0_.db_host AS db_host_31, c0_.company_group_hash AS company_group_hash_32, c0_.company_group_unique_code AS company_group_unique_code_33, c0_.enabled_module_id_list AS enabled_module_id_list_34, c0_.company_group_server_id AS company_group_server_id_35, c0_.company_group_server_hash AS company_group_server_hash_36, c0_.company_group_server_address AS company_group_server_address_37, c0_.company_group_server_port AS company_group_server_port_38, c0_.company_bin AS company_bin_39, c0_.company_tin AS company_tin_40, c0_.company_reg AS company_reg_41, c0_.company_tl AS company_tl_42, c0_.initiate_flag AS initiate_flag_43, c0_.current_server_id AS current_server_id_44, c0_.current_server_hash AS current_server_hash_45, c0_.current_server_address AS current_server_address_46, c0_.current_server_port AS current_server_port_47, c0_.usage_valid_upto_date AS usage_valid_upto_date_48, c0_.usage_valid_upto_date_ts AS usage_valid_upto_date_ts_49, c0_.company_group_server_domain_full_link AS company_group_server_domain_full_link_50, c0_.current_server_domain_full_link AS current_server_domain_full_link_51, c0_.company_group_billing_info AS company_group_billing_info_52, c0_.company_group_next_bill_date AS company_group_next_bill_date_53, c0_.company_group_next_bill_date_ts AS company_group_next_bill_date_ts_54, c0_.company_group_billing_frequency AS company_group_billing_frequency_55, c0_.cash AS cash_56, c0_.sales AS sales_57, c0_.expense AS expense_58, c0_.payable AS payable_59, c0_.net_worth AS net_worth_60, c0_.monthly_growth AS monthly_growth_61, c0_.active AS active_62, c0_.read_only_mode AS read_only_mode_63, c0_.company_status AS company_status_64, c0_.package_type AS package_type_65, c0_.subscription_expiry AS subscription_expiry_66, c0_.last_activity_at AS last_activity_at_67, c0_.current_subscription_package_id AS current_subscription_package_id_68, c0_.subscription_month AS subscription_month_69, c0_.billing_amount AS billing_amount_70, c0_.subscription_details AS subscription_details_71, c0_.company_type AS company_type_72, c0_.company_description AS company_description_73, c0_.skip_in_web_flag AS skip_in_web_flag_74, c0_.skip_in_app_flag AS skip_in_app_flag_75, c0_.schema_update_pending_flag AS schema_update_pending_flag_76, c0_.created_at AS created_at_77, c0_.updated_at AS updated_at_78 FROM company_group c0_ WHERE c0_.app_id IN (473, 488, 489, 491, 492, 493, 494, 495, 496, 497, 9013, 9051, 9113, 9128, 9129, 9130, 9145, 9174, 9253, 9255, 9275, 9287, 9288, 9289, 9334, 9370, 9371, 9372, 9373, 9374, 9376, 9377, 9378);
|