logoname22.png


























logoname22.png?12345
Products
Women-Jewelry

Brands
Van Cleef

Price
100 2000

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

Van Cleef

Best Price VC Ring
Out of Stock
VC Ring
Best Price Van Cleef Pendant
Best Price Van Cleef Gold Bracelet
Best Price Van Cleef Bracelet
Best Price Van Cleef Ear Studs
Best Price Van Cleef Ring
Best Price Van Cleef Arpels earrings
Now Rs: 1200
Rs : 1400 Van Cleef Arpels earrings
Page : 1 of 1