SELECT p.ProductId,p.Title,p.Price,p.IsActive,p.DateAdded,(SELECT ImageName FROM tblrf_productimages WHERE ProductId=p.ProductId AND Seq=1)AS ImageName,MATCH (p.Title,p.Size,p.Color) AGAINST ('Brown Decorative Square Indian Mirror Embroidered Pillow Cover 24 X 24 Inch for Sofa, Couch and Chair 24\" x 24\" Inch Brown') AS MatchScore FROM tblrf_products p WHERE p.IsActive=1 AND p.Qty>0 AND ProductId Not In(7267,7266,5088,324,325,728,730,1519,4362,4363,7269,7270,7271) AND ProductId<>7268 ORDER BY MatchScore DESC LIMIT 12