SHOW CATEGORIES

Specials

• Sweet Protection Offers
  NEW LINES ADDED!

We process all payments securely though SagePay
Accepting Visa, Visa Debit, Visa Electron, Mastercard & Maestro

SELECT TOP 18 store_products.id, store_products.prodName, CASE WHEN store_products.productYear IS NOT NULL THEN ' - '+store_products.productYear ELSE '' END AS productYear, store_products.prodDesc, store_staticPrices.lowestCurrPrice, store_staticPrices.highestOfferPrice, store_staticPrices.savingperc, store_staticPrices.highestPrice, NULL AS currB2BPriceNEW, NULL AS currB2BPrice_Grouped, NULL AS B2BOfferPrice, NULL AS lowestCurrB2BPrice, 'False' AS isB2BBrand, 'False' AS isTeamDiscountBrand, (select sum(SP03b.price) from store_productOptions AS SP03b where SP03b.id in (SELECT MIN(SP02b.id) AS Expr1 FROM store_productOptions AS SP02b WHERE (SP02b.price = (SELECT MIN(price) AS Expr1 FROM store_productOptions as SPO7 WHERE (SPO7.productID = SP03b.productID) AND ( ISNULL(SP02b.selectionSetGroupCode,0) = ISNULL(SPO7.selectionSetGroupCode,0) ) ) ) AND (SP02b.productID = SP03b.productID) GROUP BY selectionSetGroupCode) and SP03b.productID = store_products.id)*1 AS retailPrice_Grouped, store_products.promoPrice, store_products.promoStart, store_products.displayProductYear, store_products.promoEnd, store_products.shippingLevel, (select top 1 productImage from store_productOptions where productID = store_products.id AND (store_productOptions.active = 'True' )) AS prodImage, CASE WHEN (select top 1 id from store_productOptions AS STO where STO.productid = store_products.id AND STO.active = 'True' AND STO.active = 'True' AND ( (STO.STOCKLEVEL > 0 OR (STO.stockReplenishmentType < 10 AND (store_products.showEvenIfNoStock = 'True' OR STO.customer_backorderable ='True' OR (STO.b2b_backorderable ='True' AND '' = 'True')) )) ) ORDER BY STOCKLEVEL DESC, active DESC) IS NULL THEN CAST('False' as BIT) ELSE CAST('True' as BIT) END AS hasStock_canDisplay, store_products.category, store_products.active, store_products.extraFilterLabels, CASE WHEN store_products.homepageBumpText IS NOT NULL THEN store_products.modifiedDate ELSE store_products.createdDate END AS createdDate, store_products.homepageBumpText, store_products.modifiedDate, store_products.B2B_Only, store_products.showToTeamDiscounts, store_products.B2B_OrderType , store_products.UKOnly, store_products.VATRate, store_categories.id as thisCatID, NULL AS parentCatName, store_categories.CatName, CASE WHEN store_categoriesParent.CatName IS NULL THEN store_categories.catName ELSE store_categoriesParent.CatName END AS thisCatName, NULL AS parentCatName, brands_16.brandName AS brand, brands_16.thisBrandCSS, ISNULL((SELECT COUNT(DISTINCT DPC.price) AS Expr1 FROM store_productOptions AS DPC WHERE (DPC.productID = store_products.id)),1) AS differentPricingCount , NULL as MODELNAME FROM store_products LEFT JOIN store_categories on store_products.category = store_categories.id LEFT JOIN store_categories AS store_categoriesParent on store_categoriesParent.id = store_categories.parentCat LEFT JOIN brands_16 ON brands_16.id = store_products.brand LEFT JOIN store_staticPrices ON store_staticPrices.prodID = store_products.id WHERE (store_products.active = '1' ) AND ((store_products.B2B_Only < '3') ) AND (store_categories.id = '0' OR store_categories.parentCat = '0') AND store_categories.active = '1' AND (select top 1 id from store_productOptions AS STO where STO.productid = store_products.id AND STO.active = 'True' AND STO.active = 'True' AND ( (STO.STOCKLEVEL > 0 OR (STO.stockReplenishmentType < 10 AND (store_products.showEvenIfNoStock = 'True' OR STO.customer_backorderable ='True' OR (STO.b2b_backorderable ='True' AND '' = 'True')) )) ) ORDER BY STOCKLEVEL DESC, active DESC) IS NOT NULL AND (SELECT TOP (1) CASE WHEN offerPrice IS NOT NULL THEN offerPrice/packQTY ELSE price/packQTY END AS currPrice FROM store_productOptions WHERE (productID = store_products.id AND (store_productOptions.active = 'True' )) ORDER BY currPrice) IS NOT NULL AND store_products.id NOT IN (SELECT TOP 0 store_products.id FROM store_products LEFT JOIN store_categories on store_products.category = store_categories.id LEFT JOIN brands_16 ON brands_16.id = store_products.brand WHERE (store_products.active = '1' ) AND ((store_products.B2B_Only < '3') ) AND (store_categories.id = '0' OR store_categories.parentCat = '0') AND store_categories.active = '1' AND (select top 1 id from store_productOptions AS STO where STO.productid = store_products.id AND STO.active = 'True' AND STO.active = 'True' AND ( (STO.STOCKLEVEL > 0 OR (STO.stockReplenishmentType < 10 AND (store_products.showEvenIfNoStock = 'True' OR STO.customer_backorderable ='True' OR (STO.b2b_backorderable ='True' AND '' = 'True')) )) ) ORDER BY STOCKLEVEL DESC, active DESC) IS NOT NULL AND (SELECT TOP (1) CASE WHEN offerPrice IS NOT NULL THEN offerPrice/packQTY ELSE price/packQTY END AS currPrice FROM store_productOptions WHERE (productID = store_products.id AND (store_productOptions.active = 'True' )) ORDER BY currPrice) IS NOT NULL ORDER BY createdDate DESC, store_products.prodName) ORDER BY createdDate DESC, store_products.prodName

Sorry - No Items Currently Available