Onsite and Local Services

Search

Results: 1-6 of 6

A B C D E F G H I J K L M N O P Q R S T U V W X Y Z [All Results]

R.N.L.I. On site at Premier Marinas

Brighton Lifeboat Station,
Brighton Marina, East Sussex,
United Kingdom, BN25UF

01273 699966

 

ResQMax On site at Premier Marinas

14 The Slipway, Port Solent, Portsmouth, Hampshire, PO64TR

02392 379342


Richard Hocking Associates Ltd On site at Premier Marinas

Unit 10, Falmouth Marina,
North Parade, Falmouth,
Cornwall, TR11 2TD

01326 212220

www.rhasurveyors.co.uk

Chartered Surveyors.

Roger Upham Marine Electronics Ltd On site at Premier Marinas

Unit 3, The Shipyard
Chichester Marina
Birdham, PO20 7EJ

01243 514511

07711 663426

www.rumeltd.co.uk

Sales, service and installation of marine electronics.

Rinker Boat Sales

26 The Waterfront,
Sovereign Harbour,
Eastbourne,
East Sussex,
BN23 6JH

01323 470444

New and Used Boat Sales.

Ross Boat Trips


07958 246414


Boat, Harbour, Sea & Pier Trips

17 queries took 45 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` = 'marina_and_boatyard_tenant_directory') AND ( `Page`.`status` != 'Deleted') LIMIT 1115
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/marina_and_boatyard_tenant_directory/filterStart:R') AND (`Redirect`.`status` = 'Enabled') LIMIT 1002
4DESCRIBE `tenants`19193
5DESCRIBE `tenant_categories`992
6SELECT COUNT(*) AS count FROM `tenants` AS `Tenant` LEFT JOIN `tenant_categories` AS `TenantCategory` ON `Tenant`.`tenant_category_id` = `TenantCategory`.`id` LEFT JOIN `administrators` AS `CreatedBy` ON `Tenant`.`created_by` = `CreatedBy`.`id` LEFT JOIN `administrators` AS `ModifiedBy` ON `Tenant`.`modified_by` = `ModifiedBy`.`id` WHERE (`Tenant`.`status` = 'Enabled') AND ((`company_name` LIKE 'R%')) AND (`Tenant`.`status` = 'Enabled') 113
7SELECT `Tenant`.`id`, `Tenant`.`company_name`, `Tenant`.`tenant_category_id`, `Tenant`.`on_site`, `Tenant`.`description`, `Tenant`.`telephone`, `Tenant`.`mobile`, `Tenant`.`email`, `Tenant`.`website`, `Tenant`.`address`, `Tenant`.`logo`, `Tenant`.`order`, `Tenant`.`listing_style`, `Tenant`.`priority`, `Tenant`.`status`, `Tenant`.`created`, `Tenant`.`created_by`, `Tenant`.`modified`, `Tenant`.`modified_by`, `TenantCategory`.`id`, `TenantCategory`.`name`, `TenantCategory`.`parent_id`, `TenantCategory`.`order`, `TenantCategory`.`status`, `TenantCategory`.`created`, `TenantCategory`.`created_by`, `TenantCategory`.`modified`, `TenantCategory`.`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 `tenants` AS `Tenant` LEFT JOIN `tenant_categories` AS `TenantCategory` ON `Tenant`.`tenant_category_id` = `TenantCategory`.`id` LEFT JOIN `administrators` AS `CreatedBy` ON `Tenant`.`created_by` = `CreatedBy`.`id` LEFT JOIN `administrators` AS `ModifiedBy` ON `Tenant`.`modified_by` = `ModifiedBy`.`id` WHERE (`Tenant`.`status` = 'Enabled') AND ((`company_name` LIKE 'R%')) AND (`Tenant`.`status` = 'Enabled') ORDER BY `Tenant`.`priority` DESC, `Tenant`.`company_name` ASC LIMIT 10664
8SELECT `TenantCategory`.`id`, `TenantCategory`.`name` FROM `tenant_categories` AS `TenantCategory` WHERE `TenantCategory`.`status` = 'Enabled' ORDER BY `name` ASC 13131
9SELECT `Marina`.`id`, `Marina`.`name` FROM `marinas` AS `Marina` WHERE id != 8 991
10SELECT `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` = '684') LIMIT 1111
11SELECT `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` = '684') LIMIT 1112
12SELECT `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` = '684' ORDER BY `Child`.`order` ASC006
13SELECT `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 1112
14SELECT `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` ASC445
15SELECT `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` = '684') LIMIT 1111
16SELECT `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` = '684' ORDER BY `SidebarModule`.`order` ASC002
17SELECT `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 1112