SELECT `SiteTree`.*, `ResourcesPage`.*, `SiteTree`.ID, if(`SiteTree`.ClassName,`SiteTree`.ClassName,'SiteTree') AS RecordClassName FROM `SiteTree` LEFT JOIN `ResourcesPage` ON `ResourcesPage`.ID = `SiteTree`.ID WHERE (`SiteTree`.`ID` = 20) AND (`SiteTree`.ClassName IN ('ResourcesPage')) ORDER BY Sort LIMIT 1 SHOW TABLES SHOW FULL FIELDS IN `Permission` SHOW COLLATION LIKE 'utf8_general_ci' SHOW FULL FIELDS IN `Member` SELECT `Member`.*, `Member`.ID, if(`Member`.ClassName,`Member`.ClassName,'Member') AS RecordClassName FROM `Member` WHERE (Member.ID = 1) ORDER BY Surname, FirstName LIMIT 1 UPDATE Member SET LastVisited = NOW() WHERE ID = 1 SELECT `Member`.*, `Member`.ID, if(`Member`.ClassName,`Member`.ClassName,'Member') AS RecordClassName FROM `Member` WHERE (`Member`.`ID` = 1) ORDER BY Surname, FirstName LIMIT 1 SELECT `Group_Members`.*, `Group`.*, `Group`.ID, if(`Group`.ClassName,`Group`.ClassName,'Group') AS RecordClassName FROM `Group` INNER JOIN `Group_Members` ON `Group_Members`.GroupID = `Group`.ID WHERE (`Group_Members`.MemberID = 1) GROUP BY `Group`.ID SELECT `Group`.*, `Group`.ID, if(`Group`.ClassName,`Group`.ClassName,'Group') AS RecordClassName FROM `Group` WHERE (`ID` IN (1)) ORDER BY ID SELECT ID FROM Permission WHERE ( Code IN ('CMS_ACCESS_CMSMain' ,'ADMIN') AND Type = 1 AND GroupID IN (1) ) SELECT `SiteTree`.*, `GhostPage`.*, `AllEventsPage`.*, `AllVideosPage`.*, `ArticlePage`.*, `CategoryPage`.*, `EventPage`.*, `HomePage`.*, `ResourcesPage`.*, `SubCategoryPage`.*, `SubCategoryVideoPage`.*, `ErrorPage`.*, `RedirectorPage`.*, `VirtualPage`.*, `SiteTree`.ID, if(`SiteTree`.ClassName,`SiteTree`.ClassName,'SiteTree') AS RecordClassName FROM `SiteTree` LEFT JOIN `GhostPage` ON `GhostPage`.ID = `SiteTree`.ID LEFT JOIN `AllEventsPage` ON `AllEventsPage`.ID = `SiteTree`.ID LEFT JOIN `AllVideosPage` ON `AllVideosPage`.ID = `SiteTree`.ID LEFT JOIN `ArticlePage` ON `ArticlePage`.ID = `SiteTree`.ID LEFT JOIN `CategoryPage` ON `CategoryPage`.ID = `SiteTree`.ID LEFT JOIN `EventPage` ON `EventPage`.ID = `SiteTree`.ID LEFT JOIN `HomePage` ON `HomePage`.ID = `SiteTree`.ID LEFT JOIN `ResourcesPage` ON `ResourcesPage`.ID = `SiteTree`.ID LEFT JOIN `SubCategoryPage` ON `SubCategoryPage`.ID = `SiteTree`.ID LEFT JOIN `SubCategoryVideoPage` ON `SubCategoryVideoPage`.ID = `SiteTree`.ID LEFT JOIN `ErrorPage` ON `ErrorPage`.ID = `SiteTree`.ID LEFT JOIN `RedirectorPage` ON `RedirectorPage`.ID = `SiteTree`.ID LEFT JOIN `VirtualPage` ON `VirtualPage`.ID = `SiteTree`.ID WHERE (`SiteTree`.ID = 20) ORDER BY Sort LIMIT 1 SELECT `Group_Members`.*, `Group`.*, `Group`.ID, if(`Group`.ClassName,`Group`.ClassName,'Group') AS RecordClassName FROM `Group` INNER JOIN `Group_Members` ON `Group_Members`.GroupID = `Group`.ID WHERE (`Group_Members`.MemberID = 1) GROUP BY `Group`.ID SELECT `Group`.*, `Group`.ID, if(`Group`.ClassName,`Group`.ClassName,'Group') AS RecordClassName FROM `Group` WHERE (`ID` IN (1)) ORDER BY ID SELECT ID FROM Permission WHERE ( Code IN ('ADMIN' ,'ADMIN') AND Type = 1 AND GroupID IN (1) ) SELECT Version FROM `SiteTree` WHERE ID = 20 SELECT `SiteTree`.*, `VirtualPage`.*, `SiteTree`.ID, if(`SiteTree`.ClassName,`SiteTree`.ClassName,'SiteTree') AS RecordClassName FROM `SiteTree` LEFT JOIN `VirtualPage` ON `VirtualPage`.ID = `SiteTree`.ID WHERE (CopyContentFromID = 20) AND (`SiteTree`.ClassName IN ('VirtualPage')) ORDER BY Sort SELECT `SiteTree_LinkTracking`.*, `SiteTree`.*, `GhostPage`.*, `AllEventsPage`.*, `AllVideosPage`.*, `ArticlePage`.*, `CategoryPage`.*, `EventPage`.*, `HomePage`.*, `ResourcesPage`.*, `SubCategoryPage`.*, `SubCategoryVideoPage`.*, `ErrorPage`.*, `RedirectorPage`.*, `VirtualPage`.*, `SiteTree`.ID, if(`SiteTree`.ClassName,`SiteTree`.ClassName,'SiteTree') AS RecordClassName FROM `SiteTree` LEFT JOIN `GhostPage` ON `GhostPage`.ID = `SiteTree`.ID LEFT JOIN `AllEventsPage` ON `AllEventsPage`.ID = `SiteTree`.ID LEFT JOIN `AllVideosPage` ON `AllVideosPage`.ID = `SiteTree`.ID LEFT JOIN `ArticlePage` ON `ArticlePage`.ID = `SiteTree`.ID LEFT JOIN `CategoryPage` ON `CategoryPage`.ID = `SiteTree`.ID LEFT JOIN `EventPage` ON `EventPage`.ID = `SiteTree`.ID LEFT JOIN `HomePage` ON `HomePage`.ID = `SiteTree`.ID LEFT JOIN `ResourcesPage` ON `ResourcesPage`.ID = `SiteTree`.ID LEFT JOIN `SubCategoryPage` ON `SubCategoryPage`.ID = `SiteTree`.ID LEFT JOIN `SubCategoryVideoPage` ON `SubCategoryVideoPage`.ID = `SiteTree`.ID LEFT JOIN `ErrorPage` ON `ErrorPage`.ID = `SiteTree`.ID LEFT JOIN `RedirectorPage` ON `RedirectorPage`.ID = `SiteTree`.ID LEFT JOIN `VirtualPage` ON `VirtualPage`.ID = `SiteTree`.ID INNER JOIN `SiteTree_LinkTracking` ON `SiteTree_LinkTracking`.SiteTreeID = `SiteTree`.ID WHERE (`SiteTree_LinkTracking`.ChildID = 20) GROUP BY `SiteTree`.ID ORDER BY Sort SELECT `SiteTree_LinkTracking`.*, `SiteTree`.*, `GhostPage`.*, `AllEventsPage`.*, `AllVideosPage`.*, `ArticlePage`.*, `CategoryPage`.*, `EventPage`.*, `HomePage`.*, `ResourcesPage`.*, `SubCategoryPage`.*, `SubCategoryVideoPage`.*, `ErrorPage`.*, `RedirectorPage`.*, `VirtualPage`.*, `SiteTree`.ID, if(`SiteTree`.ClassName,`SiteTree`.ClassName,'SiteTree') AS RecordClassName FROM `SiteTree` LEFT JOIN `GhostPage` ON `GhostPage`.ID = `SiteTree`.ID LEFT JOIN `AllEventsPage` ON `AllEventsPage`.ID = `SiteTree`.ID LEFT JOIN `AllVideosPage` ON `AllVideosPage`.ID = `SiteTree`.ID LEFT JOIN `ArticlePage` ON `ArticlePage`.ID = `SiteTree`.ID LEFT JOIN `CategoryPage` ON `CategoryPage`.ID = `SiteTree`.ID LEFT JOIN `EventPage` ON `EventPage`.ID = `SiteTree`.ID LEFT JOIN `HomePage` ON `HomePage`.ID = `SiteTree`.ID LEFT JOIN `ResourcesPage` ON `ResourcesPage`.ID = `SiteTree`.ID LEFT JOIN `SubCategoryPage` ON `SubCategoryPage`.ID = `SiteTree`.ID LEFT JOIN `SubCategoryVideoPage` ON `SubCategoryVideoPage`.ID = `SiteTree`.ID LEFT JOIN `ErrorPage` ON `ErrorPage`.ID = `SiteTree`.ID LEFT JOIN `RedirectorPage` ON `RedirectorPage`.ID = `SiteTree`.ID LEFT JOIN `VirtualPage` ON `VirtualPage`.ID = `SiteTree`.ID INNER JOIN `SiteTree_LinkTracking` ON `SiteTree_LinkTracking`.SiteTreeID = `SiteTree`.ID WHERE (`SiteTree_LinkTracking`.ChildID = 20) GROUP BY `SiteTree`.ID ORDER BY Sort DESCRIBE SiteTree ClassName SELECT `Group_Members`.*, `Group`.*, `Group`.ID, if(`Group`.ClassName,`Group`.ClassName,'Group') AS RecordClassName FROM `Group` INNER JOIN `Group_Members` ON `Group_Members`.GroupID = `Group`.ID WHERE (`Group_Members`.MemberID = 1) GROUP BY `Group`.ID SELECT `Group`.*, `Group`.ID, if(`Group`.ClassName,`Group`.ClassName,'Group') AS RecordClassName FROM `Group` WHERE (`ID` IN (1)) ORDER BY ID SELECT ID FROM Permission WHERE ( Code IN ('SITETREE_GRANT_ACCESS' ,'ADMIN') AND Type = 1 AND GroupID IN (1) ) SELECT `SiteTree_Live`.*, `GhostPage_Live`.*, `AllEventsPage_Live`.*, `AllVideosPage_Live`.*, `ArticlePage_Live`.*, `CategoryPage_Live`.*, `EventPage_Live`.*, `HomePage_Live`.*, `ResourcesPage_Live`.*, `SubCategoryPage_Live`.*, `SubCategoryVideoPage_Live`.*, `ErrorPage_Live`.*, `RedirectorPage_Live`.*, `VirtualPage_Live`.*, `SiteTree_Live`.ID, if(`SiteTree_Live`.ClassName,`SiteTree_Live`.ClassName,'SiteTree') AS RecordClassName FROM `SiteTree_Live` LEFT JOIN `GhostPage_Live` ON `GhostPage_Live`.ID = `SiteTree_Live`.ID LEFT JOIN `AllEventsPage_Live` ON `AllEventsPage_Live`.ID = `SiteTree_Live`.ID LEFT JOIN `AllVideosPage_Live` ON `AllVideosPage_Live`.ID = `SiteTree_Live`.ID LEFT JOIN `ArticlePage_Live` ON `ArticlePage_Live`.ID = `SiteTree_Live`.ID LEFT JOIN `CategoryPage_Live` ON `CategoryPage_Live`.ID = `SiteTree_Live`.ID LEFT JOIN `EventPage_Live` ON `EventPage_Live`.ID = `SiteTree_Live`.ID LEFT JOIN `HomePage_Live` ON `HomePage_Live`.ID = `SiteTree_Live`.ID LEFT JOIN `ResourcesPage_Live` ON `ResourcesPage_Live`.ID = `SiteTree_Live`.ID LEFT JOIN `SubCategoryPage_Live` ON `SubCategoryPage_Live`.ID = `SiteTree_Live`.ID LEFT JOIN `SubCategoryVideoPage_Live` ON `SubCategoryVideoPage_Live`.ID = `SiteTree_Live`.ID LEFT JOIN `ErrorPage_Live` ON `ErrorPage_Live`.ID = `SiteTree_Live`.ID LEFT JOIN `RedirectorPage_Live` ON `RedirectorPage_Live`.ID = `SiteTree_Live`.ID LEFT JOIN `VirtualPage_Live` ON `VirtualPage_Live`.ID = `SiteTree_Live`.ID WHERE (`SiteTree_Live`.ID = 20) ORDER BY Sort LIMIT 1 SELECT Version FROM `SiteTree` WHERE ID = 20 SELECT ID FROM `SiteTree_Live` WHERE ID = 20 SELECT if(`SiteTree`.Version=`SiteTree_Live`.Version,1,0) FROM `SiteTree` INNER JOIN `SiteTree_Live` ON `SiteTree`.ID = `SiteTree_Live`.ID AND `SiteTree`.ID = 20 SELECT ID FROM `SiteTree_Live` WHERE ID = 20 SELECT `SiteTree`.*, `GhostPage`.*, `AllEventsPage`.*, `AllVideosPage`.*, `ArticlePage`.*, `CategoryPage`.*, `EventPage`.*, `HomePage`.*, `ResourcesPage`.*, `SubCategoryPage`.*, `SubCategoryVideoPage`.*, `ErrorPage`.*, `RedirectorPage`.*, `VirtualPage`.*, `SiteTree`.ID, if(`SiteTree`.ClassName,`SiteTree`.ClassName,'SiteTree') AS RecordClassName FROM `SiteTree` LEFT JOIN `GhostPage` ON `GhostPage`.ID = `SiteTree`.ID LEFT JOIN `AllEventsPage` ON `AllEventsPage`.ID = `SiteTree`.ID LEFT JOIN `AllVideosPage` ON `AllVideosPage`.ID = `SiteTree`.ID LEFT JOIN `ArticlePage` ON `ArticlePage`.ID = `SiteTree`.ID LEFT JOIN `CategoryPage` ON `CategoryPage`.ID = `SiteTree`.ID LEFT JOIN `EventPage` ON `EventPage`.ID = `SiteTree`.ID LEFT JOIN `HomePage` ON `HomePage`.ID = `SiteTree`.ID LEFT JOIN `ResourcesPage` ON `ResourcesPage`.ID = `SiteTree`.ID LEFT JOIN `SubCategoryPage` ON `SubCategoryPage`.ID = `SiteTree`.ID LEFT JOIN `SubCategoryVideoPage` ON `SubCategoryVideoPage`.ID = `SiteTree`.ID LEFT JOIN `ErrorPage` ON `ErrorPage`.ID = `SiteTree`.ID LEFT JOIN `RedirectorPage` ON `RedirectorPage`.ID = `SiteTree`.ID LEFT JOIN `VirtualPage` ON `VirtualPage`.ID = `SiteTree`.ID WHERE (`SiteTree`.ID = 20) ORDER BY Sort LIMIT 1 SELECT `SiteTree`.*, `GhostPage`.*, `AllEventsPage`.*, `AllVideosPage`.*, `ArticlePage`.*, `CategoryPage`.*, `EventPage`.*, `HomePage`.*, `ResourcesPage`.*, `SubCategoryPage`.*, `SubCategoryVideoPage`.*, `ErrorPage`.*, `RedirectorPage`.*, `VirtualPage`.*, `SiteTree`.ID, if(`SiteTree`.ClassName,`SiteTree`.ClassName,'SiteTree') AS RecordClassName FROM `SiteTree` LEFT JOIN `GhostPage` ON `GhostPage`.ID = `SiteTree`.ID LEFT JOIN `AllEventsPage` ON `AllEventsPage`.ID = `SiteTree`.ID LEFT JOIN `AllVideosPage` ON `AllVideosPage`.ID = `SiteTree`.ID LEFT JOIN `ArticlePage` ON `ArticlePage`.ID = `SiteTree`.ID LEFT JOIN `CategoryPage` ON `CategoryPage`.ID = `SiteTree`.ID LEFT JOIN `EventPage` ON `EventPage`.ID = `SiteTree`.ID LEFT JOIN `HomePage` ON `HomePage`.ID = `SiteTree`.ID LEFT JOIN `ResourcesPage` ON `ResourcesPage`.ID = `SiteTree`.ID LEFT JOIN `SubCategoryPage` ON `SubCategoryPage`.ID = `SiteTree`.ID LEFT JOIN `SubCategoryVideoPage` ON `SubCategoryVideoPage`.ID = `SiteTree`.ID LEFT JOIN `ErrorPage` ON `ErrorPage`.ID = `SiteTree`.ID LEFT JOIN `RedirectorPage` ON `RedirectorPage`.ID = `SiteTree`.ID LEFT JOIN `VirtualPage` ON `VirtualPage`.ID = `SiteTree`.ID WHERE (`SiteTree`.URLSegment = 'resources' AND `SiteTree`.ID <> '20') ORDER BY Sort LIMIT 1 update `SiteTree` SET `HasBrokenFile` = 0, `HasBrokenLink` = 0, `Version` = '2', `LastEdited` = now() where ID = 20 SELECT `SiteTree`.*, `VirtualPage`.*, `SiteTree`.ID, if(`SiteTree`.ClassName,`SiteTree`.ClassName,'SiteTree') AS RecordClassName FROM `SiteTree` LEFT JOIN `VirtualPage` ON `VirtualPage`.ID = `SiteTree`.ID WHERE (CopyContentFromID = 20) AND (`SiteTree`.ClassName IN ('VirtualPage')) ORDER BY Sort SELECT `File`.*, `File`.ID, if(`File`.ClassName,`File`.ClassName,'File') AS RecordClassName FROM `File` WHERE (Filename = 'http://www.networksolutions.com/labs/') ORDER BY Name LIMIT 1 SELECT `SiteTree_LinkTracking`.*, `SiteTree`.*, `GhostPage`.*, `AllEventsPage`.*, `AllVideosPage`.*, `ArticlePage`.*, `CategoryPage`.*, `EventPage`.*, `HomePage`.*, `ResourcesPage`.*, `SubCategoryPage`.*, `SubCategoryVideoPage`.*, `ErrorPage`.*, `RedirectorPage`.*, `VirtualPage`.*, `SiteTree`.ID, if(`SiteTree`.ClassName,`SiteTree`.ClassName,'SiteTree') AS RecordClassName FROM `SiteTree` LEFT JOIN `GhostPage` ON `GhostPage`.ID = `SiteTree`.ID LEFT JOIN `AllEventsPage` ON `AllEventsPage`.ID = `SiteTree`.ID LEFT JOIN `AllVideosPage` ON `AllVideosPage`.ID = `SiteTree`.ID LEFT JOIN `ArticlePage` ON `ArticlePage`.ID = `SiteTree`.ID LEFT JOIN `CategoryPage` ON `CategoryPage`.ID = `SiteTree`.ID LEFT JOIN `EventPage` ON `EventPage`.ID = `SiteTree`.ID LEFT JOIN `HomePage` ON `HomePage`.ID = `SiteTree`.ID LEFT JOIN `ResourcesPage` ON `ResourcesPage`.ID = `SiteTree`.ID LEFT JOIN `SubCategoryPage` ON `SubCategoryPage`.ID = `SiteTree`.ID LEFT JOIN `SubCategoryVideoPage` ON `SubCategoryVideoPage`.ID = `SiteTree`.ID LEFT JOIN `ErrorPage` ON `ErrorPage`.ID = `SiteTree`.ID LEFT JOIN `RedirectorPage` ON `RedirectorPage`.ID = `SiteTree`.ID LEFT JOIN `VirtualPage` ON `VirtualPage`.ID = `SiteTree`.ID INNER JOIN `SiteTree_LinkTracking` ON `SiteTree_LinkTracking`.ChildID = `SiteTree`.ID WHERE (`SiteTree_LinkTracking`.SiteTreeID = 20) GROUP BY `SiteTree`.ID ORDER BY Sort DELETE FROM `SiteTree_LinkTracking` WHERE SiteTreeID = 20 AND "FieldName" = 'Content' AND "SiteTreeID" = 20 SELECT `SiteTree_ImageTracking`.*, `File`.*, `File`.ID, if(`File`.ClassName,`File`.ClassName,'File') AS RecordClassName FROM `File` INNER JOIN `SiteTree_ImageTracking` ON `SiteTree_ImageTracking`.FileID = `File`.ID WHERE (`SiteTree_ImageTracking`.SiteTreeID = 20) GROUP BY `File`.ID ORDER BY Name DELETE FROM `SiteTree_ImageTracking` WHERE SiteTreeID = 20 AND FieldName = 'Content' SELECT `SiteTree`.*, `ArticlePage`.*, `SiteTree`.ID, if(`SiteTree`.ClassName,`SiteTree`.ClassName,'SiteTree') AS RecordClassName FROM `SiteTree` LEFT JOIN `ArticlePage` ON `ArticlePage`.ID = `SiteTree`.ID WHERE (ResourcesPageID = '20') AND (`SiteTree`.ClassName IN ('ArticlePage')) ORDER BY Sort SELECT `SiteTree_ViewerGroups`.*, `Group`.*, `Group`.ID, if(`Group`.ClassName,`Group`.ClassName,'Group') AS RecordClassName FROM `Group` INNER JOIN `SiteTree_ViewerGroups` ON `SiteTree_ViewerGroups`.GroupID = `Group`.ID WHERE (`SiteTree_ViewerGroups`.SiteTreeID = 20) GROUP BY `Group`.ID SELECT `SiteTree_EditorGroups`.*, `Group`.*, `Group`.ID, if(`Group`.ClassName,`Group`.ClassName,'Group') AS RecordClassName FROM `Group` INNER JOIN `SiteTree_EditorGroups` ON `SiteTree_EditorGroups`.GroupID = `Group`.ID WHERE (`SiteTree_EditorGroups`.SiteTreeID = 20) GROUP BY `Group`.ID SELECT `SiteTree`.*, `GhostPage`.*, `AllEventsPage`.*, `AllVideosPage`.*, `ArticlePage`.*, `CategoryPage`.*, `EventPage`.*, `HomePage`.*, `ResourcesPage`.*, `SubCategoryPage`.*, `SubCategoryVideoPage`.*, `ErrorPage`.*, `RedirectorPage`.*, `VirtualPage`.*, `SiteTree`.ID, if(`SiteTree`.ClassName,`SiteTree`.ClassName,'SiteTree') AS RecordClassName FROM `SiteTree` LEFT JOIN `GhostPage` ON `GhostPage`.ID = `SiteTree`.ID LEFT JOIN `AllEventsPage` ON `AllEventsPage`.ID = `SiteTree`.ID LEFT JOIN `AllVideosPage` ON `AllVideosPage`.ID = `SiteTree`.ID LEFT JOIN `ArticlePage` ON `ArticlePage`.ID = `SiteTree`.ID LEFT JOIN `CategoryPage` ON `CategoryPage`.ID = `SiteTree`.ID LEFT JOIN `EventPage` ON `EventPage`.ID = `SiteTree`.ID LEFT JOIN `HomePage` ON `HomePage`.ID = `SiteTree`.ID LEFT JOIN `ResourcesPage` ON `ResourcesPage`.ID = `SiteTree`.ID LEFT JOIN `SubCategoryPage` ON `SubCategoryPage`.ID = `SiteTree`.ID LEFT JOIN `SubCategoryVideoPage` ON `SubCategoryVideoPage`.ID = `SiteTree`.ID LEFT JOIN `ErrorPage` ON `ErrorPage`.ID = `SiteTree`.ID LEFT JOIN `RedirectorPage` ON `RedirectorPage`.ID = `SiteTree`.ID LEFT JOIN `VirtualPage` ON `VirtualPage`.ID = `SiteTree`.ID WHERE (`SiteTree`.URLSegment = 'resources' AND `SiteTree`.ID <> '20') ORDER BY Sort LIMIT 1 SELECT * FROM `SiteTree` WHERE ID = 20 SELECT MAX(Version) + 1 FROM SiteTree_versions WHERE RecordID = 20 SELECT * FROM `ResourcesPage` WHERE ID = 20 SELECT MAX(Version) + 1 FROM ResourcesPage_versions WHERE RecordID = 20 update `SiteTree` SET `MenuTitle` = null, `MetaDescription` = null, `MetaKeywords` = null, `ExtraMeta` = null, `ShowInMenus` = 1, `ShowInSearch` = 0, `HomepageForDomain` = null, `ProvideComments` = 0, `ToDo` = null, `LastEdited` = now(), `Version` = 2 where ID = 20 insert into `SiteTree` SET `MenuTitle` = null, `MetaDescription` = null, `MetaKeywords` = null, `ExtraMeta` = null, `ShowInMenus` = 1, `ShowInSearch` = 0, `HomepageForDomain` = null, `ProvideComments` = 0, `ToDo` = null, `LastEdited` = now(), `Version` = 2, ID = 20