Select count(*) as count from (SELECT a.ProductID FROM products a LEFT JOIN productdetail b ON a.ProductID=b.ProductID LEFT JOIN submodels c ON b.SubModelID=c.SubModelID LEFT Join models d ON d.ModelID = b.ModelID LEFT Join enginetypes e ON a.EngineTypeID = e.EngineTypeID LEFT Join makes f ON f.MakeID = b.MakeID LEFT JOIN oilmanange o ON a.oilId = o.id left join fueltypes ft on  ft.FuelTypeID=a.FuelTypeID  WHERE  a.ProductTypeID = 17 AND StartYear <= '1971' AND EndYear >= '1971' AND b.MakeID  = '85' AND b.ModelID  = '573' AND b.ModelID !='0' AND a.status ='0' group by a.ProductID order by a.SizeLiters ASC) x LIMIT 1