SELECT params,RequestSequenceID
FROM RemoteRequests
WHERE DestServerID = 1
AND RequestMode = 3
ORDER BY RequestSequenceID

SELECT *
FROM RemoteRequests
WHERE DestServerID = 1
AND RequestMode IN (0,2)
ORDER BY RequestSequenceID, SourceServerID

UPDATE ElementInstance
SET CacheFormat=0,
CacheValidUntil='2123-06-08 00:05:08',
ContentValidUntil='2123-06-08 00:05:08',
DataPageID=0,
DependentObjectID=0,
DynamicStatus='',
HasChildren=0,
HasData=1,
HasDynamicContent=2,
IndexStatus=0,
IsDeviceDependent=0,
ParamPageID=0,
PrintStatus=0,
ShareStatus=0,
ConflictList=''
WHERE ServerID=1
AND SubsiteID=37
AND PageID=103297
AND ControlID=0
AND CacheLevel=2
AND IsWIP=0

UPDATE ElementInstance
SET CacheFormat=0,
CacheValidUntil='2123-06-08 00:05:08',
ContentValidUntil='2123-06-08 00:05:08',
DataPageID=0,
DependentObjectID=0,
DynamicStatus='',
HasChildren=0,
HasData=1,
HasDynamicContent=2,
IndexStatus=0,
IsDeviceDependent=0,
ParamPageID=0,
PrintStatus=0,
ShareStatus=0,
ConflictList=''
WHERE ServerID=1
AND SubsiteID=251
AND PageID=195587
AND ControlID=0
AND CacheLevel=2
AND IsWIP=0

SELECT *
FROM ElementInstance
WHERE SubsiteID=367
AND PageID=366602
AND IsWIP=0
AND ServerID=1
ORDER BY ControlID DESC,CacheLevel

SELECT *
FROM SitePages
WHERE ID=366602
AND AudienceID=0

SELECT *
FROM SitePages
WHERE ID=366602

SELECT StaleCacheMaxKeepTime,DynamicContentCacheKeepTime
FROM SitePages
WHERE
(ID IN (1,2,11057))
ORDER BY ID

SELECT DISTINCT SitePages.SubSiteID
FROM SitePages, Subsites
WHERE SitePages.SubSiteID = Subsites.ID
AND Subsites.ID = 1

SELECT PageType
FROM SitePages
WHERE ID = 11057

SELECT SubsiteID
FROM SitePages
WHERE ID = 366602

SELECT ID
FROM SitePages
WHERE ID = 366602
AND (PageType IN (0,1,2,8,6,3,11,14,15))

SELECT OriginalString AS Word
, KeywordType As KeywordTypeID
FROM ObjectKeywords
WHERE ObjectID = 366602
AND KeywordType = 0
ORDER BY Position, OriginalString

SELECT GeneralCategories.Category, RenderOptions.PageID
FROM RenderOptions, GeneralCategories
WHERE GeneralCategories.ID = RenderOptions.CategoryID
AND GeneralCategories.CategoryTypeID = 12
AND
(RenderOptions.PageID IN (1,2,11057,366602))
ORDER BY RenderOptions.PageID Desc

SELECT PageType, SubSiteID, CategoryID, InheritedTemplateList, DocType, Uploaded
FROM SitePages
WHERE ID = 366602

SELECT Data_FieldValue.PageID, Data_FieldValue.FieldValue, FormInputControl.FieldName, FormInputControl.type, FormControl.FormName,
FormControl.ID AS FormControlID, FormInputControl.ID AS ficID,
Data_FieldValue.MemoValue, Data_FieldValue.listid, FormInputControl.params AS fieldParams
FROM FormInputControl,FormControl,FormInputControlMap,Data_FieldValue,FormControlMap
WHERE
(Data_FieldValue.PageID IN (1,2,11057,366602))
AND Data_FieldValue.FieldID = FormInputControl.ID
AND Data_FieldValue.FormID = FormControl.ID
AND FormInputControl.ID = FormInputControlMap.FieldID
AND FormControl.ID = FormInputControlMap.FormID
AND FormControl.ID = FormControlMap.FormID
AND (
(
(FormControlMap.ClassConstant = 4)
AND
(FormControlMap.ClassID IN (1,367))
)
OR (
(FormControlMap.ClassConstant = 1)
AND (
(FormControlMap.ClassID IN (1,2,11057))
)
)
OR (
(FormControlMap.ClassConstant = 2)
AND (FormControlMap.ClassID = 1)
)
)
ORDER BY PageID DESC, FormControl.ID, FormInputControl.ID

SELECT *
FROM Data_ClassNames
WHERE
(PageID IN (1,2,11057,366602))
AND VersionState = 2
AND OutputTypeID = 0
ORDER BY PageID DESC, ControlID DESC

SELECT *
FROM Data_StyleSheetGroups
WHERE
(PageID IN (1,2,11057,366602))
AND VersionState = 2
ORDER BY PageID DESC, ItemPos ASC

SELECT *
FROM Data_Custom_Render
WHERE
(PageID IN (1,2,11057,366602))
AND VersionState >= 2
AND ModuleID <> 0

SELECT DISTINCT ControlID
FROM ItemSecurity
WHERE PageID = 366602
AND ApplyTo = 0

SELECT SubsiteID,Filename,PageType
FROM SitePages
WHERE ID = 11057

SELECT DISTINCT DestServerID
FROM FileActionQueue

SELECT *
FROM ItemSecurity
WHERE PageID = 366602
AND ApplyTo = 0

SELECT SiteID
FROM ServerSites
WHERE SiteID = 8
AND (UsersDataSourceName='commonspot-users-customer')

SELECT AuthenticationType, AuthenticationInheritFromSiteID
FROM ServerSites
WHERE SiteID = 8

SELECT *
FROM SAMLSettings
WHERE SiteID = 8
AND ((VersionState=2) OR (LastModifiedDate > '2023-06-07 23:07:03'))
ORDER BY VersionState DESC

SELECT c.FirstName, c.LastName, c.Middle, u.userID
FROM Contacts c
JOIN Users u ON c.ContactID = u.ID
WHERE c.ContactID = 1000012

SELECT SiteName
FROM ServerSites
WHERE UsersDataSourceName = 'commonspot-users-customer'
AND AuthenticationType = 2
AND AuthenticationInheritFromSiteID = 8