Company not found

SELECT Company.*, Country.Name AS CountryName FROM Company LEFT JOIN Country ON Company.CountryID = Country.ID WHERE Company.NameShort = 'CLAPR1254EN0517 MR CLN at Eastern Coatings Show.pdf' AND Company.Live = 1 ORDER BY ListedAsFeatured DESC