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

Rs: 9000

Tory Espadrilles

Best Price Chloe Espadrilles

Rs: 9000

Chloe Espadrilles

Best Price Christian Dior Open Espadrilles

Rs: 9000

Christian Dior Open Espadrilles

Best Price Christian Dior Pattern Espadrilles

Rs: 9000

Christian Dior Pattern Espadrilles

Best Price Valentino Pump Heels

Rs: 3500

Valentino Pump Heels

Best Price MK Monogram Flipflops

Rs: 3000

MK Monogram Flipflops

Best Price Tory Pattern Flipflop

Rs: 3000

Tory Pattern Flipflop

Best Price Tory Floral Flipflop

Rs: 3000

Tory Floral Flipflop

Best Price Gucci Espadrilles

Rs: 9000

Gucci Espadrilles

Best Price Ted Baker Cross Slippers

Rs: 2800

Ted Baker Cross Slippers

Best Price Versace Heels

Rs: 3500

Versace Heels

Best Price Zara Chain Slippers

Rs: 2500

Zara Chain Slippers

Best Price Gucci Slippers

Rs: 2800

Gucci Slippers

Best Price Chanel Slippers

Rs: 2800

Chanel Slippers

Best Price Valentino Shoes

Rs: 4800

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

Rs: 2400

Louis Vuitton

Best Price Tory Slippers

Rs: 2400

Tory Slippers

Best Price Zara Embellished Stone Slippers

Rs: 2500

Zara Embellished Stone Slippers

Best Price LV Ladies Slippers

Rs: 2500

LV Ladies Slippers

Best Price Christian Dior Pattern Slippers

Rs: 2500

Christian Dior Pattern Slippers

Best Price Pink Pink Panther Slides

Rs: 2200

Pink Pink Panther Slides

Best Price Pink Pink Black Panther Slides

Rs: 2200

Pink Pink Black Panther Slides

Best Price Pink Pink Blue Panther Slides

Rs: 2200

Pink Pink Blue Panther Slides

Best Price Valentino Pump Shoes

Rs: 2800

Valentino Pump Shoes

Best Price Tory Burch Flats

Rs: 2500

Tory Burch Flats

Best Price Manolo Buckle Heels

Rs: 3300

Manolo Buckle Heels

Best Price Gucci Wedges

Rs: 2600

Gucci Wedges

Best Price Ferragamo Block Heels

Rs: 3000

Ferragamo Block Heels

Best Price VLTN slippers

Rs: 2200

VLTN slippers

Best Price Hermes Colorful Slippers

Rs: 2700

Hermes Colorful Slippers

Best Price Supreme Unisex Highshoes

Rs: 4000

Supreme Unisex Highshoes

Best Price Christian Dior Flat Slippers

Rs: 2200

Christian Dior Flat Slippers

Best Price Zara Slippers

Rs: 2600

Zara Slippers

Best Price Christian Dior Flats

Rs: 2600

Christian Dior Flats

Best Price Chloe Slippers

Rs: 3000

Chloe Slippers

Best Price Prada Slippers

Rs: 2600

Prada Slippers

Best Price Tory flats

Rs: 2200

Tory flats

Best Price Gucci Stones Slippers

Rs: 2500

Gucci Stones Slippers

Best Price Zara Stones Slippers

Rs: 2800

Zara Stones Slippers

Best Price Mach Mach Glitter Heels

Rs: 4500

Mach Mach Glitter Heels

Best Price Mach Mach Flower Heels

Rs: 3800

Mach Mach Flower Heels

Best Price LV White Gray Joggers

Rs: 4800

LV White Gray Joggers

Best Price LV Black Gold Joggers

Rs: 4800

LV Black Gold Joggers

Best Price LV Red Black Joggers

Rs: 4800

LV Red Black Joggers

Best Price ONON Black Highshoes

Rs: 4600

ONON Black Highshoes

Best Price ONON Maroon Highshoes

Rs: 4600

ONON Maroon Highshoes

Best Price ONON Gray Highshoes

Rs: 4600

ONON Gray Highshoes

Best Price Hermes Oran Slippers

Rs: 2200

Hermes Oran Slippers

Best Price Mach n Mach Heels

Rs: 4200

Mach n Mach Heels

Best Price Manolo Rhinestones Slippers

Rs: 2500

Manolo Rhinestones Slippers

Best Price Tom Ford Flat Slippers

Out of Stock

Tom Ford Flat Slippers

Best Price Manolo Slippers

Rs: 2300

Manolo Slippers

Best Price LV Flipflop Slippers

Rs: 2500

LV Flipflop Slippers

Best Price Tory Burch Slippers

Rs: 2500

Tory Burch Slippers

Best Price Chanel Pearl Slippers

Rs: 2500

Chanel Pearl Slippers

Best Price Puma Slippers

Rs: 2300

Puma Slippers

Best Price Adidas Slippers

Rs: 2300

Adidas Slippers

Best Price Hermes crocodile slippers

Rs: 2200

Hermes crocodile slippers

Best Price Bunny Ear Slides

Rs: 1600

Bunny Ear Slides

Best Price Rabbit Slides

Rs: 1600

Rabbit Slides

Best Price What the Duck Slides

Rs: 1600

What the Duck Slides

Best Price Tory Burch Slippers

Rs: 2300

Tory Burch Slippers

Best Price YSL Chain Slippers

Rs: 2300

YSL Chain Slippers

Best Price S15 Highshoes

Rs: 3500

S15 Highshoes

Best Price Green Wave Highshoes

Rs: 4000

Green Wave Highshoes

Best Price Ted Baker Bowtie Flat Slippers

Rs: 2200

Ted Baker Bowtie Flat Slippers

Best Price Zara Flat Slippers

Rs: 2300

Zara Flat Slippers

Best Price Jimmy Choo Transparent Heels

Rs: 3000

Jimmy Choo Transparent Heels

Best Price Valentino Slippers

Rs: 2500

Valentino Slippers

Best Price Tory Two Tone Flat Slippers

Rs: 2200

Tory Two Tone Flat Slippers

Best Price Silver Heels

Rs: 3600

Silver Heels

Best Price Zara Flats

Rs: 2600

Zara Flats

Best Price Gucci Flat Slippers

Rs: 2400

Gucci Flat Slippers

Best Price Clear Heels

Rs: 2800

Clear Heels

Best Price Dior Slippers

Rs: 2000

Dior Slippers

Best Price Manolo Transparent Heels

Rs: 3000

Manolo Transparent Heels

Best Price Manolo Flat Slippers

Rs: 2700

Manolo Flat Slippers

Best Price Valentino Slippers

Rs: 2200

Valentino Slippers

Best Price Chanel Floral Slippers

Rs: 2700

Chanel Floral Slippers

Best Price Tory Fur Slippers

Now Rs: 1600

Rs : 1800 Tory Fur Slippers

Best Price Tory Slippers

Rs: 2200

Tory Slippers

Best Price Tie Heels

Rs: 3500

Tie Heels

Best Price Black Pearl Heels

Rs: 4000

Black Pearl Heels

Best Price High Quality Trainer Shoes

Rs: 4000

High Quality Trainer Shoes

Best Price Hermes oran slippers

Rs: 2200

Hermes oran slippers

Best Price Fila Disruptor 2

Rs: 4300

Fila Disruptor 2

Best Price Gucci Bee Shoes

Rs: 4500

Gucci Bee Shoes

Best Price Nike Airforce 1

Out of Stock

Nike Airforce 1

Best Price Hermes Slippers

Rs: 2200

Hermes Slippers

Best Price Dior JADior Kitten Heel Pump

Out of Stock

Dior JADior Kitten Heel Pump

Best Price Dior Slippers

Rs: 2700

Dior Slippers

Best Price Gucci Heart Sneakers

Rs: 3800

Gucci Heart Sneakers

Best Price Gucci Velvet Combo

Out of Stock

Gucci Velvet Combo

Best Price Gucci Snake Embroidered Shoes

Out of Stock

Gucci Snake Embroidered Shoes

Page : 1 of 1

Previous
Next