Get a Quote

Weather and Tides

Premier Advantage Unique savings & benefits

Fuel at cost
42 free visitor nights - any marina, any length of stay
Cruising Credits
Easy marina transfers
Free storage ashore
15% off boatyard services

Refer a friend and save Refer a friend to Premier You could both save �500! Find out more

Premier Marinas - First-class South Coast Marinas

Outstanding value and a passion for service is what makes us Premier

Premier Marinas owns eight prestigious marinas on the south coast of the UK. Each marina offers quality berthing and facilities, boat storage ashore and a full service boatyard. Premier's marina locations include Eastbourne, Brighton, Chichester, Southsea, Port Solent, Gosport, Swanwick and Falmouth.

FROM �0.65 PER METRE/PER DAY
& GREAT BOATYARD SAVINGS

From £24 per metre/per month
Plus try a marina for free!

Get a quote

Latest News from Premier Marinas

Great Savings on Boatyard Services this summer

17th May 13

Boatyard Offers Now Live, Plus your Chance to Win your Round the Island Race Entry Fee

Premier Marinas is pleased to announce the publication of this year's summer boatyard offers. Savings up to 40% are available on selected boatyard services at all of our south coast marinas.

Inaugural British Motor Yacht Show Launches at Premier Marinas Swanwick!

3rd April 13

The three biggest names in UK motor yacht sales have teamed up with Premier Marinas to launch a new show in 2013.

A NEW CLIPPER MARINE ARRIVES IN PORT SOLENT MARINA!

25th March 13

A new Clipper Marine office has now opened in Port Solent Marina. This is Clipper Marine's seventh office bringing their comprehensive marine services to even more customers.

Premier Marinas continues to invest heavily in Brighton Marina

14th March 13
Premier Marinas has been improving the face of Brighton Marina by undergoing significant maintenance works.
Read more »

Chichester Marina completes a successful lock shutdown

14th March 13

Despite some bitterly cold weather, Chichester Marina is pleased to announce that the lock shutdown was completed on schedule with the lock re-opening at midday on Friday 15^th February.

Swanwick Marina's facilities to undergo a total refurbishment!

14th March 13
Berth Holders at Swanwick Marina will be delighted to know that Swanwick's main facility block is to undergo a total refurbishment with work scheduled to start in the winter.
Read more »

Replacement cill walkway at Falmouth Marina

14th March 13
Falmouth Marina is pleased to report the replacement of the cill walkway, which, after 30 years of use and the constant strain of grounding at low water, was in need of attention.
Read more »

Premier Marinas:: Eastbourne; Brighton; Chichester; Port Solent; Southsea; Gosport; Swanwick; Falmouth

58 queries took 110 ms
Nr	Query	Affected	Num. rows	Took (ms)
1	DESCRIBE `pages`	24	24	4
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	1
8	DESCRIBE `image_type_versions`	11	11	2
9	DESCRIBE `layout_blocks`	4	4	1
10	DESCRIBE `layout_block_types`	8	8	1
11	DESCRIBE `containers`	4	4	2
12	DESCRIBE `modules`	5	5	1
13	DESCRIBE `module_types`	13	13	2
14	DESCRIBE `layout_block_type_containers`	9	9	1
15	DESCRIBE `sidebar_modules`	10	10	1
16	DESCRIBE `wp_users`	10	10	1
17	DESCRIBE `account_profiles`	46	46	2
18	DESCRIBE `marinas`	15	15	1
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	2
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	3
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` = 'home') AND ( `Page`.`status` != 'Deleted') LIMIT 1	1	1	1
30	DESCRIBE `redirects`	8	8	1
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` = '/') AND (`Redirect`.`status` = 'Enabled') LIMIT 1	0	0	1
32	SELECT `SpecialOffer`.`id`,`SpecialOffer`.`link_text`,`SpecialOffer`.`description` FROM `special_offers` AS `SpecialOffer` WHERE `SpecialOffer`.`category_id` <> 61 AND `SpecialOffer`.`display_on_homepage` = 1 AND `SpecialOffer`.`status` = 'Enabled' ORDER BY RAND() LIMIT 2	0	0	1
33	DESCRIBE `homepage_modules`	17	17	2
34	SELECT `HomepageModule`.`id`, `HomepageModule`.`heading`, `HomepageModule`.`description`, `HomepageModule`.`image_id`, `HomepageModule`.`link1_text`, `HomepageModule`.`link1_url`, `HomepageModule`.`link2_text`, `HomepageModule`.`link2_url`, `HomepageModule`.`link3_text`, `HomepageModule`.`link3_url`, `HomepageModule`.`order`, `HomepageModule`.`type`, `HomepageModule`.`status`, `HomepageModule`.`created`, `HomepageModule`.`created_by`, `HomepageModule`.`modified`, `HomepageModule`.`modified_by`, `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 `homepage_modules` AS `HomepageModule` LEFT JOIN `images` AS `Image` ON `HomepageModule`.`image_id` = `Image`.`id` WHERE (`HomepageModule`.`type` = 'Default') AND (`HomepageModule`.`status` = 'Enabled') ORDER BY `HomepageModule`.`order` ASC	1	1	2
35	SELECT `NewsEvent`.`id`, `NewsEvent`.`title`, `NewsEvent`.`abstract`, `NewsEvent`.`text`, `NewsEvent`.`type`, `NewsEvent`.`date`, `NewsEvent`.`end_date`, `NewsEvent`.`image_id`, `NewsEvent`.`download_id`, `NewsEvent`.`marina_id`, `NewsEvent`.`category_id`, `NewsEvent`.`display_on_homepage`, `NewsEvent`.`status`, `NewsEvent`.`created`, `NewsEvent`.`created_by`, `NewsEvent`.`modified`, `NewsEvent`.`modified_by`, `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 `news_events` AS `NewsEvent` LEFT JOIN `images` AS `Image` ON `NewsEvent`.`image_id` = `Image`.`id` WHERE `NewsEvent`.`status` = 'Enabled' AND `NewsEvent`.`display_on_homepage` = '1' AND (( `NewsEvent`.`type` = 'News item' AND `NewsEvent`.`date` <= '2013-05-18') OR ( `NewsEvent`.`type` = 'Event' AND `NewsEvent`.`date` >= '2013-05-18')) ORDER BY `NewsEvent`.`date` DESC	7	7	6
36	DESCRIBE `static_modules`	10	10	1
37	SELECT `StaticModule`.`id`, `StaticModule`.`name`, `StaticModule`.`description`, `StaticModule`.`element`, `StaticModule`.`class`, `StaticModule`.`status`, `StaticModule`.`created`, `StaticModule`.`created_by`, `StaticModule`.`modified`, `StaticModule`.`modified_by` FROM `static_modules` AS `StaticModule` WHERE `StaticModule`.`id` = '31' LIMIT 1	1	1	1
38	SELECT `StaticModule`.`id`, `StaticModule`.`name`, `StaticModule`.`description`, `StaticModule`.`element`, `StaticModule`.`class`, `StaticModule`.`status`, `StaticModule`.`created`, `StaticModule`.`created_by`, `StaticModule`.`modified`, `StaticModule`.`modified_by` FROM `static_modules` AS `StaticModule` WHERE `StaticModule`.`id` = '32' LIMIT 1	1	1	2
39	SELECT `StaticModule`.`id`, `StaticModule`.`name`, `StaticModule`.`description`, `StaticModule`.`element`, `StaticModule`.`class`, `StaticModule`.`status`, `StaticModule`.`created`, `StaticModule`.`created_by`, `StaticModule`.`modified`, `StaticModule`.`modified_by` FROM `static_modules` AS `StaticModule` WHERE `StaticModule`.`id` = '33' LIMIT 1	1	1	1
40	SELECT `StaticModule`.`id`, `StaticModule`.`name`, `StaticModule`.`description`, `StaticModule`.`element`, `StaticModule`.`class`, `StaticModule`.`status`, `StaticModule`.`created`, `StaticModule`.`created_by`, `StaticModule`.`modified`, `StaticModule`.`modified_by` FROM `static_modules` AS `StaticModule` WHERE `StaticModule`.`id` = '34' LIMIT 1	1	1	2
41	SELECT `StaticModule`.`id`, `StaticModule`.`name`, `StaticModule`.`description`, `StaticModule`.`element`, `StaticModule`.`class`, `StaticModule`.`status`, `StaticModule`.`created`, `StaticModule`.`created_by`, `StaticModule`.`modified`, `StaticModule`.`modified_by` FROM `static_modules` AS `StaticModule` WHERE `StaticModule`.`id` = '35' LIMIT 1	1	1	1
42	SELECT `StaticModule`.`id`, `StaticModule`.`name`, `StaticModule`.`description`, `StaticModule`.`element`, `StaticModule`.`class`, `StaticModule`.`status`, `StaticModule`.`created`, `StaticModule`.`created_by`, `StaticModule`.`modified`, `StaticModule`.`modified_by` FROM `static_modules` AS `StaticModule` WHERE `StaticModule`.`id` = '36' LIMIT 1	1	1	1
43	SELECT `StaticModule`.`id`, `StaticModule`.`name`, `StaticModule`.`description`, `StaticModule`.`element`, `StaticModule`.`class`, `StaticModule`.`status`, `StaticModule`.`created`, `StaticModule`.`created_by`, `StaticModule`.`modified`, `StaticModule`.`modified_by` FROM `static_modules` AS `StaticModule` WHERE `StaticModule`.`id` = '2' LIMIT 1	1	1	2
44	SELECT `StaticModule`.`id`, `StaticModule`.`name`, `StaticModule`.`description`, `StaticModule`.`element`, `StaticModule`.`class`, `StaticModule`.`status`, `StaticModule`.`created`, `StaticModule`.`created_by`, `StaticModule`.`modified`, `StaticModule`.`modified_by` FROM `static_modules` AS `StaticModule` WHERE `StaticModule`.`id` = '10' LIMIT 1	1	1	1
45	SELECT `StaticModule`.`id`, `StaticModule`.`name`, `StaticModule`.`description`, `StaticModule`.`element`, `StaticModule`.`class`, `StaticModule`.`status`, `StaticModule`.`created`, `StaticModule`.`created_by`, `StaticModule`.`modified`, `StaticModule`.`modified_by` FROM `static_modules` AS `StaticModule` WHERE `StaticModule`.`id` = '30' LIMIT 1	1	1	3
46	SELECT `StaticModule`.`id`, `StaticModule`.`name`, `StaticModule`.`description`, `StaticModule`.`element`, `StaticModule`.`class`, `StaticModule`.`status`, `StaticModule`.`created`, `StaticModule`.`created_by`, `StaticModule`.`modified`, `StaticModule`.`modified_by` FROM `static_modules` AS `StaticModule` WHERE `StaticModule`.`id` = '46' LIMIT 1	1	1	2
47	SELECT `StaticModule`.`id`, `StaticModule`.`name`, `StaticModule`.`description`, `StaticModule`.`element`, `StaticModule`.`class`, `StaticModule`.`status`, `StaticModule`.`created`, `StaticModule`.`created_by`, `StaticModule`.`modified`, `StaticModule`.`modified_by` FROM `static_modules` AS `StaticModule` WHERE `StaticModule`.`id` = '45' LIMIT 1	1	1	2
48	SELECT `StaticModule`.`id`, `StaticModule`.`name`, `StaticModule`.`description`, `StaticModule`.`element`, `StaticModule`.`class`, `StaticModule`.`status`, `StaticModule`.`created`, `StaticModule`.`created_by`, `StaticModule`.`modified`, `StaticModule`.`modified_by` FROM `static_modules` AS `StaticModule` WHERE `StaticModule`.`id` = '55' LIMIT 1	1	1	1
49	SELECT `StaticModule`.`id`, `StaticModule`.`name`, `StaticModule`.`description`, `StaticModule`.`element`, `StaticModule`.`class`, `StaticModule`.`status`, `StaticModule`.`created`, `StaticModule`.`created_by`, `StaticModule`.`modified`, `StaticModule`.`modified_by` FROM `static_modules` AS `StaticModule` WHERE `StaticModule`.`id` = '56' LIMIT 1	1	1	7
50	DESCRIBE `dynamic_modules`	10	10	2
51	SELECT `DynamicModule`.`id`, `DynamicModule`.`name`, `DynamicModule`.`description`, `DynamicModule`.`url`, `DynamicModule`.`class`, `DynamicModule`.`status`, `DynamicModule`.`created`, `DynamicModule`.`created_by`, `DynamicModule`.`modified`, `DynamicModule`.`modified_by` FROM `dynamic_modules` AS `DynamicModule` WHERE (`DynamicModule`.`id` = '1') LIMIT 1	1	1	1
52	SELECT `DynamicModule`.`id`, `DynamicModule`.`name`, `DynamicModule`.`description`, `DynamicModule`.`url`, `DynamicModule`.`class`, `DynamicModule`.`status`, `DynamicModule`.`created`, `DynamicModule`.`created_by`, `DynamicModule`.`modified`, `DynamicModule`.`modified_by` FROM `dynamic_modules` AS `DynamicModule` WHERE (`DynamicModule`.`id` = '199') LIMIT 1	1	1	2
53	DESCRIBE `boats`	28	28	4
54	DESCRIBE `boat_images`	4	4	2
55	DESCRIBE `boat_plan_images`	4	4	2
56	DESCRIBE `boat_downloads`	4	4	4
57	DESCRIBE `fuel_prices`	9	9	4
58	SELECT `FuelPrice`.`id`, `FuelPrice`.`name`, `FuelPrice`.`price`, `FuelPrice`.`marina_id`, `FuelPrice`.`status`, `FuelPrice`.`created`, `FuelPrice`.`created_by`, `FuelPrice`.`modified`, `FuelPrice`.`modified_by`, `Marina`.`id`, `Marina`.`name`, `Marina`.`alternative_marina_1`, `Marina`.`alternative_marina_2`, `Marina`.`telephone`, `Marina`.`email`, `Marina`.`wp_category_id`, `Marina`.`early_payment_multiplier`, `Marina`.`direct_debit_multiplier`, `Marina`.`offers_pump_out`, `Marina`.`status`, `Marina`.`created`, `Marina`.`created_by`, `Marina`.`modified`, `Marina`.`modified_by` FROM `fuel_prices` AS `FuelPrice` LEFT JOIN `marinas` AS `Marina` ON `FuelPrice`.`marina_id` = `Marina`.`id` WHERE (`FuelPrice`.`status` = 'Enabled')	2	2	3

58 queries took 110 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`

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

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

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

SELECT `SpecialOffer`.`id`,`SpecialOffer`.`link_text`,`SpecialOffer`.`description` FROM `special_offers` AS `SpecialOffer` WHERE `SpecialOffer`.`category_id` <> 61 AND `SpecialOffer`.`display_on_homepage` = 1 AND `SpecialOffer`.`status` = 'Enabled' ORDER BY RAND() LIMIT 2

DESCRIBE `homepage_modules`

SELECT `HomepageModule`.`id`, `HomepageModule`.`heading`, `HomepageModule`.`description`, `HomepageModule`.`image_id`, `HomepageModule`.`link1_text`, `HomepageModule`.`link1_url`, `HomepageModule`.`link2_text`, `HomepageModule`.`link2_url`, `HomepageModule`.`link3_text`, `HomepageModule`.`link3_url`, `HomepageModule`.`order`, `HomepageModule`.`type`, `HomepageModule`.`status`, `HomepageModule`.`created`, `HomepageModule`.`created_by`, `HomepageModule`.`modified`, `HomepageModule`.`modified_by`, `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 `homepage_modules` AS `HomepageModule` LEFT JOIN `images` AS `Image` ON `HomepageModule`.`image_id` = `Image`.`id` WHERE (`HomepageModule`.`type` = 'Default') AND (`HomepageModule`.`status` = 'Enabled') ORDER BY `HomepageModule`.`order` ASC

SELECT `NewsEvent`.`id`, `NewsEvent`.`title`, `NewsEvent`.`abstract`, `NewsEvent`.`text`, `NewsEvent`.`type`, `NewsEvent`.`date`, `NewsEvent`.`end_date`, `NewsEvent`.`image_id`, `NewsEvent`.`download_id`, `NewsEvent`.`marina_id`, `NewsEvent`.`category_id`, `NewsEvent`.`display_on_homepage`, `NewsEvent`.`status`, `NewsEvent`.`created`, `NewsEvent`.`created_by`, `NewsEvent`.`modified`, `NewsEvent`.`modified_by`, `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 `news_events` AS `NewsEvent` LEFT JOIN `images` AS `Image` ON `NewsEvent`.`image_id` = `Image`.`id` WHERE `NewsEvent`.`status` = 'Enabled' AND `NewsEvent`.`display_on_homepage` = '1' AND (( `NewsEvent`.`type` = 'News item' AND `NewsEvent`.`date` <= '2013-05-18') OR ( `NewsEvent`.`type` = 'Event' AND `NewsEvent`.`date` >= '2013-05-18')) ORDER BY `NewsEvent`.`date` DESC

DESCRIBE `static_modules`

SELECT `StaticModule`.`id`, `StaticModule`.`name`, `StaticModule`.`description`, `StaticModule`.`element`, `StaticModule`.`class`, `StaticModule`.`status`, `StaticModule`.`created`, `StaticModule`.`created_by`, `StaticModule`.`modified`, `StaticModule`.`modified_by` FROM `static_modules` AS `StaticModule` WHERE `StaticModule`.`id` = '31' LIMIT 1

DESCRIBE `dynamic_modules`

SELECT `DynamicModule`.`id`, `DynamicModule`.`name`, `DynamicModule`.`description`, `DynamicModule`.`url`, `DynamicModule`.`class`, `DynamicModule`.`status`, `DynamicModule`.`created`, `DynamicModule`.`created_by`, `DynamicModule`.`modified`, `DynamicModule`.`modified_by` FROM `dynamic_modules` AS `DynamicModule` WHERE (`DynamicModule`.`id` = '1') LIMIT 1

DESCRIBE `boats`

DESCRIBE `boat_images`

DESCRIBE `boat_plan_images`

DESCRIBE `boat_downloads`

DESCRIBE `fuel_prices`

SELECT `FuelPrice`.`id`, `FuelPrice`.`name`, `FuelPrice`.`price`, `FuelPrice`.`marina_id`, `FuelPrice`.`status`, `FuelPrice`.`created`, `FuelPrice`.`created_by`, `FuelPrice`.`modified`, `FuelPrice`.`modified_by`, `Marina`.`id`, `Marina`.`name`, `Marina`.`alternative_marina_1`, `Marina`.`alternative_marina_2`, `Marina`.`telephone`, `Marina`.`email`, `Marina`.`wp_category_id`, `Marina`.`early_payment_multiplier`, `Marina`.`direct_debit_multiplier`, `Marina`.`offers_pump_out`, `Marina`.`status`, `Marina`.`created`, `Marina`.`created_by`, `Marina`.`modified`, `Marina`.`modified_by` FROM `fuel_prices` AS `FuelPrice` LEFT JOIN `marinas` AS `Marina` ON `FuelPrice`.`marina_id` = `Marina`.`id` WHERE (`FuelPrice`.`status` = 'Enabled')