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

Women-Jewelry

Best Price Hermes Clic H Bangle

Rs: 2500

Hermes Clic H Bangle

Best Price Tory Burch Gold Bangle

Rs: 1999

Tory Burch Gold Bangle

Best Price LV Charms Bangle

Rs: 1800

LV Charms Bangle

Best Price LV Silver Jewelry Set

Rs: 2000

LV Silver Jewelry Set

Best Price GG Silver Jewelry Set

Rs: 2000

GG Silver Jewelry Set

Best Price LV Black Gold Jewelry Set

Rs: 2000

LV Black Gold Jewelry Set

Best Price Gucci Round Jewelry Set

Rs: 2000

Gucci Round Jewelry Set

Best Price GG Black Gold Jewelry Set

Rs: 2000

GG Black Gold Jewelry Set

Best Price Rolex Jewelry Set

Rs: 2000

Rolex Jewelry Set

Best Price LV Buckle Bangle

Rs: 1800

LV Buckle Bangle

Best Price LV Trunk Style Bangle

Rs: 1800

LV Trunk Style Bangle

Best Price LV Charms Bangle

Rs: 1800

LV Charms Bangle

Best Price LV Stones Bangle

Rs: 1800

LV Stones Bangle

Best Price Chanel Bangle

Rs: 1800

Chanel Bangle

Best Price Gucci Chain Pendant with earrings

Rs: 2000

Gucci Chain Pendant with earrings

Best Price Bvlgari Chain Pendant with earrings

Rs: 2000

Bvlgari Chain Pendant with earrings

Best Price Rolex Chain Pendant with earrings

Rs: 2000

Rolex Chain Pendant with earrings

Best Price Tiffany & Co studs

Rs: 1400

Tiffany & Co studs

Best Price Cartier Nail Ring with Stones

Rs: 800

Cartier Nail Ring with Stones

Rs: 2300

Cartier Nail bangle stones with brand packaging

Best Price Versace Bangle

Out of Stock

Versace Bangle

Best Price CD Cuff Bangle

Out of Stock

CD Cuff Bangle

Best Price LV Charms Bracelet

Out of Stock

LV Charms Bracelet

Best Price VC Ring

Out of Stock

VC Ring

Best Price Van Cleef Pendant

Rs: 1600

Van Cleef Pendant

Best Price Rolex Bangle

Now Rs: 1300

Rs : 1500 Rolex Bangle

Best Price MK Beads Bracelet

Rs: 1700

MK Beads Bracelet

Best Price Gucci Bangle

Rs: 1600

Gucci Bangle

Best Price Cartier Love Ring with Complete Packaging

Rs: 1300

Cartier Love Ring with Complete Packaging

Best Price Cartier Nail Ring with Complete Packaging

Rs: 1300

Cartier Nail Ring with Complete Packaging

Best Price Cartier Zircon Bangle

Out of Stock

Cartier Zircon Bangle

Best Price Cartier Zircon Ring

Rs: 2000

Cartier Zircon Ring

Best Price LV Thick Bangle

Rs: 2000

LV Thick Bangle

Best Price MK Stones Thin Bangle

Rs: 1700

MK Stones Thin Bangle

Best Price LV Bangle

Rs: 1700

LV Bangle

Best Price LV Bangle

Rs: 1700

LV Bangle

Best Price LV Hanging Bangle

Rs: 1700

LV Hanging Bangle

Best Price Van Cleef Gold Bracelet

Rs: 2000

Van Cleef Gold Bracelet

Best Price Bvlgari Dial Bracelet

Rs: 1700

Bvlgari Dial Bracelet

Best Price Bvlgari Stones Bracelet

Rs: 1700

Bvlgari Stones Bracelet

Best Price Van Cleef Bracelet

Rs: 1800

Van Cleef Bracelet

Best Price Cartier Leather Nail Bracelet

Rs: 1600

Cartier Leather Nail Bracelet

Best Price Van Cleef Ear Studs

Rs: 1400

Van Cleef Ear Studs

Best Price Gucci Brooch

Rs: 1200

Gucci Brooch

Best Price Van Cleef Ear Studs

Rs: 1200

Van Cleef Ear Studs

Best Price Van Cleef Ring

Rs: 1000

Van Cleef Ring

Best Price Versace Bangle

Out of Stock

Versace Bangle

Best Price Chanel Bottle Earrings

Rs: 1400

Chanel Bottle Earrings

Best Price Jadior Pearl and Stones Earrings

Rs: 1400

Jadior Pearl and Stones Earrings

Best Price Gucci Stones Pendant Only

Rs: 1600

Gucci Stones Pendant Only

Best Price Gucci Earrings VI

Rs: 1400

Gucci Earrings VI

Best Price Gucci Earrings IV

Rs: 1400

Gucci Earrings IV

Best Price Gucci Earrings V

Rs: 1400

Gucci Earrings V

Best Price Gucci Snake Earrings I

Rs: 1400

Gucci Snake Earrings I

Best Price Gucci Pendant Earrings Set

Rs: 2999

Gucci Pendant Earrings Set

Best Price Pendant Studs Set VIII Premium Quality

Out of Stock

Pendant Studs Set VIII Premium Quality

Best Price Pendant Studs Set II

Out of Stock

Pendant Studs Set II

Best Price MK Lock with Stones Bangle

Rs: 1700

MK Lock with Stones Bangle

Best Price Hermes H Bracelet Each

Rs: 1700

Hermes H Bracelet Each

Best Price Hermes Narrow Clic Bracelet Each

Rs: 1700

Hermes Narrow Clic Bracelet Each

Best Price Gucci Dial Bracelet

Out of Stock

Gucci Dial Bracelet

Best Price Bvlgari Bracelet With Stones

Rs: 1700

Bvlgari Bracelet With Stones

Best Price Gucci Bangle Each

Rs: 1700

Gucci Bangle Each

Best Price Van Cleef Arpels earrings

Now Rs: 1200

Rs : 1400 Van Cleef Arpels earrings

Best Price Hermes Bracelet Each

Rs: 2200

Hermes Bracelet Each

Best Price Cartier Love Bracelet

Rs: 2000

Cartier Love Bracelet

Best Price Cartier Nail Bracelets

Rs: 1700

Cartier Nail Bracelets

Best Price Cartier Love Bracelet with screw Driver, Same as original

Rs: 2000

Cartier Love Bracelet with screw Driver, Same as original

Best Price Cartier Bracelet and Ring Rose Gold

Rs: 2600

Cartier Bracelet and Ring Rose Gold

Best Price Cartier Bracelet and Ring Silver

Rs: 2600

Cartier Bracelet and Ring Silver

Best Price Cartier Bracelet and Ring

Rs: 2600

Cartier Bracelet and Ring

Best Price Cartier Love Ring with stone

Rs: 800

Cartier Love Ring with stone

Best Price Cartier Nail Ring

Rs: 800

Cartier Nail Ring

Best Price Cartier Nail Bracelet with Stones

Rs: 1700

Cartier Nail Bracelet with Stones

Best Price Cartier Love Bangle with Stones

Rs: 2000

Cartier Love Bangle with Stones

Page : 1 of 1

Previous
Next