Guest User

Untitled

a guest
Feb 27th, 2020
103
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