SELECT X.*
		FROM
		(
			SELECT CON_SHIPPER_CONTENT_ID
			,CON_SA_CREATE_DATETIME
			,CON_PK_JOB_ID
			,CON_PK_DATABASE_CONTAINER_ID
			,CON_MAILCLASS
			,CON_PROCESSINGCATEGORY
			,CON_ENTRY_POINT_PHYSICAL
			,VerificationLocation
			,CON_ZONE_SKIPPING_INDICATOR
			,PriorityMailIndicator
			,CON_NEWS_INDICATOR
			,CON_DESTINATION_DISCOUNT_INDICATOR
			,CON_RATETYPE			
			,CON_SCHEDULED_INDUCTION_DATE
			,CON_INHOME_START_DATETIME	 
			FROM MDB_CONTENT_INFO 
			WHERE ((CON_CONSIGNEE_ID IS NULL) OR (CON_CONSIGNEE_ID = 'N/A'))
			AND ((CON_FAST_CONTENT_ID IS NULL) OR (CON_FAST_CONTENT_ID = 'N/A'))				
			AND (SAC_IsLinked is null or SAC_IsLinked = 'False' )	
			AND (SAC_SchedulerContentID is null)	
			AND ShipperApptRequestID is null
			AND (CON_SHIPPER_CONTENT_ID not in (SELECT items FROM dbo.GetCommaSplitValue(@InputVariable,',')))
			AND (@MailClass = '-1-' OR CON_MailClass = @MailClass)
			And (@MailShape = '-1-' OR CON_ProcessingCategory = @MailShape)
			And (@InductionDate = '-1-' OR CON_SCHEDULED_INDUCTION_DATE = @InductionDate)
			And (@VerificationLocation = '-1-' OR VerificationLocation  like '%' + @VerificationLocation+ '%')
			And (@LocaleKey = '-1-' OR CON_ENTRY_POINT_PHYSICAL  like '%' + @LocaleKey+ '%')
			And (@IsPriorityMail = '-1-' OR ( PriorityMailIndicator  = 
																CASE  WHEN @IsPriorityMail = 'True' THEN 1
																	  WHEN @IsPriorityMail ='False' THEN  0															      
																END
											 )) 
			And (@IsZoneSkip = '-1-' OR ( CON_ZONE_SKIPPING_INDICATOR  = 
																CASE  WHEN @IsZoneSkip = 'True' THEN 1
																	  WHEN @IsZoneSkip ='False' THEN  0															      
																END
											 )) 
			And (@IsNews = '-1-' OR ( CON_NEWS_INDICATOR  = 
																CASE  WHEN @IsNews = 'True' THEN 1
																	  WHEN @IsNews ='False' THEN  0															      
																END
											 )) 
			And (@IsDestinationDiscount = '-1-' OR ( CON_DESTINATION_DISCOUNT_INDICATOR  = 
																CASE  WHEN @IsDestinationDiscount = 'True' THEN 1
																	  WHEN @IsDestinationDiscount ='False' THEN  0															      
																END
											 ))		
			AND ISDATE(CON_SCHEDULED_INDUCTION_DATE) = 1
			And ISDATE(CON_INHOME_START_DATETIME) = 1
			/*AND CON_ENTRY_POINT_PHYSICAL is not null
						And LEN(CON_ENTRY_POINT_PHYSICAL) > 6			
						AND Right(CON_ENTRY_POINT_PHYSICAL, 6) in 
																(
																Select RIGHT(Rtrim(Ltrim(RAL_DROPSITE_KEY)), 6) 
																FROM REF_ADDRESS_LIST_FILE
																Where  RAL_DROPSITE_KEY IS NOT NULL 
																AND RAL_DS_DLVYADD_STATEABBRV IS NOT NULL
																AND RTRIM(LTRIM(RAL_DS_DLVYADD_STATEABBRV))
																in (
																	SELECT RTRIM(LTRIM(RAL_DS_PHYSADD_STATEABBRV))
																	FROM REF_ADDRESS_LIST_FILE
																	INNER JOIN 
																		(
																			SELECT DISTRICTS.DIS_PK_ZIP_CODE 
																			FROM DISTRICTS 
																			WHERE DISTRICTS.DIS_PK_DISTRICT_ID in 
																				(
																					SELECT UDR_FK_DISTRICT_ID = CAST(UDR_FK_DISTRICT_ID as int)  
																					FROM USER_DISTRICT 
																					WHERE  UDR_FK_LOGIN_ID = @UserLoginID
																				)
																		)x ON x.DIS_PK_ZIP_CODE = LEFT(RAL_DS_PHYSADD_ZIP4CODE,3)
																   )
																) 		
			*/		
			
			
	) X
			WHERE convert(datetime, X.CON_SCHEDULED_INDUCTION_DATE,112) >= GetDate() 		
			And convert(datetime, X.CON_INHOME_START_DATETIME,112) >= GetDate()
			/*AND CON_ENTRY_POINT_PHYSICAL is not null
			And LEN(CON_ENTRY_POINT_PHYSICAL) > 6			
			AND Right(CON_ENTRY_POINT_PHYSICAL, 6) in 
													(
													Select RIGHT(Rtrim(Ltrim(RAL_DROPSITE_KEY)), 6) 
													FROM REF_ADDRESS_LIST_FILE
													Where  RAL_DROPSITE_KEY IS NOT NULL 
													AND RAL_DS_DLVYADD_STATEABBRV IS NOT NULL
													AND RTRIM(LTRIM(RAL_DS_DLVYADD_STATEABBRV))
													in (
														SELECT RTRIM(LTRIM(RAL_DS_PHYSADD_STATEABBRV))
														FROM REF_ADDRESS_LIST_FILE
														INNER JOIN 
															(
																SELECT DISTRICTS.DIS_PK_ZIP_CODE 
																FROM DISTRICTS 
																WHERE DISTRICTS.DIS_PK_DISTRICT_ID in 
																	(
																		SELECT UDR_FK_DISTRICT_ID = CAST(UDR_FK_DISTRICT_ID as int)  
																		FROM USER_DISTRICT 
																		WHERE  UDR_FK_LOGIN_ID = @UserLoginID
																	)
															)x ON x.DIS_PK_ZIP_CODE = LEFT(RAL_DS_PHYSADD_ZIP4CODE,3)
													   )
													) 		
			*/										
			Order by CON_PK_JOB_ID, CON_PK_DATABASE_CONTAINER_ID

SELECT RIGHT(RTRIM(LTRIM(r1.RAL_DROPSITE_KEY)), 6)
 
FROM REF_ADDRESS_LIST_FILE r1

INNER JOIN REF_ADDRESS_LIST_FILE r2 
	ON RTRIM(LTRIM(r2.RAL_DS_PHYSADD_STATEABBRV)) = RTRIM(LTRIM(r1.RAL_DS_DLVYADD_STATEABBRV)) 
	 
INNER JOIN DISTRICTS d
	ON d.DIS_PK_ZIP_CODE = LEFT(r2.RAL_DS_PHYSADD_ZIP4CODE,3)
	
INNER JOIN USER_DISTRICT u 
	ON CAST(u.UDR_FK_DISTRICT_ID AS INT) = d.DIS_PK_DISTRICT_ID 
	AND u.UDR_FK_LOGIN_ID = @UserLoginID

WHERE r1.RAL_DROPSITE_KEY IS NOT NULL 
	AND r1.RAL_DS_DLVYADD_STATEABBRV IS NOT NULL