SELECT Distinct d.`id`,d.`Name` as Category,d.`Parent_Id` as Parent FROM `dt_category-websites` a inner join `dt_category` d on = a.Category_Id WHERE Website = 'garmsandswagga' and a.Displayed = 'Yes' AND d.Displayed = 'Yes'

(SELECT DISTINCT b.light_logo,b.dark_logo,b.light_logo_width,b.light_logo_height,b.dark_logo_width,b.dark_logo_height,a.Brand_Name , a.Brand_Name LIKE '' as selectedBrand FROM `dt_product` a,`dt_brands` b WHERE b.`garmsandswagga` = 'on' AND a.Brand_Name=b.brand_name AND a.`Displayed` = "Yes"AND b.Displayed = 'Yes' AND a.Category IN() ORDER BY a.Brand_Name)

(SELECT DISTINCT,a.depth,a.Parent_Id as Parent,a.Name as Category, REPLACE(REPLACE(a.Name,',',''),'-',' ') LIKE '' as Selected, REPLACE(LOWER(a.Name), '&', 'and') as CategoryURL,a.Weight,a.Womens_Product,a.Mens_Product, b.Mens_Total as mensTotal,b.Womens_Total as womensTotal,b.Unisex_Total as unisexTotal FROM `dt_category` a, `dt_category-websites` b WHERE a.Displayed='Yes' AND AND b.Displayed='Yes' AND b.Website='garmsandswagga' AND (b.Womens_Total!=0 or b.Mens_Total!=0 or b.Unisex_Total != 0) ORDER BY a.Name ASC )

About Garms and Swagga - Brands at the best prices
Sharpest Fashions

    All about Garms & Swagga

    Garms & Swagga are an international company specialized in quality world-famous brands of clothes, shoes and other related products that people wish to buy.

    We started Garms & Swagga with the aim of providing the best designer labels at the best price available. This is something that we have stuck to and we beleive you will not find the latest gear any cheaper than on our site.

    Buying quality brands

    We believe it should be easy to find quality famous and in-style and fashionable brands from all over the world. We ensure our suppliers provide a quality aftercare service should you ever need to return an item and that this will be dealt with promptly

    Designed & Built by: Web Juice: Web Development