Advertisement
Guest User

Untitled

a guest
Oct 21st, 2019
108
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 11.79 KB | None | 0 0
  1. SELECT
  2. sessions.target_id AS "data.target_id"
  3. ,sessions.device_id AS "data.device_id"
  4. ,sessions.nativeSessionName AS "data.nativeSessionName"
  5. ,sessions.terminal AS "data.terminal"
  6. ,sessions.username AS "data.username"
  7. ,sessions.displayName AS "data.displayName"
  8. ,sessions.active AS "data.active"
  9. ,sessions.created AS "data.created"
  10. ,sessions.updated AS "data.updated"
  11. ,sessions.etag AS "data.etag"
  12. ,sessions.online AS "data.online"
  13. ,sessions_index.id
  14. ,sessions_index.etag
  15. ,sessions_activegroups.content AS "activegroups.content"
  16. ,sessions_activegroups.updated AS "activegroups.updated"
  17. ,sessions_activegroups.etag AS "activegroups.etag"
  18. ,sessions_activepolicies.content AS "activepolicies.content"
  19. ,sessions_activepolicies.updated AS "activepolicies.updated"
  20. ,sessions_activepolicies.etag AS "activepolicies.etag"
  21. ,sessions_applications.content AS "applications.content"
  22. ,sessions_applications.updated AS "applications.updated"
  23. ,sessions_applications.etag AS "applications.etag"
  24. ,sessions_directive.content AS "directive.content"
  25. ,sessions_directive.updated AS "directive.updated"
  26. ,sessions_directive.etag AS "directive.etag"
  27. ,sessions_properties.content AS "properties.content"
  28. ,sessions_properties.updated AS "properties.updated"
  29. ,sessions_properties.etag AS "properties.etag"
  30. FROM
  31. sessions_index LEFT JOIN sessions
  32. USING (id) LEFT JOIN sessions_activegroups
  33. USING (id) LEFT JOIN sessions_activepolicies
  34. USING (id) LEFT JOIN sessions_applications
  35. USING (id) LEFT JOIN sessions_directive
  36. USING (id) LEFT JOIN sessions_properties
  37. USING (id)
  38. WHERE
  39. sessions_index.deleted IS NULL
  40. UNION
  41. SELECT
  42. sessions.target_id
  43. ,sessions.device_id
  44. ,sessions.nativeSessionName
  45. ,sessions.terminal
  46. ,sessions.username
  47. ,sessions.displayName
  48. ,sessions.active
  49. ,sessions.created
  50. ,sessions.updated
  51. ,sessions.etag
  52. ,sessions.online
  53. ,sessions_index.id
  54. ,sessions_index.etag
  55. ,sessions_activegroups.content
  56. ,sessions_activegroups.updated
  57. ,sessions_activegroups.etag
  58. ,sessions_activepolicies.content
  59. ,sessions_activepolicies.updated
  60. ,sessions_activepolicies.etag
  61. ,sessions_applications.content
  62. ,sessions_applications.updated
  63. ,sessions_applications.etag
  64. ,sessions_directive.content
  65. ,sessions_directive.updated
  66. ,sessions_directive.etag
  67. ,sessions_properties.content
  68. ,sessions_properties.updated
  69. ,sessions_properties.etag
  70. FROM
  71. sessions LEFT JOIN sessions_properties
  72. USING (id) LEFT JOIN sessions_index
  73. USING (id) LEFT JOIN sessions_directive
  74. USING (id) LEFT JOIN sessions_applications
  75. USING (id) LEFT JOIN sessions_activepolicies
  76. USING (id) LEFT JOIN sessions_activegroups
  77. USING (id)
  78. WHERE
  79. sessions_index.deleted IS NULL
  80. AND sessions_index.id IS NOT NULL
  81. AND sessions.id IS NOT NULL
  82. UNION
  83. SELECT
  84. sessions.target_id
  85. ,sessions.device_id
  86. ,sessions.nativeSessionName
  87. ,sessions.terminal
  88. ,sessions.username
  89. ,sessions.displayName
  90. ,sessions.active
  91. ,sessions.created
  92. ,sessions.updated
  93. ,sessions.etag
  94. ,sessions.online
  95. ,sessions_index.id
  96. ,sessions_index.etag
  97. ,sessions_activegroups.content
  98. ,sessions_activegroups.updated
  99. ,sessions_activegroups.etag
  100. ,sessions_activepolicies.content
  101. ,sessions_activepolicies.updated
  102. ,sessions_activepolicies.etag
  103. ,sessions_applications.content
  104. ,sessions_applications.updated
  105. ,sessions_applications.etag
  106. ,sessions_directive.content
  107. ,sessions_directive.updated
  108. ,sessions_directive.etag
  109. ,sessions_properties.content
  110. ,sessions_properties.updated
  111. ,sessions_properties.etag
  112. FROM
  113. sessions_activegroups LEFT JOIN sessions_properties
  114. USING (id) LEFT JOIN sessions_index
  115. USING (id) LEFT JOIN sessions_directive
  116. USING (id) LEFT JOIN sessions_applications
  117. USING (id) LEFT JOIN sessions_activepolicies
  118. USING (id) LEFT JOIN sessions
  119. USING (id)
  120. WHERE
  121. sessions_index.deleted IS NULL
  122. AND sessions_index.id IS NOT NULL
  123. AND sessions.id IS NOT NULL
  124. UNION
  125. SELECT
  126. sessions.target_id
  127. ,sessions.device_id
  128. ,sessions.nativeSessionName
  129. ,sessions.terminal
  130. ,sessions.username
  131. ,sessions.displayName
  132. ,sessions.active
  133. ,sessions.created
  134. ,sessions.updated
  135. ,sessions.etag
  136. ,sessions.online
  137. ,sessions_index.id
  138. ,sessions_index.etag
  139. ,sessions_activegroups.content
  140. ,sessions_activegroups.updated
  141. ,sessions_activegroups.etag
  142. ,sessions_activepolicies.content
  143. ,sessions_activepolicies.updated
  144. ,sessions_activepolicies.etag
  145. ,sessions_applications.content
  146. ,sessions_applications.updated
  147. ,sessions_applications.etag
  148. ,sessions_directive.content
  149. ,sessions_directive.updated
  150. ,sessions_directive.etag
  151. ,sessions_properties.content
  152. ,sessions_properties.updated
  153. ,sessions_properties.etag
  154. FROM
  155. sessions_activepolicies LEFT JOIN sessions_properties
  156. USING (id) LEFT JOIN sessions_index
  157. USING (id) LEFT JOIN sessions_directive
  158. USING (id) LEFT JOIN sessions_applications
  159. USING (id) LEFT JOIN sessions_activegroups
  160. USING (id) LEFT JOIN sessions
  161. USING (id)
  162. WHERE
  163. sessions_index.deleted IS NULL
  164. AND sessions_index.id IS NOT NULL
  165. AND sessions.id IS NOT NULL
  166. UNION
  167. SELECT
  168. sessions.target_id
  169. ,sessions.device_id
  170. ,sessions.nativeSessionName
  171. ,sessions.terminal
  172. ,sessions.username
  173. ,sessions.displayName
  174. ,sessions.active
  175. ,sessions.created
  176. ,sessions.updated
  177. ,sessions.etag
  178. ,sessions.online
  179. ,sessions_index.id
  180. ,sessions_index.etag
  181. ,sessions_activegroups.content
  182. ,sessions_activegroups.updated
  183. ,sessions_activegroups.etag
  184. ,sessions_activepolicies.content
  185. ,sessions_activepolicies.updated
  186. ,sessions_activepolicies.etag
  187. ,sessions_applications.content
  188. ,sessions_applications.updated
  189. ,sessions_applications.etag
  190. ,sessions_directive.content
  191. ,sessions_directive.updated
  192. ,sessions_directive.etag
  193. ,sessions_properties.content
  194. ,sessions_properties.updated
  195. ,sessions_properties.etag
  196. FROM
  197. sessions_applications LEFT JOIN sessions_properties
  198. USING (id) LEFT JOIN sessions_index
  199. USING (id) LEFT JOIN sessions_directive
  200. USING (id) LEFT JOIN sessions_activepolicies
  201. USING (id) LEFT JOIN sessions_activegroups
  202. USING (id) LEFT JOIN sessions
  203. USING (id)
  204. WHERE
  205. sessions_index.deleted IS NULL
  206. AND sessions_index.id IS NOT NULL
  207. AND sessions.id IS NOT NULL
  208. UNION
  209. SELECT
  210. sessions.target_id
  211. ,sessions.device_id
  212. ,sessions.nativeSessionName
  213. ,sessions.terminal
  214. ,sessions.username
  215. ,sessions.displayName
  216. ,sessions.active
  217. ,sessions.created
  218. ,sessions.updated
  219. ,sessions.etag
  220. ,sessions.online
  221. ,sessions_index.id
  222. ,sessions_index.etag
  223. ,sessions_activegroups.content
  224. ,sessions_activegroups.updated
  225. ,sessions_activegroups.etag
  226. ,sessions_activepolicies.content
  227. ,sessions_activepolicies.updated
  228. ,sessions_activepolicies.etag
  229. ,sessions_applications.content
  230. ,sessions_applications.updated
  231. ,sessions_applications.etag
  232. ,sessions_directive.content
  233. ,sessions_directive.updated
  234. ,sessions_directive.etag
  235. ,sessions_properties.content
  236. ,sessions_properties.updated
  237. ,sessions_properties.etag
  238. FROM
  239. sessions_directive LEFT JOIN sessions_properties
  240. USING (id) LEFT JOIN sessions_index
  241. USING (id) LEFT JOIN sessions_applications
  242. USING (id) LEFT JOIN sessions_activepolicies
  243. USING (id) LEFT JOIN sessions_activegroups
  244. USING (id) LEFT JOIN sessions
  245. USING (id)
  246. WHERE
  247. sessions_index.deleted IS NULL
  248. AND sessions_index.id IS NOT NULL
  249. AND sessions.id IS NOT NULL
  250. UNION
  251. SELECT
  252. sessions.target_id
  253. ,sessions.device_id
  254. ,sessions.nativeSessionName
  255. ,sessions.terminal
  256. ,sessions.username
  257. ,sessions.displayName
  258. ,sessions.active
  259. ,sessions.created
  260. ,sessions.updated
  261. ,sessions.etag
  262. ,sessions.online
  263. ,sessions_index.id
  264. ,sessions_index.etag
  265. ,sessions_activegroups.content
  266. ,sessions_activegroups.updated
  267. ,sessions_activegroups.etag
  268. ,sessions_activepolicies.content
  269. ,sessions_activepolicies.updated
  270. ,sessions_activepolicies.etag
  271. ,sessions_applications.content
  272. ,sessions_applications.updated
  273. ,sessions_applications.etag
  274. ,sessions_directive.content
  275. ,sessions_directive.updated
  276. ,sessions_directive.etag
  277. ,sessions_properties.content
  278. ,sessions_properties.updated
  279. ,sessions_properties.etag
  280. FROM
  281. sessions_index LEFT JOIN sessions_properties
  282. USING (id) LEFT JOIN sessions_directive
  283. USING (id) LEFT JOIN sessions_applications
  284. USING (id) LEFT JOIN sessions_activepolicies
  285. USING (id) LEFT JOIN sessions_activegroups
  286. USING (id) LEFT JOIN sessions
  287. USING (id)
  288. WHERE
  289. sessions_index.deleted IS NULL
  290. AND sessions_index.id IS NOT NULL
  291. AND sessions.id IS NOT NULL
  292. UNION
  293. SELECT
  294. sessions.target_id
  295. ,sessions.device_id
  296. ,sessions.nativeSessionName
  297. ,sessions.terminal
  298. ,sessions.username
  299. ,sessions.displayName
  300. ,sessions.active
  301. ,sessions.created
  302. ,sessions.updated
  303. ,sessions.etag
  304. ,sessions.online
  305. ,sessions_index.id
  306. ,sessions_index.etag
  307. ,sessions_activegroups.content
  308. ,sessions_activegroups.updated
  309. ,sessions_activegroups.etag
  310. ,sessions_activepolicies.content
  311. ,sessions_activepolicies.updated
  312. ,sessions_activepolicies.etag
  313. ,sessions_applications.content
  314. ,sessions_applications.updated
  315. ,sessions_applications.etag
  316. ,sessions_directive.content
  317. ,sessions_directive.updated
  318. ,sessions_directive.etag
  319. ,sessions_properties.content
  320. ,sessions_properties.updated
  321. ,sessions_properties.etag
  322. FROM
  323. sessions_properties LEFT JOIN sessions_index
  324. USING (id) LEFT JOIN sessions_directive
  325. USING (id) LEFT JOIN sessions_applications
  326. USING (id) LEFT JOIN sessions_activepolicies
  327. USING (id) LEFT JOIN sessions_activegroups
  328. USING (id) LEFT JOIN sessions
  329. USING (id)
  330. WHERE
  331. sessions_index.deleted IS NULL
  332. AND sessions_index.id IS NOT NULL
  333. AND sessions.id IS NOT NULL
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement