Query   SELECT SQL_CALC_FOUND_ROWS DISTINCT `organizations`.`id` AS `organizations___id`,
 `organizations`.`id` AS `organizations___id_raw`,
 `organizations`.`date_time` AS `organizations___date_time`,
 `organizations`.`date_time` AS `organizations___date_time_raw`,
 `organizations`.`organization_country` AS `organizations___organization_country_raw`,
 CONCAT_WS('', IF(LENGTH(`geo_countries`.name_ru_RU),`geo_countries`.name_ru_RU,`geo_countries`.name_en_GB)) AS `organizations___organization_country`,
 `organizations`.`organization_name` AS `organizations___organization_name_raw`,
 CONCAT_WS('', IF(LENGTH(`org_list`.name_ru_RU),`org_list`.name_ru_RU,IF(LENGTH(`org_list`.name_en_GB),`org_list`.name_en_GB,`org_list`.name_ru_RU))) AS `organizations___organization_name`,
 `organizations`.`user_id` AS `organizations___user_id_raw`,
 `si1ez_users`.`name` AS `organizations___user_id`,
 `organizations`.`is_subordinate` AS `organizations___is_subordinate`,
 `organizations`.`is_subordinate` AS `organizations___is_subordinate_raw`,
 `organizations`.`sub_id` AS `organizations___sub_id_raw`,
 CONCAT_WS('', IF(LENGTH(`subs_list`.name_ru_RU),`subs_list`.name_ru_RU,IF(LENGTH(`subs_list`.name_en_GB),`subs_list`.name_en_GB,`subs_list`.name_ru_RU))) AS `organizations___sub_id`,
 `organizations`.`position_id` AS `organizations___position_id_raw`,
 CONCAT_WS('', IF(LENGTH(`organizations_position`.name_ru_RU),`organizations_position`.name_ru_RU,`organizations_position`.name_en_GB)) AS `organizations___position_id`,
 `organizations`.`name_en_GB` AS `organizations___name_en_GB`,
 `organizations`.`name_en_GB` AS `organizations___name_en_GB_raw`,
 `organizations`.`name_ar_AA` AS `organizations___name_ar_AA`,
 `organizations`.`name_ar_AA` AS `organizations___name_ar_AA_raw`,
 `organizations`.`name_de_DE` AS `organizations___name_de_DE`,
 `organizations`.`name_de_DE` AS `organizations___name_de_DE_raw`,
 `organizations`.`name_es_ES` AS `organizations___name_es_ES`,
 `organizations`.`name_es_ES` AS `organizations___name_es_ES_raw`,
 `organizations`.`name_fa_IR` AS `organizations___name_fa_IR`,
 `organizations`.`name_fa_IR` AS `organizations___name_fa_IR_raw`,
 `organizations`.`name_it_IT` AS `organizations___name_it_IT`,
 `organizations`.`name_it_IT` AS `organizations___name_it_IT_raw`,
 `organizations`.`name_ja_JP` AS `organizations___name_ja_JP`,
 `organizations`.`name_ja_JP` AS `organizations___name_ja_JP_raw`,
 `organizations`.`name_ko_KR` AS `organizations___name_ko_KR`,
 `organizations`.`name_ko_KR` AS `organizations___name_ko_KR_raw`,
 `organizations`.`name_pt_PT` AS `organizations___name_pt_PT`,
 `organizations`.`name_pt_PT` AS `organizations___name_pt_PT_raw`,
 `organizations`.`name_ru_RU` AS `organizations___name_ru_RU`,
 `organizations`.`name_ru_RU` AS `organizations___name_ru_RU_raw`,
 `organizations`.`name_tr_TR` AS `organizations___name_tr_TR`,
 `organizations`.`name_tr_TR` AS `organizations___name_tr_TR_raw`,
 `organizations`.`name_zh_CN` AS `organizations___name_zh_CN`,
 `organizations`.`name_zh_CN` AS `organizations___name_zh_CN_raw`,
 `organizations`.`name_fr_FR` AS `organizations___name_fr_FR`,
 `organizations`.`name_fr_FR` AS `organizations___name_fr_FR_raw`,
 `organizations`.`to_check` AS `organizations___to_check`,
 `organizations`.`to_check` AS `organizations___to_check_raw`,
 `organizations`.`to_check_coord` AS `organizations___to_check_coord`,
 `organizations`.`to_check_coord` AS `organizations___to_check_coord_raw`,
 `si1ez_users_profiles`.`id` AS `si1ez_users_profiles___id`,
 `si1ez_users_profiles`.`id` AS `si1ez_users_profiles___id_raw`,
 `si1ez_users_profiles`.`education_level` AS `si1ez_users_profiles___education_level`,
 `si1ez_users_profiles`.`education_level` AS `si1ez_users_profiles___education_level_raw`,
 `si1ez_users_profiles`.`user_id` AS `si1ez_users_profiles___user_id_raw`,
 `si1ez_users_1`.`name` AS `si1ez_users_profiles___user_id`,
 `si1ez_users_profiles`.`user_group` AS `si1ez_users_profiles___user_group`,
 `si1ez_users_profiles`.`user_group` AS `si1ez_users_profiles___user_group_raw`,
 `si1ez_users_profiles`.`date_time` AS `si1ez_users_profiles___date_time`,
 `si1ez_users_profiles`.`date_time` AS `si1ez_users_profiles___date_time_raw`,
 `si1ez_users_profiles`.`researcher_profile` AS `si1ez_users_profiles___researcher_profile`,
 `si1ez_users_profiles`.`researcher_profile` AS `si1ez_users_profiles___researcher_profile_raw`,
 `si1ez_users_profiles`.`lector_degree` AS `si1ez_users_profiles___lector_degree`,
 `si1ez_users_profiles`.`lector_degree` AS `si1ez_users_profiles___lector_degree_raw`,
 `si1ez_users_profiles`.`about_id` AS `si1ez_users_profiles___about_id_raw`,
 CONCAT_WS('', IF(LENGTH(`si1ez_users_profiles_about_0`.name_ru_RU),`si1ez_users_profiles_about_0`.name_ru_RU,`si1ez_users_profiles_about_0`.name_en_GB)) AS `si1ez_users_profiles___about_id`,
 (SELECT GROUP_CONCAT(lookup.fos_name_en  SEPARATOR '//..*..//') FROM si1ez_users_profiles_repeat_fos
        LEFT JOIN sti_oecd_fos AS lookup ON lookup.id = si1ez_users_profiles_repeat_fos.fos WHERE si1ez_users_profiles_repeat_fos.parent_id = `si1ez_users_profiles`.`id`) AS `si1ez_users_profiles___fos`,
 (SELECT GROUP_CONCAT(id SEPARATOR '//..*..//') FROM si1ez_users_profiles_repeat_fos WHERE parent_id = `si1ez_users_profiles`.`id`) AS `si1ez_users_profiles___fos_raw`,
 (SELECT GROUP_CONCAT(fos SEPARATOR '//..*..//') FROM si1ez_users_profiles_repeat_fos WHERE si1ez_users_profiles_repeat_fos.parent_id = `si1ez_users_profiles`.`id`) AS `si1ez_users_profiles___fos_id`,
 (SELECT GROUP_CONCAT(params SEPARATOR '//..*..//') FROM si1ez_users_profiles_repeat_fos WHERE parent_id = `si1ez_users_profiles`.`id`) AS `si1ez_users_profiles___fos___params`,
 (SELECT GROUP_CONCAT(lookup.title  SEPARATOR '//..*..//') FROM si1ez_users_profiles_repeat_fos_tags
        LEFT JOIN si1ez_tags AS lookup ON lookup.id = si1ez_users_profiles_repeat_fos_tags.fos_tags WHERE si1ez_users_profiles_repeat_fos_tags.parent_id = `si1ez_users_profiles`.`id`) AS `si1ez_users_profiles___fos_tags`,
 (SELECT GROUP_CONCAT(id SEPARATOR '//..*..//') FROM si1ez_users_profiles_repeat_fos_tags WHERE parent_id = `si1ez_users_profiles`.`id`) AS `si1ez_users_profiles___fos_tags_raw`,
 (SELECT GROUP_CONCAT(fos_tags SEPARATOR '//..*..//') FROM si1ez_users_profiles_repeat_fos_tags WHERE si1ez_users_profiles_repeat_fos_tags.parent_id = `si1ez_users_profiles`.`id`) AS `si1ez_users_profiles___fos_tags_id`,
 (SELECT GROUP_CONCAT(params SEPARATOR '//..*..//') FROM si1ez_users_profiles_repeat_fos_tags WHERE parent_id = `si1ez_users_profiles`.`id`) AS `si1ez_users_profiles___fos_tags___params`,
 `si1ez_users_profiles`.`wikipedia` AS `si1ez_users_profiles___wikipedia`,
 `si1ez_users_profiles`.`wikipedia` AS `si1ez_users_profiles___wikipedia_raw`,
 `si1ez_users_profiles`.`lector_orcid` AS `si1ez_users_profiles___lector_orcid`,
 `si1ez_users_profiles`.`lector_orcid` AS `si1ez_users_profiles___lector_orcid_raw`,
 `si1ez_users_profiles`.`lector_author_id_scopus` AS `si1ez_users_profiles___lector_author_id_scopus`,
 `si1ez_users_profiles`.`lector_author_id_scopus` AS `si1ez_users_profiles___lector_author_id_scopus_raw`,
 `si1ez_users_profiles`.`lector_spin` AS `si1ez_users_profiles___lector_spin`,
 `si1ez_users_profiles`.`lector_spin` AS `si1ez_users_profiles___lector_spin_raw`,
 `si1ez_users_profiles`.`lector_citation_profile_google_scholar` AS `si1ez_users_profiles___lector_citation_profile_google_scholar`,
 `si1ez_users_profiles`.`lector_citation_profile_google_scholar` AS `si1ez_users_profiles___lector_citation_profile_google_scholar_raw`,
 `si1ez_users_profiles`.`lector_researcherid_web_of_science` AS `si1ez_users_profiles___lector_researcherid_web_of_science`,
 `si1ez_users_profiles`.`lector_researcherid_web_of_science` AS `si1ez_users_profiles___lector_researcherid_web_of_science_raw`,
 `si1ez_users_profiles`.`researchgate` AS `si1ez_users_profiles___researchgate`,
 `si1ez_users_profiles`.`researchgate` AS `si1ez_users_profiles___researchgate_raw`,
 (SELECT GROUP_CONCAT(lookup.wl_name  SEPARATOR '//..*..//') FROM si1ez_users_profiles_repeat_work_lang
        LEFT JOIN sti_work_languges AS lookup ON lookup.id = si1ez_users_profiles_repeat_work_lang.work_lang WHERE si1ez_users_profiles_repeat_work_lang.parent_id = `si1ez_users_profiles`.`id`) AS `si1ez_users_profiles___work_lang`,
 (SELECT GROUP_CONCAT(id SEPARATOR '//..*..//') FROM si1ez_users_profiles_repeat_work_lang WHERE parent_id = `si1ez_users_profiles`.`id`) AS `si1ez_users_profiles___work_lang_raw`,
 (SELECT GROUP_CONCAT(work_lang SEPARATOR '//..*..//') FROM si1ez_users_profiles_repeat_work_lang WHERE si1ez_users_profiles_repeat_work_lang.parent_id = `si1ez_users_profiles`.`id`) AS `si1ez_users_profiles___work_lang_id`,
 (SELECT GROUP_CONCAT(params SEPARATOR '//..*..//') FROM si1ez_users_profiles_repeat_work_lang WHERE parent_id = `si1ez_users_profiles`.`id`) AS `si1ez_users_profiles___work_lang___params`,
 `si1ez_users_profiles`.`org_head_id` AS `si1ez_users_profiles___org_head_id_raw`,
 `organizations_0`.`organization_name` AS `si1ez_users_profiles___org_head_id`,
 `si1ez_users_profiles`.`sti_status` AS `si1ez_users_profiles___sti_status_raw`,
 `sti_flow_0`.`sti_status` AS `si1ez_users_profiles___sti_status`,
 `si1ez_users_profiles_about`.`id` AS `si1ez_users_profiles_about___id`,
 `si1ez_users_profiles_about`.`id` AS `si1ez_users_profiles_about___id_raw`,
 `si1ez_users_profiles_about`.`date_time` AS `si1ez_users_profiles_about___date_time`,
 `si1ez_users_profiles_about`.`date_time` AS `si1ez_users_profiles_about___date_time_raw`,
 `si1ez_users_profiles_about`.`name_en_GB` AS `si1ez_users_profiles_about___name_en_GB`,
 `si1ez_users_profiles_about`.`name_en_GB` AS `si1ez_users_profiles_about___name_en_GB_raw`,
 `si1ez_users_profiles_about`.`name_ar_AA` AS `si1ez_users_profiles_about___name_ar_AA`,
 `si1ez_users_profiles_about`.`name_ar_AA` AS `si1ez_users_profiles_about___name_ar_AA_raw`,
 `si1ez_users_profiles_about`.`name_de_DE` AS `si1ez_users_profiles_about___name_de_DE`,
 `si1ez_users_profiles_about`.`name_de_DE` AS `si1ez_users_profiles_about___name_de_DE_raw`,
 `si1ez_users_profiles_about`.`name_es_ES` AS `si1ez_users_profiles_about___name_es_ES`,
 `si1ez_users_profiles_about`.`name_es_ES` AS `si1ez_users_profiles_about___name_es_ES_raw`,
 `si1ez_users_profiles_about`.`name_fa_IR` AS `si1ez_users_profiles_about___name_fa_IR`,
 `si1ez_users_profiles_about`.`name_fa_IR` AS `si1ez_users_profiles_about___name_fa_IR_raw`,
 `si1ez_users_profiles_about`.`name_fr_FR` AS `si1ez_users_profiles_about___name_fr_FR`,
 `si1ez_users_profiles_about`.`name_fr_FR` AS `si1ez_users_profiles_about___name_fr_FR_raw`,
 `si1ez_users_profiles_about`.`name_it_IT` AS `si1ez_users_profiles_about___name_it_IT`,
 `si1ez_users_profiles_about`.`name_it_IT` AS `si1ez_users_profiles_about___name_it_IT_raw`,
 `si1ez_users_profiles_about`.`name_ja_JP` AS `si1ez_users_profiles_about___name_ja_JP`,
 `si1ez_users_profiles_about`.`name_ja_JP` AS `si1ez_users_profiles_about___name_ja_JP_raw`,
 `si1ez_users_profiles_about`.`name_ko_KR` AS `si1ez_users_profiles_about___name_ko_KR`,
 `si1ez_users_profiles_about`.`name_ko_KR` AS `si1ez_users_profiles_about___name_ko_KR_raw`,
 `si1ez_users_profiles_about`.`name_pt_PT` AS `si1ez_users_profiles_about___name_pt_PT`,
 `si1ez_users_profiles_about`.`name_pt_PT` AS `si1ez_users_profiles_about___name_pt_PT_raw`,
 `si1ez_users_profiles_about`.`name_ru_RU` AS `si1ez_users_profiles_about___name_ru_RU`,
 `si1ez_users_profiles_about`.`name_ru_RU` AS `si1ez_users_profiles_about___name_ru_RU_raw`,
 `si1ez_users_profiles_about`.`name_tr_TR` AS `si1ez_users_profiles_about___name_tr_TR`,
 `si1ez_users_profiles_about`.`name_tr_TR` AS `si1ez_users_profiles_about___name_tr_TR_raw`,
 `si1ez_users_profiles_about`.`name_zh_CN` AS `si1ez_users_profiles_about___name_zh_CN`,
 `si1ez_users_profiles_about`.`name_zh_CN` AS `si1ez_users_profiles_about___name_zh_CN_raw`,
 `si1ez_users_profiles_about`.`trans_meta` AS `si1ez_users_profiles_about___trans_meta`,
 `si1ez_users_profiles_about`.`trans_meta` AS `si1ez_users_profiles_about___trans_meta_raw`,
 `sti_flow`.`date_time` AS `sti_flow___date_time`,
 `sti_flow`.`date_time` AS `sti_flow___date_time_raw`,
 `sti_flow`.`id` AS `sti_flow___id`,
 `sti_flow`.`id` AS `sti_flow___id_raw`,
 `sti_flow`.`sti_status` AS `sti_flow___sti_status`,
 `sti_flow`.`sti_status` AS `sti_flow___sti_status_raw`,
 `sti_flow`.`sti_log` AS `sti_flow___sti_log`,
 `sti_flow`.`sti_log` AS `sti_flow___sti_log_raw`,
 `sti_flow`.`flow_owner` AS `sti_flow___flow_owner_raw`,
 `si1ez_users_0`.`name` AS `sti_flow___flow_owner`,
 `si1ez_users_profiles`.`id` AS slug
 , `si1ez_users_profiles`.`id` AS `__pk_val`

FROM `si1ez_users_profiles`
LEFT JOIN  `organizations` AS `organizations` ON `organizations`.`user_id` = `si1ez_users_profiles`.`user_id`
LEFT JOIN  `sti_flow` AS `sti_flow` ON `sti_flow`.`id` = `si1ez_users_profiles`.`sti_status`
LEFT JOIN  `si1ez_users_profiles_about` AS `si1ez_users_profiles_about` ON `si1ez_users_profiles_about`.`id` = `si1ez_users_profiles`.`about_id`
LEFT JOIN  `organizations_position` AS `organizations_position` ON `organizations_position`.`id` = `organizations`.`position_id`
LEFT JOIN  `si1ez_users` AS `si1ez_users` ON `si1ez_users`.`id` = `organizations`.`user_id`
LEFT JOIN  `org_list` AS `org_list` ON `org_list`.`id` = `organizations`.`organization_name`
LEFT JOIN  `subs_list` AS `subs_list` ON `subs_list`.`id` = `organizations`.`sub_id`
LEFT JOIN  `geo_countries` AS `geo_countries` ON `geo_countries`.`alpha2` = `organizations`.`organization_country`
LEFT JOIN  `si1ez_users` AS `si1ez_users_0` ON `si1ez_users_0`.`id` = `sti_flow`.`flow_owner`
LEFT JOIN  `sti_flow` AS `sti_flow_0` ON `sti_flow_0`.`id` = `si1ez_users_profiles`.`sti_status`
LEFT JOIN  `si1ez_users` AS `si1ez_users_1` ON `si1ez_users_1`.`id` = `si1ez_users_profiles`.`user_id`
LEFT JOIN  `si1ez_users_profiles_about` AS `si1ez_users_profiles_about_0` ON `si1ez_users_profiles_about_0`.`id` = `si1ez_users_profiles`.`about_id`
LEFT JOIN  `organizations` AS `organizations_0` ON `organizations_0`.`id` = `si1ez_users_profiles`.`org_head_id`
WHERE ( ( `si1ez_users_1`.`id` > 1 ) ) AND (  `si1ez_users_1`.`name` regexp LOWER('Алена') ) LIMIT 0, 10