SHARE
TWEET

Untitled

a guest Feb 27th, 2020 81 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. select
  2.     distinct user0_.id as id1_14_0_,
  3.              contact4_.id as id1_0_1_,
  4.              user7_.id as id1_14_2_,
  5.              organizati9_.id as id1_3_3_,
  6.              contact10_.id as id1_0_4_,
  7.              user12_.id as id1_14_5_,
  8.              role14_.id as id1_18_6_,
  9.              contact15_.id as id1_0_7_,
  10.              user0_.active as active2_14_0_,
  11.              user0_.avatar as avatar3_14_0_,
  12.              user0_.birth_day as birth_da4_14_0_,
  13.              user0_.create_date as create_d5_14_0_,
  14.              user0_.creation_as_author_date as creation6_14_0_,
  15.              user0_.esia_contact_id as esia_co19_14_0_,
  16.              user0_.inn as inn7_14_0_,
  17.              user0_.internal_contact_id as interna20_14_0_,
  18.              user0_.last_update as last_upd8_14_0_,
  19.              user0_.middlename as middlena9_14_0_,
  20.              user0_.name as name10_14_0_,
  21.              user0_.nick_name as nick_na11_14_0_,
  22.              user0_.password as passwor12_14_0_,
  23.              user0_.pen_name as pen_nam13_14_0_,
  24.              user0_.probation as probati14_14_0_,
  25.              user0_.snils as snils15_14_0_,
  26.              user0_.status_id as status_16_14_0_,
  27.              user0_.surname as surname17_14_0_,
  28.              user0_.username as usernam18_14_0_,
  29.              pseudonyms5_.user_id as user_id1_13_0__,
  30.              pseudonyms5_.pseudonyms as pseudony2_13_0__,
  31.              contact4_.email as email2_0_1_,
  32.              contact4_.phone as phone3_0_1_,
  33.              pseudonyms5_.user_id as user_id1_13_0__,
  34.              pseudonyms5_.pseudonyms as pseudony2_13_0__,
  35.              user7_.active as active2_14_2_,
  36.              user7_.avatar as avatar3_14_2_,
  37.              user7_.birth_day as birth_da4_14_2_,
  38.              user7_.create_date as create_d5_14_2_,
  39.              user7_.creation_as_author_date as creation6_14_2_,
  40.              user7_.esia_contact_id as esia_co19_14_2_,
  41.              user7_.inn as inn7_14_2_,
  42.              user7_.internal_contact_id as interna20_14_2_,
  43.              user7_.last_update as last_upd8_14_2_,
  44.              user7_.middlename as middlena9_14_2_,
  45.              user7_.name as name10_14_2_,
  46.              user7_.nick_name as nick_na11_14_2_,
  47.              user7_.password as passwor12_14_2_,
  48.              user7_.pen_name as pen_nam13_14_2_,
  49.              user7_.probation as probati14_14_2_,
  50.              user7_.snils as snils15_14_2_,
  51.              user7_.status_id as status_16_14_2_,
  52.              user7_.surname as surname17_14_2_,
  53.              user7_.username as usernam18_14_2_,
  54.              children6_.child_id as child_id2_16_1__,
  55.              children6_.parent_id as parent_i1_16_1__,
  56.              organizati9_.address as address2_3_3_,
  57.              organizati9_.contact_id as contact12_3_3_,
  58.              organizati9_.full_name as full_nam3_3_3_,
  59.              organizati9_.head_person as head_per4_3_3_,
  60.              organizati9_.inn as inn5_3_3_,
  61.              organizati9_.kpp as kpp6_3_3_,
  62.              organizati9_.legal_form as legal_fo7_3_3_,
  63.              organizati9_.ogrn as ogrn8_3_3_,
  64.              organizati9_.short_name as short_na9_3_3_,
  65.              organizati9_.site as site10_3_3_,
  66.              organizati9_.org_type as org_typ11_3_3_,
  67.              organizati8_.user_id as user_id1_15_2__,
  68.              organizati8_.organizations_id as organiza2_15_2__,
  69.              contact10_.email as email2_0_4_,
  70.              contact10_.phone as phone3_0_4_,
  71.              user12_.active as active2_14_5_,
  72.              user12_.avatar as avatar3_14_5_,
  73.              user12_.birth_day as birth_da4_14_5_,
  74.              user12_.create_date as create_d5_14_5_,
  75.              user12_.creation_as_author_date as creation6_14_5_,
  76.              user12_.esia_contact_id as esia_co19_14_5_,
  77.              user12_.inn as inn7_14_5_,
  78.              user12_.internal_contact_id as interna20_14_5_,
  79.              user12_.last_update as last_upd8_14_5_,
  80.              user12_.middlename as middlena9_14_5_,
  81.              user12_.name as name10_14_5_,
  82.              user12_.nick_name as nick_na11_14_5_,
  83.              user12_.password as passwor12_14_5_,
  84.              user12_.pen_name as pen_nam13_14_5_,
  85.              user12_.probation as probati14_14_5_,
  86.              user12_.snils as snils15_14_5_,
  87.              user12_.status_id as status_16_14_5_,
  88.              user12_.surname as surname17_14_5_,
  89.              user12_.username as usernam18_14_5_,
  90.              parents11_.parent_id as parent_i1_16_3__,
  91.              parents11_.child_id as child_id2_16_3__,
  92.              role14_.id_school as id_schoo2_18_6_,
  93.              role14_.role_name as role_nam3_18_6_,
  94.              roles13_.user_id as user_id1_17_4__,
  95.              roles13_.role_id as role_id2_17_4__,
  96.              contact15_.email as email2_0_7_,
  97.              contact15_.phone as phone3_0_7_
  98. from
  99.     users user0_
  100.         left outer join
  101.     contact contact4_
  102.     on user0_.esia_contact_id=contact4_.id
  103.         left outer join
  104.     user_pseudonyms pseudonyms5_
  105.     on user0_.id=pseudonyms5_.user_id
  106.         left outer join
  107.     users_rel children6_
  108.     on user0_.id=children6_.child_id
  109.         left outer join
  110.     users user7_
  111.     on children6_.parent_id=user7_.id
  112.         left outer join
  113.     users_organizations organizati8_
  114.     on user0_.id=organizati8_.user_id
  115.         left outer join
  116.     organization organizati9_
  117.     on organizati8_.organizations_id=organizati9_.id
  118.         left outer join
  119.     contact contact10_
  120.     on organizati9_.contact_id=contact10_.id
  121.         left outer join
  122.     users_rel parents11_
  123.     on user0_.id=parents11_.parent_id
  124.         left outer join
  125.     users user12_
  126.     on parents11_.child_id=user12_.id
  127.         left outer join
  128.     users_role_mapping roles13_
  129.     on user0_.id=roles13_.user_id
  130.         left outer join
  131.     users_roles role14_
  132.     on roles13_.role_id=role14_.id
  133.         left outer join
  134.     contact contact15_
  135.     on user0_.internal_contact_id=contact15_.id
  136. where
  137.         user0_.id in (
  138.         select
  139.             user1_.id
  140.         from
  141.             users user1_
  142.                 inner join
  143.             contact contact2_
  144.             on user1_.esia_contact_id=contact2_.id
  145.                 inner join
  146.             contact contact3_
  147.             on user1_.internal_contact_id=contact3_.id
  148.         where
  149.             (
  150.                     user1_.id in (
  151.                     user0_.id
  152.                     )
  153.                 )
  154.           and (
  155.                     lower(contact2_.email) like 'es'
  156.                 or lower(contact3_.email) like 'es'
  157.             )
  158.     )
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
Top