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

Rs: 3000

Marc Jacobs Shades

Best Price Marc Jacobs Transparent Sunglasses

Rs: 3000

Marc Jacobs Transparent Sunglasses

Best Price LV Ladies Sunglasses

Rs: 2800

LV Ladies Sunglasses

Best Price Carrera Glasses Unisex

Rs: 3800

Carrera Glasses Unisex

Best Price Burberry Gents Glasses

Rs: 2600

Burberry Gents Glasses

Best Price Rayban Ferrari

Rs: 2500

Rayban Ferrari

Best Price Dita Shaded Sunglasses

Rs: 2500

Dita Shaded Sunglasses

Best Price LV Unisex Shades

Rs: 2600

LV Unisex Shades

Best Price American Optical Sunglasses

Rs: 2000

American Optical Sunglasses

Best Price Rayban Sunglasses

Rs: 2000

Rayban Sunglasses

Best Price Rayban Aviators

Rs: 2000

Rayban Aviators

Best Price Gucci Shades

Rs: 2600

Gucci Shades

Best Price LV Shaded Sunglasses

Rs: 2500

LV Shaded Sunglasses

Best Price LV Sunglasses

Rs: 2600

LV Sunglasses

Best Price LV Shades

Rs: 2500

LV Shades

Best Price Rayban Oval Wayfarer

Rs: 2200

Rayban Oval Wayfarer

Best Price Rayban Aviator III

Rs: 2000

Rayban Aviator III

Best Price Rayban Aviator II

Rs: 2000

Rayban Aviator II

Best Price Rayban Octa II

Rs: 2000

Rayban Octa II

Best Price Rayban Gold Green Sunglasses with Box

Rs: 1850

Rayban Gold Green Sunglasses with Box

Best Price Rayban Black Sunglasses with box

Rs: 1850

Rayban Black Sunglasses with box

Best Price Rayban Gold Sunglasses with Box

Rs: 1850

Rayban Gold Sunglasses with Box

Best Price Rayban Sunglasses with Box

Rs: 1850

Rayban Sunglasses with Box

Best Price Rayban Sunglasses with Box

Rs: 1850

Rayban Sunglasses with Box

Best Price Rayban Black Sunglasses with box

Rs: 1850

Rayban Black Sunglasses with box

Best Price Rayban Sunglasses Black with Box

Rs: 1850

Rayban Sunglasses Black with Box

Best Price Rayban Sunglasses with box

Rs: 1850

Rayban Sunglasses with box

Best Price Rayban Sunglasses with box

Rs: 1850

Rayban Sunglasses with box

Best Price Rayban Sunglasses with Box

Rs: 1850

Rayban Sunglasses with Box

Best Price Rayban Round Sunglasses

Rs: 1800

Rayban Round Sunglasses

Rs: 1800

American Optical with Brand Box

Best Price Jannat Mirza Cateye Sunglasses

Rs: 1300

Jannat Mirza Cateye Sunglasses

Best Price Rayban Club Master Sunglasses

Rs: 1800

Rayban Club Master Sunglasses

Best Price Kabir Singh Sunglasses

Rs: 1300

Kabir Singh Sunglasses

Best Price VLTN Unisex Sunglasses

Rs: 1500

VLTN Unisex Sunglasses

Best Price Rayban (New Edition) Black

Rs: 1800

Rayban (New Edition) Black

Best Price Rayban Aviator with box (Silver Frame)

Rs: 2000

Rayban Aviator with box (Silver Frame)

Best Price Rayban Aviator with box (Golden Frame)

Rs: 2000

Rayban Aviator with box (Golden Frame)

Best Price Rayban Aviator with box

Rs: 2000

Rayban Aviator with box

Best Price Rayban Aviator with box (Blue)

Rs: 2000

Rayban Aviator with box (Blue)

Best Price Rayban Aviator Full Black

Rs: 2000

Rayban Aviator Full Black

Best Price Randolph Engineering Aviator

Rs: 2000

Randolph Engineering Aviator

Best Price Dior Love Punch

Out of Stock

Dior Love Punch

Best Price Rayban Octagonal Sunglasses

Rs: 2000

Rayban Octagonal Sunglasses

Best Price Randolph Engineering Aviator Silver

Rs: 2000

Randolph Engineering Aviator Silver

Page : 1 of 1

Previous
Next