logoname22.png
























logoname22.png?12345
Products
Footwear

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

Price
100 5000

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

shoes

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 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