Skip to content

Instantly share code, notes, and snippets.

@pierresetteskog

pierresetteskog/enovacmspagetype

Created September 19, 2014 07:02
Show Gist options
  • Save pierresetteskog/183cb18f1d43eca48817 to your computer and use it in GitHub Desktop.
Save pierresetteskog/183cb18f1d43eca48817 to your computer and use it in GitHub Desktop.
Download ZIP
enova cms pagetype
Raw
enovacmspagetype
SELECT EnovaAction.Guid, EnovaController.Guid AS Expr1, EnovaViewData.Guid AS Expr2, EnovaController.SiteID, EnovaCmsSiteGroup.Name_lang1, EnovaViewData.ID AS viewdataid, EnovaAction.ID AS actionid,
EnovaController.ID AS controllerid, EnovaView.ID AS viewid
FROM EnovaViewData INNER JOIN
EnovaView ON EnovaViewData.ID = EnovaView.ViewDataID INNER JOIN
EnovaAction INNER JOIN
EnovaController ON EnovaAction.ControllerID = EnovaController.ID INNER JOIN
EnovaCmsSiteGroup ON EnovaController.SiteID = EnovaCmsSiteGroup.ID ON EnovaViewData.ID = EnovaAction.ViewDataID
WHERE (EnovaViewData.Deleted = 0) AND (EnovaAction.Deleted = 0) AND (EnovaController.Deleted = 0) AND (EnovaCmsSiteGroup.Deleted = 0) AND (EnovaView.Deleted = 0)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment