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

Rayban Sunglasses

Rs: 2500

Rayban Ferrari

Rs: 2000

Rayban Sunglasses

Rs: 2000

Rayban Aviators

Rs: 2200

Rayban Oval Wayfarer

Rs: 2000

Rayban Aviator III

Rs: 2000

Rayban Aviator II

Rs: 2000

Rayban Octa II

Rs: 1850

Rayban Gold Green Sunglasses with Box

Rs: 1850

Rayban Black Sunglasses with box

Rs: 1850

Rayban Gold Sunglasses with Box

Rs: 1850

Rayban Sunglasses with Box

Rs: 1850

Rayban Sunglasses with Box

Rs: 1850

Rayban Black Sunglasses with box

Rs: 1850

Rayban Sunglasses Black with Box

Rs: 1850

Rayban Sunglasses with box

Rs: 1850

Rayban Sunglasses with box

Rs: 1850

Rayban Sunglasses with Box

Rs: 1800

Rayban Round Sunglasses

Rs: 1800

Rayban Club Master Sunglasses

Rs: 1800

Rayban (New Edition) Black

Rs: 2000

Rayban Aviator with box (Silver Frame)

Rs: 2000

Rayban Aviator with box (Golden Frame)

Rs: 2000

Rayban Aviator with box

Rs: 2000

Rayban Aviator with box (Blue)

Rs: 2000

Rayban Aviator Full Black

Rs: 2000

Rayban Octagonal Sunglasses

Page : 1 of 1