SELECT * FROM Firm WHERE FirmStatus!=2 AND TownId=468787 AND LanguageCode='en' ORDER BY FirmId DESC LIMIT 50