SHARE
TWEET

Untitled

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