Summer Boatyard Offers for Premier Berth Holders

Take advantage of Premier's quality boatyard Services this summer and SAVE up to 40%

Whether you are planning a competitive or leisurely summer on the water, our summer special boatyard packages will help you to get the most from your boat this season, and save you money.

Book in a quick turnaround lift, wash and relaunch or incorporate up to 7 days ashore to carry out that essential summer maintenance.

Contact your marina now to book, or follow the links below for details of our special seasonal promotions at your marina:

WIN your Round the Island Race Entry Fee in our boatyard competition!

When you book our 'Summer Scrub and Splash' boatyard service, you can opt into our competition to win your Round the Island Race Entry Fee. Ask us for details when making your booking! Terms and conditions apply.

Sovereign Harbour

'Summer Scrub and Splash' SAVE 40%
Lift, pressure wash and relaunch

'Summer Pit Stop' SAVE 35%
Lift, pressure wash, up to 7 days ashore and relaunch

View Details

Port Solent Marina

'Summer Scrub and Splash' SAVE 40%
Lift, pressure wash and relaunch

'Summer Pit Stop' SAVE 35%
Lift, pressure wash, up to 7 days ashore and relaunch

View Details

Brighton Marina

'Summer Scrub and Splash' SAVE 40%
Lift, pressure wash and relaunch

'Summer Pit Stop' SAVE 35%
Lift, pressure wash, up to 7 days ashore and relaunch

View Details

Gosport Marina

'Summer Scrub and Splash' SAVE 40%
Lift, pressure wash and relaunch

'Summer Pit Stop' SAVE 35%
Lift, pressure wash, up to 7 days ashore and relaunch

View Details

Chichester Marina

'Summer Scrub and Splash' SAVE 40%
Lift, pressure wash and relaunch

'Summer Pit Stop' SAVE 35%
Lift, pressure wash, up to 7 days ashore and relaunch

View Details

We are also offering a Coral Worm Wash, alift and launch with pressure wash including bow thrusters, props, drives and outlets

View Details

Swanwick Marina

Round the Island Race Special Offer
Lift, scrub, hold in slings and relaunch

Berth Holder Summer Boatyard Special Offers
Lift, scrub, hold in slings and relaunch
Lift, scrub, up to 7 days ashore and relaunch

Southsea Marina

'Summer Scrub and Splash' SAVE 40%
Lift, pressure wash and relaunch

'Summer Pit Stop' SAVE 35%
Lift, pressure wash, up to 7 days ashore and relaunch

View Details

Falmouth Marina

'Summer Scrub and Splash' SAVE 40%
Lift, pressure wash and relaunch

'Summer Pit Stop' SAVE 35%
Lift, pressure wash, up to 7 days ashore and relaunch

View Details

80 queries took 141 ms
Nr	Query	Affected	Num. rows	Took (ms)
1	DESCRIBE `pages`	24	24	3
2	DESCRIBE `images`	12	12	2
3	DESCRIBE `categories`	9	9	2
4	DESCRIBE `administrators`	11	11	2
5	DESCRIBE `administrator_groups`	10	10	2
6	DESCRIBE `administrator_permissions`	7	7	2
7	DESCRIBE `image_types`	7	7	4
8	DESCRIBE `image_type_versions`	11	11	2
9	DESCRIBE `layout_blocks`	4	4	2
10	DESCRIBE `layout_block_types`	8	8	2
11	DESCRIBE `containers`	4	4	2
12	DESCRIBE `modules`	5	5	1
13	DESCRIBE `module_types`	13	13	1
14	DESCRIBE `layout_block_type_containers`	9	9	2
15	DESCRIBE `sidebar_modules`	10	10	2
16	DESCRIBE `wp_users`	10	10	1
17	DESCRIBE `account_profiles`	46	46	3
18	DESCRIBE `marinas`	15	15	2
19	DESCRIBE `wp_terms`	4	4	1
20	DESCRIBE `wp_term_taxonomy`	6	6	2
21	DESCRIBE `wp_posts`	24	24	2
22	DESCRIBE `news_events`	17	17	1
23	DESCRIBE `downloads`	11	11	1
24	DESCRIBE `special_offers`	16	16	1
25	DESCRIBE `berthing_charges`	11	11	1
26	DESCRIBE `account_types`	3	3	1
27	DESCRIBE `account_members`	6	6	1
28	SELECT `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	7	7	2
29	SELECT `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` = 'boatyard_offers_for_berth_holders') AND ( `Page`.`status` != 'Deleted') LIMIT 1	1	1	5
30	DESCRIBE `redirects`	8	8	2
31	SELECT `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/boatyard_offers_for_berth_holders') AND (`Redirect`.`status` = 'Enabled') LIMIT 1	0	0	2
32	SELECT `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` = '907') LIMIT 1	1	1	1
33	SELECT `LayoutBlock`.`id`, `LayoutBlock`.`page_id`, `LayoutBlock`.`order`, `LayoutBlock`.`layout_block_type_id` FROM `layout_blocks` AS `LayoutBlock` WHERE `LayoutBlock`.`page_id` = '907' ORDER BY `LayoutBlock`.`order` ASC	6	6	2
34	SELECT `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` = '2'	1	1	1
35	SELECT `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'	1	1	1
36	SELECT `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` = '3'	1	1	1
37	SELECT `Container`.`id`, `Container`.`layout_block_id`, `Container`.`order`, `Container`.`class` FROM `containers` AS `Container` WHERE `Container`.`layout_block_id` = '2022' ORDER BY `Container`.`order` ASC	2	2	2
38	SELECT `Module`.`id`, `Module`.`container_id`, `Module`.`order`, `Module`.`module_type_id`, `Module`.`subid` FROM `modules` AS `Module` WHERE `Module`.`container_id` = '3239' ORDER BY `Module`.`order` ASC	1	1	2
39	SELECT `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'	1	1	1
40	SELECT `Module`.`id`, `Module`.`container_id`, `Module`.`order`, `Module`.`module_type_id`, `Module`.`subid` FROM `modules` AS `Module` WHERE `Module`.`container_id` = '3240' ORDER BY `Module`.`order` ASC	2	2	1
41	SELECT `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` = '2'	1	1	1
42	SELECT `Container`.`id`, `Container`.`layout_block_id`, `Container`.`order`, `Container`.`class` FROM `containers` AS `Container` WHERE `Container`.`layout_block_id` = '2212' ORDER BY `Container`.`order` ASC	1	1	1
43	SELECT `Module`.`id`, `Module`.`container_id`, `Module`.`order`, `Module`.`module_type_id`, `Module`.`subid` FROM `modules` AS `Module` WHERE `Module`.`container_id` = '3499' ORDER BY `Module`.`order` ASC	1	1	1
44	SELECT `Container`.`id`, `Container`.`layout_block_id`, `Container`.`order`, `Container`.`class` FROM `containers` AS `Container` WHERE `Container`.`layout_block_id` = '2209' ORDER BY `Container`.`order` ASC	2	2	1
45	SELECT `Module`.`id`, `Module`.`container_id`, `Module`.`order`, `Module`.`module_type_id`, `Module`.`subid` FROM `modules` AS `Module` WHERE `Module`.`container_id` = '3493' ORDER BY `Module`.`order` ASC	1	1	1
46	SELECT `Module`.`id`, `Module`.`container_id`, `Module`.`order`, `Module`.`module_type_id`, `Module`.`subid` FROM `modules` AS `Module` WHERE `Module`.`container_id` = '3494' ORDER BY `Module`.`order` ASC	1	1	2
47	SELECT `Container`.`id`, `Container`.`layout_block_id`, `Container`.`order`, `Container`.`class` FROM `containers` AS `Container` WHERE `Container`.`layout_block_id` = '2210' ORDER BY `Container`.`order` ASC	2	2	2
48	SELECT `Module`.`id`, `Module`.`container_id`, `Module`.`order`, `Module`.`module_type_id`, `Module`.`subid` FROM `modules` AS `Module` WHERE `Module`.`container_id` = '3495' ORDER BY `Module`.`order` ASC	1	1	1
49	SELECT `Module`.`id`, `Module`.`container_id`, `Module`.`order`, `Module`.`module_type_id`, `Module`.`subid` FROM `modules` AS `Module` WHERE `Module`.`container_id` = '3496' ORDER BY `Module`.`order` ASC	1	1	1
50	SELECT `Container`.`id`, `Container`.`layout_block_id`, `Container`.`order`, `Container`.`class` FROM `containers` AS `Container` WHERE `Container`.`layout_block_id` = '2211' ORDER BY `Container`.`order` ASC	2	2	2
51	SELECT `Module`.`id`, `Module`.`container_id`, `Module`.`order`, `Module`.`module_type_id`, `Module`.`subid` FROM `modules` AS `Module` WHERE `Module`.`container_id` = '3497' ORDER BY `Module`.`order` ASC	1	1	1
52	SELECT `Module`.`id`, `Module`.`container_id`, `Module`.`order`, `Module`.`module_type_id`, `Module`.`subid` FROM `modules` AS `Module` WHERE `Module`.`container_id` = '3498' ORDER BY `Module`.`order` ASC	1	1	1
53	SELECT `Container`.`id`, `Container`.`layout_block_id`, `Container`.`order`, `Container`.`class` FROM `containers` AS `Container` WHERE `Container`.`layout_block_id` = '2208' ORDER BY `Container`.`order` ASC	2	2	2
54	SELECT `Module`.`id`, `Module`.`container_id`, `Module`.`order`, `Module`.`module_type_id`, `Module`.`subid` FROM `modules` AS `Module` WHERE `Module`.`container_id` = '3491' ORDER BY `Module`.`order` ASC	1	1	2
55	SELECT `Module`.`id`, `Module`.`container_id`, `Module`.`order`, `Module`.`module_type_id`, `Module`.`subid` FROM `modules` AS `Module` WHERE `Module`.`container_id` = '3492' ORDER BY `Module`.`order` ASC	1	1	1
56	DESCRIBE `text_modules`	5	5	3
57	SELECT `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` = '2031' LIMIT 1	1	1	2
58	DESCRIBE `image_modules`	3	3	2
59	SELECT `ImageModule`.`id`, `ImageModule`.`image_id`, `ImageModule`.`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 `image_modules` AS `ImageModule` LEFT JOIN `images` AS `Image` ON `ImageModule`.`image_id` = `Image`.`id` WHERE `ImageModule`.`id` = '1043' LIMIT 1	1	1	2
60	SELECT `ImageModule`.`id`, `ImageModule`.`image_id`, `ImageModule`.`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 `image_modules` AS `ImageModule` LEFT JOIN `images` AS `Image` ON `ImageModule`.`image_id` = `Image`.`id` WHERE `ImageModule`.`id` = '1107' LIMIT 1	1	1	2
61	SELECT `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` = '2235' LIMIT 1	1	1	1
62	SELECT `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` = '2227' LIMIT 1	1	1	2
63	SELECT `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` = '2232' LIMIT 1	1	1	2
64	SELECT `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` = '2228' LIMIT 1	1	1	1
65	SELECT `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` = '2233' LIMIT 1	1	1	2
66	SELECT `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` = '2229' LIMIT 1	1	1	1
67	SELECT `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` = '2234' LIMIT 1	1	1	2
68	SELECT `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` = '2230' LIMIT 1	1	1	2
69	SELECT `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` = '2231' LIMIT 1	1	1	2
70	SELECT `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` = '907') AND ( `Page`.`status` != 'Deleted') LIMIT 1	1	1	5
71	SELECT `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` = '907' ORDER BY `Child`.`order` ASC	0	0	4
72	SELECT `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` = '907' ORDER BY `SidebarModule`.`order` ASC	0	0	1
73	SELECT * FROM image_type_versions	18	18	1
74	SELECT `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` = '907') LIMIT 1	1	1	1
75	SELECT `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` = '907') LIMIT 1	1	1	1
76	SELECT `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` = '907' ORDER BY `Child`.`order` ASC	0	0	5
77	SELECT `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` = '7') LIMIT 1	1	1	2
78	SELECT `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` = '7' ORDER BY `Child`.`order` ASC	4	4	2
79	SELECT `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` = '907' ORDER BY `SidebarModule`.`order` ASC	0	0	1
80	SELECT `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` = '7') LIMIT 1	1	1	1

80 queries took 141 ms

Query

Error

Affected

Num. rows

Took (ms)

DESCRIBE `pages`

DESCRIBE `images`

DESCRIBE `categories`

DESCRIBE `administrators`

DESCRIBE `administrator_groups`

DESCRIBE `administrator_permissions`

DESCRIBE `image_types`

DESCRIBE `image_type_versions`

DESCRIBE `layout_blocks`

DESCRIBE `layout_block_types`

DESCRIBE `containers`

DESCRIBE `modules`

DESCRIBE `module_types`

DESCRIBE `layout_block_type_containers`

DESCRIBE `sidebar_modules`

DESCRIBE `wp_users`

DESCRIBE `account_profiles`

DESCRIBE `marinas`

DESCRIBE `wp_terms`

DESCRIBE `wp_term_taxonomy`

DESCRIBE `wp_posts`

DESCRIBE `news_events`

DESCRIBE `downloads`

DESCRIBE `special_offers`

DESCRIBE `berthing_charges`

DESCRIBE `account_types`

DESCRIBE `account_members`

DESCRIBE `redirects`

SELECT `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/boatyard_offers_for_berth_holders') AND (`Redirect`.`status` = 'Enabled') LIMIT 1

SELECT `LayoutBlock`.`id`, `LayoutBlock`.`page_id`, `LayoutBlock`.`order`, `LayoutBlock`.`layout_block_type_id` FROM `layout_blocks` AS `LayoutBlock` WHERE `LayoutBlock`.`page_id` = '907' ORDER BY `LayoutBlock`.`order` ASC

SELECT `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` = '2'

SELECT `Container`.`id`, `Container`.`layout_block_id`, `Container`.`order`, `Container`.`class` FROM `containers` AS `Container` WHERE `Container`.`layout_block_id` = '2022' ORDER BY `Container`.`order` ASC

SELECT `Module`.`id`, `Module`.`container_id`, `Module`.`order`, `Module`.`module_type_id`, `Module`.`subid` FROM `modules` AS `Module` WHERE `Module`.`container_id` = '3239' ORDER BY `Module`.`order` ASC

SELECT `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'

DESCRIBE `text_modules`

SELECT `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` = '2031' LIMIT 1

DESCRIBE `image_modules`

SELECT `ImageModule`.`id`, `ImageModule`.`image_id`, `ImageModule`.`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 `image_modules` AS `ImageModule` LEFT JOIN `images` AS `Image` ON `ImageModule`.`image_id` = `Image`.`id` WHERE `ImageModule`.`id` = '1043' LIMIT 1

SELECT `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` = '907') AND ( `Page`.`status` != 'Deleted') LIMIT 1

SELECT `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` = '907' ORDER BY `Child`.`order` ASC

SELECT `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` = '907' ORDER BY `SidebarModule`.`order` ASC

SELECT * FROM image_type_versions

SELECT `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` = '907') LIMIT 1

SELECT `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` = '907' ORDER BY `Child`.`order` ASC

SELECT `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` = '7' ORDER BY `Child`.`order` ASC

SELECT `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` = '907' ORDER BY `SidebarModule`.`order` ASC