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

Gucci (GG) Handbags

Rs: 7500

Gucci Mormont

Rs: 5500

Gucci bag

Rs: 5000

Gucci Padlock Small

Rs: 6500

Gucci Handbag

Rs: 6000

Gucci Canvas Duffle Handbag

Rs: 5200

Dionysus Bag

Rs: 5500

Gucci Bamboo Canvas Bag

Now Rs: 4800

Rs : 5500 Gucci Cross Body Bag

Out of Stock

Gucci Padlock Sidebag

Rs: 6800

Gucci Tote

Out of Stock

Gucci Mormont Camera Sidebag

Rs: 4500

Gucci Crossbody bag

Rs: 4800

Gucci Traveler Bag

Out of Stock

Gucci Dionysus

Rs: 4800

Gucci two pieces sidebag With Brand Box

Rs: 4000

Gucci NEO Vintage

Rs: 5000

Gucci Pattern Sidebag

Rs: 5800

Gucci Diana

Rs: 4300

Gucci Mormont Matelasse Shoulder Bag

Out of Stock

Gucci Soho Disco Bag

Out of Stock

Gucci Soho Disco Bag

Rs: 8000

Hermes Birkin Master Copy

Rs: 5000

Gucci Padlock

Rs: 5000

Gucci Horsbit Crossbody Bag

Rs: 3500

Gucci Bag with Ribbon

Out of Stock

Gucci Snake Wallet

Out of Stock

Gucci Lion Wallet

Rs: 3500

Gucci Soho Disco Bag

Out of Stock

Gucci Soho Round

Out of Stock

Gucci Soho Chain

Page : 1 of 1