Gucci (GG)

100 2999

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

Gucci (GG) Women-Jewelry

Best Price GG Silver Jewelry Set
Best Price Gucci Round Jewelry Set
Best Price GG Black Gold Jewelry Set
Best Price Rolex Bangle
Now Rs: 1300
Rs : 1500 Rolex Bangle
Best Price Gucci Bangle
Best Price Gucci Brooch
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
Page : 1 of 1