SHARE
TWEET

Untitled

a guest Feb 27th, 2020 88 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.         role4_.id as id1_18_1_,
  4.         user6_.id as id1_14_2_,
  5.         organizati8_.id as id1_3_3_,
  6.         contact9_.id as id1_0_4_,
  7.         contact10_.id as id1_0_5_,
  8.         user12_.id as id1_14_6_,
  9.         contact14_.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.         pseudonyms13_.user_id as user_id1_13_4__,
  30.         pseudonyms13_.pseudonyms as pseudony2_13_4__,
  31.         role4_.id_school as id_schoo2_18_1_,
  32.         role4_.role_name as role_nam3_18_1_,
  33.         roles3_.user_id as user_id1_17_0__,
  34.         roles3_.role_id as role_id2_17_0__,
  35.         pseudonyms13_.user_id as user_id1_13_4__,
  36.         pseudonyms13_.pseudonyms as pseudony2_13_4__,
  37.         user6_.active as active2_14_2_,
  38.         user6_.avatar as avatar3_14_2_,
  39.         user6_.birth_day as birth_da4_14_2_,
  40.         user6_.create_date as create_d5_14_2_,
  41.         user6_.creation_as_author_date as creation6_14_2_,
  42.         user6_.esia_contact_id as esia_co19_14_2_,
  43.         user6_.inn as inn7_14_2_,
  44.         user6_.internal_contact_id as interna20_14_2_,
  45.         user6_.last_update as last_upd8_14_2_,
  46.         user6_.middlename as middlena9_14_2_,
  47.         user6_.name as name10_14_2_,
  48.         user6_.nick_name as nick_na11_14_2_,
  49.         user6_.password as passwor12_14_2_,
  50.         user6_.pen_name as pen_nam13_14_2_,
  51.         user6_.probation as probati14_14_2_,
  52.         user6_.snils as snils15_14_2_,
  53.         user6_.status_id as status_16_14_2_,
  54.         user6_.surname as surname17_14_2_,
  55.         user6_.username as usernam18_14_2_,
  56.         children5_.child_id as child_id2_16_1__,
  57.         children5_.parent_id as parent_i1_16_1__,
  58.         pseudonyms13_.user_id as user_id1_13_4__,
  59.         pseudonyms13_.pseudonyms as pseudony2_13_4__,
  60.         organizati8_.address as address2_3_3_,
  61.         organizati8_.contact_id as contact12_3_3_,
  62.         organizati8_.full_name as full_nam3_3_3_,
  63.         organizati8_.head_person as head_per4_3_3_,
  64.         organizati8_.inn as inn5_3_3_,
  65.         organizati8_.kpp as kpp6_3_3_,
  66.         organizati8_.legal_form as legal_fo7_3_3_,
  67.         organizati8_.ogrn as ogrn8_3_3_,
  68.         organizati8_.short_name as short_na9_3_3_,
  69.         organizati8_.site as site10_3_3_,
  70.         organizati8_.org_type as org_typ11_3_3_,
  71.         organizati7_.user_id as user_id1_15_2__,
  72.         organizati7_.organizations_id as organiza2_15_2__,
  73.         pseudonyms13_.user_id as user_id1_13_4__,
  74.         pseudonyms13_.pseudonyms as pseudony2_13_4__,
  75.         contact9_.email as email2_0_4_,
  76.         contact9_.phone as phone3_0_4_,
  77.         contact10_.email as email2_0_5_,
  78.         contact10_.phone as phone3_0_5_,
  79.         pseudonyms13_.user_id as user_id1_13_4__,
  80.         pseudonyms13_.pseudonyms as pseudony2_13_4__,
  81.         user12_.active as active2_14_6_,
  82.         user12_.avatar as avatar3_14_6_,
  83.         user12_.birth_day as birth_da4_14_6_,
  84.         user12_.create_date as create_d5_14_6_,
  85.         user12_.creation_as_author_date as creation6_14_6_,
  86.         user12_.esia_contact_id as esia_co19_14_6_,
  87.         user12_.inn as inn7_14_6_,
  88.         user12_.internal_contact_id as interna20_14_6_,
  89.         user12_.last_update as last_upd8_14_6_,
  90.         user12_.middlename as middlena9_14_6_,
  91.         user12_.name as name10_14_6_,
  92.         user12_.nick_name as nick_na11_14_6_,
  93.         user12_.password as passwor12_14_6_,
  94.         user12_.pen_name as pen_nam13_14_6_,
  95.         user12_.probation as probati14_14_6_,
  96.         user12_.snils as snils15_14_6_,
  97.         user12_.status_id as status_16_14_6_,
  98.         user12_.surname as surname17_14_6_,
  99.         user12_.username as usernam18_14_6_,
  100.         parents11_.parent_id as parent_i1_16_3__,
  101.         parents11_.child_id as child_id2_16_3__,
  102.         pseudonyms13_.user_id as user_id1_13_4__,
  103.         pseudonyms13_.pseudonyms as pseudony2_13_4__,
  104.         contact14_.email as email2_0_7_,
  105.         contact14_.phone as phone3_0_7_
  106.     from
  107.         users user0_
  108.     left outer join
  109.         users_role_mapping roles3_
  110.             on user0_.id=roles3_.user_id
  111.     left outer join
  112.         users_roles role4_
  113.             on roles3_.role_id=role4_.id
  114.     left outer join
  115.         users_rel children5_
  116.             on user0_.id=children5_.child_id
  117.     left outer join
  118.         users user6_
  119.             on children5_.parent_id=user6_.id
  120.     left outer join
  121.         users_organizations organizati7_
  122.             on user0_.id=organizati7_.user_id
  123.     left outer join
  124.         organization organizati8_
  125.             on organizati7_.organizations_id=organizati8_.id
  126.     left outer join
  127.         contact contact9_
  128.             on organizati8_.contact_id=contact9_.id
  129.     left outer join
  130.         contact contact10_
  131.             on user0_.internal_contact_id=contact10_.id
  132.     left outer join
  133.         users_rel parents11_
  134.             on user0_.id=parents11_.parent_id
  135.     left outer join
  136.         users user12_
  137.             on parents11_.child_id=user12_.id
  138.     left outer join
  139.         user_pseudonyms pseudonyms13_
  140.             on user0_.id=pseudonyms13_.user_id
  141.     left outer join
  142.         contact contact14_
  143.             on user0_.esia_contact_id=contact14_.id
  144.     where
  145.         user0_.id in (
  146.             select
  147.                 user1_.id
  148.             from
  149.                 users user1_
  150.             inner join
  151.                 contact contact2_
  152.                     on user1_.internal_contact_id=contact2_.id
  153.             where
  154.                 (
  155.                     user1_.id in (
  156.                         user0_.id
  157.                     )
  158.                 )
  159.                 and (
  160.                     lower(contact2_.email) like ?
  161.                 )
  162.         )
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