logoname22.png


























logoname22.png?12345
Products
Women-Jewelry

Brands
Bvlgari
Cartier
Chanel (CC)
Dior
Gucci (GG)
Hermes
Louis Vuitton (LV)
Michael Kors (MK)
Rolex
Tiffany
Tory Burch
Unbranded
Van Cleef
Versace

Price
100 3800

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 Tory Burch Gold Bangle
Best Price LV Charms Bangle
Best Price LV Silver Jewelry Set
Best Price GG Silver Jewelry Set
Best Price LV Black Gold Jewelry Set
Best Price Gucci Round Jewelry Set
Best Price GG Black Gold Jewelry Set
Best Price Rolex Jewelry Set
Best Price LV Buckle Bangle
Best Price LV Trunk Style Bangle
Best Price LV Charms Bangle
Best Price LV Stones Bangle
Best Price Chanel Bangle
Best Price Tiffany & Co studs
Best Price VC Ring
Out of Stock
VC Ring
Best Price Van Cleef Pendant
Best Price Rolex Bangle
Now Rs: 1300
Rs : 1500 Rolex Bangle
Best Price MK Beads Bracelet
Best Price Gucci Bangle
Best Price Cartier Zircon Ring
Best Price LV Thick Bangle
Best Price 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
Best Price Van Cleef Gold Bracelet
Best Price Bvlgari Dial Bracelet
Best Price Bvlgari Stones Bracelet
Best Price Van Cleef Bracelet
Best Price Van Cleef Ear Studs
Best Price Gucci Brooch
Best Price Van Cleef Ring
Best Price Chanel Bottle Earrings
Best Price Gucci Stones Pendant Only
Best Price Gucci Earrings VI
Best Price Gucci Earrings IV
Best Price Gucci Earrings V
Best Price Gucci Snake Earrings I
Best Price Gucci Bangle Each
Best Price Van Cleef Arpels earrings
Now Rs: 1200
Rs : 1400 Van Cleef Arpels earrings
Page : 1 of 1