Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 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`.`sub_id` AS `organizations___sub_id_raw`,
- CONCAT_WS('', IF(LENGTH(`subs_list_0`.name_ru_RU),`subs_list_0`.name_ru_RU,IF(LENGTH(`subs_list_0`.name_en_GB),`subs_list_0`.name_en_GB,`subs_list_0`.name_ru_RU))) AS `organizations___sub_id`,
- `organizations`.`organization_country` AS `organizations___organization_country_raw`,
- CONCAT_WS('', IF(LENGTH(`geo_countries_0`.name_ru_RU),`geo_countries_0`.name_ru_RU,`geo_countries_0`.name_en_GB)) AS `organizations___organization_country`,
- `organizations`.`organization_city` AS `organizations___organization_city_raw`,
- CONCAT_WS('', IF(LENGTH(`geoname`.name_ru_RU),`geoname`.name_ru_RU,`geoname`.name),IF(LENGTH(`geoname`.regname),concat(' (',`geoname`.regname,')'),NULL)) AS `organizations___organization_city`,
- `organizations`.`organization_name` AS `organizations___organization_name_raw`,
- CONCAT_WS('', IF(LENGTH(`org_list_2`.name_ru_RU),`org_list_2`.name_ru_RU,IF(LENGTH(`org_list_2`.name_en_GB),`org_list_2`.name_en_GB,`org_list_2`.name_ru_RU))) AS `organizations___organization_name`,
- `organizations`.`organization_type` AS `organizations___organization_type`,
- `organizations`.`organization_type` AS `organizations___organization_type_raw`,
- `organizations`.`user_id` AS `organizations___user_id_raw`,
- `si1ez_users_2`.`name` AS `organizations___user_id`,
- `organizations`.`is_subordinate` AS `organizations___is_subordinate`,
- `organizations`.`is_subordinate` AS `organizations___is_subordinate_raw`,
- `organizations`.`sub_name_id` AS `organizations___sub_name_id_raw`,
- CONCAT_WS('', IF(LENGTH(`organizations_sub_name_0`.name_ru_RU),`organizations_sub_name_0`.name_ru_RU,`organizations_sub_name_0`.name_en_GB)) AS `organizations___sub_name_id`,
- `organizations`.`position_id` AS `organizations___position_id_raw`,
- CONCAT_WS('', IF(LENGTH(`organizations_position_0`.name_ru_RU),`organizations_position_0`.name_ru_RU,`organizations_position_0`.name_en_GB)) AS `organizations___position_id`,
- `organizations`.`organisations_about_id` AS `organizations___organisations_about_id_raw`,
- CONCAT_WS('', IF(LENGTH(`organisations_organisations_about_1`.name_ru_RU),`organisations_organisations_about_1`.name_ru_RU,`organisations_organisations_about_1`.name_en_GB)) AS `organizations___organisations_about_id`,
- `organizations`.`organization_MO` AS `organizations___organization_MO`,
- `organizations`.`organization_MO` AS `organizations___organization_MO_raw`,
- `organizations`.`to_check_coord` AS `organizations___to_check_coord`,
- `organizations`.`to_check_coord` AS `organizations___to_check_coord_raw`,
- `org_list`.`id` AS `org_list___id`,
- `org_list`.`id` AS `org_list___id_raw`,
- `org_list`.`date_time` AS `org_list___date_time`,
- `org_list`.`date_time` AS `org_list___date_time_raw`,
- `org_list`.`short_name` AS `org_list___short_name`,
- `org_list`.`short_name` AS `org_list___short_name_raw`,
- `org_list`.`website` AS `org_list___website`,
- `org_list`.`website` AS `org_list___website_raw`,
- `org_list`.`org_head_position` AS `org_list___org_head_position`,
- `org_list`.`org_head_position` AS `org_list___org_head_position_raw`,
- `org_list`.`org_head_name` AS `org_list___org_head_name`,
- `org_list`.`org_head_name` AS `org_list___org_head_name_raw`,
- `org_list`.`org_head_mail` AS `org_list___org_head_mail`,
- `org_list`.`org_head_mail` AS `org_list___org_head_mail_raw`,
- `org_list`.`lng_name` AS `org_list___lng_name`,
- `org_list`.`lng_name` AS `org_list___lng_name_raw`,
- `org_list`.`userid` AS `org_list___userid`,
- `org_list`.`userid` AS `org_list___userid_raw`,
- `org_list`.`status` AS `org_list___status`,
- `org_list`.`status` AS `org_list___status_raw`,
- `org_list_0`.`creator` AS `org_list___creator_raw`,
- `si1ez_users_0`.`name` AS `org_list___creator`,
- `org_list_0`.`to_check` AS `org_list___to_check_raw`,
- `si1ez_users_1`.`name` AS `org_list___to_check`,
- `org_list`.`poc_confirmed` AS `org_list___poc_confirmed`,
- `org_list`.`poc_confirmed` AS `org_list___poc_confirmed_raw`,
- `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_position`.`id` AS `organizations_position___id`,
- `organizations_position`.`id` AS `organizations_position___id_raw`,
- `organizations_position`.`date_time` AS `organizations_position___date_time`,
- `organizations_position`.`date_time` AS `organizations_position___date_time_raw`,
- `organizations_position`.`name_en_GB` AS `organizations_position___name_en_GB`,
- `organizations_position`.`name_en_GB` AS `organizations_position___name_en_GB_raw`,
- `organizations_position`.`name_ar_AA` AS `organizations_position___name_ar_AA`,
- `organizations_position`.`name_ar_AA` AS `organizations_position___name_ar_AA_raw`,
- `organizations_position`.`name_de_DE` AS `organizations_position___name_de_DE`,
- `organizations_position`.`name_de_DE` AS `organizations_position___name_de_DE_raw`,
- `organizations_position`.`name_en_US` AS `organizations_position___name_en_US`,
- `organizations_position`.`name_en_US` AS `organizations_position___name_en_US_raw`,
- `organizations_position`.`name_es_ES` AS `organizations_position___name_es_ES`,
- `organizations_position`.`name_es_ES` AS `organizations_position___name_es_ES_raw`,
- `organizations_position`.`name_fa_IR` AS `organizations_position___name_fa_IR`,
- `organizations_position`.`name_fa_IR` AS `organizations_position___name_fa_IR_raw`,
- `organizations_position`.`name_fr_FR` AS `organizations_position___name_fr_FR`,
- `organizations_position`.`name_fr_FR` AS `organizations_position___name_fr_FR_raw`,
- `organizations_position`.`name_it_IT` AS `organizations_position___name_it_IT`,
- `organizations_position`.`name_it_IT` AS `organizations_position___name_it_IT_raw`,
- `organizations_position`.`name_ja_JP` AS `organizations_position___name_ja_JP`,
- `organizations_position`.`name_ja_JP` AS `organizations_position___name_ja_JP_raw`,
- `organizations_position`.`name_ko_KR` AS `organizations_position___name_ko_KR`,
- `organizations_position`.`name_ko_KR` AS `organizations_position___name_ko_KR_raw`,
- `organizations_position`.`name_pt_PT` AS `organizations_position___name_pt_PT`,
- `organizations_position`.`name_pt_PT` AS `organizations_position___name_pt_PT_raw`,
- `organizations_position`.`name_ru_RU` AS `organizations_position___name_ru_RU`,
- `organizations_position`.`name_ru_RU` AS `organizations_position___name_ru_RU_raw`,
- `organizations_position`.`name_tr_TR` AS `organizations_position___name_tr_TR`,
- `organizations_position`.`name_tr_TR` AS `organizations_position___name_tr_TR_raw`,
- `organizations_position`.`name_zh_CN` AS `organizations_position___name_zh_CN`,
- `organizations_position`.`name_zh_CN` AS `organizations_position___name_zh_CN_raw`,
- `organizations_sub_name`.`id` AS `organizations_sub_name___id`,
- `organizations_sub_name`.`id` AS `organizations_sub_name___id_raw`,
- `organizations_sub_name`.`date_time` AS `organizations_sub_name___date_time`,
- `organizations_sub_name`.`date_time` AS `organizations_sub_name___date_time_raw`,
- `organizations_sub_name`.`name_en_GB` AS `organizations_sub_name___name_en_GB`,
- `organizations_sub_name`.`name_en_GB` AS `organizations_sub_name___name_en_GB_raw`,
- `organizations_sub_name`.`name_ar_AA` AS `organizations_sub_name___name_ar_AA`,
- `organizations_sub_name`.`name_ar_AA` AS `organizations_sub_name___name_ar_AA_raw`,
- `organizations_sub_name`.`name_de_DE` AS `organizations_sub_name___name_de_DE`,
- `organizations_sub_name`.`name_de_DE` AS `organizations_sub_name___name_de_DE_raw`,
- `organizations_sub_name`.`name_en_US` AS `organizations_sub_name___name_en_US`,
- `organizations_sub_name`.`name_en_US` AS `organizations_sub_name___name_en_US_raw`,
- `organizations_sub_name`.`name_es_ES` AS `organizations_sub_name___name_es_ES`,
- `organizations_sub_name`.`name_es_ES` AS `organizations_sub_name___name_es_ES_raw`,
- `organizations_sub_name`.`name_fr_FR` AS `organizations_sub_name___name_fr_FR`,
- `organizations_sub_name`.`name_fr_FR` AS `organizations_sub_name___name_fr_FR_raw`,
- `organizations_sub_name`.`name_fa_IR` AS `organizations_sub_name___name_fa_IR`,
- `organizations_sub_name`.`name_fa_IR` AS `organizations_sub_name___name_fa_IR_raw`,
- `organizations_sub_name`.`name_it_IT` AS `organizations_sub_name___name_it_IT`,
- `organizations_sub_name`.`name_it_IT` AS `organizations_sub_name___name_it_IT_raw`,
- `organizations_sub_name`.`name_ja_JP` AS `organizations_sub_name___name_ja_JP`,
- `organizations_sub_name`.`name_ja_JP` AS `organizations_sub_name___name_ja_JP_raw`,
- `organizations_sub_name`.`name_ko_KR` AS `organizations_sub_name___name_ko_KR`,
- `organizations_sub_name`.`name_ko_KR` AS `organizations_sub_name___name_ko_KR_raw`,
- `organizations_sub_name`.`name_pt_PT` AS `organizations_sub_name___name_pt_PT`,
- `organizations_sub_name`.`name_pt_PT` AS `organizations_sub_name___name_pt_PT_raw`,
- `organizations_sub_name`.`name_ru_RU` AS `organizations_sub_name___name_ru_RU`,
- `organizations_sub_name`.`name_ru_RU` AS `organizations_sub_name___name_ru_RU_raw`,
- `organizations_sub_name`.`name_tr_TR` AS `organizations_sub_name___name_tr_TR`,
- `organizations_sub_name`.`name_tr_TR` AS `organizations_sub_name___name_tr_TR_raw`,
- `organizations_sub_name`.`name_zh_CN` AS `organizations_sub_name___name_zh_CN`,
- `organizations_sub_name`.`name_zh_CN` AS `organizations_sub_name___name_zh_CN_raw`,
- `organisations_organisations_about`.`id` AS `organisations_organisations_about___id`,
- `organisations_organisations_about`.`id` AS `organisations_organisations_about___id_raw`,
- `organisations_organisations_about`.`date_time` AS `organisations_organisations_about___date_time`,
- `organisations_organisations_about`.`date_time` AS `organisations_organisations_about___date_time_raw`,
- `organisations_organisations_about`.`name_en_GB` AS `organisations_organisations_about___name_en_GB`,
- `organisations_organisations_about`.`name_en_GB` AS `organisations_organisations_about___name_en_GB_raw`,
- `organisations_organisations_about`.`name_ar_AA` AS `organisations_organisations_about___name_ar_AA`,
- `organisations_organisations_about`.`name_ar_AA` AS `organisations_organisations_about___name_ar_AA_raw`,
- `organisations_organisations_about`.`name_de_DE` AS `organisations_organisations_about___name_de_DE`,
- `organisations_organisations_about`.`name_de_DE` AS `organisations_organisations_about___name_de_DE_raw`,
- `organisations_organisations_about`.`name_en_US` AS `organisations_organisations_about___name_en_US`,
- `organisations_organisations_about`.`name_en_US` AS `organisations_organisations_about___name_en_US_raw`,
- `organisations_organisations_about`.`name_es_ES` AS `organisations_organisations_about___name_es_ES`,
- `organisations_organisations_about`.`name_es_ES` AS `organisations_organisations_about___name_es_ES_raw`,
- `organisations_organisations_about`.`name_fr_FR` AS `organisations_organisations_about___name_fr_FR`,
- `organisations_organisations_about`.`name_fr_FR` AS `organisations_organisations_about___name_fr_FR_raw`,
- `organisations_organisations_about`.`name_fa_IR` AS `organisations_organisations_about___name_fa_IR`,
- `organisations_organisations_about`.`name_fa_IR` AS `organisations_organisations_about___name_fa_IR_raw`,
- `organisations_organisations_about`.`name_it_IT` AS `organisations_organisations_about___name_it_IT`,
- `organisations_organisations_about`.`name_it_IT` AS `organisations_organisations_about___name_it_IT_raw`,
- `organisations_organisations_about`.`name_ja_JP` AS `organisations_organisations_about___name_ja_JP`,
- `organisations_organisations_about`.`name_ja_JP` AS `organisations_organisations_about___name_ja_JP_raw`,
- `organisations_organisations_about`.`name_ko_KR` AS `organisations_organisations_about___name_ko_KR`,
- `organisations_organisations_about`.`name_ko_KR` AS `organisations_organisations_about___name_ko_KR_raw`,
- `organisations_organisations_about`.`name_pt_PT` AS `organisations_organisations_about___name_pt_PT`,
- `organisations_organisations_about`.`name_pt_PT` AS `organisations_organisations_about___name_pt_PT_raw`,
- `organisations_organisations_about`.`name_ru_RU` AS `organisations_organisations_about___name_ru_RU`,
- `organisations_organisations_about`.`name_ru_RU` AS `organisations_organisations_about___name_ru_RU_raw`,
- `organisations_organisations_about`.`name_tr_TR` AS `organisations_organisations_about___name_tr_TR`,
- `organisations_organisations_about`.`name_tr_TR` AS `organisations_organisations_about___name_tr_TR_raw`,
- `organisations_organisations_about`.`name_zh_CN` AS `organisations_organisations_about___name_zh_CN`,
- `organisations_organisations_about`.`name_zh_CN` AS `organisations_organisations_about___name_zh_CN_raw`,
- `subs_list`.`date_time` AS `subs_list___date_time`,
- `subs_list`.`date_time` AS `subs_list___date_time_raw`,
- `subs_list`.`id` AS `subs_list___id`,
- `subs_list`.`id` AS `subs_list___id_raw`,
- `subs_list`.`sub_creator` AS `subs_list___sub_creator_raw`,
- `si1ez_users`.`name` AS `subs_list___sub_creator`,
- `subs_list`.`sub_country` AS `subs_list___sub_country_raw`,
- CONCAT_WS('', IF(LENGTH(`geo_countries`.name_ru_RU),`geo_countries`.name_ru_RU,`geo_countries`.name_en_GB)) AS `subs_list___sub_country`,
- `subs_list`.`sub_org_name` AS `subs_list___sub_org_name_raw`,
- CONCAT_WS('', IF(LENGTH(`org_list_1`.name_ru_RU),`org_list_1`.name_ru_RU,IF(LENGTH(`org_list_1`.name_en_GB),`org_list_1`.name_en_GB,`org_list_1`.name_ru_RU))) AS `subs_list___sub_org_name`,
- `subs_list`.`sub_name` AS `subs_list___sub_name`,
- `subs_list`.`sub_name` AS `subs_list___sub_name_raw`,
- `subs_list`.`sub_about_id` AS `subs_list___sub_about_id_raw`,
- CONCAT_WS('', IF(LENGTH(`organisations_organisations_about_0`.name_ru_RU),`organisations_organisations_about_0`.name_ru_RU,`organisations_organisations_about_0`.name_en_GB)) AS `subs_list___sub_about_id`,
- `subs_list`.`special_address` AS `subs_list___special_address`,
- `subs_list`.`special_address` AS `subs_list___special_address_raw`,
- `subs_list`.`sub_city` AS `subs_list___sub_city_raw`,
- CONCAT_WS('', IF(LENGTH(`geoname_0`.name_ru_RU),`geoname_0`.name_ru_RU,`geoname_0`.name),IF(LENGTH(`geoname_0`.regname),concat(' (',`geoname_0`.regname,')'),NULL)) AS `subs_list___sub_city`,
- `subs_list`.`sub_url` AS `subs_list___sub_url`,
- `subs_list`.`sub_url` AS `subs_list___sub_url_raw`,
- `subs_list`.`sub_add` AS `subs_list___sub_add`,
- `subs_list`.`sub_add` AS `subs_list___sub_add_raw`,
- `subs_list`.`map_location` AS `subs_list___map_location`,
- `subs_list`.`map_location` AS `subs_list___map_location_raw`,
- `subs_list`.`sub_opening_hours` AS `subs_list___sub_opening_hours`,
- `subs_list`.`sub_opening_hours` AS `subs_list___sub_opening_hours_raw`,
- (SELECT GROUP_CONCAT(lookup.fos_name_en SEPARATOR '//..*..//') FROM subs_list_repeat_sub_fos
- LEFT JOIN sti_oecd_fos AS lookup ON lookup.id = subs_list_repeat_sub_fos.sub_fos WHERE subs_list_repeat_sub_fos.parent_id = `subs_list`.`id`) AS `subs_list___sub_fos`,
- (SELECT GROUP_CONCAT(id SEPARATOR '//..*..//') FROM subs_list_repeat_sub_fos WHERE parent_id = `subs_list`.`id`) AS `subs_list___sub_fos_raw`,
- (SELECT GROUP_CONCAT(sub_fos SEPARATOR '//..*..//') FROM subs_list_repeat_sub_fos WHERE subs_list_repeat_sub_fos.parent_id = `subs_list`.`id`) AS `subs_list___sub_fos_id`,
- (SELECT GROUP_CONCAT(params SEPARATOR '//..*..//') FROM subs_list_repeat_sub_fos WHERE parent_id = `subs_list`.`id`) AS `subs_list___sub_fos___params`,
- (SELECT GROUP_CONCAT(lookup.title SEPARATOR '//..*..//') FROM subs_list_repeat_sub_fos_tags
- LEFT JOIN si1ez_tags AS lookup ON lookup.id = subs_list_repeat_sub_fos_tags.sub_fos_tags WHERE subs_list_repeat_sub_fos_tags.parent_id = `subs_list`.`id`) AS `subs_list___sub_fos_tags`,
- (SELECT GROUP_CONCAT(id SEPARATOR '//..*..//') FROM subs_list_repeat_sub_fos_tags WHERE parent_id = `subs_list`.`id`) AS `subs_list___sub_fos_tags_raw`,
- (SELECT GROUP_CONCAT(sub_fos_tags SEPARATOR '//..*..//') FROM subs_list_repeat_sub_fos_tags WHERE subs_list_repeat_sub_fos_tags.parent_id = `subs_list`.`id`) AS `subs_list___sub_fos_tags_id`,
- (SELECT GROUP_CONCAT(params SEPARATOR '//..*..//') FROM subs_list_repeat_sub_fos_tags WHERE parent_id = `subs_list`.`id`) AS `subs_list___sub_fos_tags___params`,
- (SELECT GROUP_CONCAT(lookup.wl_name SEPARATOR '//..*..//') FROM subs_list_repeat_work_languages
- LEFT JOIN sti_work_languges AS lookup ON lookup.id = subs_list_repeat_work_languages.work_languages WHERE subs_list_repeat_work_languages.parent_id = `subs_list`.`id`) AS `subs_list___work_languages`,
- (SELECT GROUP_CONCAT(id SEPARATOR '//..*..//') FROM subs_list_repeat_work_languages WHERE parent_id = `subs_list`.`id`) AS `subs_list___work_languages_raw`,
- (SELECT GROUP_CONCAT(work_languages SEPARATOR '//..*..//') FROM subs_list_repeat_work_languages WHERE subs_list_repeat_work_languages.parent_id = `subs_list`.`id`) AS `subs_list___work_languages_id`,
- (SELECT GROUP_CONCAT(params SEPARATOR '//..*..//') FROM subs_list_repeat_work_languages WHERE parent_id = `subs_list`.`id`) AS `subs_list___work_languages___params`,
- `subs_list`.`name_en_GB` AS `subs_list___name_en_GB`,
- `subs_list`.`name_en_GB` AS `subs_list___name_en_GB_raw`,
- `subs_list`.`waiting_students` AS `subs_list___waiting_students`,
- `subs_list`.`waiting_students` AS `subs_list___waiting_students_raw`,
- `subs_list`.`name_ar_AA` AS `subs_list___name_ar_AA`,
- `subs_list`.`name_ar_AA` AS `subs_list___name_ar_AA_raw`,
- `subs_list`.`waiting_prof` AS `subs_list___waiting_prof`,
- `subs_list`.`waiting_prof` AS `subs_list___waiting_prof_raw`,
- `subs_list`.`name_de_DE` AS `subs_list___name_de_DE`,
- `subs_list`.`name_de_DE` AS `subs_list___name_de_DE_raw`,
- `subs_list`.`name_es_ES` AS `subs_list___name_es_ES`,
- `subs_list`.`name_es_ES` AS `subs_list___name_es_ES_raw`,
- `subs_list`.`name_fa_IR` AS `subs_list___name_fa_IR`,
- `subs_list`.`name_fa_IR` AS `subs_list___name_fa_IR_raw`,
- `subs_list`.`name_fr_FR` AS `subs_list___name_fr_FR`,
- `subs_list`.`name_fr_FR` AS `subs_list___name_fr_FR_raw`,
- `subs_list`.`name_it_IT` AS `subs_list___name_it_IT`,
- `subs_list`.`name_it_IT` AS `subs_list___name_it_IT_raw`,
- `subs_list`.`name_ja_JP` AS `subs_list___name_ja_JP`,
- `subs_list`.`name_ja_JP` AS `subs_list___name_ja_JP_raw`,
- `subs_list`.`name_ko_KR` AS `subs_list___name_ko_KR`,
- `subs_list`.`name_ko_KR` AS `subs_list___name_ko_KR_raw`,
- `subs_list`.`name_pt_PT` AS `subs_list___name_pt_PT`,
- `subs_list`.`name_pt_PT` AS `subs_list___name_pt_PT_raw`,
- `subs_list`.`name_ru_RU` AS `subs_list___name_ru_RU`,
- `subs_list`.`name_ru_RU` AS `subs_list___name_ru_RU_raw`,
- `subs_list`.`name_tr_TR` AS `subs_list___name_tr_TR`,
- `subs_list`.`name_tr_TR` AS `subs_list___name_tr_TR_raw`,
- `subs_list`.`name_zh_CN` AS `subs_list___name_zh_CN`,
- `subs_list`.`name_zh_CN` AS `subs_list___name_zh_CN_raw`,
- `organizations`.`id` AS slug
- , `organizations`.`id` AS `__pk_val`
- FROM `organizations`
- LEFT JOIN `organizations_sub_name` AS `organizations_sub_name` ON `organizations_sub_name`.`id` = `organizations`.`sub_name_id`
- LEFT JOIN `organizations_position` AS `organizations_position` ON `organizations_position`.`id` = `organizations`.`position_id`
- LEFT JOIN `subs_list` AS `subs_list` ON `subs_list`.`id` = `organizations`.`sub_id`
- LEFT JOIN `org_list` AS `org_list` ON `org_list`.`id` = `organizations`.`organization_name`
- LEFT JOIN `org_list` AS `org_list_0` ON `org_list_0`.`id` = `organizations`.`organization_name`
- LEFT JOIN `organisations_organisations_about` AS `organisations_organisations_about` ON `organisations_organisations_about`.`id` = `organizations`.`organisations_about_id`
- LEFT JOIN `geoname` AS `geoname` ON `geoname`.`geonameid` = `organizations`.`organization_city`
- LEFT JOIN `geoname` AS `geoname_0` ON `geoname_0`.`geonameid` = `subs_list`.`sub_city`
- LEFT JOIN `organisations_organisations_about` AS `organisations_organisations_about_0` ON `organisations_organisations_about_0`.`id` = `subs_list`.`sub_about_id`
- LEFT JOIN `org_list` AS `org_list_1` ON `org_list_1`.`id` = `subs_list`.`sub_org_name`
- LEFT JOIN `geo_countries` AS `geo_countries` ON `geo_countries`.`alpha2` = `subs_list`.`sub_country`
- LEFT JOIN `si1ez_users` AS `si1ez_users` ON `si1ez_users`.`id` = `subs_list`.`sub_creator`
- LEFT JOIN `subs_list` AS `subs_list_0` ON `subs_list_0`.`id` = `organizations`.`sub_id`
- LEFT JOIN `org_list` AS `org_list_2` ON `org_list_2`.`id` = `organizations`.`organization_name`
- LEFT JOIN `organisations_organisations_about` AS `organisations_organisations_about_1` ON `organisations_organisations_about_1`.`id` = `organizations`.`organisations_about_id`
- LEFT JOIN `organizations_position` AS `organizations_position_0` ON `organizations_position_0`.`id` = `organizations`.`position_id`
- LEFT JOIN `organizations_sub_name` AS `organizations_sub_name_0` ON `organizations_sub_name_0`.`id` = `organizations`.`sub_name_id`
- LEFT JOIN `geo_countries` AS `geo_countries_0` ON `geo_countries_0`.`alpha2` = `organizations`.`organization_country`
- LEFT JOIN `si1ez_users` AS `si1ez_users_2` ON `si1ez_users_2`.`id` = `organizations`.`user_id`
- LEFT JOIN `si1ez_users` AS `si1ez_users_0` ON `si1ez_users_0`.`id` = `org_list_0`.`creator`
- LEFT JOIN `si1ez_users` AS `si1ez_users_1` ON `si1ez_users_1`.`id` = `org_list_0`.`to_check`
- WHERE ( (organizations.is_subordinate = '0' OR organizations.is_subordinate LIKE '[\"0\"%' OR organizations.is_subordinate LIKE '%\"0\"%' OR organizations.is_subordinate LIKE '%\"0\"]') AND ( organizations.organization_MO IN (select `org_host_id` from `si1ez_users_profiles` where `user_id`=569) ) ) AND ( ( CONCAT_WS('', IF(LENGTH(`geoname`.name_ru_RU),`geoname`.name_ru_RU,`geoname`.name),IF(LENGTH(`geoname`.regname),concat(' (',`geoname`.regname,')'),NULL)) regexp LOWER('Oleg') OR CONCAT_WS('', IF(LENGTH(`org_list_2`.name_ru_RU),`org_list_2`.name_ru_RU,IF(LENGTH(`org_list_2`.name_en_GB),`org_list_2`.name_en_GB,`org_list_2`.name_ru_RU))) regexp LOWER('Oleg') OR `si1ez_users_2`.`name` regexp LOWER('Oleg') OR CONCAT_WS('', IF(LENGTH(`organisations_organisations_about_1`.name_ru_RU),`organisations_organisations_about_1`.name_ru_RU,`organisations_organisations_about_1`.name_en_GB)) regexp LOWER('Oleg') OR LOWER(`org_list`.`short_name`) regexp LOWER('Oleg') ) ) LIMIT 0, 10
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement