Skip to content

Instantly share code, notes, and snippets.

@pierresetteskog

pierresetteskog/enovacms

Last active August 29, 2015 14:10
Show Gist options
  • Save pierresetteskog/bac77368d4e4675d5a3e to your computer and use it in GitHub Desktop.
Save pierresetteskog/bac77368d4e4675d5a3e to your computer and use it in GitHub Desktop.
Download ZIP
enovacms synk
Raw
enovacms
SELECT EnovaCmsSiteGroup.Identifier, EnovaController.Guid AS controller, EnovaAction.Guid AS action, EnovaViewData.Guid AS viewdata, EnovaView.Guid AS enovaview, EnovaAction.ID AS actionid,
EnovaView.ID AS viewid
FROM EnovaViewData LEFT OUTER JOIN
EnovaView ON EnovaViewData.ID = EnovaView.ViewDataID RIGHT OUTER JOIN
EnovaCmsSiteGroup ON EnovaViewData.SiteID = EnovaCmsSiteGroup.ID LEFT OUTER JOIN
EnovaController LEFT OUTER JOIN
EnovaAction ON EnovaController.ID = EnovaAction.ControllerID ON EnovaCmsSiteGroup.ID = EnovaController.SiteID
WHERE (EnovaView.Deleted = 0) AND (EnovaViewData.Deleted = 0) AND (EnovaCmsSiteGroup.Deleted = 0) AND (EnovaController.Deleted = 0) AND (EnovaAction.Deleted = 0)
ORDER BY EnovaCmsSiteGroup.Identifier, controller, action
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment