Premier Careers

Jobs with Premier Marinas

We embrace the concepts of team working to achieve high levels of productivity and quality standards through employees who think and act as part of management.

We adopt an integrated management team approach, with problem solving and decision making being effected quickly at the lowest level and without undue bureaucracy.

To achieve this, we recognise the benefit derived from investing in people through training and development to constantly improve efficiency, productivity, quality and satisfaction in employment through a mutual recognition of each others' motivations and goals. Premier Marinas Limited has held the Investors in People accreditation since 2000.

SWANWICK MARINA

DOCKMASTER

In a very busy marina the Dockmaster is required to provide high levels of customer service. They  deal with vessel movements in and out of the marina, boat handling/towing, serving customers, handling money and recording data both within the office,  on the pontoons and fuel bay, whilst maximising the opportunity to sell our marina services to berth holders and visitors.  The Dockmasters work a shift rota which covers 24 hours a day and 7 days a week, including all Bank and Public holidays inclusive of Christmas and New Year.  Knowledge of boats, cash handling and computer literacy are preferable along with first class customer service skills and a willingness to work outdoors in all weather conditions.

Premier Marinas have a reputation for excellent standards of customer service and therefore a positive "can do" attitude with flexibility to work unsociable hours is essential.

Applicants are required to apply in writing sending a current CV and covering letter stating why you are interested in the role to: Tracey Jefkins, HR Manager, Premier Marinas Head Office, Swanwick Marina, Southampton, SO31 1ZL. Alternatively you may send your application to office@premiermarinas.com . Closing date for applications is 24th May 2013. Successful applicants will be contacted within 2 weeks of the closing date; if you are not contacted then unfortunately your application has been unsuccessful on this occasion.


MARINA ADMINISTRATOR - Swanwick


Swanwick Marina is seeking a full time Office Administrator.

The successful candidate will join a small hard working team and will mainly concentrate on the financial aspects of the marina operation but will also be required to assist on the front desk/reception area. They will be expected to sell annual berthing and boatyard services as may be required whilst undertaking administration duties. The role also requires occasional working outside serving fuel and assisting around the marina when required.

This role is customer facing and the successful applicant will need excellent customer service skills with a "nothing is too much trouble" attitude.

They must also be computer literate and a knowledge of boats would be very desirable.

Candidates must be prepared to work some weekends as part of a rota system.

Applications, enclosing a full CV, should be returned by 24/05/13 to:

Mrs Tracey Jefkins, HR Manager, Premier Marinas Ltd, Swanwick Marina, Southapton, Hampshire, SO31 1ZL

Boatyard Operative - Port Solent

The position of "Marina Operative" has become available at Premier's Port Solent Marina. This position covers many aspects of the day to day running of a busy, proactive site at the heart of Portsmouth Harbour.

The key areas of responsibility for this position are:

Boat Yard Operations - Working within a team to conduct boat lifting & launching using a 40T boat hoist.

Assisting the Lock Master with boat moving and the towing of vessels within the marina.

Boat Yard and boating experience is preferred but not essential. A full clean UK driving license is required.

This position involves outdoor working and candidates should be prepared to work weekends as the Company promotes and develops the boating lifting service to customers at weekends.

If you are interested in this position please contact Tracey Jefkins by 24th May 2013 with a covering letter and a copy of your CV at Head Office, Swanwick Marina, Swanwick, Southampton, Hants, SO31 1ZL.

29 queries took 40 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT `Page`.`id`, `Page`.`slug`, `Page`.`parent_id`, `Page`.`order`, `Page`.`menu_text`, `Page`.`meta_title`, `Page`.`meta_description`, `Page`.`meta_keywords`, `Page`.`page_heading`, `Page`.`spotlight_title`, `Page`.`spotlight_text`, `Page`.`spotlight_image_id`, `Page`.`type`, `Page`.`has_menu`, `Page`.`content_managed_sidebar`, `Page`.`simulated_page_id`, `Page`.`url`, `Page`.`body_class`, `Page`.`navigation_style`, `Page`.`status`, `Page`.`created`, `Page`.`created_by`, `Page`.`modified`, `Page`.`modified_by` FROM `pages` AS `Page` WHERE `Page`.`parent_id` = '1' AND `Page`.`status` = 'Enabled' ORDER BY `Page`.`order` ASC 773
2SELECT `Page`.`id`, `Page`.`slug`, `Page`.`parent_id`, `Page`.`order`, `Page`.`menu_text`, `Page`.`meta_title`, `Page`.`meta_description`, `Page`.`meta_keywords`, `Page`.`page_heading`, `Page`.`spotlight_title`, `Page`.`spotlight_text`, `Page`.`spotlight_image_id`, `Page`.`type`, `Page`.`has_menu`, `Page`.`content_managed_sidebar`, `Page`.`simulated_page_id`, `Page`.`url`, `Page`.`body_class`, `Page`.`navigation_style`, `Page`.`status`, `Page`.`created`, `Page`.`created_by`, `Page`.`modified`, `Page`.`modified_by` FROM `pages` AS `Page` WHERE (`Page`.`slug` = 'premier_vacancies1') AND ( `Page`.`status` != 'Deleted') LIMIT 1111
3SELECT `Redirect`.`id`, `Redirect`.`source_url`, `Redirect`.`destination_url`, `Redirect`.`status`, `Redirect`.`created`, `Redirect`.`created_by`, `Redirect`.`modified`, `Redirect`.`modified_by`, `CreatedBy`.`id`, `CreatedBy`.`name`, `CreatedBy`.`email`, `CreatedBy`.`password`, `CreatedBy`.`last_visit`, `CreatedBy`.`administrator_group_id`, `CreatedBy`.`status`, `CreatedBy`.`created`, `CreatedBy`.`created_by`, `CreatedBy`.`modified`, `CreatedBy`.`modified_by`, `ModifiedBy`.`id`, `ModifiedBy`.`name`, `ModifiedBy`.`email`, `ModifiedBy`.`password`, `ModifiedBy`.`last_visit`, `ModifiedBy`.`administrator_group_id`, `ModifiedBy`.`status`, `ModifiedBy`.`created`, `ModifiedBy`.`created_by`, `ModifiedBy`.`modified`, `ModifiedBy`.`modified_by` FROM `redirects` AS `Redirect` LEFT JOIN `administrators` AS `CreatedBy` ON `Redirect`.`created_by` = `CreatedBy`.`id` LEFT JOIN `administrators` AS `ModifiedBy` ON `Redirect`.`modified_by` = `ModifiedBy`.`id` WHERE (`Redirect`.`source_url` = '/pages/premier_vacancies1') AND (`Redirect`.`status` = 'Enabled') LIMIT 1001
4SELECT `Page`.`id`, `Page`.`slug`, `Page`.`parent_id`, `Page`.`order`, `Page`.`menu_text`, `Page`.`meta_title`, `Page`.`meta_description`, `Page`.`meta_keywords`, `Page`.`page_heading`, `Page`.`spotlight_title`, `Page`.`spotlight_text`, `Page`.`spotlight_image_id`, `Page`.`type`, `Page`.`has_menu`, `Page`.`content_managed_sidebar`, `Page`.`simulated_page_id`, `Page`.`url`, `Page`.`body_class`, `Page`.`navigation_style`, `Page`.`status`, `Page`.`created`, `Page`.`created_by`, `Page`.`modified`, `Page`.`modified_by` FROM `pages` AS `Page` WHERE (`Page`.`id` = '978') LIMIT 1111
5SELECT `LayoutBlock`.`id`, `LayoutBlock`.`page_id`, `LayoutBlock`.`order`, `LayoutBlock`.`layout_block_type_id` FROM `layout_blocks` AS `LayoutBlock` WHERE `LayoutBlock`.`page_id` = '978' ORDER BY `LayoutBlock`.`order` ASC551
6SELECT `LayoutBlockType`.`id`, `LayoutBlockType`.`name`, `LayoutBlockType`.`class`, `LayoutBlockType`.`status`, `LayoutBlockType`.`created`, `LayoutBlockType`.`created_by`, `LayoutBlockType`.`modified`, `LayoutBlockType`.`modified_by` FROM `layout_block_types` AS `LayoutBlockType` WHERE `LayoutBlockType`.`id` = '1'111
7SELECT `Container`.`id`, `Container`.`layout_block_id`, `Container`.`order`, `Container`.`class` FROM `containers` AS `Container` WHERE `Container`.`layout_block_id` = '2198' ORDER BY `Container`.`order` ASC111
8SELECT `Module`.`id`, `Module`.`container_id`, `Module`.`order`, `Module`.`module_type_id`, `Module`.`subid` FROM `modules` AS `Module` WHERE `Module`.`container_id` = '3478' ORDER BY `Module`.`order` ASC111
9SELECT `ModuleType`.`id`, `ModuleType`.`name`, `ModuleType`.`description`, `ModuleType`.`editable`, `ModuleType`.`browse_url`, `ModuleType`.`model`, `ModuleType`.`class`, `ModuleType`.`section`, `ModuleType`.`status`, `ModuleType`.`created`, `ModuleType`.`created_by`, `ModuleType`.`modified`, `ModuleType`.`modified_by` FROM `module_types` AS `ModuleType` WHERE `ModuleType`.`id` = '1'111
10SELECT `Container`.`id`, `Container`.`layout_block_id`, `Container`.`order`, `Container`.`class` FROM `containers` AS `Container` WHERE `Container`.`layout_block_id` = '2195' ORDER BY `Container`.`order` ASC112
11SELECT `Module`.`id`, `Module`.`container_id`, `Module`.`order`, `Module`.`module_type_id`, `Module`.`subid` FROM `modules` AS `Module` WHERE `Module`.`container_id` = '3475' ORDER BY `Module`.`order` ASC111
12SELECT `Container`.`id`, `Container`.`layout_block_id`, `Container`.`order`, `Container`.`class` FROM `containers` AS `Container` WHERE `Container`.`layout_block_id` = '2196' ORDER BY `Container`.`order` ASC111
13SELECT `Module`.`id`, `Module`.`container_id`, `Module`.`order`, `Module`.`module_type_id`, `Module`.`subid` FROM `modules` AS `Module` WHERE `Module`.`container_id` = '3476' ORDER BY `Module`.`order` ASC111
14SELECT `Container`.`id`, `Container`.`layout_block_id`, `Container`.`order`, `Container`.`class` FROM `containers` AS `Container` WHERE `Container`.`layout_block_id` = '2200' ORDER BY `Container`.`order` ASC111
15SELECT `Module`.`id`, `Module`.`container_id`, `Module`.`order`, `Module`.`module_type_id`, `Module`.`subid` FROM `modules` AS `Module` WHERE `Module`.`container_id` = '3480' ORDER BY `Module`.`order` ASC111
16SELECT `Container`.`id`, `Container`.`layout_block_id`, `Container`.`order`, `Container`.`class` FROM `containers` AS `Container` WHERE `Container`.`layout_block_id` = '2197' ORDER BY `Container`.`order` ASC110
17SELECT `Module`.`id`, `Module`.`container_id`, `Module`.`order`, `Module`.`module_type_id`, `Module`.`subid` FROM `modules` AS `Module` WHERE `Module`.`container_id` = '3477' ORDER BY `Module`.`order` ASC001
18SELECT `TextModule`.`id`, `TextModule`.`content`, `TextModule`.`image_id`, `TextModule`.`alignment`, `TextModule`.`alt`, `Image`.`id`, `Image`.`name`, `Image`.`caption`, `Image`.`alt`, `Image`.`category_id`, `Image`.`image_type_id`, `Image`.`extension`, `Image`.`status`, `Image`.`created`, `Image`.`created_by`, `Image`.`modified`, `Image`.`modified_by` FROM `text_modules` AS `TextModule` LEFT JOIN `images` AS `Image` ON `TextModule`.`image_id` = `Image`.`id` WHERE `TextModule`.`id` = '2214' LIMIT 1112
19SELECT `TextModule`.`id`, `TextModule`.`content`, `TextModule`.`image_id`, `TextModule`.`alignment`, `TextModule`.`alt`, `Image`.`id`, `Image`.`name`, `Image`.`caption`, `Image`.`alt`, `Image`.`category_id`, `Image`.`image_type_id`, `Image`.`extension`, `Image`.`status`, `Image`.`created`, `Image`.`created_by`, `Image`.`modified`, `Image`.`modified_by` FROM `text_modules` AS `TextModule` LEFT JOIN `images` AS `Image` ON `TextModule`.`image_id` = `Image`.`id` WHERE `TextModule`.`id` = '2225' LIMIT 1111
20SELECT `TextModule`.`id`, `TextModule`.`content`, `TextModule`.`image_id`, `TextModule`.`alignment`, `TextModule`.`alt`, `Image`.`id`, `Image`.`name`, `Image`.`caption`, `Image`.`alt`, `Image`.`category_id`, `Image`.`image_type_id`, `Image`.`extension`, `Image`.`status`, `Image`.`created`, `Image`.`created_by`, `Image`.`modified`, `Image`.`modified_by` FROM `text_modules` AS `TextModule` LEFT JOIN `images` AS `Image` ON `TextModule`.`image_id` = `Image`.`id` WHERE `TextModule`.`id` = '2216' LIMIT 1112
21SELECT `TextModule`.`id`, `TextModule`.`content`, `TextModule`.`image_id`, `TextModule`.`alignment`, `TextModule`.`alt`, `Image`.`id`, `Image`.`name`, `Image`.`caption`, `Image`.`alt`, `Image`.`category_id`, `Image`.`image_type_id`, `Image`.`extension`, `Image`.`status`, `Image`.`created`, `Image`.`created_by`, `Image`.`modified`, `Image`.`modified_by` FROM `text_modules` AS `TextModule` LEFT JOIN `images` AS `Image` ON `TextModule`.`image_id` = `Image`.`id` WHERE `TextModule`.`id` = '2226' LIMIT 1112
22SELECT `Page`.`id`, `Page`.`slug`, `Page`.`parent_id`, `Page`.`order`, `Page`.`menu_text`, `Page`.`meta_title`, `Page`.`meta_description`, `Page`.`meta_keywords`, `Page`.`page_heading`, `Page`.`spotlight_title`, `Page`.`spotlight_text`, `Page`.`spotlight_image_id`, `Page`.`type`, `Page`.`has_menu`, `Page`.`content_managed_sidebar`, `Page`.`simulated_page_id`, `Page`.`url`, `Page`.`body_class`, `Page`.`navigation_style`, `Page`.`status`, `Page`.`created`, `Page`.`created_by`, `Page`.`modified`, `Page`.`modified_by`, `Parent`.`id`, `Parent`.`slug`, `Parent`.`parent_id`, `Parent`.`order`, `Parent`.`menu_text`, `Parent`.`meta_title`, `Parent`.`meta_description`, `Parent`.`meta_keywords`, `Parent`.`page_heading`, `Parent`.`spotlight_title`, `Parent`.`spotlight_text`, `Parent`.`spotlight_image_id`, `Parent`.`type`, `Parent`.`has_menu`, `Parent`.`content_managed_sidebar`, `Parent`.`simulated_page_id`, `Parent`.`url`, `Parent`.`body_class`, `Parent`.`navigation_style`, `Parent`.`status`, `Parent`.`created`, `Parent`.`created_by`, `Parent`.`modified`, `Parent`.`modified_by` , `SpotlightImage`.`id`, `SpotlightImage`.`name`, `SpotlightImage`.`caption`, `SpotlightImage`.`alt`, `SpotlightImage`.`category_id`, `SpotlightImage`.`image_type_id`, `SpotlightImage`.`extension`, `SpotlightImage`.`status`, `SpotlightImage`.`created`, `SpotlightImage`.`created_by`, `SpotlightImage`.`modified`, `SpotlightImage`.`modified_by`, `SimulatedPage`.`id`, `SimulatedPage`.`slug`, `SimulatedPage`.`parent_id`, `SimulatedPage`.`order`, `SimulatedPage`.`menu_text`, `SimulatedPage`.`meta_title`, `SimulatedPage`.`meta_description`, `SimulatedPage`.`meta_keywords`, `SimulatedPage`.`page_heading`, `SimulatedPage`.`spotlight_title`, `SimulatedPage`.`spotlight_text`, `SimulatedPage`.`spotlight_image_id`, `SimulatedPage`.`type`, `SimulatedPage`.`has_menu`, `SimulatedPage`.`content_managed_sidebar`, `SimulatedPage`.`simulated_page_id`, `SimulatedPage`.`url`, `SimulatedPage`.`body_class`, `SimulatedPage`.`navigation_style`, `SimulatedPage`.`status`, `SimulatedPage`.`created`, `SimulatedPage`.`created_by`, `SimulatedPage`.`modified`, `SimulatedPage`.`modified_by`, `CreatedBy`.`id`, `CreatedBy`.`name`, `CreatedBy`.`email`, `CreatedBy`.`password`, `CreatedBy`.`last_visit`, `CreatedBy`.`administrator_group_id`, `CreatedBy`.`status`, `CreatedBy`.`created`, `CreatedBy`.`created_by`, `CreatedBy`.`modified`, `CreatedBy`.`modified_by`, `ModifiedBy`.`id`, `ModifiedBy`.`name`, `ModifiedBy`.`email`, `ModifiedBy`.`password`, `ModifiedBy`.`last_visit`, `ModifiedBy`.`administrator_group_id`, `ModifiedBy`.`status`, `ModifiedBy`.`created`, `ModifiedBy`.`created_by`, `ModifiedBy`.`modified`, `ModifiedBy`.`modified_by` FROM `pages` AS `Page` LEFT JOIN `pages` AS `Parent` ON `Page`.`parent_id` = `Parent`.`id` LEFT JOIN `images` AS `SpotlightImage` ON `Page`.`spotlight_image_id` = `SpotlightImage`.`id` LEFT JOIN `pages` AS `SimulatedPage` ON `Page`.`simulated_page_id` = `SimulatedPage`.`id` LEFT JOIN `administrators` AS `CreatedBy` ON `Page`.`created_by` = `CreatedBy`.`id` LEFT JOIN `administrators` AS `ModifiedBy` ON `Page`.`modified_by` = `ModifiedBy`.`id` WHERE (`Page`.`id` = '978') AND ( `Page`.`status` != 'Deleted') LIMIT 1114
23SELECT `Child`.`id`, `Child`.`slug`, `Child`.`parent_id`, `Child`.`order`, `Child`.`menu_text`, `Child`.`meta_title`, `Child`.`meta_description`, `Child`.`meta_keywords`, `Child`.`page_heading`, `Child`.`spotlight_title`, `Child`.`spotlight_text`, `Child`.`spotlight_image_id`, `Child`.`type`, `Child`.`has_menu`, `Child`.`content_managed_sidebar`, `Child`.`simulated_page_id`, `Child`.`url`, `Child`.`body_class`, `Child`.`navigation_style`, `Child`.`status`, `Child`.`created`, `Child`.`created_by`, `Child`.`modified`, `Child`.`modified_by` FROM `pages` AS `Child` WHERE `Child`.`status` <> 'Deleted' AND `Child`.`parent_id` = '978' ORDER BY `Child`.`order` ASC001
24SELECT `SidebarModule`.`id`, `SidebarModule`.`page_id`, `SidebarModule`.`order`, `SidebarModule`.`module_type_id`, `SidebarModule`.`subid`, `SidebarModule`.`status`, `SidebarModule`.`created`, `SidebarModule`.`created_by`, `SidebarModule`.`modified`, `SidebarModule`.`modified_by` FROM `sidebar_modules` AS `SidebarModule` WHERE `SidebarModule`.`page_id` = '978' ORDER BY `SidebarModule`.`order` ASC001
25SELECT `Page`.`navigation_style` FROM `pages` AS `Page` LEFT JOIN `pages` AS `Parent` ON `Page`.`parent_id` = `Parent`.`id` LEFT JOIN `images` AS `SpotlightImage` ON `Page`.`spotlight_image_id` = `SpotlightImage`.`id` LEFT JOIN `pages` AS `SimulatedPage` ON `Page`.`simulated_page_id` = `SimulatedPage`.`id` LEFT JOIN `administrators` AS `CreatedBy` ON `Page`.`created_by` = `CreatedBy`.`id` LEFT JOIN `administrators` AS `ModifiedBy` ON `Page`.`modified_by` = `ModifiedBy`.`id` WHERE (`Page`.`id` = '978') LIMIT 1111
26SELECT `Page`.`id`, `Page`.`slug`, `Page`.`parent_id`, `Page`.`order`, `Page`.`menu_text`, `Page`.`meta_title`, `Page`.`meta_description`, `Page`.`meta_keywords`, `Page`.`page_heading`, `Page`.`spotlight_title`, `Page`.`spotlight_text`, `Page`.`spotlight_image_id`, `Page`.`type`, `Page`.`has_menu`, `Page`.`content_managed_sidebar`, `Page`.`simulated_page_id`, `Page`.`url`, `Page`.`body_class`, `Page`.`navigation_style`, `Page`.`status`, `Page`.`created`, `Page`.`created_by`, `Page`.`modified`, `Page`.`modified_by`, `Parent`.`id`, `Parent`.`slug`, `Parent`.`parent_id`, `Parent`.`order`, `Parent`.`menu_text`, `Parent`.`meta_title`, `Parent`.`meta_description`, `Parent`.`meta_keywords`, `Parent`.`page_heading`, `Parent`.`spotlight_title`, `Parent`.`spotlight_text`, `Parent`.`spotlight_image_id`, `Parent`.`type`, `Parent`.`has_menu`, `Parent`.`content_managed_sidebar`, `Parent`.`simulated_page_id`, `Parent`.`url`, `Parent`.`body_class`, `Parent`.`navigation_style`, `Parent`.`status`, `Parent`.`created`, `Parent`.`created_by`, `Parent`.`modified`, `Parent`.`modified_by` FROM `pages` AS `Page` LEFT JOIN `pages` AS `Parent` ON `Page`.`parent_id` = `Parent`.`id` WHERE (`Page`.`id` = '978') LIMIT 1112
27SELECT `Child`.`id`, `Child`.`slug`, `Child`.`parent_id`, `Child`.`order`, `Child`.`menu_text`, `Child`.`meta_title`, `Child`.`meta_description`, `Child`.`meta_keywords`, `Child`.`page_heading`, `Child`.`spotlight_title`, `Child`.`spotlight_text`, `Child`.`spotlight_image_id`, `Child`.`type`, `Child`.`has_menu`, `Child`.`content_managed_sidebar`, `Child`.`simulated_page_id`, `Child`.`url`, `Child`.`body_class`, `Child`.`navigation_style`, `Child`.`status`, `Child`.`created`, `Child`.`created_by`, `Child`.`modified`, `Child`.`modified_by` FROM `pages` AS `Child` WHERE `Child`.`simulated_page_id` = 0 AND `Child`.`status` = 'Enabled' AND `Child`.`parent_id` = '978' ORDER BY `Child`.`order` ASC002
28SELECT `Page`.`id`, `Page`.`slug`, `Page`.`parent_id`, `Page`.`order`, `Page`.`menu_text`, `Page`.`meta_title`, `Page`.`meta_description`, `Page`.`meta_keywords`, `Page`.`page_heading`, `Page`.`spotlight_title`, `Page`.`spotlight_text`, `Page`.`spotlight_image_id`, `Page`.`type`, `Page`.`has_menu`, `Page`.`content_managed_sidebar`, `Page`.`simulated_page_id`, `Page`.`url`, `Page`.`body_class`, `Page`.`navigation_style`, `Page`.`status`, `Page`.`created`, `Page`.`created_by`, `Page`.`modified`, `Page`.`modified_by`, `Parent`.`id`, `Parent`.`slug`, `Parent`.`parent_id`, `Parent`.`order`, `Parent`.`menu_text`, `Parent`.`meta_title`, `Parent`.`meta_description`, `Parent`.`meta_keywords`, `Parent`.`page_heading`, `Parent`.`spotlight_title`, `Parent`.`spotlight_text`, `Parent`.`spotlight_image_id`, `Parent`.`type`, `Parent`.`has_menu`, `Parent`.`content_managed_sidebar`, `Parent`.`simulated_page_id`, `Parent`.`url`, `Parent`.`body_class`, `Parent`.`navigation_style`, `Parent`.`status`, `Parent`.`created`, `Parent`.`created_by`, `Parent`.`modified`, `Parent`.`modified_by` FROM `pages` AS `Page` LEFT JOIN `pages` AS `Parent` ON `Page`.`parent_id` = `Parent`.`id` WHERE (`Page`.`id` IS NULL) LIMIT 1002
29SELECT `SidebarModule`.`id`, `SidebarModule`.`page_id`, `SidebarModule`.`order`, `SidebarModule`.`module_type_id`, `SidebarModule`.`subid`, `SidebarModule`.`status`, `SidebarModule`.`created`, `SidebarModule`.`created_by`, `SidebarModule`.`modified`, `SidebarModule`.`modified_by` FROM `sidebar_modules` AS `SidebarModule` WHERE `SidebarModule`.`status` = 'Enabled' AND `SidebarModule`.`page_id` = '978' ORDER BY `SidebarModule`.`order` ASC001