logoname22.png


























logoname22.png?12345
Products
Footwear

Brands
Adidas
Chanel (CC)
Chloe
Dior
Fila
Gucci (GG)
Hermes
Jimmy choo
Louis Vuitton (LV)
Manolo Blahnik
Michael Kors (MK)
Nike
Prada
Puma
Saint Laurent (YSL)
Salvatore Ferragamo
Ted Baker
Tom Ford
Tory Burch
Unbranded
Valentino
Versace
Zara

Price
100 9000

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='FPK641941E56B8371.64397589' where a.ItemActive=1 and (BrandName like '%%Footwear%' OR PageTags like '%%Footwear%') Order By SrNo desc LIMIT 0, 250;

Footwear

Best Price Tory Espadrilles
Best Price Chloe Espadrilles
Best Price Gucci Espadrilles
Best Price Versace Heels
Best Price Gucci Slippers
Best Price Chanel Slippers
Best Price Valentino Shoes
Best Price Versace
Rs: 4800
Versace
Best Price Gucci Mules
Rs: 3200
Gucci Mules
Best Price Tory
Rs: 3000
Tory
Best Price Jimmy Choo
Rs: 3500
Jimmy Choo
Best Price Fur Slides
Now Rs: 1600
Rs : 2200 Fur Slides
Best Price Louis Vuitton
Best Price Tory Slippers
Best Price LV Ladies Slippers
Best Price Tory Burch Flats
Best Price Gucci Wedges
Best Price VLTN slippers
Best Price Zara Slippers
Best Price Chloe Slippers
Best Price Prada Slippers
Best Price Tory flats
Rs: 2200
Tory flats
Best Price Mach n Mach Heels
Best Price Manolo Slippers
Best Price Puma Slippers
Best Price Adidas Slippers
Best Price Bunny Ear Slides
Best Price Rabbit Slides
Best Price YSL Chain Slippers
Best Price S15 Highshoes
Best Price Zara Flat Slippers
Best Price Valentino Slippers
Best Price Silver Heels
Best Price Zara Flats
Rs: 2600
Zara Flats
Best Price Clear Heels
Rs: 2800
Clear Heels
Best Price Dior Slippers
Best Price Valentino Slippers
Best Price Tory Fur Slippers
Now Rs: 1600
Rs : 1800 Tory Fur Slippers
Best Price Tory Slippers
Best Price Tie Heels
Rs: 3500
Tie Heels
Best Price Black Pearl Heels
Best Price Fila Disruptor 2
Best Price Gucci Bee Shoes
Best Price Hermes Slippers
Best Price Dior Slippers
Page : 1 of 1