: Select * from `Menus` where `Active` = '1'

: Select `Objects`.`ID`, `Objects`.`TemplateID`, `Objects`.`Alias`, `Objects`.`NewWindow`, `Objects`.`ObjectID`, `Objects`.`PageTitle`, `Objects`.`MetaDescription`, `Objects`.`MetaKeywords`, `ObjectClasses`.`TableName`, `ObjectClasses`.`ClassName`, `Templates`.`Name` as `TemplateName`, `Templates`.`Positions`, `Components`.`Name`, `Components`.`Folder` from `Objects` left join `ObjectClasses` on `ObjectClasses`.`ID` = `Objects`.`ObjectClassID` left join `Components` on `Components`.`ID` = `ObjectClasses`.`ComponentID` left join `Templates` on `Templates`.`ID` = `Objects`.`TemplateID` left join `Menus` on `Menus`.`ID` = `Objects`.`MenuID` where `Alias` = 'care-management'

: Select `Objects`.`ID`, `Objects`.`TemplateID`, `Objects`.`Alias`, `Objects`.`NewWindow`, `Objects`.`ObjectID`, `Objects`.`PageTitle`, `Objects`.`MetaDescription`, `Objects`.`MetaKeywords`, `ObjectClasses`.`TableName`, `ObjectClasses`.`ClassName`, `Templates`.`Name` as `TemplateName`, `Templates`.`Positions`, `Contents`.`Name`, `Contents`.`RightText`, `Contents`.`TopImage`, `Contents`.`GalleryID`, `Contents`.`AddText`, `Contents`.`BlueTitle`, `Contents`.`BlueLeft`, `Contents`.`BlueRight`, `Contents`.`Text` from `Objects` left join `ObjectClasses` on `ObjectClasses`.`ID` = `Objects`.`ObjectClassID` left join `Contents` on `Contents`.`ID` = `Objects`.`ObjectID` left join `Templates` on `Templates`.`ID` = `Objects`.`TemplateID` left join `Menus` on `Menus`.`ID` = `Objects`.`MenuID` where `Objects`.`ID` = '1'

: Select `Modules`.*, `Components`.`ClassName`, `Components`.`Folder` from `Modules` left join `Modules2Objects` on `Modules2Objects`.`ModuleID` = `Modules`.`ID` left join `Components` on `Components`.`ID` = `Modules`.`ComponentID` where (`Modules2Objects`.`ObjectID` = '0' or `Modules2Objects`.`ObjectID` = '0') and `Modules2Objects`.`Position` = 'MainMenu' and `Modules2Objects`.`Active` = '1' order by `Modules2Objects`.`Order`

: Select `Modules`.*, `Components`.`ClassName`, `Components`.`Folder` from `Modules` left join `Modules2Objects` on `Modules2Objects`.`ModuleID` = `Modules`.`ID` left join `Components` on `Components`.`ID` = `Modules`.`ComponentID` where (`Modules2Objects`.`ObjectID` = '0' or `Modules2Objects`.`ObjectID` = '0') and `Modules2Objects`.`Position` = 'TopText' and `Modules2Objects`.`Active` = '1' order by `Modules2Objects`.`Order`

: Select `Modules`.*, `Components`.`ClassName`, `Components`.`Folder` from `Modules` left join `Modules2Objects` on `Modules2Objects`.`ModuleID` = `Modules`.`ID` left join `Components` on `Components`.`ID` = `Modules`.`ComponentID` where (`Modules2Objects`.`ObjectID` = '0' or `Modules2Objects`.`ObjectID` = '0') and `Modules2Objects`.`Position` = 'AddText' and `Modules2Objects`.`Active` = '1' order by `Modules2Objects`.`Order`

: Select `Modules`.*, `Components`.`ClassName`, `Components`.`Folder` from `Modules` left join `Modules2Objects` on `Modules2Objects`.`ModuleID` = `Modules`.`ID` left join `Components` on `Components`.`ID` = `Modules`.`ComponentID` where (`Modules2Objects`.`ObjectID` = '0' or `Modules2Objects`.`ObjectID` = '0') and `Modules2Objects`.`Position` = 'BlueTitle' and `Modules2Objects`.`Active` = '1' order by `Modules2Objects`.`Order`

: Select `Modules`.*, `Components`.`ClassName`, `Components`.`Folder` from `Modules` left join `Modules2Objects` on `Modules2Objects`.`ModuleID` = `Modules`.`ID` left join `Components` on `Components`.`ID` = `Modules`.`ComponentID` where (`Modules2Objects`.`ObjectID` = '0' or `Modules2Objects`.`ObjectID` = '0') and `Modules2Objects`.`Position` = 'BlueLeft' and `Modules2Objects`.`Active` = '1' order by `Modules2Objects`.`Order`

: Select `Modules`.*, `Components`.`ClassName`, `Components`.`Folder` from `Modules` left join `Modules2Objects` on `Modules2Objects`.`ModuleID` = `Modules`.`ID` left join `Components` on `Components`.`ID` = `Modules`.`ComponentID` where (`Modules2Objects`.`ObjectID` = '0' or `Modules2Objects`.`ObjectID` = '0') and `Modules2Objects`.`Position` = 'BlueRight' and `Modules2Objects`.`Active` = '1' order by `Modules2Objects`.`Order`

: Select `Modules`.*, `Components`.`ClassName`, `Components`.`Folder` from `Modules` left join `Modules2Objects` on `Modules2Objects`.`ModuleID` = `Modules`.`ID` left join `Components` on `Components`.`ID` = `Modules`.`ComponentID` where (`Modules2Objects`.`ObjectID` = '0' or `Modules2Objects`.`ObjectID` = '0') and `Modules2Objects`.`Position` = 'SubText' and `Modules2Objects`.`Active` = '1' order by `Modules2Objects`.`Order`

: Select `Modules`.*, `Components`.`ClassName`, `Components`.`Folder` from `Modules` left join `Modules2Objects` on `Modules2Objects`.`ModuleID` = `Modules`.`ID` left join `Components` on `Components`.`ID` = `Modules`.`ComponentID` where (`Modules2Objects`.`ObjectID` = '0' or `Modules2Objects`.`ObjectID` = '0') and `Modules2Objects`.`Position` = 'TopImage' and `Modules2Objects`.`Active` = '1' order by `Modules2Objects`.`Order`

: Select `Modules`.*, `Components`.`ClassName`, `Components`.`Folder` from `Modules` left join `Modules2Objects` on `Modules2Objects`.`ModuleID` = `Modules`.`ID` left join `Components` on `Components`.`ID` = `Modules`.`ComponentID` where (`Modules2Objects`.`ObjectID` = '0' or `Modules2Objects`.`ObjectID` = '0') and `Modules2Objects`.`Position` = '' and `Modules2Objects`.`Active` = '1' order by `Modules2Objects`.`Order`

: Select `Forms`.* from `Forms` left join `Forms2Objects` on `Forms2Objects`.`FormID` = `Forms`.`ID` where `Forms2Objects`.`ObjectID` = '0' and `Forms`.`Active` = '1' order by `Name` limit 1

: Select count(`ID`) as `Count` from `FormSubmissions` where `FormID` = '0'