SELECT DISTINCT p1.ID, p1.FDcatid, p1.FDsubID, p1.FDtitle, p1.FDprice, p1.FDbrand, p1.FDstockno, p1.FDstatus, p1.FDspecial, p1.FDdiscount, p1.FDdelivery, c1.FDcategory, c1.FDorder,b1.FDtitle as FDbrandname ,b1.ID as FDbrandID ,s1.FDname AS FDsubname, col1.FDcolour,col1.ID AS FDcolourID FROM TBLproducts p1 INNER JOIN TBLcategories c1 ON p1.FDcatid = c1.ID INNER JOIN TBLsubcategories s1 ON p1.FDsubid = s1.ID INNER JOIN TBLBrands b1 ON p1.FDbrand = b1.ID INNER JOIN TBLcolours col1 ON p1.ID = col1.FDproductID WHERE p1.ID >0 AND p1.FDstatus='True' AND p1.FDcatID='0' AND p1.FDsubID='Shortboard 0' ORDER BY FDprice ASC System.Data.SqlClient.SqlException (0x80131904): Conversion failed when converting the varchar value 'Shortboard 0' to data type int. at Microsoft.VisualBasic.CompilerServices.Symbols.Container.InvokeMethod(Method TargetProcedure, Object[] Arguments, Boolean[] CopyBack, BindingFlags Flags) at Microsoft.VisualBasic.CompilerServices.NewLateBinding.CallMethod(Container BaseReference, String MethodName, Object[] Arguments, String[] ArgumentNames, Type[] TypeArguments, Boolean[] CopyBack, BindingFlags InvocationFlags, Boolean ReportErrors, ResolutionFailure& Failure) at Microsoft.VisualBasic.CompilerServices.NewLateBinding.ObjectLateCall(Object Instance, Type Type, String MemberName, Object[] Arguments, String[] ArgumentNames, Type[] TypeArguments, Boolean[] CopyBack, Boolean IgnoreReturn) at Microsoft.VisualBasic.CompilerServices.NewLateBinding.LateCall(Object Instance, Type Type, String MemberName, Object[] Arguments, String[] ArgumentNames, Type[] TypeArguments, Boolean[] CopyBack, Boolean IgnoreReturn) at online_shop_Default.Page_Load(Object sender, EventArgs e) in C:\Domains\surfguru.co.uk\wwwroot\online-shop\listing.aspx.vb:line 128 ClientConnectionId:51844d66-6052-44e6-8b13-0815ded573e3 Error Number:245,State:1,Class:16SELECT DISTINCT TBLcolours.FDcolour FROM TBLproducts INNER JOIN TBLcolours ON TBLproducts.ID = TBLcolours.FDproductID WHERE TBLcolours.ID>0 AND TBLproducts.FDsubID = 'Shortboard 0' SELECT DISTINCT TBLsizes.FDuk,TBLsizes.FDeuro FROM TBLproducts INNER JOIN TBLcolours ON TBLproducts.ID = TBLcolours.FDproductID Inner Join TBLsizes On TBLsizes.FDcolourID = TBLcolours.ID WHERE TBLcolours.ID>0 AND TBLproducts.FDsubID = 'Shortboard' SELECT DISTINCT TBLbrands.ID,TBLbrands.FDtitle FROM TBLproducts Inner Join TBLbrands On TBLbrands.ID = TBLproducts.FDbrand INNER JOIN TBLcolours ON TBLproducts.ID = TBLcolours.FDproductID WHERE TBLbrands.ID>0 AND TBLproducts.FDsubID = 'Shortboard' SELECT DISTINCT TBLsubcategories.ID,TBLsubcategories.FDname FROM TBLproducts Inner Join TBLsubcategories On TBLsubcategories.ID = TBLproducts.FDsubID INNER JOIN TBLcolours ON TBLproducts.ID = TBLcolours.FDproductID WHERE TBLsubcategories.ID>0 AND TBLproducts.FDsubID = 'Shortboard ' Untitled Page

Welcome to Surf Guru - Online Surf Shop

Member Login

Username:*
Password: *
Not Registered?

Lost your details?

If you have forgotten your password please enter your username below and we will email you the password :

Username: *  

Or if you have forgotten your username please enter your email address below and we will email you the username and password :

Email: *


Delivery Label
Total Inc Delivery Label

Checkout
Web Design in Scarborough

Order Results By :

Please select from the following options
Select Colour -

Select Size -

 

Search:

reset all filters

Newsletter Sign Up

Login to Surf Guru

  • Registering with surf guru allows you to contribute. Once logged in you will be able to add new surfing beaches, comment on existing listing, add classified ads and more.

    Username
     
    Password
     

    Not Registered? Register Here now!

Latest Activity

What's been going on on surf guru recently

Find A Beach

Use the form below to enter your search criteria.


Regions
CornwallDevon
South CoastNorth East
North ScotlandEast Scotland
WalesEast Anglia
West ScotlandHebrides
OrkneysChannel Islands

Find A Classified

A selection of our latest surf classifieds are shown below, or click here for are full surf classifed list


  • sumitihomelenposted a We offer Cash Price £9000 in Pompano Beach Highlands
  • Sammyjoposted a Dry robe Price £90.00 in Polzeath
  • Sammyjoposted a Ocean and Earth quad wheel short board fish coffin bag size 7feet Price £200.00 in Polzeath
  • Cherieposted a Torq Channel Islands x lite surfboard Price £475.00 in Chesterfield
  • cdriffyposted a Bic Dura-Tec 7"3 Mini Malibu surfboard (barely used) Price £180 in Wrexham
  • timloweposted a 6' 4" JP (John Purton) CM (Calvin Maine) Surfboard for sale USED ONCE in Very Good Condition Price £250.00 in Derby
  • happysurfer1posted a Magazines Price £50.00 in Blandford
  • JamesCposted a Custard Point 9ft Noserider Price £295.00 in Lewes
  • Johndsrptposted a M&M Minimal - Disrupt Price £385 in Newquay
  • Johndsrptposted a The Dory - Disrupt Price £300 in Newquay

    •

    Search Surf Guru

    WELCOME

    Lorem ipsum dolor sit amet, consectetur adipiscing elit. Suspendisse fermentum aliquet varius. Maecenas mattis rutrum condimentum. Pellentesque at nisi sed arcu accumsan malesuada. Vestibulum sapien arcu, tincidunt.