Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT
- NULL
- ,NULL
- ,NULL
- ,NULL
- ,NULL
- ,NULL
- ,NULL
- ,NULL
- ,NULL
- ,NULL
- ,NULL
- ,sessions_index.id
- ,sessions_index.etag
- ,sessions_index.deleted
- ,NULL
- ,NULL
- ,NULL
- ,NULL
- ,NULL
- ,NULL
- ,NULL
- ,NULL
- ,NULL
- ,NULL
- ,NULL
- ,NULL
- ,NULL
- ,NULL
- ,NULL
- FROM
- sessions_index LEFT JOIN sessions
- USING (id) LEFT JOIN sessions_activegroups
- USING (id) LEFT JOIN sessions_activepolicies
- USING (id) LEFT JOIN sessions_applications
- USING (id) LEFT JOIN sessions_directive
- USING (id) LEFT JOIN sessions_properties
- USING (id)
- WHERE
- sessions_index.delete IS NOT NULL
- UNION
- SELECT
- sessions.target_id
- ,sessions.device_id
- ,sessions.nativeSessionName
- ,sessions.terminal
- ,sessions.username
- ,sessions.displayName
- ,sessions.active
- ,sessions.created
- ,sessions.updated
- ,sessions.etag
- ,sessions.online
- ,sessions_index.id
- ,sessions_index.etag
- ,sessions_index.deleted
- ,sessions_activegroups.content
- ,sessions_activegroups.updated
- ,sessions_activegroups.etag
- ,sessions_activepolicies.content
- ,sessions_activepolicies.updated
- ,sessions_activepolicies.etag
- ,sessions_applications.content
- ,sessions_applications.updated
- ,sessions_applications.etag
- ,sessions_directive.content
- ,sessions_directive.updated
- ,sessions_directive.etag
- ,sessions_properties.content
- ,sessions_properties.updated
- ,sessions_properties.etag
- FROM
- sessions LEFT JOIN sessions_properties
- USING (id) LEFT JOIN sessions_index
- USING (id) LEFT JOIN sessions_directive
- USING (id) LEFT JOIN sessions_applications
- USING (id) LEFT JOIN sessions_activepolicies
- USING (id) LEFT JOIN sessions_activegroups
- USING (id)
- WHERE
- sessions.etag > : since
- AND sessions_index.deleted IS NULL
- AND sessions_index.id IS NOT NULL
- AND sessions.id IS NOT NULL
- UNION
- SELECT
- sessions.target_id
- ,sessions.device_id
- ,sessions.nativeSessionName
- ,sessions.terminal
- ,sessions.username
- ,sessions.displayName
- ,sessions.active
- ,sessions.created
- ,sessions.updated
- ,sessions.etag
- ,sessions.online
- ,sessions_index.id
- ,sessions_index.etag
- ,sessions_index.deleted
- ,sessions_activegroups.content
- ,sessions_activegroups.updated
- ,sessions_activegroups.etag
- ,sessions_activepolicies.content
- ,sessions_activepolicies.updated
- ,sessions_activepolicies.etag
- ,sessions_applications.content
- ,sessions_applications.updated
- ,sessions_applications.etag
- ,sessions_directive.content
- ,sessions_directive.updated
- ,sessions_directive.etag
- ,sessions_properties.content
- ,sessions_properties.updated
- ,sessions_properties.etag
- FROM
- sessions_activegroups LEFT JOIN sessions_properties
- USING (id) LEFT JOIN sessions_index
- USING (id) LEFT JOIN sessions_directive
- USING (id) LEFT JOIN sessions_applications
- USING (id) LEFT JOIN sessions_activepolicies
- USING (id) LEFT JOIN sessions
- USING (id)
- WHERE
- sessions_activegroups.etag > : since
- AND sessions_index.deleted IS NULL
- AND sessions_index.id IS NOT NULL
- AND sessions.id IS NOT NULL
- UNION
- SELECT
- sessions.target_id
- ,sessions.device_id
- ,sessions.nativeSessionName
- ,sessions.terminal
- ,sessions.username
- ,sessions.displayName
- ,sessions.active
- ,sessions.created
- ,sessions.updated
- ,sessions.etag
- ,sessions.online
- ,sessions_index.id
- ,sessions_index.etag
- ,sessions_index.deleted
- ,sessions_activegroups.content
- ,sessions_activegroups.updated
- ,sessions_activegroups.etag
- ,sessions_activepolicies.content
- ,sessions_activepolicies.updated
- ,sessions_activepolicies.etag
- ,sessions_applications.content
- ,sessions_applications.updated
- ,sessions_applications.etag
- ,sessions_directive.content
- ,sessions_directive.updated
- ,sessions_directive.etag
- ,sessions_properties.content
- ,sessions_properties.updated
- ,sessions_properties.etag
- FROM
- sessions_activepolicies LEFT JOIN sessions_properties
- USING (id) LEFT JOIN sessions_index
- USING (id) LEFT JOIN sessions_directive
- USING (id) LEFT JOIN sessions_applications
- USING (id) LEFT JOIN sessions_activegroups
- USING (id) LEFT JOIN sessions
- USING (id)
- WHERE
- sessions_activepolicies.etag > : since
- AND sessions_index.deleted IS NULL
- AND sessions_index.id IS NOT NULL
- AND sessions.id IS NOT NULL
- UNION
- SELECT
- sessions.target_id
- ,sessions.device_id
- ,sessions.nativeSessionName
- ,sessions.terminal
- ,sessions.username
- ,sessions.displayName
- ,sessions.active
- ,sessions.created
- ,sessions.updated
- ,sessions.etag
- ,sessions.online
- ,sessions_index.id
- ,sessions_index.etag
- ,sessions_index.deleted
- ,sessions_activegroups.content
- ,sessions_activegroups.updated
- ,sessions_activegroups.etag
- ,sessions_activepolicies.content
- ,sessions_activepolicies.updated
- ,sessions_activepolicies.etag
- ,sessions_applications.content
- ,sessions_applications.updated
- ,sessions_applications.etag
- ,sessions_directive.content
- ,sessions_directive.updated
- ,sessions_directive.etag
- ,sessions_properties.content
- ,sessions_properties.updated
- ,sessions_properties.etag
- FROM
- sessions_applications LEFT JOIN sessions_properties
- USING (id) LEFT JOIN sessions_index
- USING (id) LEFT JOIN sessions_directive
- USING (id) LEFT JOIN sessions_activepolicies
- USING (id) LEFT JOIN sessions_activegroups
- USING (id) LEFT JOIN sessions
- USING (id)
- WHERE
- sessions_applications.etag > : since
- AND sessions_index.deleted IS NULL
- AND sessions_index.id IS NOT NULL
- AND sessions.id IS NOT NULL
- UNION
- SELECT
- sessions.target_id
- ,sessions.device_id
- ,sessions.nativeSessionName
- ,sessions.terminal
- ,sessions.username
- ,sessions.displayName
- ,sessions.active
- ,sessions.created
- ,sessions.updated
- ,sessions.etag
- ,sessions.online
- ,sessions_index.id
- ,sessions_index.etag
- ,sessions_index.deleted
- ,sessions_activegroups.content
- ,sessions_activegroups.updated
- ,sessions_activegroups.etag
- ,sessions_activepolicies.content
- ,sessions_activepolicies.updated
- ,sessions_activepolicies.etag
- ,sessions_applications.content
- ,sessions_applications.updated
- ,sessions_applications.etag
- ,sessions_directive.content
- ,sessions_directive.updated
- ,sessions_directive.etag
- ,sessions_properties.content
- ,sessions_properties.updated
- ,sessions_properties.etag
- FROM
- sessions_directive LEFT JOIN sessions_properties
- USING (id) LEFT JOIN sessions_index
- USING (id) LEFT JOIN sessions_applications
- USING (id) LEFT JOIN sessions_activepolicies
- USING (id) LEFT JOIN sessions_activegroups
- USING (id) LEFT JOIN sessions
- USING (id)
- WHERE
- sessions_directive.etag > : since
- AND sessions_index.deleted IS NULL
- AND sessions_index.id IS NOT NULL
- AND sessions.id IS NOT NULL
- UNION
- SELECT
- sessions.target_id
- ,sessions.device_id
- ,sessions.nativeSessionName
- ,sessions.terminal
- ,sessions.username
- ,sessions.displayName
- ,sessions.active
- ,sessions.created
- ,sessions.updated
- ,sessions.etag
- ,sessions.online
- ,sessions_index.id
- ,sessions_index.etag
- ,sessions_index.deleted
- ,sessions_activegroups.content
- ,sessions_activegroups.updated
- ,sessions_activegroups.etag
- ,sessions_activepolicies.content
- ,sessions_activepolicies.updated
- ,sessions_activepolicies.etag
- ,sessions_applications.content
- ,sessions_applications.updated
- ,sessions_applications.etag
- ,sessions_directive.content
- ,sessions_directive.updated
- ,sessions_directive.etag
- ,sessions_properties.content
- ,sessions_properties.updated
- ,sessions_properties.etag
- FROM
- sessions_index LEFT JOIN sessions_properties
- USING (id) LEFT JOIN sessions_directive
- USING (id) LEFT JOIN sessions_applications
- USING (id) LEFT JOIN sessions_activepolicies
- USING (id) LEFT JOIN sessions_activegroups
- USING (id) LEFT JOIN sessions
- USING (id)
- WHERE
- sessions_index.etag > : since
- AND sessions_index.deleted IS NULL
- AND sessions_index.id IS NOT NULL
- AND sessions.id IS NOT NULL
- UNION
- SELECT
- sessions.target_id
- ,sessions.device_id
- ,sessions.nativeSessionName
- ,sessions.terminal
- ,sessions.username
- ,sessions.displayName
- ,sessions.active
- ,sessions.created
- ,sessions.updated
- ,sessions.etag
- ,sessions.online
- ,sessions_index.id
- ,sessions_index.etag
- ,sessions_index.deleted
- ,sessions_activegroups.content
- ,sessions_activegroups.updated
- ,sessions_activegroups.etag
- ,sessions_activepolicies.content
- ,sessions_activepolicies.updated
- ,sessions_activepolicies.etag
- ,sessions_applications.content
- ,sessions_applications.updated
- ,sessions_applications.etag
- ,sessions_directive.content
- ,sessions_directive.updated
- ,sessions_directive.etag
- ,sessions_properties.content
- ,sessions_properties.updated
- ,sessions_properties.etag
- FROM
- sessions_properties LEFT JOIN sessions_index
- USING (id) LEFT JOIN sessions_directive
- USING (id) LEFT JOIN sessions_applications
- USING (id) LEFT JOIN sessions_activepolicies
- USING (id) LEFT JOIN sessions_activegroups
- USING (id) LEFT JOIN sessions
- USING (id)
- WHERE
- sessions_properties.etag > : since
- AND sessions_index.deleted IS NULL
- AND sessions_index.id IS NOT NULL
- AND sessions.id IS NOT NULL
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement