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

Chanel (CC)

Rs: 6800

Chanel Tote Shoulder Bag

Rs: 2800

Chanel Slippers

Rs: 24000

Chanel 4 pcs Gift Box

Rs: 2800

Chanel Waist Belt for Her with Original Packaging

Rs: 2999

Chanel 2cm Belt for Her

Rs: 2999

Chanel 2cm Belt for Her

Rs: 1800

Chanel Bangle

Rs: 6800

Chanel Boy Cavier with Box (AAA)

Rs: 6500

Chanel Double Flap Bag

Rs: 6000

Chanel Dual Color Chain Bag

Rs: 6500

Chanel Rhinestones Bag With Brand Box

Rs: 4000

Chanel Flap Small

Rs: 2500

Chanel Pearl Slippers

Rs: 4000

Chanel clutch

Rs: 5800

Chanel Shoulder Bag

Rs: 5800

Chanel Bag

Rs: 4000

Chanel Shoulder Bag with Pochette

Rs: 2700

Chanel Floral Slippers

Rs: 4000

Chanel Small Crossbody Bag 2021

Rs: 6500

Chanel Deauville Pearl Tote Bag

Rs: 1400

Chanel Bottle Earrings

Rs: 6000

Chanel Flap Cavier

Out of Stock

Chanel Boy plain

Rs: 6500

Chanel Classic Bag

Page : 1 of 1