Guest User

Untitled

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