logoname22.png


























logoname22.png?12345
Products
Women-Jewelry

Brands
Gucci (GG)
Rolex

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

Rolex Women-Jewelry

Best Price Rolex Jewelry Set
Best Price Rolex Bangle
Now Rs: 1300
Rs : 1500 Rolex Bangle
Page : 1 of 1