SELECT Distinct d.`id`,d.`Name` as Category,d.`Parent_Id` as Parent FROM `dt_category-websites` a inner join `dt_category` d on d.id = 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.id,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 a.id=b.Category_Id 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 )

Non-clothing items from FireBrand Fashion
Sharpest Fashions
Categories

    Non Clothing Items

    You can't wear everything? Some things you gotta hang on the wall, stand around your house or ride on.

    Art, skateboards, Toys, Figures, you'll find them in this section

     

    Designed & Built by: Web Juice: Web Development