: 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-category'

: 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` = 'shop'

: 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` = 'duramax'

: 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` = '2011-2016-lml'

: 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` = 'exhaust-systems-components-1-2011-2016-lml'

: 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` = 'exhaust-manifolds-up-pipes-downpipes-1-exhaust-systems-components-1-2011-2016-lml'

: 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` = 'vendorlogos'

: 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'