2.16 ms (100.00%)
1
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 . claimed_promo_code_ids AS claimed_promo_code_ids_224 , t0 . referred_coins_earned AS referred_coins_earned_225 , t0 . referred_amount_earned AS referred_amount_earned_226 , t0 . rating_weight AS rating_weight_227 , t0 . rating_total AS rating_total_228 , t0 . rating_count AS rating_count_229 , t0 . preferred_consultancy_language_ids AS preferred_consultancy_language_ids_230 , t0 . preferred_consultancy_topic_country_ids AS preferred_consultancy_topic_country_ids_231 , t0 . preferred_consultancy_student_country_ids AS preferred_consultancy_student_country_ids_232 , t0 . preferred_schedule_data_for_getting_consultancy AS preferred_schedule_data_for_getting_consultancy_233 , t0 . preferred_schedule_data_for_providing_consultancy AS preferred_schedule_data_for_providing_consultancy_234 , t0 . selector AS selector_235 , t0 . apply_for_consultant AS apply_for_consultant_236 , t0 . apply_for_consultant_date AS apply_for_consultant_date_237 , t0 . consultant_application_feedback AS consultant_application_feedback_238 , t0 . apply_for_retailer AS apply_for_retailer_239 , t0 . apply_for_retailer_date AS apply_for_retailer_date_240 , t0 . doc_image AS doc_image_241 , t0 . document_list AS document_list_242 , t0 . document_list_by_topic_id AS document_list_by_topic_id_243 , t0 . document_list_by_session_id AS document_list_by_session_id_244 , t0 . work_experience_year AS work_experience_year_245 , t0 . description AS description_246 , t0 . summary_text AS summary_text_247 , t0 . professional_title AS professional_title_248 , t0 . work_experience_text AS work_experience_text_249 , t0 . profession_text AS profession_text_250 , t0 . education_text AS education_text_251 , t0 . education_major_text AS education_major_text_252 , t0 . highest_degree_achieved AS highest_degree_achieved_253 , t0 . target_education_degree AS target_education_degree_254 , t0 . target_education_major AS target_education_major_255 , t0 . lead_query_text AS lead_query_text_256 , t0 . university_text AS university_text_257 , t0 . experience_text AS experience_text_258 , t0 . skillstext AS skillstext_259 , t0 . interest AS interest_260 , t0 . speciality AS speciality_261 , t0 . last_settings_updated_ts AS last_settings_updated_ts_262 , t0 . created_at AS created_at_263 , t0 . actual_registration_at AS actual_registration_at_264 , t0 . updated_at AS updated_at_265 FROM entity_applicant_details t0 WHERE t0 . applicant_id = ? LIMIT 1
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 . claimed_promo_code_ids AS claimed_promo_code_ids_224 ,
t0 . referred_coins_earned AS referred_coins_earned_225 ,
t0 . referred_amount_earned AS referred_amount_earned_226 ,
t0 . rating_weight AS rating_weight_227 ,
t0 . rating_total AS rating_total_228 ,
t0 . rating_count AS rating_count_229 ,
t0 . preferred_consultancy_language_ids AS preferred_consultancy_language_ids_230 ,
t0 . preferred_consultancy_topic_country_ids AS preferred_consultancy_topic_country_ids_231 ,
t0 . preferred_consultancy_student_country_ids AS preferred_consultancy_student_country_ids_232 ,
t0 . preferred_schedule_data_for_getting_consultancy AS preferred_schedule_data_for_getting_consultancy_233 ,
t0 . preferred_schedule_data_for_providing_consultancy AS preferred_schedule_data_for_providing_consultancy_234 ,
t0 . selector AS selector_235 ,
t0 . apply_for_consultant AS apply_for_consultant_236 ,
t0 . apply_for_consultant_date AS apply_for_consultant_date_237 ,
t0 . consultant_application_feedback AS consultant_application_feedback_238 ,
t0 . apply_for_retailer AS apply_for_retailer_239 ,
t0 . apply_for_retailer_date AS apply_for_retailer_date_240 ,
t0 . doc_image AS doc_image_241 ,
t0 . document_list AS document_list_242 ,
t0 . document_list_by_topic_id AS document_list_by_topic_id_243 ,
t0 . document_list_by_session_id AS document_list_by_session_id_244 ,
t0 . work_experience_year AS work_experience_year_245 ,
t0 . description AS description_246 ,
t0 . summary_text AS summary_text_247 ,
t0 . professional_title AS professional_title_248 ,
t0 . work_experience_text AS work_experience_text_249 ,
t0 . profession_text AS profession_text_250 ,
t0 . education_text AS education_text_251 ,
t0 . education_major_text AS education_major_text_252 ,
t0 . highest_degree_achieved AS highest_degree_achieved_253 ,
t0 . target_education_degree AS target_education_degree_254 ,
t0 . target_education_major AS target_education_major_255 ,
t0 . lead_query_text AS lead_query_text_256 ,
t0 . university_text AS university_text_257 ,
t0 . experience_text AS experience_text_258 ,
t0 . skillstext AS skillstext_259 ,
t0 . interest AS interest_260 ,
t0 . speciality AS speciality_261 ,
t0 . last_settings_updated_ts AS last_settings_updated_ts_262 ,
t0 . created_at AS created_at_263 ,
t0 . actual_registration_at AS actual_registration_at_264 ,
t0 . updated_at AS updated_at_265
FROM
entity_applicant_details t0
WHERE
t0 . applicant_id = ?
LIMIT
1
Copy
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 . claimed_promo_code_ids AS claimed_promo_code_ids_224 , t0 . referred_coins_earned AS referred_coins_earned_225 , t0 . referred_amount_earned AS referred_amount_earned_226 , t0 . rating_weight AS rating_weight_227 , t0 . rating_total AS rating_total_228 , t0 . rating_count AS rating_count_229 , t0 . preferred_consultancy_language_ids AS preferred_consultancy_language_ids_230 , t0 . preferred_consultancy_topic_country_ids AS preferred_consultancy_topic_country_ids_231 , t0 . preferred_consultancy_student_country_ids AS preferred_consultancy_student_country_ids_232 , t0 . preferred_schedule_data_for_getting_consultancy AS preferred_schedule_data_for_getting_consultancy_233 , t0 . preferred_schedule_data_for_providing_consultancy AS preferred_schedule_data_for_providing_consultancy_234 , t0 . selector AS selector_235 , t0 . apply_for_consultant AS apply_for_consultant_236 , t0 . apply_for_consultant_date AS apply_for_consultant_date_237 , t0 . consultant_application_feedback AS consultant_application_feedback_238 , t0 . apply_for_retailer AS apply_for_retailer_239 , t0 . apply_for_retailer_date AS apply_for_retailer_date_240 , t0 . doc_image AS doc_image_241 , t0 . document_list AS document_list_242 , t0 . document_list_by_topic_id AS document_list_by_topic_id_243 , t0 . document_list_by_session_id AS document_list_by_session_id_244 , t0 . work_experience_year AS work_experience_year_245 , t0 . description AS description_246 , t0 . summary_text AS summary_text_247 , t0 . professional_title AS professional_title_248 , t0 . work_experience_text AS work_experience_text_249 , t0 . profession_text AS profession_text_250 , t0 . education_text AS education_text_251 , t0 . education_major_text AS education_major_text_252 , t0 . highest_degree_achieved AS highest_degree_achieved_253 , t0 . target_education_degree AS target_education_degree_254 , t0 . target_education_major AS target_education_major_255 , t0 . lead_query_text AS lead_query_text_256 , t0 . university_text AS university_text_257 , t0 . experience_text AS experience_text_258 , t0 . skillstext AS skillstext_259 , t0 . interest AS interest_260 , t0 . speciality AS speciality_261 , t0 . last_settings_updated_ts AS last_settings_updated_ts_262 , t0 . created_at AS created_at_263 , t0 . actual_registration_at AS actual_registration_at_264 , t0 . updated_at AS updated_at_265 FROM entity_applicant_details t0 WHERE t0 . applicant_id = '7497' LIMIT 1 ;
Copy