logoname22.png


























logoname22.png?12345
Products
Sunglasses

Brands
American Optical
Burberry
Carrera
Dior
Gucci (GG)
Louis Vuitton (LV)
Marc Jacob
Rayban
Unbranded

Price
100 3800

SQL SELECT item_categories.categoriesname as 'category', a.BrandName as 'BrandName',b.Quantity,a.*,Case WHEN (a.ImageQty) REGEXP '^[0-9]+$' THEN 'No' else 'Yes' end AS 'HasSize', LOCATE('/',a.ImageColor) as 'HasColor' FROM items_list a inner join item_categories on item_categories.SrNo = a.`ImageCategory` LEFT JOIN ShopingCart_new b ON a.ItemCode = b.ItemCode and b.SID='FPK6419433B8F6400.80139080' where a.ItemActive=1 and (BrandName like '%%Sunglasses%' OR PageTags like '%%Sunglasses%') Order By SrNo desc LIMIT 0, 250;

Sunglasses

Best Price Marc Jacobs Shades
Best Price Rayban Ferrari
Best Price LV Unisex Shades
Best Price Rayban Sunglasses
Best Price Rayban Aviators
Best Price Gucci Shades
Best Price LV Sunglasses
Best Price LV Shades
Rs: 2500
LV Shades
Best Price Rayban Aviator III
Best Price Rayban Aviator II
Best Price Rayban Octa II
Best Price Rayban Round Sunglasses
Best Price VLTN Unisex Sunglasses
Page : 1 of 1