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 a.id,a.Web_Site_Price,a.Supplier,a.Brand_Name,a.Supplier_Ref,a.Last_Update,a.Gender,a.Category,a.Title,a.Feed,a.Image_Path,a.`Image_Width`,a.`Image_Height`FROM dt_product a, dt_brands b WHERE a.Displayed='Yes' AND b.Displayed='Yes' AND a.Brand_Name=b.brand_name AND b.`garmsandswagga`='on' AND REPLACE(REPLACE(REPLACE(REPLACE(a.Brand_Name,' ',''),'-',''),'\'',''),',','') like 'fredperry' AND (a.Gender = 'both' or a.Gender = 'Unisex' or a.Gender ='Mens' or a.Gender ='Womens') ORDER BY a.Priority DESC,a.Title asc LIMIT 0,80)

(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 'fred perry' 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 )

(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,`dt_brands` d, `dt_product` e 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)AND (d.Brand_Name LIKE 'fred perry' or d.Brand_Name LIKE 'fred-perry') AND a.Name = e.Category AND d.displayed='Yes' AND e.Displayed = 'Yes' AND e.Brand_Name = d.Brand_Name ORDER BY a.Name ASC )

Fred Perry - The Latest Shoes From Firebrand | Garmsandswagga
Sharpest Fashions
Categories

Fred Perry

Designed & Built by: Web Juice: Web Development