SELECT Password,PasswordProtected,BulkDiscountPercentage, BulkDiscountQty, WholesaleProduct, DateAdded, SubPaymentInterval,AffiliateLink, MinQuantity, Deadline, DiscountPercentage, OfferAllowed, StockQty, StockControl, Sizes,Colours,Products.CatID,Products.SubCatID,SubSubCatID,Photo1,Photo2,Photo3,Photo4,ProductDescription,Products.ProductID,ProductName,Price,Thumbnail,SupportingFile,ShippingCost FROM (Products LEFT OUTER JOIN Discounts ON Products.ProductID = Discounts.ProductID) LEFT JOIN SubCategories ON Products.SubCatID = SubCategories.SubCatID WHERE ShowProduct='True' AND Products.CatID=2 AND Products.SubCatID=2 ORDER BY SubCatOrder DESC, ListPriority DESC LIMIT 0,16;

Classic Alpargatas  >> Plain

Sub-categories: Plain | Split Colour | Spotted | Striped |

Alpargatas - turquoise

£12.00

Alpargatas - dark blue

£12.00
Classic Alpargatas  >> Plain

Alpargatas - black

£12.00

Alpargatas - maroon

£12.00
Classic Alpargatas  >> Plain

Alpargatas - white

£12.00
Classic Alpargatas  >> Plain