Response Query on Already Authorized Cards

ResponseQueryAuthCards

SELECT 
					SYSOENT.ORDER_STATUS,
					SYSOENT.PO_NUMBER,
					SYSOENT.ORDER_NO,
					SYSOENT.ORDER_SOURCE,
					SYSOENT.AUTH_CODE,
					SYSOENT.AUTH_DATE,
					SYSOENT.CREATED_BY,
					SYSOENT.ORDER_DATE,
					SYSOENT.CUSTOMER_ID,
					SYSOENT.AUTH_CODE,
					SYSOENT.DIVISION,
					SYSCUST.CUSTOMER_ID,
					SYSCUST.LAST_NAME,
					SYSCUST.FIRST_NAME,
					SYSCUST.EMAIL1,
					SYSCUST.ADDRESS_LINE1,
					SYSCUST.ADDRESS_LINE2,
					SYSCUST.CITY,
					SYSCUST.STATE,
					SYSCUST.ZIPCODE,
					SYSCUST.COUNTRY,
					SYSCUST.PHONE_AREA,
					SYSCUST.PHONE_EXCH,
					SYSCUST.PHONE_EXT,
					SYSOENT.PAYMENT_CODE,
					SYSOENT.CREDIT_CARD_#,
					CONVERT (varchar, SYSOENT.EXPIRES, 121) AS CCEXPIRES 
				FROM SYSOENT 
				INNER JOIN SYSCUST ON SYSOENT.CUSTOMER_ID = SYSCUST.CUSTOMER_ID 
				WHERE SYSOENT.ORDER_STATUS IN
				  (SELECT SYSOENT.ORDER_STATUS FROM SYSOENT WHERE 
					SYSOENT.ORDER_STATUS IN ("D","E","W")) AND
					SYSOENT.PO_NUMBER <> "" AND SYSOENT.ORDER_SOURCE = "web" AND SYSOENT.AUTH_CODE <> "" AND SYSOENT.AUTH_DATE >= "' . $timeshift .'"'