Company not found

SELECT Company.*, Country.Name AS CountryName FROM Company LEFT JOIN Country ON Company.CountryID = Country.ID WHERE Company.NameShort = 'CLAPR1275EN0717 MR CLN BeautyForward II in China.pdf' AND Company.Live = 1 ORDER BY ListedAsFeatured DESC