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` = 'certifications' 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`.`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 `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` = 'certification-6020' 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`.`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` = 'TopText2' 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' MG Credential
: 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` = 'certifications'
: 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`.`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 `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` = 'certification-6020'
: 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`.`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` = 'TopText2' 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'
Select * from `Forms` where `ID` = '1' Select count(`ID`) as `Count` from `FormSubmissions` where `FormID` = '0' Select * from `FormFields` where `FormID` = '0' order by `Order` Select * from `FormConfiguration` limit 1