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

Cartier Women-Jewelry

Rs: 800

Cartier Nail Ring with Stones

Rs: 2300

Cartier Nail bangle stones with brand packaging

Rs: 1300

Cartier Love Ring with Complete Packaging

Rs: 1300

Cartier Nail Ring with Complete Packaging

Out of Stock

Cartier Zircon Bangle

Rs: 2000

Cartier Zircon Ring

Rs: 1600

Cartier Leather Nail Bracelet

Rs: 2000

Cartier Love Bracelet

Rs: 1700

Cartier Nail Bracelets

Rs: 2000

Cartier Love Bracelet with screw Driver, Same as original

Rs: 2600

Cartier Bracelet and Ring Rose Gold

Rs: 2600

Cartier Bracelet and Ring Silver

Rs: 2600

Cartier Bracelet and Ring

Rs: 800

Cartier Love Ring with stone

Rs: 800

Cartier Nail Ring

Rs: 1700

Cartier Nail Bracelet with Stones

Rs: 2000

Cartier Love Bangle with Stones

Page : 1 of 1