: 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` = 'product'
: 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`.`TopText`,
`Contents`.`SmallTopText`,
`Contents`.`TopImage`,
`Contents`.`GalleryID`,
`Contents`.`TeamID`,
`Contents`.`Quote`,
`Contents`.`QuoteName`,
`Contents`.`QuoteTitle`,
`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` = 'baby-onesies'
: 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`.`TopText`,
`Contents`.`SmallTopText`,
`Contents`.`TopImage`,
`Contents`.`GalleryID`,
`Contents`.`TeamID`,
`Contents`.`Quote`,
`Contents`.`QuoteName`,
`Contents`.`QuoteTitle`,
`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` = 'Assets'
: 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`.`TopText`,
`Contents`.`SmallTopText`,
`Contents`.`TopImage`,
`Contents`.`GalleryID`,
`Contents`.`TeamID`,
`Contents`.`Quote`,
`Contents`.`QuoteName`,
`Contents`.`QuoteTitle`,
`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` = 'Images'
: 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`.`TopText`,
`Contents`.`SmallTopText`,
`Contents`.`TopImage`,
`Contents`.`GalleryID`,
`Contents`.`TeamID`,
`Contents`.`Quote`,
`Contents`.`QuoteName`,
`Contents`.`QuoteTitle`,
`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` = 'top'
: 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`.`TopText`,
`Contents`.`SmallTopText`,
`Contents`.`TopImage`,
`Contents`.`GalleryID`,
`Contents`.`TeamID`,
`Contents`.`Quote`,
`Contents`.`QuoteName`,
`Contents`.`QuoteTitle`,
`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` = 'Assets'
: 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`.`TopText`,
`Contents`.`SmallTopText`,
`Contents`.`TopImage`,
`Contents`.`GalleryID`,
`Contents`.`TeamID`,
`Contents`.`Quote`,
`Contents`.`QuoteName`,
`Contents`.`QuoteTitle`,
`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` = 'Images'
: 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`.`TopText`,
`Contents`.`SmallTopText`,
`Contents`.`TopImage`,
`Contents`.`GalleryID`,
`Contents`.`TeamID`,
`Contents`.`Quote`,
`Contents`.`QuoteName`,
`Contents`.`QuoteTitle`,
`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` = 'top'
: 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`.`TopText`,
`Contents`.`SmallTopText`,
`Contents`.`TopImage`,
`Contents`.`GalleryID`,
`Contents`.`TeamID`,
`Contents`.`Quote`,
`Contents`.`QuoteName`,
`Contents`.`QuoteTitle`,
`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` = 'performancetop.jpg'
: 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`.`TopText`,
`Contents`.`SmallTopText`,
`Contents`.`TopImage`,
`Contents`.`GalleryID`,
`Contents`.`TeamID`,
`Contents`.`Quote`,
`Contents`.`QuoteName`,
`Contents`.`QuoteTitle`,
`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'