Subscription Clean Up

SELECT CallNo, OwnerId, ClientNo, SourceId, ShipId, ActivationId, ProductId, Sal, FirstName, LastName, FullName, Company, Address1, Address2, Address3, Address4, Address5, City, State, Country, ISO2Char, PostalCode, Phone, HPhone, Mobile, Email, ActivationCode, DateSubscribe, SubscriptionStart, ExpiryDate, LastIssueDelivered, LastFulfillmentDate, SubscriptionCode, CommonName, SourceDescription, OwnerName, SubscriberAccountNo, AddressType, EmailType, ExportForPublisher, DATEDIFF(month,SubscriptionStart, ExpiryDate) + 1 AS terms FROM dbo.View_SelectAllSubscription WHERE (ISO2Char = N'HK') AND (SubscriptionCode = N'NGM') AND (ExportForPublisher IS NULL) AND (SubscriptionStart < CONVERT(DATETIME, '2016-01-01 00:00:00', 102)) AND (OwnerId <> 3) AND (DATEDIFF(month, SubscriptionStart, ExpiryDate) + 1 <= 24) AND (DATEDIFF(month, SubscriptionStart, ExpiryDate) + 1 >= 6) ORDER BY SubscriptionStart, CallNo;
<----- Cleaning Completed ----->