ECONSUMER@SUSAPROD1> sta query_prod01.sql USER_ID ---------- EMAIL_ADDR -------------------------------------------------------------------------------- GIVEN_NAME -------------------------------------------------------------------------------- SOURCE -------------------------------------------------------------------------------- CHANNEL -------------------------------------------------------------------------------- MEMBER_STATUS PREV_REGIMEN_ID LAST_REGIMEN_ID ------------- --------------- --------------- PURCHASE_FLAG -------------------------------------------------------------------------------- 5270588 gillerlainja@yahoo.com Anthony eConsumer Web 1 15 15 USER_ID ---------- EMAIL_ADDR -------------------------------------------------------------------------------- GIVEN_NAME -------------------------------------------------------------------------------- SOURCE -------------------------------------------------------------------------------- CHANNEL -------------------------------------------------------------------------------- MEMBER_STATUS PREV_REGIMEN_ID LAST_REGIMEN_ID ------------- --------------- --------------- PURCHASE_FLAG -------------------------------------------------------------------------------- 5783904 i.elias@yahoo.com Ihsan SKinID Web 1 true USER_ID ---------- EMAIL_ADDR -------------------------------------------------------------------------------- GIVEN_NAME -------------------------------------------------------------------------------- SOURCE -------------------------------------------------------------------------------- CHANNEL -------------------------------------------------------------------------------- MEMBER_STATUS PREV_REGIMEN_ID LAST_REGIMEN_ID ------------- --------------- --------------- PURCHASE_FLAG -------------------------------------------------------------------------------- 5790795 marlinsbaseball12@hotmail.com Dennis SKinID Web 1 true USER_ID ---------- EMAIL_ADDR -------------------------------------------------------------------------------- GIVEN_NAME -------------------------------------------------------------------------------- SOURCE -------------------------------------------------------------------------------- CHANNEL -------------------------------------------------------------------------------- MEMBER_STATUS PREV_REGIMEN_ID LAST_REGIMEN_ID ------------- --------------- --------------- PURCHASE_FLAG -------------------------------------------------------------------------------- 5288429 firebolt1247@gmail.com Frani eConsumer Web 3 9 9 USER_ID ---------- EMAIL_ADDR -------------------------------------------------------------------------------- GIVEN_NAME -------------------------------------------------------------------------------- SOURCE -------------------------------------------------------------------------------- CHANNEL -------------------------------------------------------------------------------- MEMBER_STATUS PREV_REGIMEN_ID LAST_REGIMEN_ID ------------- --------------- --------------- PURCHASE_FLAG -------------------------------------------------------------------------------- 5585561 mhegi2@aol.com Meredith eConsumer Web 2 18 18 USER_ID ---------- EMAIL_ADDR -------------------------------------------------------------------------------- GIVEN_NAME -------------------------------------------------------------------------------- SOURCE -------------------------------------------------------------------------------- CHANNEL -------------------------------------------------------------------------------- MEMBER_STATUS PREV_REGIMEN_ID LAST_REGIMEN_ID ------------- --------------- --------------- PURCHASE_FLAG -------------------------------------------------------------------------------- 5242622 wingchun32@yahoo.com eric eConsumer Web 1 25 9 USER_ID ---------- EMAIL_ADDR -------------------------------------------------------------------------------- GIVEN_NAME -------------------------------------------------------------------------------- SOURCE -------------------------------------------------------------------------------- CHANNEL -------------------------------------------------------------------------------- MEMBER_STATUS PREV_REGIMEN_ID LAST_REGIMEN_ID ------------- --------------- --------------- PURCHASE_FLAG -------------------------------------------------------------------------------- 4918914 cherylphoebe@gmail.com Cheryl eConsumer Web 1 29 USER_ID ---------- EMAIL_ADDR -------------------------------------------------------------------------------- GIVEN_NAME -------------------------------------------------------------------------------- SOURCE -------------------------------------------------------------------------------- CHANNEL -------------------------------------------------------------------------------- MEMBER_STATUS PREV_REGIMEN_ID LAST_REGIMEN_ID ------------- --------------- --------------- PURCHASE_FLAG -------------------------------------------------------------------------------- 5810492 blackapril54@yahoo.com vivi SKinID Web 1 true no rows selected no rows selected USER_ID ---------- EMAIL_ADDR -------------------------------------------------------------------------------- GIVEN_NAME -------------------------------------------------------------------------------- SOURCE -------------------------------------------------------------------------------- CHANNEL -------------------------------------------------------------------------------- MEMBER_STATUS PREV_REGIMEN_ID LAST_REGIMEN_ID ------------- --------------- --------------- PURCHASE_FLAG -------------------------------------------------------------------------------- 5809937 coachdebs@aol.com nicole SKinID Web 1 true ECONSUMER@SUSAPROD1> spool off