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

Contact us today for more information.
Or Call (603)-224-6100

DISCOVER A CAREER THAT'S MUCH MORE THAN SIMPLY HELPING OTHERS. WE'RE ABOUT CONNECTING TO BRING THE VERY BEST QUALITY OF LIFE.

We're dedicated in providing the best home care services in the Greater Concord, NH area. We achieve this with the amazing people on our team.

Our employees are provided with the training and support to help them further enhance their natural abilities to offer compassion and enhance someone else's life.

Jumpstart your career and talk with us today!

Join Our Team!