| Scope | | railo | | Struct | | release-date | | Date Time | {ts '2009-04-29 00:00:00'} |
| | version | | | versionName | | | state | | | versionNameExplanation | | string | http://en.wikipedia.org/wiki/Barry_(dog) |
|
| | java | | Struct | | version | | | totalMemory | | | maxMemory | | | freeMemory | | | vendor | | string | Sun Microsystems Inc. |
|
| | 49fad7ecf04102c2808eb425c14cf93f | | Struct | | DEBUGENTRIES | | Array | | 1 | | Struct | | ITOTAL | | | RECORDED | | Date Time | {ts '2010-03-13 01:00:10'} |
| | IPADDRESS | | | CALLEDURL | | string | /Application/Silverpop/schChUndeliverables.cfm?RequestTimeout=300 |
| | DEBUGINFO | | Struct | | pages | | Query | | Execution Time (ms) | 0 | | recordcount | 5 | | cached | No | | result | | id | count | min | max | avg | app | load | query | total | src | | 12035 | 1 | 3687 | 3687 | 3687 | 3687 | 0 | 0 | 3687 | C:\webRoot\Silverpop\CFC\Silverpop.cfc$processChUndeliverables | | 12033 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | C:\webRoot\Silverpop\CFC\Silverpop.cfc | | 12037 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | C:\Program Files\Railo\webapps\ROOT\WEB-INF\railo\context\templates\debugging\debugging-2-console.cfm | | 12032 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | C:\webRoot\Silverpop\schChUndeliverables.cfm | | 12034 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | C:\Program Files\Railo\webapps\ROOT\WEB-INF\railo\context\Component.cfc |
|
| | traces | | Query | | Execution Time (ms) | 0 | | recordcount | 0 | | cached | No | | result | | type | category | text | template | line | varname | varvalue | time |
|
| | queries | | Query | | Execution Time (ms) | 0 | | recordcount | 3 | | cached | No | | result | | name | time | sql | src | count | datasource | | qUserId | 0 |
SELECT account_id
FROM cm_silverpop_users
WHERE user_id = 'gorlap@clubhotel.com'
| C:\webRoot\Silverpop\CFC\Silverpop.cfc | 1 | hmcclub | | qUserId | 0 |
SELECT silverpop_marketer_pwd
FROM cm_silverpop_users
WHERE user_id = 'gorlap@clubhotel.com'
| C:\webRoot\Silverpop\CFC\Silverpop.cfc | 1 | hmcclub | | qInsertBatch | 0 |
INSERT INTO members_stale_flg_batches (list_id, file_path,list_type)
VALUES (11341335, '/download/Master Suppression List - Undeliverables - Mar 13 2010 01-00-08 AM.CSV', 'ch')
| C:\webRoot\Silverpop\CFC\Silverpop.cfc | 0 | hmcclub |
|
| | timers | | Query | | Execution Time (ms) | 0 | | recordcount | 0 | | cached | No | | result | |
| | history | | Query | | Execution Time (ms) | 0 | | recordcount | 5 | | cached | No | | result | | id | level | | 12032 | 1 | | 12033 | 2 | | 12034 | 3 | | 12035 | 2 | | 12037 | 1 |
|
|
|
| | 2 | | Struct | | ITOTAL | | | RECORDED | | Date Time | {ts '2010-03-13 01:30:09'} |
| | IPADDRESS | | | CALLEDURL | | string | /Application/Silverpop/schTransactUndeliverables.cfm?RequestTimeout=300 |
| | DEBUGINFO | | Struct | | pages | | Query | | Execution Time (ms) | 0 | | recordcount | 5 | | cached | No | | result | | id | count | min | max | avg | app | load | query | total | src | | 12105 | 1 | 2531 | 2531 | 2531 | 2531 | 0 | 0 | 2531 | C:\webRoot\Silverpop\CFC\Silverpop.cfc$processChUndeliverables | | 12103 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | C:\webRoot\Silverpop\CFC\Silverpop.cfc | | 12106 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | C:\Program Files\Railo\webapps\ROOT\WEB-INF\railo\context\templates\debugging\debugging-2-console.cfm | | 12102 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | C:\webRoot\Silverpop\schTransactUndeliverables.cfm | | 12104 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | C:\Program Files\Railo\webapps\ROOT\WEB-INF\railo\context\Component.cfc |
|
| | traces | | Query | | Execution Time (ms) | 0 | | recordcount | 0 | | cached | No | | result | | type | category | text | template | line | varname | varvalue | time |
|
| | queries | | Query | | Execution Time (ms) | 0 | | recordcount | 3 | | cached | No | | result | | name | time | sql | src | count | datasource | | qUserId | 0 |
SELECT account_id
FROM cm_silverpop_users
WHERE user_id = 'gorlap2@clubhotel.com'
| C:\webRoot\Silverpop\CFC\Silverpop.cfc | 1 | hmcclub | | qUserId | 0 |
SELECT silverpop_marketer_pwd
FROM cm_silverpop_users
WHERE user_id = 'gorlap2@clubhotel.com'
| C:\webRoot\Silverpop\CFC\Silverpop.cfc | 1 | hmcclub | | qInsertBatch | 0 |
INSERT INTO members_stale_flg_batches (list_id, file_path,list_type)
VALUES (11341444, '/download/Master Suppression List - Undeliverables - Mar 13 2010 01-30-08 AM.CSV', 'tr')
| C:\webRoot\Silverpop\CFC\Silverpop.cfc | 0 | hmcclub |
|
| | timers | | Query | | Execution Time (ms) | 0 | | recordcount | 0 | | cached | No | | result | |
| | history | | Query | | Execution Time (ms) | 0 | | recordcount | 5 | | cached | No | | result | | id | level | | 12102 | 1 | | 12103 | 2 | | 12104 | 3 | | 12105 | 2 | | 12106 | 1 |
|
|
|
| | 3 | | Struct | | ITOTAL | | | RECORDED | | Date Time | {ts '2010-03-13 01:30:09'} |
| | IPADDRESS | | | CALLEDURL | | string | /Application/Silverpop/schTransactUndeliverables.cfm?RequestTimeout=300 |
| | DEBUGINFO | | Struct | | pages | | Query | | Execution Time (ms) | 0 | | recordcount | 5 | | cached | No | | result | | id | count | min | max | avg | app | load | query | total | src | | 12101 | 1 | 2672 | 2672 | 2672 | 2672 | 0 | 0 | 2672 | C:\webRoot\Silverpop\CFC\Silverpop.cfc$processChUndeliverables | | 12099 | 1 | 0 | 0 | 0 | 0 | 0 | 32 | 0 | C:\webRoot\Silverpop\CFC\Silverpop.cfc | | 12107 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | C:\Program Files\Railo\webapps\ROOT\WEB-INF\railo\context\templates\debugging\debugging-2-console.cfm | | 12098 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | C:\webRoot\Silverpop\schTransactUndeliverables.cfm | | 12100 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | C:\Program Files\Railo\webapps\ROOT\WEB-INF\railo\context\Component.cfc |
|
| | traces | | Query | | Execution Time (ms) | 0 | | recordcount | 0 | | cached | No | | result | | type | category | text | template | line | varname | varvalue | time |
|
| | queries | | Query | | Execution Time (ms) | 0 | | recordcount | 3 | | cached | No | | result | | name | time | sql | src | count | datasource | | qUserId | 32 |
SELECT account_id
FROM cm_silverpop_users
WHERE user_id = 'gorlap2@clubhotel.com'
| C:\webRoot\Silverpop\CFC\Silverpop.cfc | 1 | hmcclub | | qUserId | 0 |
SELECT silverpop_marketer_pwd
FROM cm_silverpop_users
WHERE user_id = 'gorlap2@clubhotel.com'
| C:\webRoot\Silverpop\CFC\Silverpop.cfc | 1 | hmcclub | | qInsertBatch | 0 |
INSERT INTO members_stale_flg_batches (list_id, file_path,list_type)
VALUES (11341445, '/download/Master Suppression List - Undeliverables - Mar 13 2010 01-30-08 AM.CSV', 'tr')
| C:\webRoot\Silverpop\CFC\Silverpop.cfc | 0 | hmcclub |
|
| | timers | | Query | | Execution Time (ms) | 0 | | recordcount | 0 | | cached | No | | result | |
| | history | | Query | | Execution Time (ms) | 0 | | recordcount | 5 | | cached | No | | result | | id | level | | 12098 | 1 | | 12099 | 2 | | 12100 | 3 | | 12101 | 2 | | 12107 | 1 |
|
|
|
| | 4 | | Struct | | ITOTAL | | | RECORDED | | Date Time | {ts '2010-03-13 03:00:16'} |
| | IPADDRESS | | | CALLEDURL | | string | /Application/Silverpop/schProcessUndeliverableBatches.cfm?RequestTimeout=50 |
| | DEBUGINFO | | Struct | | pages | | Query | | Execution Time (ms) | 0 | | recordcount | 5 | | cached | No | | result | | id | count | min | max | avg | app | load | query | total | src | | 12216 | 1 | 10797 | 10797 | 10797 | 10797 | 0 | 0 | 10797 | C:\webRoot\Silverpop\CFC\Silverpop.cfc$processUndeliverableBatches | | 12213 | 1 | 15 | 15 | 15 | 15 | 0 | 0 | 15 | C:\webRoot\Silverpop\schProcessUndeliverableBatches.cfm | | 12214 | 1 | 0 | 0 | 0 | 0 | 0 | 141 | 0 | C:\webRoot\Silverpop\CFC\Silverpop.cfc | | 12221 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | C:\Program Files\Railo\webapps\ROOT\WEB-INF\railo\context\templates\debugging\debugging-2-console.cfm | | 12215 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | C:\Program Files\Railo\webapps\ROOT\WEB-INF\railo\context\Component.cfc |
|
| | traces | | Query | | Execution Time (ms) | 0 | | recordcount | 0 | | cached | No | | result | | type | category | text | template | line | varname | varvalue | time |
|
| | queries | | Query | | Execution Time (ms) | 0 | | recordcount | 27 | | cached | No | | result | | name | time | sql | src | count | datasource | | qUserId | 31 |
SELECT account_id
FROM cm_silverpop_users
WHERE user_id = 'gorlap@clubhotel.com'
| C:\webRoot\Silverpop\CFC\Silverpop.cfc | 1 | hmcclub | | qUserId | 16 |
SELECT silverpop_marketer_pwd
FROM cm_silverpop_users
WHERE user_id = 'gorlap@clubhotel.com'
| C:\webRoot\Silverpop\CFC\Silverpop.cfc | 1 | hmcclub | | qBatches | 94 |
SELECT batch_id,
list_id,
file_path,
list_type
FROM members_stale_flg_batches
WHERE status = 0
| C:\webRoot\Silverpop\CFC\Silverpop.cfc | 4 | hmcclub | | qUserId | 0 |
SELECT account_id
FROM cm_silverpop_users
WHERE user_id = 'gorlap@clubhotel.com'
| C:\webRoot\Silverpop\CFC\Silverpop.cfc | 1 | hmcclub | | qUserId | 0 |
SELECT silverpop_ftp_pwd
FROM cm_silverpop_users
WHERE user_id = 'gorlap@clubhotel.com'
| C:\webRoot\Silverpop\CFC\Silverpop.cfc | 1 | hmcclub | | qUpdateUndeliverables | 0 |
UPDATE members
SET stale_flg = 1
WHERE lower(email1) IN ('jhjhjhj@ttyty.ll.ca','dfdfdf@iiiii.com','virgiliosousa@iol.pt','anne@edelmanleather.com','jdennis@blueyounder.co.uk','ngueynk@clubhotel.com','ycosta@teledata.mz')
| C:\webRoot\Silverpop\CFC\Silverpop.cfc | 0 | hmcclub | | qInsertStaleFlagUpdate | 0 |
INSERT INTO members_stale_flg_updates
(SELECT NULL AS UPD_ID,
MEMBER_ID,
1 AS STL_FLG,
SYSDATE AS DT,
'C' AS type
FROM members
WHERE lower(email1) IN ('jhjhjhj@ttyty.ll.ca','dfdfdf@iiiii.com','virgiliosousa@iol.pt','anne@edelmanleather.com','jdennis@blueyounder.co.uk','ngueynk@clubhotel.com','ycosta@teledata.mz'))
| C:\webRoot\Silverpop\CFC\Silverpop.cfc | 0 | hmcclub | | qUpdateUndeliverables | 0 |
UPDATE ghr_members
SET stale_flg = 1
WHERE lower(email1) IN ('jhjhjhj@ttyty.ll.ca','dfdfdf@iiiii.com','virgiliosousa@iol.pt','anne@edelmanleather.com','jdennis@blueyounder.co.uk','ngueynk@clubhotel.com','ycosta@teledata.mz')
| C:\webRoot\Silverpop\CFC\Silverpop.cfc | 0 | vhr_members | | qUpdateBatch | 0 |
UPDATE members_stale_flg_batches
SET status = 1
WHERE list_id = 11341334
| C:\webRoot\Silverpop\CFC\Silverpop.cfc | 0 | hmcclub | | qUserId | 0 |
SELECT account_id
FROM cm_silverpop_users
WHERE user_id = 'gorlap@clubhotel.com'
| C:\webRoot\Silverpop\CFC\Silverpop.cfc | 1 | hmcclub | | qUserId | 0 |
SELECT silverpop_ftp_pwd
FROM cm_silverpop_users
WHERE user_id = 'gorlap@clubhotel.com'
| C:\webRoot\Silverpop\CFC\Silverpop.cfc | 1 | hmcclub | | qUpdateUndeliverables | 0 |
UPDATE members
SET stale_flg = 1
WHERE lower(email1) IN ('jhjhjhj@ttyty.ll.ca','dfdfdf@iiiii.com','virgiliosousa@iol.pt','anne@edelmanleather.com','jdennis@blueyounder.co.uk','ngueynk@clubhotel.com','ycosta@teledata.mz')
| C:\webRoot\Silverpop\CFC\Silverpop.cfc | 0 | hmcclub | | qInsertStaleFlagUpdate | 0 |
INSERT INTO members_stale_flg_updates
(SELECT NULL AS UPD_ID,
MEMBER_ID,
1 AS STL_FLG,
SYSDATE AS DT,
'C' AS type
FROM members
WHERE lower(email1) IN ('jhjhjhj@ttyty.ll.ca','dfdfdf@iiiii.com','virgiliosousa@iol.pt','anne@edelmanleather.com','jdennis@blueyounder.co.uk','ngueynk@clubhotel.com','ycosta@teledata.mz'))
| C:\webRoot\Silverpop\CFC\Silverpop.cfc | 0 | hmcclub | | qUpdateUndeliverables | 0 |
UPDATE ghr_members
SET stale_flg = 1
WHERE lower(email1) IN ('jhjhjhj@ttyty.ll.ca','dfdfdf@iiiii.com','virgiliosousa@iol.pt','anne@edelmanleather.com','jdennis@blueyounder.co.uk','ngueynk@clubhotel.com','ycosta@teledata.mz')
| C:\webRoot\Silverpop\CFC\Silverpop.cfc | 0 | vhr_members | | qUpdateBatch | 0 |
UPDATE members_stale_flg_batches
SET status = 1
WHERE list_id = 11341335
| C:\webRoot\Silverpop\CFC\Silverpop.cfc | 0 | hmcclub | | qUserId | 0 |
SELECT account_id
FROM cm_silverpop_users
WHERE user_id = 'gorlap2@clubhotel.com'
| C:\webRoot\Silverpop\CFC\Silverpop.cfc | 1 | hmcclub | | qUserId | 0 |
SELECT silverpop_ftp_pwd
FROM cm_silverpop_users
WHERE user_id = 'gorlap2@clubhotel.com'
| C:\webRoot\Silverpop\CFC\Silverpop.cfc | 1 | hmcclub | | qUpdateUndeliverables | 0 |
UPDATE members
SET stale_flg = 1
WHERE lower(email1) IN ('alan0135@yahoo.com.my','zhangxianjiang@icmbc.com.cn','albajenning@optusnet.com.au','louise.ibanaz@yahoo.com.ph','rgrgrhtjyudgdfdg@126.com','afsd_ng@yahoo.com','zhangweijun@yahoo.com','ob@yahoo.com','khaw12234@yahoo.com','13708978656@139.com','crissysison@rocketmail.com.p','chienchuping@yahoo.com.tw','fjy92@263.net','lmv@yahoo.com','yangyubing@vip.163.com','fr_snti@yahoo.com.ph','146594@qq.com','tn@yahoo.com','chenty0766@sohu.com','lencite@263.net','vwong12345@yahoo.com','13853205575@139.com','sinhua@yahoo.com','joelle168@yahoo.com.cn','beautiful.rain@leto.eonet.ne.jp','16569848@qq.com','whs@yahoo.com','liujing_bj@chinastock.com','kaicheing@yahoo.com','thelmalagrimas@yahoo.com.ph','mei@qq.com','sandypery@yahoo.com.ph','pfmary@163.com','jeri3jer@hotmail.com','113678414@163.com','24997804@qq.com','13924972738@139.com','hywan2@163.com','at23@yahoo.com','13823116362@139.com','ganhong@hotmail.com','wuqi@yahoo.com','loewiov@163.net','rebeccachung333@yahoo.com.hk','jwkboy@yahoo.com.hk','summerueml@hotmail.com','pyhpan3388@yahoo.com','13906023559@139.com','jnszpxw@163.com','atty_victor@yahoo.c','yuyongchun156@163.com','zgql_mmsq@sohu.com','rgaoz@ford.com','lilylihome@hotmail.com','liangyuehong@sohu.com','zhupeijing11@126.com','5239432912323@qq.com','huasheng@136.com','shizss@263.net','15986694828@139.com','shengcai777@136.com','13827480321@139.com','trisica-ph@hotmail.com','luoxiaogang145@sohu.com','zhangxi145@126.com','huangshufen@sohu.com','yongguangsu@163.com','ubt104@gmail.com','panlilei@sohu.com','hlm0501@126.com','zhangajun156@126.com','linlin-0377@126.com','13666651879@139.com','liuzhouming126@126.com','13757179349@139.com','13957166606@139.com','dongyuewu111@beijingdics.com','yuuie00@163.com','13306537071@139.com','wangzheng@163.net','cjesly@163.com','13802237859@139.com','g.christophe321@alice.fr','malei145@yahoo.com.cn','lin-lin-0377@163.com','1390119@139.com','chenpeng147@sohu.com','chenxinying145@163.com','wukai88@136.com','mrlarrypowel@yahoo.co.uk','luismiguel70@yahoo.es','pablo@poctalum.net','xepasal@gmail.com','luisnadov@hotmail.com','richardmanby@silversattime.com','carlos@vnexport.es','eeeesette@tiscali.it','crifin@cnstacurva.com','15810365717@139.om','xiaozou-aimeili@hotmail.com','sgtabolilla@hotmail.com','ricardobianchini@terra.com.br4','julio.llamo@klingspon.es','norelisalva123@hotmail.com','yponcean@hotmail.com','williiam_0084@hotmail.com','alessandraprest@yahoo.it','gtalleri@gmail.com.br3','linavillaverde2@hotmail.com','carmennovel@hotmail.com','zrsardinha@hotmail.com.br','maf.ichasoan@planet.t','flesprin@gmail.com','djorlan@hotmail.com','rpmerimo@yahoo.es','alba-cabo@hotmail.com','gnrybpm@yahoo.com','lanvic11@hotmail.com','abaggefilho@terra.com.br3','silvia@nacscosmeticos.com.br1','ignaciolajarza@yahoo.es','abaggefilho@terra1.com.br','vlinkgo@hotmail.com','lrsardinha@hotmail.com.br','magdag27@hotmail.com','sanchiz@botegascastano.com','mmorfila@ibsalut.caib','simona.catanero@tin.it','abaggefilho@terra.com.br.6','ministerioevangelicoraulynjante@hotmail.com','iguasi@vesitges.com','bellisimabillon@gmail.com','ministerioevangelicoraulynjante2@hotmail.com','ministerioevangelicoraulynjante3@hotmail.com','massibi79@hotmail.it','j.hanlet@hotmail.com','m@h.com.br','lyerly@aol.com','alex.jdunning@btinternet.com','pamirom9@hotmail.com','anaelirr@yahoo.com','beatriz51515@hotmail.com','erodriguez@blindeca.com','terry@abtec-eng.co','judithmartinez@prensa.com','judithmartinez@aprensa.hn','peter@abtec-eng.co','cvillarreal3049@students.leredo.edu','marcode@br.com.br','hilton@br.com.br4','mauroalm@br.com.br4','velascosvastiduos@hotmail.com','bogotamonica@yahoo.com.co','jmanzano@inciativasbcn.com','campomarta1@hotmail.com','gregorreece@mail.com','hilton@br.com.br5','hilton@br.com.br6','jjstivel@senado.gov.br','ciro.santalucia@terra.com.br6','alberto10@globo.com6','claramoun1@yahoo.com','alberto10@globo.com7','josejoaojr@copperfrigu.com.br','avedolin@yahoo.com.br9','cgm.godoijunior@hotmail.com','alberto10@globo.com9','marconde@br.com.br9','alberto10@globo.com4','ciro.santalucia@terra.com.br9','ciro.santalucia@terra.com.br4','avedolin@yahoo.com.br1','victornavas@cable.net.com','pablo@villamichele.net','eaustin@flowtrinidad.net','claramoun12@yahoo.com','marconde@br.com.br1','alejandro@morbidoni.com','amauricgalvao@hotmail.com4','avedolin@yahoo.com.br3','claramunt2@yahoo.com','alberto10@globo.com8','silvia@netsite.com.br.3','novaes@hotmail.com.r','cordycom@gmail.com','rene@bauance.com.br','silvia@netsoite.com.b','durval@marrj.com.br','luisio728@yahoo.com','aaamaya_mendoza@hotmail.com','marisela@mora.com','sarahn.ackbarali@hotmail.com','dleitzalar@yahoo.com','rene@bauance.com.br5','rosales1@yahoo.com','flavia@studio.cerri.com.br','aliyya_shakeer@hotmail.com','fmofarreje@hotmail.com.br','krcsilva@gmail.com.br','riancerdeira@gmail.com.br','marthairma@yahoo.com.mx','sharon_deronique@hotmail.com','atendimento@kamiline.com.br1','novaes@hotmail.com.br6','victoralfaro0216@yahoo.com','apgsantos@gmail.com.br','fmofarreje@hotmail.com','angelica-mar@uol.com.br1','angelica-mar@uol.com.br2','elijay60@gmail.com','priloaguiar@hotmail.com','priloaguiar@hotmail.comb')
| C:\webRoot\Silverpop\CFC\Silverpop.cfc | 0 | hmcclub | | qInsertStaleFlagUpdate | 0 |
INSERT INTO members_stale_flg_updates
(SELECT NULL AS UPD_ID,
MEMBER_ID,
1 AS STL_FLG,
SYSDATE AS DT,
'C' AS type
FROM members
WHERE lower(email1) IN ('alan0135@yahoo.com.my','zhangxianjiang@icmbc.com.cn','albajenning@optusnet.com.au','louise.ibanaz@yahoo.com.ph','rgrgrhtjyudgdfdg@126.com','afsd_ng@yahoo.com','zhangweijun@yahoo.com','ob@yahoo.com','khaw12234@yahoo.com','13708978656@139.com','crissysison@rocketmail.com.p','chienchuping@yahoo.com.tw','fjy92@263.net','lmv@yahoo.com','yangyubing@vip.163.com','fr_snti@yahoo.com.ph','146594@qq.com','tn@yahoo.com','chenty0766@sohu.com','lencite@263.net','vwong12345@yahoo.com','13853205575@139.com','sinhua@yahoo.com','joelle168@yahoo.com.cn','beautiful.rain@leto.eonet.ne.jp','16569848@qq.com','whs@yahoo.com','liujing_bj@chinastock.com','kaicheing@yahoo.com','thelmalagrimas@yahoo.com.ph','mei@qq.com','sandypery@yahoo.com.ph','pfmary@163.com','jeri3jer@hotmail.com','113678414@163.com','24997804@qq.com','13924972738@139.com','hywan2@163.com','at23@yahoo.com','13823116362@139.com','ganhong@hotmail.com','wuqi@yahoo.com','loewiov@163.net','rebeccachung333@yahoo.com.hk','jwkboy@yahoo.com.hk','summerueml@hotmail.com','pyhpan3388@yahoo.com','13906023559@139.com','jnszpxw@163.com','atty_victor@yahoo.c','yuyongchun156@163.com','zgql_mmsq@sohu.com','rgaoz@ford.com','lilylihome@hotmail.com','liangyuehong@sohu.com','zhupeijing11@126.com','5239432912323@qq.com','huasheng@136.com','shizss@263.net','15986694828@139.com','shengcai777@136.com','13827480321@139.com','trisica-ph@hotmail.com','luoxiaogang145@sohu.com','zhangxi145@126.com','huangshufen@sohu.com','yongguangsu@163.com','ubt104@gmail.com','panlilei@sohu.com','hlm0501@126.com','zhangajun156@126.com','linlin-0377@126.com','13666651879@139.com','liuzhouming126@126.com','13757179349@139.com','13957166606@139.com','dongyuewu111@beijingdics.com','yuuie00@163.com','13306537071@139.com','wangzheng@163.net','cjesly@163.com','13802237859@139.com','g.christophe321@alice.fr','malei145@yahoo.com.cn','lin-lin-0377@163.com','1390119@139.com','chenpeng147@sohu.com','chenxinying145@163.com','wukai88@136.com','mrlarrypowel@yahoo.co.uk','luismiguel70@yahoo.es','pablo@poctalum.net','xepasal@gmail.com','luisnadov@hotmail.com','richardmanby@silversattime.com','carlos@vnexport.es','eeeesette@tiscali.it','crifin@cnstacurva.com','15810365717@139.om','xiaozou-aimeili@hotmail.com','sgtabolilla@hotmail.com','ricardobianchini@terra.com.br4','julio.llamo@klingspon.es','norelisalva123@hotmail.com','yponcean@hotmail.com','williiam_0084@hotmail.com','alessandraprest@yahoo.it','gtalleri@gmail.com.br3','linavillaverde2@hotmail.com','carmennovel@hotmail.com','zrsardinha@hotmail.com.br','maf.ichasoan@planet.t','flesprin@gmail.com','djorlan@hotmail.com','rpmerimo@yahoo.es','alba-cabo@hotmail.com','gnrybpm@yahoo.com','lanvic11@hotmail.com','abaggefilho@terra.com.br3','silvia@nacscosmeticos.com.br1','ignaciolajarza@yahoo.es','abaggefilho@terra1.com.br','vlinkgo@hotmail.com','lrsardinha@hotmail.com.br','magdag27@hotmail.com','sanchiz@botegascastano.com','mmorfila@ibsalut.caib','simona.catanero@tin.it','abaggefilho@terra.com.br.6','ministerioevangelicoraulynjante@hotmail.com','iguasi@vesitges.com','bellisimabillon@gmail.com','ministerioevangelicoraulynjante2@hotmail.com','ministerioevangelicoraulynjante3@hotmail.com','massibi79@hotmail.it','j.hanlet@hotmail.com','m@h.com.br','lyerly@aol.com','alex.jdunning@btinternet.com','pamirom9@hotmail.com','anaelirr@yahoo.com','beatriz51515@hotmail.com','erodriguez@blindeca.com','terry@abtec-eng.co','judithmartinez@prensa.com','judithmartinez@aprensa.hn','peter@abtec-eng.co','cvillarreal3049@students.leredo.edu','marcode@br.com.br','hilton@br.com.br4','mauroalm@br.com.br4','velascosvastiduos@hotmail.com','bogotamonica@yahoo.com.co','jmanzano@inciativasbcn.com','campomarta1@hotmail.com','gregorreece@mail.com','hilton@br.com.br5','hilton@br.com.br6','jjstivel@senado.gov.br','ciro.santalucia@terra.com.br6','alberto10@globo.com6','claramoun1@yahoo.com','alberto10@globo.com7','josejoaojr@copperfrigu.com.br','avedolin@yahoo.com.br9','cgm.godoijunior@hotmail.com','alberto10@globo.com9','marconde@br.com.br9','alberto10@globo.com4','ciro.santalucia@terra.com.br9','ciro.santalucia@terra.com.br4','avedolin@yahoo.com.br1','victornavas@cable.net.com','pablo@villamichele.net','eaustin@flowtrinidad.net','claramoun12@yahoo.com','marconde@br.com.br1','alejandro@morbidoni.com','amauricgalvao@hotmail.com4','avedolin@yahoo.com.br3','claramunt2@yahoo.com','alberto10@globo.com8','silvia@netsite.com.br.3','novaes@hotmail.com.r','cordycom@gmail.com','rene@bauance.com.br','silvia@netsoite.com.b','durval@marrj.com.br','luisio728@yahoo.com','aaamaya_mendoza@hotmail.com','marisela@mora.com','sarahn.ackbarali@hotmail.com','dleitzalar@yahoo.com','rene@bauance.com.br5','rosales1@yahoo.com','flavia@studio.cerri.com.br','aliyya_shakeer@hotmail.com','fmofarreje@hotmail.com.br','krcsilva@gmail.com.br','riancerdeira@gmail.com.br','marthairma@yahoo.com.mx','sharon_deronique@hotmail.com','atendimento@kamiline.com.br1','novaes@hotmail.com.br6','victoralfaro0216@yahoo.com','apgsantos@gmail.com.br','fmofarreje@hotmail.com','angelica-mar@uol.com.br1','angelica-mar@uol.com.br2','elijay60@gmail.com','priloaguiar@hotmail.com','priloaguiar@hotmail.comb'))
| C:\webRoot\Silverpop\CFC\Silverpop.cfc | 0 | hmcclub | | qUpdateUndeliverables | 0 |
UPDATE ghr_members
SET stale_flg = 1
WHERE lower(email1) IN ('alan0135@yahoo.com.my','zhangxianjiang@icmbc.com.cn','albajenning@optusnet.com.au','louise.ibanaz@yahoo.com.ph','rgrgrhtjyudgdfdg@126.com','afsd_ng@yahoo.com','zhangweijun@yahoo.com','ob@yahoo.com','khaw12234@yahoo.com','13708978656@139.com','crissysison@rocketmail.com.p','chienchuping@yahoo.com.tw','fjy92@263.net','lmv@yahoo.com','yangyubing@vip.163.com','fr_snti@yahoo.com.ph','146594@qq.com','tn@yahoo.com','chenty0766@sohu.com','lencite@263.net','vwong12345@yahoo.com','13853205575@139.com','sinhua@yahoo.com','joelle168@yahoo.com.cn','beautiful.rain@leto.eonet.ne.jp','16569848@qq.com','whs@yahoo.com','liujing_bj@chinastock.com','kaicheing@yahoo.com','thelmalagrimas@yahoo.com.ph','mei@qq.com','sandypery@yahoo.com.ph','pfmary@163.com','jeri3jer@hotmail.com','113678414@163.com','24997804@qq.com','13924972738@139.com','hywan2@163.com','at23@yahoo.com','13823116362@139.com','ganhong@hotmail.com','wuqi@yahoo.com','loewiov@163.net','rebeccachung333@yahoo.com.hk','jwkboy@yahoo.com.hk','summerueml@hotmail.com','pyhpan3388@yahoo.com','13906023559@139.com','jnszpxw@163.com','atty_victor@yahoo.c','yuyongchun156@163.com','zgql_mmsq@sohu.com','rgaoz@ford.com','lilylihome@hotmail.com','liangyuehong@sohu.com','zhupeijing11@126.com','5239432912323@qq.com','huasheng@136.com','shizss@263.net','15986694828@139.com','shengcai777@136.com','13827480321@139.com','trisica-ph@hotmail.com','luoxiaogang145@sohu.com','zhangxi145@126.com','huangshufen@sohu.com','yongguangsu@163.com','ubt104@gmail.com','panlilei@sohu.com','hlm0501@126.com','zhangajun156@126.com','linlin-0377@126.com','13666651879@139.com','liuzhouming126@126.com','13757179349@139.com','13957166606@139.com','dongyuewu111@beijingdics.com','yuuie00@163.com','13306537071@139.com','wangzheng@163.net','cjesly@163.com','13802237859@139.com','g.christophe321@alice.fr','malei145@yahoo.com.cn','lin-lin-0377@163.com','1390119@139.com','chenpeng147@sohu.com','chenxinying145@163.com','wukai88@136.com','mrlarrypowel@yahoo.co.uk','luismiguel70@yahoo.es','pablo@poctalum.net','xepasal@gmail.com','luisnadov@hotmail.com','richardmanby@silversattime.com','carlos@vnexport.es','eeeesette@tiscali.it','crifin@cnstacurva.com','15810365717@139.om','xiaozou-aimeili@hotmail.com','sgtabolilla@hotmail.com','ricardobianchini@terra.com.br4','julio.llamo@klingspon.es','norelisalva123@hotmail.com','yponcean@hotmail.com','williiam_0084@hotmail.com','alessandraprest@yahoo.it','gtalleri@gmail.com.br3','linavillaverde2@hotmail.com','carmennovel@hotmail.com','zrsardinha@hotmail.com.br','maf.ichasoan@planet.t','flesprin@gmail.com','djorlan@hotmail.com','rpmerimo@yahoo.es','alba-cabo@hotmail.com','gnrybpm@yahoo.com','lanvic11@hotmail.com','abaggefilho@terra.com.br3','silvia@nacscosmeticos.com.br1','ignaciolajarza@yahoo.es','abaggefilho@terra1.com.br','vlinkgo@hotmail.com','lrsardinha@hotmail.com.br','magdag27@hotmail.com','sanchiz@botegascastano.com','mmorfila@ibsalut.caib','simona.catanero@tin.it','abaggefilho@terra.com.br.6','ministerioevangelicoraulynjante@hotmail.com','iguasi@vesitges.com','bellisimabillon@gmail.com','ministerioevangelicoraulynjante2@hotmail.com','ministerioevangelicoraulynjante3@hotmail.com','massibi79@hotmail.it','j.hanlet@hotmail.com','m@h.com.br','lyerly@aol.com','alex.jdunning@btinternet.com','pamirom9@hotmail.com','anaelirr@yahoo.com','beatriz51515@hotmail.com','erodriguez@blindeca.com','terry@abtec-eng.co','judithmartinez@prensa.com','judithmartinez@aprensa.hn','peter@abtec-eng.co','cvillarreal3049@students.leredo.edu','marcode@br.com.br','hilton@br.com.br4','mauroalm@br.com.br4','velascosvastiduos@hotmail.com','bogotamonica@yahoo.com.co','jmanzano@inciativasbcn.com','campomarta1@hotmail.com','gregorreece@mail.com','hilton@br.com.br5','hilton@br.com.br6','jjstivel@senado.gov.br','ciro.santalucia@terra.com.br6','alberto10@globo.com6','claramoun1@yahoo.com','alberto10@globo.com7','josejoaojr@copperfrigu.com.br','avedolin@yahoo.com.br9','cgm.godoijunior@hotmail.com','alberto10@globo.com9','marconde@br.com.br9','alberto10@globo.com4','ciro.santalucia@terra.com.br9','ciro.santalucia@terra.com.br4','avedolin@yahoo.com.br1','victornavas@cable.net.com','pablo@villamichele.net','eaustin@flowtrinidad.net','claramoun12@yahoo.com','marconde@br.com.br1','alejandro@morbidoni.com','amauricgalvao@hotmail.com4','avedolin@yahoo.com.br3','claramunt2@yahoo.com','alberto10@globo.com8','silvia@netsite.com.br.3','novaes@hotmail.com.r','cordycom@gmail.com','rene@bauance.com.br','silvia@netsoite.com.b','durval@marrj.com.br','luisio728@yahoo.com','aaamaya_mendoza@hotmail.com','marisela@mora.com','sarahn.ackbarali@hotmail.com','dleitzalar@yahoo.com','rene@bauance.com.br5','rosales1@yahoo.com','flavia@studio.cerri.com.br','aliyya_shakeer@hotmail.com','fmofarreje@hotmail.com.br','krcsilva@gmail.com.br','riancerdeira@gmail.com.br','marthairma@yahoo.com.mx','sharon_deronique@hotmail.com','atendimento@kamiline.com.br1','novaes@hotmail.com.br6','victoralfaro0216@yahoo.com','apgsantos@gmail.com.br','fmofarreje@hotmail.com','angelica-mar@uol.com.br1','angelica-mar@uol.com.br2','elijay60@gmail.com','priloaguiar@hotmail.com','priloaguiar@hotmail.comb')
| C:\webRoot\Silverpop\CFC\Silverpop.cfc | 0 | vhr_members | | qUpdateBatch | 0 |
UPDATE members_stale_flg_batches
SET status = 1
WHERE list_id = 11341444
| C:\webRoot\Silverpop\CFC\Silverpop.cfc | 0 | hmcclub | | qUserId | 0 |
SELECT account_id
FROM cm_silverpop_users
WHERE user_id = 'gorlap2@clubhotel.com'
| C:\webRoot\Silverpop\CFC\Silverpop.cfc | 1 | hmcclub | | qUserId | 0 |
SELECT silverpop_ftp_pwd
FROM cm_silverpop_users
WHERE user_id = 'gorlap2@clubhotel.com'
| C:\webRoot\Silverpop\CFC\Silverpop.cfc | 1 | hmcclub | | qUpdateUndeliverables | 0 |
UPDATE members
SET stale_flg = 1
WHERE lower(email1) IN ('alan0135@yahoo.com.my','zhangxianjiang@icmbc.com.cn','albajenning@optusnet.com.au','louise.ibanaz@yahoo.com.ph','rgrgrhtjyudgdfdg@126.com','afsd_ng@yahoo.com','zhangweijun@yahoo.com','ob@yahoo.com','khaw12234@yahoo.com','13708978656@139.com','crissysison@rocketmail.com.p','chienchuping@yahoo.com.tw','fjy92@263.net','lmv@yahoo.com','yangyubing@vip.163.com','fr_snti@yahoo.com.ph','146594@qq.com','tn@yahoo.com','chenty0766@sohu.com','lencite@263.net','vwong12345@yahoo.com','13853205575@139.com','sinhua@yahoo.com','joelle168@yahoo.com.cn','beautiful.rain@leto.eonet.ne.jp','16569848@qq.com','whs@yahoo.com','liujing_bj@chinastock.com','kaicheing@yahoo.com','thelmalagrimas@yahoo.com.ph','mei@qq.com','sandypery@yahoo.com.ph','pfmary@163.com','jeri3jer@hotmail.com','113678414@163.com','24997804@qq.com','13924972738@139.com','hywan2@163.com','at23@yahoo.com','13823116362@139.com','ganhong@hotmail.com','wuqi@yahoo.com','loewiov@163.net','rebeccachung333@yahoo.com.hk','jwkboy@yahoo.com.hk','summerueml@hotmail.com','pyhpan3388@yahoo.com','13906023559@139.com','jnszpxw@163.com','atty_victor@yahoo.c','yuyongchun156@163.com','zgql_mmsq@sohu.com','rgaoz@ford.com','lilylihome@hotmail.com','liangyuehong@sohu.com','zhupeijing11@126.com','5239432912323@qq.com','huasheng@136.com','shizss@263.net','15986694828@139.com','shengcai777@136.com','13827480321@139.com','trisica-ph@hotmail.com','luoxiaogang145@sohu.com','zhangxi145@126.com','huangshufen@sohu.com','yongguangsu@163.com','ubt104@gmail.com','panlilei@sohu.com','hlm0501@126.com','zhangajun156@126.com','linlin-0377@126.com','13666651879@139.com','liuzhouming126@126.com','13757179349@139.com','13957166606@139.com','dongyuewu111@beijingdics.com','yuuie00@163.com','13306537071@139.com','wangzheng@163.net','cjesly@163.com','13802237859@139.com','g.christophe321@alice.fr','malei145@yahoo.com.cn','lin-lin-0377@163.com','1390119@139.com','chenpeng147@sohu.com','chenxinying145@163.com','wukai88@136.com','mrlarrypowel@yahoo.co.uk','luismiguel70@yahoo.es','pablo@poctalum.net','xepasal@gmail.com','luisnadov@hotmail.com','richardmanby@silversattime.com','carlos@vnexport.es','eeeesette@tiscali.it','crifin@cnstacurva.com','15810365717@139.om','xiaozou-aimeili@hotmail.com','sgtabolilla@hotmail.com','ricardobianchini@terra.com.br4','julio.llamo@klingspon.es','norelisalva123@hotmail.com','yponcean@hotmail.com','williiam_0084@hotmail.com','alessandraprest@yahoo.it','gtalleri@gmail.com.br3','linavillaverde2@hotmail.com','carmennovel@hotmail.com','zrsardinha@hotmail.com.br','maf.ichasoan@planet.t','flesprin@gmail.com','djorlan@hotmail.com','rpmerimo@yahoo.es','alba-cabo@hotmail.com','gnrybpm@yahoo.com','lanvic11@hotmail.com','abaggefilho@terra.com.br3','silvia@nacscosmeticos.com.br1','ignaciolajarza@yahoo.es','abaggefilho@terra1.com.br','vlinkgo@hotmail.com','lrsardinha@hotmail.com.br','magdag27@hotmail.com','sanchiz@botegascastano.com','mmorfila@ibsalut.caib','simona.catanero@tin.it','abaggefilho@terra.com.br.6','ministerioevangelicoraulynjante@hotmail.com','iguasi@vesitges.com','bellisimabillon@gmail.com','ministerioevangelicoraulynjante2@hotmail.com','ministerioevangelicoraulynjante3@hotmail.com','massibi79@hotmail.it','j.hanlet@hotmail.com','m@h.com.br','lyerly@aol.com','alex.jdunning@btinternet.com','pamirom9@hotmail.com','anaelirr@yahoo.com','beatriz51515@hotmail.com','erodriguez@blindeca.com','terry@abtec-eng.co','judithmartinez@prensa.com','judithmartinez@aprensa.hn','peter@abtec-eng.co','cvillarreal3049@students.leredo.edu','marcode@br.com.br','hilton@br.com.br4','mauroalm@br.com.br4','velascosvastiduos@hotmail.com','bogotamonica@yahoo.com.co','jmanzano@inciativasbcn.com','campomarta1@hotmail.com','gregorreece@mail.com','hilton@br.com.br5','hilton@br.com.br6','jjstivel@senado.gov.br','ciro.santalucia@terra.com.br6','alberto10@globo.com6','claramoun1@yahoo.com','alberto10@globo.com7','josejoaojr@copperfrigu.com.br','avedolin@yahoo.com.br9','cgm.godoijunior@hotmail.com','alberto10@globo.com9','marconde@br.com.br9','alberto10@globo.com4','ciro.santalucia@terra.com.br9','ciro.santalucia@terra.com.br4','avedolin@yahoo.com.br1','victornavas@cable.net.com','pablo@villamichele.net','eaustin@flowtrinidad.net','claramoun12@yahoo.com','marconde@br.com.br1','alejandro@morbidoni.com','amauricgalvao@hotmail.com4','avedolin@yahoo.com.br3','claramunt2@yahoo.com','alberto10@globo.com8','silvia@netsite.com.br.3','novaes@hotmail.com.r','cordycom@gmail.com','rene@bauance.com.br','silvia@netsoite.com.b','durval@marrj.com.br','luisio728@yahoo.com','aaamaya_mendoza@hotmail.com','marisela@mora.com','sarahn.ackbarali@hotmail.com','dleitzalar@yahoo.com','rene@bauance.com.br5','rosales1@yahoo.com','flavia@studio.cerri.com.br','aliyya_shakeer@hotmail.com','fmofarreje@hotmail.com.br','krcsilva@gmail.com.br','riancerdeira@gmail.com.br','marthairma@yahoo.com.mx','sharon_deronique@hotmail.com','atendimento@kamiline.com.br1','novaes@hotmail.com.br6','victoralfaro0216@yahoo.com','apgsantos@gmail.com.br','fmofarreje@hotmail.com','angelica-mar@uol.com.br1','angelica-mar@uol.com.br2','elijay60@gmail.com','priloaguiar@hotmail.com','priloaguiar@hotmail.comb')
| C:\webRoot\Silverpop\CFC\Silverpop.cfc | 0 | hmcclub | | qInsertStaleFlagUpdate | 0 |
INSERT INTO members_stale_flg_updates
(SELECT NULL AS UPD_ID,
MEMBER_ID,
1 AS STL_FLG,
SYSDATE AS DT,
'C' AS type
FROM members
WHERE lower(email1) IN ('alan0135@yahoo.com.my','zhangxianjiang@icmbc.com.cn','albajenning@optusnet.com.au','louise.ibanaz@yahoo.com.ph','rgrgrhtjyudgdfdg@126.com','afsd_ng@yahoo.com','zhangweijun@yahoo.com','ob@yahoo.com','khaw12234@yahoo.com','13708978656@139.com','crissysison@rocketmail.com.p','chienchuping@yahoo.com.tw','fjy92@263.net','lmv@yahoo.com','yangyubing@vip.163.com','fr_snti@yahoo.com.ph','146594@qq.com','tn@yahoo.com','chenty0766@sohu.com','lencite@263.net','vwong12345@yahoo.com','13853205575@139.com','sinhua@yahoo.com','joelle168@yahoo.com.cn','beautiful.rain@leto.eonet.ne.jp','16569848@qq.com','whs@yahoo.com','liujing_bj@chinastock.com','kaicheing@yahoo.com','thelmalagrimas@yahoo.com.ph','mei@qq.com','sandypery@yahoo.com.ph','pfmary@163.com','jeri3jer@hotmail.com','113678414@163.com','24997804@qq.com','13924972738@139.com','hywan2@163.com','at23@yahoo.com','13823116362@139.com','ganhong@hotmail.com','wuqi@yahoo.com','loewiov@163.net','rebeccachung333@yahoo.com.hk','jwkboy@yahoo.com.hk','summerueml@hotmail.com','pyhpan3388@yahoo.com','13906023559@139.com','jnszpxw@163.com','atty_victor@yahoo.c','yuyongchun156@163.com','zgql_mmsq@sohu.com','rgaoz@ford.com','lilylihome@hotmail.com','liangyuehong@sohu.com','zhupeijing11@126.com','5239432912323@qq.com','huasheng@136.com','shizss@263.net','15986694828@139.com','shengcai777@136.com','13827480321@139.com','trisica-ph@hotmail.com','luoxiaogang145@sohu.com','zhangxi145@126.com','huangshufen@sohu.com','yongguangsu@163.com','ubt104@gmail.com','panlilei@sohu.com','hlm0501@126.com','zhangajun156@126.com','linlin-0377@126.com','13666651879@139.com','liuzhouming126@126.com','13757179349@139.com','13957166606@139.com','dongyuewu111@beijingdics.com','yuuie00@163.com','13306537071@139.com','wangzheng@163.net','cjesly@163.com','13802237859@139.com','g.christophe321@alice.fr','malei145@yahoo.com.cn','lin-lin-0377@163.com','1390119@139.com','chenpeng147@sohu.com','chenxinying145@163.com','wukai88@136.com','mrlarrypowel@yahoo.co.uk','luismiguel70@yahoo.es','pablo@poctalum.net','xepasal@gmail.com','luisnadov@hotmail.com','richardmanby@silversattime.com','carlos@vnexport.es','eeeesette@tiscali.it','crifin@cnstacurva.com','15810365717@139.om','xiaozou-aimeili@hotmail.com','sgtabolilla@hotmail.com','ricardobianchini@terra.com.br4','julio.llamo@klingspon.es','norelisalva123@hotmail.com','yponcean@hotmail.com','williiam_0084@hotmail.com','alessandraprest@yahoo.it','gtalleri@gmail.com.br3','linavillaverde2@hotmail.com','carmennovel@hotmail.com','zrsardinha@hotmail.com.br','maf.ichasoan@planet.t','flesprin@gmail.com','djorlan@hotmail.com','rpmerimo@yahoo.es','alba-cabo@hotmail.com','gnrybpm@yahoo.com','lanvic11@hotmail.com','abaggefilho@terra.com.br3','silvia@nacscosmeticos.com.br1','ignaciolajarza@yahoo.es','abaggefilho@terra1.com.br','vlinkgo@hotmail.com','lrsardinha@hotmail.com.br','magdag27@hotmail.com','sanchiz@botegascastano.com','mmorfila@ibsalut.caib','simona.catanero@tin.it','abaggefilho@terra.com.br.6','ministerioevangelicoraulynjante@hotmail.com','iguasi@vesitges.com','bellisimabillon@gmail.com','ministerioevangelicoraulynjante2@hotmail.com','ministerioevangelicoraulynjante3@hotmail.com','massibi79@hotmail.it','j.hanlet@hotmail.com','m@h.com.br','lyerly@aol.com','alex.jdunning@btinternet.com','pamirom9@hotmail.com','anaelirr@yahoo.com','beatriz51515@hotmail.com','erodriguez@blindeca.com','terry@abtec-eng.co','judithmartinez@prensa.com','judithmartinez@aprensa.hn','peter@abtec-eng.co','cvillarreal3049@students.leredo.edu','marcode@br.com.br','hilton@br.com.br4','mauroalm@br.com.br4','velascosvastiduos@hotmail.com','bogotamonica@yahoo.com.co','jmanzano@inciativasbcn.com','campomarta1@hotmail.com','gregorreece@mail.com','hilton@br.com.br5','hilton@br.com.br6','jjstivel@senado.gov.br','ciro.santalucia@terra.com.br6','alberto10@globo.com6','claramoun1@yahoo.com','alberto10@globo.com7','josejoaojr@copperfrigu.com.br','avedolin@yahoo.com.br9','cgm.godoijunior@hotmail.com','alberto10@globo.com9','marconde@br.com.br9','alberto10@globo.com4','ciro.santalucia@terra.com.br9','ciro.santalucia@terra.com.br4','avedolin@yahoo.com.br1','victornavas@cable.net.com','pablo@villamichele.net','eaustin@flowtrinidad.net','claramoun12@yahoo.com','marconde@br.com.br1','alejandro@morbidoni.com','amauricgalvao@hotmail.com4','avedolin@yahoo.com.br3','claramunt2@yahoo.com','alberto10@globo.com8','silvia@netsite.com.br.3','novaes@hotmail.com.r','cordycom@gmail.com','rene@bauance.com.br','silvia@netsoite.com.b','durval@marrj.com.br','luisio728@yahoo.com','aaamaya_mendoza@hotmail.com','marisela@mora.com','sarahn.ackbarali@hotmail.com','dleitzalar@yahoo.com','rene@bauance.com.br5','rosales1@yahoo.com','flavia@studio.cerri.com.br','aliyya_shakeer@hotmail.com','fmofarreje@hotmail.com.br','krcsilva@gmail.com.br','riancerdeira@gmail.com.br','marthairma@yahoo.com.mx','sharon_deronique@hotmail.com','atendimento@kamiline.com.br1','novaes@hotmail.com.br6','victoralfaro0216@yahoo.com','apgsantos@gmail.com.br','fmofarreje@hotmail.com','angelica-mar@uol.com.br1','angelica-mar@uol.com.br2','elijay60@gmail.com','priloaguiar@hotmail.com','priloaguiar@hotmail.comb'))
| C:\webRoot\Silverpop\CFC\Silverpop.cfc | 0 | hmcclub | | qUpdateUndeliverables | 0 |
UPDATE ghr_members
SET stale_flg = 1
WHERE lower(email1) IN ('alan0135@yahoo.com.my','zhangxianjiang@icmbc.com.cn','albajenning@optusnet.com.au','louise.ibanaz@yahoo.com.ph','rgrgrhtjyudgdfdg@126.com','afsd_ng@yahoo.com','zhangweijun@yahoo.com','ob@yahoo.com','khaw12234@yahoo.com','13708978656@139.com','crissysison@rocketmail.com.p','chienchuping@yahoo.com.tw','fjy92@263.net','lmv@yahoo.com','yangyubing@vip.163.com','fr_snti@yahoo.com.ph','146594@qq.com','tn@yahoo.com','chenty0766@sohu.com','lencite@263.net','vwong12345@yahoo.com','13853205575@139.com','sinhua@yahoo.com','joelle168@yahoo.com.cn','beautiful.rain@leto.eonet.ne.jp','16569848@qq.com','whs@yahoo.com','liujing_bj@chinastock.com','kaicheing@yahoo.com','thelmalagrimas@yahoo.com.ph','mei@qq.com','sandypery@yahoo.com.ph','pfmary@163.com','jeri3jer@hotmail.com','113678414@163.com','24997804@qq.com','13924972738@139.com','hywan2@163.com','at23@yahoo.com','13823116362@139.com','ganhong@hotmail.com','wuqi@yahoo.com','loewiov@163.net','rebeccachung333@yahoo.com.hk','jwkboy@yahoo.com.hk','summerueml@hotmail.com','pyhpan3388@yahoo.com','13906023559@139.com','jnszpxw@163.com','atty_victor@yahoo.c','yuyongchun156@163.com','zgql_mmsq@sohu.com','rgaoz@ford.com','lilylihome@hotmail.com','liangyuehong@sohu.com','zhupeijing11@126.com','5239432912323@qq.com','huasheng@136.com','shizss@263.net','15986694828@139.com','shengcai777@136.com','13827480321@139.com','trisica-ph@hotmail.com','luoxiaogang145@sohu.com','zhangxi145@126.com','huangshufen@sohu.com','yongguangsu@163.com','ubt104@gmail.com','panlilei@sohu.com','hlm0501@126.com','zhangajun156@126.com','linlin-0377@126.com','13666651879@139.com','liuzhouming126@126.com','13757179349@139.com','13957166606@139.com','dongyuewu111@beijingdics.com','yuuie00@163.com','13306537071@139.com','wangzheng@163.net','cjesly@163.com','13802237859@139.com','g.christophe321@alice.fr','malei145@yahoo.com.cn','lin-lin-0377@163.com','1390119@139.com','chenpeng147@sohu.com','chenxinying145@163.com','wukai88@136.com','mrlarrypowel@yahoo.co.uk','luismiguel70@yahoo.es','pablo@poctalum.net','xepasal@gmail.com','luisnadov@hotmail.com','richardmanby@silversattime.com','carlos@vnexport.es','eeeesette@tiscali.it','crifin@cnstacurva.com','15810365717@139.om','xiaozou-aimeili@hotmail.com','sgtabolilla@hotmail.com','ricardobianchini@terra.com.br4','julio.llamo@klingspon.es','norelisalva123@hotmail.com','yponcean@hotmail.com','williiam_0084@hotmail.com','alessandraprest@yahoo.it','gtalleri@gmail.com.br3','linavillaverde2@hotmail.com','carmennovel@hotmail.com','zrsardinha@hotmail.com.br','maf.ichasoan@planet.t','flesprin@gmail.com','djorlan@hotmail.com','rpmerimo@yahoo.es','alba-cabo@hotmail.com','gnrybpm@yahoo.com','lanvic11@hotmail.com','abaggefilho@terra.com.br3','silvia@nacscosmeticos.com.br1','ignaciolajarza@yahoo.es','abaggefilho@terra1.com.br','vlinkgo@hotmail.com','lrsardinha@hotmail.com.br','magdag27@hotmail.com','sanchiz@botegascastano.com','mmorfila@ibsalut.caib','simona.catanero@tin.it','abaggefilho@terra.com.br.6','ministerioevangelicoraulynjante@hotmail.com','iguasi@vesitges.com','bellisimabillon@gmail.com','ministerioevangelicoraulynjante2@hotmail.com','ministerioevangelicoraulynjante3@hotmail.com','massibi79@hotmail.it','j.hanlet@hotmail.com','m@h.com.br','lyerly@aol.com','alex.jdunning@btinternet.com','pamirom9@hotmail.com','anaelirr@yahoo.com','beatriz51515@hotmail.com','erodriguez@blindeca.com','terry@abtec-eng.co','judithmartinez@prensa.com','judithmartinez@aprensa.hn','peter@abtec-eng.co','cvillarreal3049@students.leredo.edu','marcode@br.com.br','hilton@br.com.br4','mauroalm@br.com.br4','velascosvastiduos@hotmail.com','bogotamonica@yahoo.com.co','jmanzano@inciativasbcn.com','campomarta1@hotmail.com','gregorreece@mail.com','hilton@br.com.br5','hilton@br.com.br6','jjstivel@senado.gov.br','ciro.santalucia@terra.com.br6','alberto10@globo.com6','claramoun1@yahoo.com','alberto10@globo.com7','josejoaojr@copperfrigu.com.br','avedolin@yahoo.com.br9','cgm.godoijunior@hotmail.com','alberto10@globo.com9','marconde@br.com.br9','alberto10@globo.com4','ciro.santalucia@terra.com.br9','ciro.santalucia@terra.com.br4','avedolin@yahoo.com.br1','victornavas@cable.net.com','pablo@villamichele.net','eaustin@flowtrinidad.net','claramoun12@yahoo.com','marconde@br.com.br1','alejandro@morbidoni.com','amauricgalvao@hotmail.com4','avedolin@yahoo.com.br3','claramunt2@yahoo.com','alberto10@globo.com8','silvia@netsite.com.br.3','novaes@hotmail.com.r','cordycom@gmail.com','rene@bauance.com.br','silvia@netsoite.com.b','durval@marrj.com.br','luisio728@yahoo.com','aaamaya_mendoza@hotmail.com','marisela@mora.com','sarahn.ackbarali@hotmail.com','dleitzalar@yahoo.com','rene@bauance.com.br5','rosales1@yahoo.com','flavia@studio.cerri.com.br','aliyya_shakeer@hotmail.com','fmofarreje@hotmail.com.br','krcsilva@gmail.com.br','riancerdeira@gmail.com.br','marthairma@yahoo.com.mx','sharon_deronique@hotmail.com','atendimento@kamiline.com.br1','novaes@hotmail.com.br6','victoralfaro0216@yahoo.com','apgsantos@gmail.com.br','fmofarreje@hotmail.com','angelica-mar@uol.com.br1','angelica-mar@uol.com.br2','elijay60@gmail.com','priloaguiar@hotmail.com','priloaguiar@hotmail.comb')
| C:\webRoot\Silverpop\CFC\Silverpop.cfc | 0 | vhr_members | | qUpdateBatch | 0 |
UPDATE members_stale_flg_batches
SET status = 1
WHERE list_id = 11341445
| C:\webRoot\Silverpop\CFC\Silverpop.cfc | 0 | hmcclub |
|
| | timers | | Query | | Execution Time (ms) | 0 | | recordcount | 0 | | cached | No | | result | |
| | history | | Query | | Execution Time (ms) | 0 | | recordcount | 5 | | cached | No | | result | | id | level | | 12213 | 1 | | 12214 | 2 | | 12215 | 3 | | 12216 | 2 | | 12221 | 1 |
|
|
|
| | 5 | | Struct | | ITOTAL | | | RECORDED | | Date Time | {ts '2010-03-13 03:00:16'} |
| | IPADDRESS | | | CALLEDURL | | string | /Application/Silverpop/schProcessUndeliverableBatches.cfm?RequestTimeout=50 |
| | DEBUGINFO | | Struct | | pages | | Query | | Execution Time (ms) | 0 | | recordcount | 5 | | cached | No | | result | | id | count | min | max | avg | app | load | query | total | src | | 12220 | 1 | 11516 | 11516 | 11516 | 11516 | 0 | 0 | 11516 | C:\webRoot\Silverpop\CFC\Silverpop.cfc$processUndeliverableBatches | | 12217 | 1 | 16 | 16 | 16 | 16 | 0 | 0 | 16 | C:\webRoot\Silverpop\schProcessUndeliverableBatches.cfm | | 12218 | 1 | 0 | 0 | 0 | 0 | 0 | 110 | 0 | C:\webRoot\Silverpop\CFC\Silverpop.cfc | | 12222 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | C:\Program Files\Railo\webapps\ROOT\WEB-INF\railo\context\templates\debugging\debugging-2-console.cfm | | 12219 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | C:\Program Files\Railo\webapps\ROOT\WEB-INF\railo\context\Component.cfc |
|
| | traces | | Query | | Execution Time (ms) | 0 | | recordcount | 0 | | cached | No | | result | | type | category | text | template | line | varname | varvalue | time |
|
| | queries | | Query | | Execution Time (ms) | 0 | | recordcount | 27 | | cached | No | | result | | name | time | sql | src | count | datasource | | qUserId | 16 |
SELECT account_id
FROM cm_silverpop_users
WHERE user_id = 'gorlap@clubhotel.com'
| C:\webRoot\Silverpop\CFC\Silverpop.cfc | 1 | hmcclub | | qUserId | 0 |
SELECT silverpop_marketer_pwd
FROM cm_silverpop_users
WHERE user_id = 'gorlap@clubhotel.com'
| C:\webRoot\Silverpop\CFC\Silverpop.cfc | 1 | hmcclub | | qBatches | 94 |
SELECT batch_id,
list_id,
file_path,
list_type
FROM members_stale_flg_batches
WHERE status = 0
| C:\webRoot\Silverpop\CFC\Silverpop.cfc | 4 | hmcclub | | qUserId | 0 |
SELECT account_id
FROM cm_silverpop_users
WHERE user_id = 'gorlap@clubhotel.com'
| C:\webRoot\Silverpop\CFC\Silverpop.cfc | 1 | hmcclub | | qUserId | 0 |
SELECT silverpop_ftp_pwd
FROM cm_silverpop_users
WHERE user_id = 'gorlap@clubhotel.com'
| C:\webRoot\Silverpop\CFC\Silverpop.cfc | 1 | hmcclub | | qUpdateUndeliverables | 0 |
UPDATE members
SET stale_flg = 1
WHERE lower(email1) IN ('jhjhjhj@ttyty.ll.ca','dfdfdf@iiiii.com','virgiliosousa@iol.pt','anne@edelmanleather.com','jdennis@blueyounder.co.uk','ngueynk@clubhotel.com','ycosta@teledata.mz')
| C:\webRoot\Silverpop\CFC\Silverpop.cfc | 0 | hmcclub | | qInsertStaleFlagUpdate | 0 |
INSERT INTO members_stale_flg_updates
(SELECT NULL AS UPD_ID,
MEMBER_ID,
1 AS STL_FLG,
SYSDATE AS DT,
'C' AS type
FROM members
WHERE lower(email1) IN ('jhjhjhj@ttyty.ll.ca','dfdfdf@iiiii.com','virgiliosousa@iol.pt','anne@edelmanleather.com','jdennis@blueyounder.co.uk','ngueynk@clubhotel.com','ycosta@teledata.mz'))
| C:\webRoot\Silverpop\CFC\Silverpop.cfc | 0 | hmcclub | | qUpdateUndeliverables | 0 |
UPDATE ghr_members
SET stale_flg = 1
WHERE lower(email1) IN ('jhjhjhj@ttyty.ll.ca','dfdfdf@iiiii.com','virgiliosousa@iol.pt','anne@edelmanleather.com','jdennis@blueyounder.co.uk','ngueynk@clubhotel.com','ycosta@teledata.mz')
| C:\webRoot\Silverpop\CFC\Silverpop.cfc | 0 | vhr_members | | qUpdateBatch | 0 |
UPDATE members_stale_flg_batches
SET status = 1
WHERE list_id = 11341334
| C:\webRoot\Silverpop\CFC\Silverpop.cfc | 0 | hmcclub | | qUserId | 0 |
SELECT account_id
FROM cm_silverpop_users
WHERE user_id = 'gorlap@clubhotel.com'
| C:\webRoot\Silverpop\CFC\Silverpop.cfc | 1 | hmcclub | | qUserId | 0 |
SELECT silverpop_ftp_pwd
FROM cm_silverpop_users
WHERE user_id = 'gorlap@clubhotel.com'
| C:\webRoot\Silverpop\CFC\Silverpop.cfc | 1 | hmcclub | | qUpdateUndeliverables | 0 |
UPDATE members
SET stale_flg = 1
WHERE lower(email1) IN ('jhjhjhj@ttyty.ll.ca','dfdfdf@iiiii.com','virgiliosousa@iol.pt','anne@edelmanleather.com','jdennis@blueyounder.co.uk','ngueynk@clubhotel.com','ycosta@teledata.mz')
| C:\webRoot\Silverpop\CFC\Silverpop.cfc | 0 | hmcclub | | qInsertStaleFlagUpdate | 0 |
INSERT INTO members_stale_flg_updates
(SELECT NULL AS UPD_ID,
MEMBER_ID,
1 AS STL_FLG,
SYSDATE AS DT,
'C' AS type
FROM members
WHERE lower(email1) IN ('jhjhjhj@ttyty.ll.ca','dfdfdf@iiiii.com','virgiliosousa@iol.pt','anne@edelmanleather.com','jdennis@blueyounder.co.uk','ngueynk@clubhotel.com','ycosta@teledata.mz'))
| C:\webRoot\Silverpop\CFC\Silverpop.cfc | 0 | hmcclub | | qUpdateUndeliverables | 0 |
UPDATE ghr_members
SET stale_flg = 1
WHERE lower(email1) IN ('jhjhjhj@ttyty.ll.ca','dfdfdf@iiiii.com','virgiliosousa@iol.pt','anne@edelmanleather.com','jdennis@blueyounder.co.uk','ngueynk@clubhotel.com','ycosta@teledata.mz')
| C:\webRoot\Silverpop\CFC\Silverpop.cfc | 0 | vhr_members | | qUpdateBatch | 0 |
UPDATE members_stale_flg_batches
SET status = 1
WHERE list_id = 11341335
| C:\webRoot\Silverpop\CFC\Silverpop.cfc | 0 | hmcclub | | qUserId | 0 |
SELECT account_id
FROM cm_silverpop_users
WHERE user_id = 'gorlap2@clubhotel.com'
| C:\webRoot\Silverpop\CFC\Silverpop.cfc | 1 | hmcclub | | qUserId | 0 |
SELECT silverpop_ftp_pwd
FROM cm_silverpop_users
WHERE user_id = 'gorlap2@clubhotel.com'
| C:\webRoot\Silverpop\CFC\Silverpop.cfc | 1 | hmcclub | | qUpdateUndeliverables | 0 |
UPDATE members
SET stale_flg = 1
WHERE lower(email1) IN ('alan0135@yahoo.com.my','zhangxianjiang@icmbc.com.cn','albajenning@optusnet.com.au','louise.ibanaz@yahoo.com.ph','rgrgrhtjyudgdfdg@126.com','afsd_ng@yahoo.com','zhangweijun@yahoo.com','ob@yahoo.com','khaw12234@yahoo.com','13708978656@139.com','crissysison@rocketmail.com.p','chienchuping@yahoo.com.tw','fjy92@263.net','lmv@yahoo.com','yangyubing@vip.163.com','fr_snti@yahoo.com.ph','146594@qq.com','tn@yahoo.com','chenty0766@sohu.com','lencite@263.net','vwong12345@yahoo.com','13853205575@139.com','sinhua@yahoo.com','joelle168@yahoo.com.cn','beautiful.rain@leto.eonet.ne.jp','16569848@qq.com','whs@yahoo.com','liujing_bj@chinastock.com','kaicheing@yahoo.com','thelmalagrimas@yahoo.com.ph','mei@qq.com','sandypery@yahoo.com.ph','pfmary@163.com','jeri3jer@hotmail.com','113678414@163.com','24997804@qq.com','13924972738@139.com','hywan2@163.com','at23@yahoo.com','13823116362@139.com','ganhong@hotmail.com','wuqi@yahoo.com','loewiov@163.net','rebeccachung333@yahoo.com.hk','jwkboy@yahoo.com.hk','summerueml@hotmail.com','pyhpan3388@yahoo.com','13906023559@139.com','jnszpxw@163.com','atty_victor@yahoo.c','yuyongchun156@163.com','zgql_mmsq@sohu.com','rgaoz@ford.com','lilylihome@hotmail.com','liangyuehong@sohu.com','zhupeijing11@126.com','5239432912323@qq.com','huasheng@136.com','shizss@263.net','15986694828@139.com','shengcai777@136.com','13827480321@139.com','trisica-ph@hotmail.com','luoxiaogang145@sohu.com','zhangxi145@126.com','huangshufen@sohu.com','yongguangsu@163.com','ubt104@gmail.com','panlilei@sohu.com','hlm0501@126.com','zhangajun156@126.com','linlin-0377@126.com','13666651879@139.com','liuzhouming126@126.com','13757179349@139.com','13957166606@139.com','dongyuewu111@beijingdics.com','yuuie00@163.com','13306537071@139.com','wangzheng@163.net','cjesly@163.com','13802237859@139.com','g.christophe321@alice.fr','malei145@yahoo.com.cn','lin-lin-0377@163.com','1390119@139.com','chenpeng147@sohu.com','chenxinying145@163.com','wukai88@136.com','mrlarrypowel@yahoo.co.uk','luismiguel70@yahoo.es','pablo@poctalum.net','xepasal@gmail.com','luisnadov@hotmail.com','richardmanby@silversattime.com','carlos@vnexport.es','eeeesette@tiscali.it','crifin@cnstacurva.com','15810365717@139.om','xiaozou-aimeili@hotmail.com','sgtabolilla@hotmail.com','ricardobianchini@terra.com.br4','julio.llamo@klingspon.es','norelisalva123@hotmail.com','yponcean@hotmail.com','williiam_0084@hotmail.com','alessandraprest@yahoo.it','gtalleri@gmail.com.br3','linavillaverde2@hotmail.com','carmennovel@hotmail.com','zrsardinha@hotmail.com.br','maf.ichasoan@planet.t','flesprin@gmail.com','djorlan@hotmail.com','rpmerimo@yahoo.es','alba-cabo@hotmail.com','gnrybpm@yahoo.com','lanvic11@hotmail.com','abaggefilho@terra.com.br3','silvia@nacscosmeticos.com.br1','ignaciolajarza@yahoo.es','abaggefilho@terra1.com.br','vlinkgo@hotmail.com','lrsardinha@hotmail.com.br','magdag27@hotmail.com','sanchiz@botegascastano.com','mmorfila@ibsalut.caib','simona.catanero@tin.it','abaggefilho@terra.com.br.6','ministerioevangelicoraulynjante@hotmail.com','iguasi@vesitges.com','bellisimabillon@gmail.com','ministerioevangelicoraulynjante2@hotmail.com','ministerioevangelicoraulynjante3@hotmail.com','massibi79@hotmail.it','j.hanlet@hotmail.com','m@h.com.br','lyerly@aol.com','alex.jdunning@btinternet.com','pamirom9@hotmail.com','anaelirr@yahoo.com','beatriz51515@hotmail.com','erodriguez@blindeca.com','terry@abtec-eng.co','judithmartinez@prensa.com','judithmartinez@aprensa.hn','peter@abtec-eng.co','cvillarreal3049@students.leredo.edu','marcode@br.com.br','hilton@br.com.br4','mauroalm@br.com.br4','velascosvastiduos@hotmail.com','bogotamonica@yahoo.com.co','jmanzano@inciativasbcn.com','campomarta1@hotmail.com','gregorreece@mail.com','hilton@br.com.br5','hilton@br.com.br6','jjstivel@senado.gov.br','ciro.santalucia@terra.com.br6','alberto10@globo.com6','claramoun1@yahoo.com','alberto10@globo.com7','josejoaojr@copperfrigu.com.br','avedolin@yahoo.com.br9','cgm.godoijunior@hotmail.com','alberto10@globo.com9','marconde@br.com.br9','alberto10@globo.com4','ciro.santalucia@terra.com.br9','ciro.santalucia@terra.com.br4','avedolin@yahoo.com.br1','victornavas@cable.net.com','pablo@villamichele.net','eaustin@flowtrinidad.net','claramoun12@yahoo.com','marconde@br.com.br1','alejandro@morbidoni.com','amauricgalvao@hotmail.com4','avedolin@yahoo.com.br3','claramunt2@yahoo.com','alberto10@globo.com8','silvia@netsite.com.br.3','novaes@hotmail.com.r','cordycom@gmail.com','rene@bauance.com.br','silvia@netsoite.com.b','durval@marrj.com.br','luisio728@yahoo.com','aaamaya_mendoza@hotmail.com','marisela@mora.com','sarahn.ackbarali@hotmail.com','dleitzalar@yahoo.com','rene@bauance.com.br5','rosales1@yahoo.com','flavia@studio.cerri.com.br','aliyya_shakeer@hotmail.com','fmofarreje@hotmail.com.br','krcsilva@gmail.com.br','riancerdeira@gmail.com.br','marthairma@yahoo.com.mx','sharon_deronique@hotmail.com','atendimento@kamiline.com.br1','novaes@hotmail.com.br6','victoralfaro0216@yahoo.com','apgsantos@gmail.com.br','fmofarreje@hotmail.com','angelica-mar@uol.com.br1','angelica-mar@uol.com.br2','elijay60@gmail.com','priloaguiar@hotmail.com','priloaguiar@hotmail.comb')
| C:\webRoot\Silverpop\CFC\Silverpop.cfc | 0 | hmcclub | | qInsertStaleFlagUpdate | 0 |
INSERT INTO members_stale_flg_updates
(SELECT NULL AS UPD_ID,
MEMBER_ID,
1 AS STL_FLG,
SYSDATE AS DT,
'C' AS type
FROM members
WHERE lower(email1) IN ('alan0135@yahoo.com.my','zhangxianjiang@icmbc.com.cn','albajenning@optusnet.com.au','louise.ibanaz@yahoo.com.ph','rgrgrhtjyudgdfdg@126.com','afsd_ng@yahoo.com','zhangweijun@yahoo.com','ob@yahoo.com','khaw12234@yahoo.com','13708978656@139.com','crissysison@rocketmail.com.p','chienchuping@yahoo.com.tw','fjy92@263.net','lmv@yahoo.com','yangyubing@vip.163.com','fr_snti@yahoo.com.ph','146594@qq.com','tn@yahoo.com','chenty0766@sohu.com','lencite@263.net','vwong12345@yahoo.com','13853205575@139.com','sinhua@yahoo.com','joelle168@yahoo.com.cn','beautiful.rain@leto.eonet.ne.jp','16569848@qq.com','whs@yahoo.com','liujing_bj@chinastock.com','kaicheing@yahoo.com','thelmalagrimas@yahoo.com.ph','mei@qq.com','sandypery@yahoo.com.ph','pfmary@163.com','jeri3jer@hotmail.com','113678414@163.com','24997804@qq.com','13924972738@139.com','hywan2@163.com','at23@yahoo.com','13823116362@139.com','ganhong@hotmail.com','wuqi@yahoo.com','loewiov@163.net','rebeccachung333@yahoo.com.hk','jwkboy@yahoo.com.hk','summerueml@hotmail.com','pyhpan3388@yahoo.com','13906023559@139.com','jnszpxw@163.com','atty_victor@yahoo.c','yuyongchun156@163.com','zgql_mmsq@sohu.com','rgaoz@ford.com','lilylihome@hotmail.com','liangyuehong@sohu.com','zhupeijing11@126.com','5239432912323@qq.com','huasheng@136.com','shizss@263.net','15986694828@139.com','shengcai777@136.com','13827480321@139.com','trisica-ph@hotmail.com','luoxiaogang145@sohu.com','zhangxi145@126.com','huangshufen@sohu.com','yongguangsu@163.com','ubt104@gmail.com','panlilei@sohu.com','hlm0501@126.com','zhangajun156@126.com','linlin-0377@126.com','13666651879@139.com','liuzhouming126@126.com','13757179349@139.com','13957166606@139.com','dongyuewu111@beijingdics.com','yuuie00@163.com','13306537071@139.com','wangzheng@163.net','cjesly@163.com','13802237859@139.com','g.christophe321@alice.fr','malei145@yahoo.com.cn','lin-lin-0377@163.com','1390119@139.com','chenpeng147@sohu.com','chenxinying145@163.com','wukai88@136.com','mrlarrypowel@yahoo.co.uk','luismiguel70@yahoo.es','pablo@poctalum.net','xepasal@gmail.com','luisnadov@hotmail.com','richardmanby@silversattime.com','carlos@vnexport.es','eeeesette@tiscali.it','crifin@cnstacurva.com','15810365717@139.om','xiaozou-aimeili@hotmail.com','sgtabolilla@hotmail.com','ricardobianchini@terra.com.br4','julio.llamo@klingspon.es','norelisalva123@hotmail.com','yponcean@hotmail.com','williiam_0084@hotmail.com','alessandraprest@yahoo.it','gtalleri@gmail.com.br3','linavillaverde2@hotmail.com','carmennovel@hotmail.com','zrsardinha@hotmail.com.br','maf.ichasoan@planet.t','flesprin@gmail.com','djorlan@hotmail.com','rpmerimo@yahoo.es','alba-cabo@hotmail.com','gnrybpm@yahoo.com','lanvic11@hotmail.com','abaggefilho@terra.com.br3','silvia@nacscosmeticos.com.br1','ignaciolajarza@yahoo.es','abaggefilho@terra1.com.br','vlinkgo@hotmail.com','lrsardinha@hotmail.com.br','magdag27@hotmail.com','sanchiz@botegascastano.com','mmorfila@ibsalut.caib','simona.catanero@tin.it','abaggefilho@terra.com.br.6','ministerioevangelicoraulynjante@hotmail.com','iguasi@vesitges.com','bellisimabillon@gmail.com','ministerioevangelicoraulynjante2@hotmail.com','ministerioevangelicoraulynjante3@hotmail.com','massibi79@hotmail.it','j.hanlet@hotmail.com','m@h.com.br','lyerly@aol.com','alex.jdunning@btinternet.com','pamirom9@hotmail.com','anaelirr@yahoo.com','beatriz51515@hotmail.com','erodriguez@blindeca.com','terry@abtec-eng.co','judithmartinez@prensa.com','judithmartinez@aprensa.hn','peter@abtec-eng.co','cvillarreal3049@students.leredo.edu','marcode@br.com.br','hilton@br.com.br4','mauroalm@br.com.br4','velascosvastiduos@hotmail.com','bogotamonica@yahoo.com.co','jmanzano@inciativasbcn.com','campomarta1@hotmail.com','gregorreece@mail.com','hilton@br.com.br5','hilton@br.com.br6','jjstivel@senado.gov.br','ciro.santalucia@terra.com.br6','alberto10@globo.com6','claramoun1@yahoo.com','alberto10@globo.com7','josejoaojr@copperfrigu.com.br','avedolin@yahoo.com.br9','cgm.godoijunior@hotmail.com','alberto10@globo.com9','marconde@br.com.br9','alberto10@globo.com4','ciro.santalucia@terra.com.br9','ciro.santalucia@terra.com.br4','avedolin@yahoo.com.br1','victornavas@cable.net.com','pablo@villamichele.net','eaustin@flowtrinidad.net','claramoun12@yahoo.com','marconde@br.com.br1','alejandro@morbidoni.com','amauricgalvao@hotmail.com4','avedolin@yahoo.com.br3','claramunt2@yahoo.com','alberto10@globo.com8','silvia@netsite.com.br.3','novaes@hotmail.com.r','cordycom@gmail.com','rene@bauance.com.br','silvia@netsoite.com.b','durval@marrj.com.br','luisio728@yahoo.com','aaamaya_mendoza@hotmail.com','marisela@mora.com','sarahn.ackbarali@hotmail.com','dleitzalar@yahoo.com','rene@bauance.com.br5','rosales1@yahoo.com','flavia@studio.cerri.com.br','aliyya_shakeer@hotmail.com','fmofarreje@hotmail.com.br','krcsilva@gmail.com.br','riancerdeira@gmail.com.br','marthairma@yahoo.com.mx','sharon_deronique@hotmail.com','atendimento@kamiline.com.br1','novaes@hotmail.com.br6','victoralfaro0216@yahoo.com','apgsantos@gmail.com.br','fmofarreje@hotmail.com','angelica-mar@uol.com.br1','angelica-mar@uol.com.br2','elijay60@gmail.com','priloaguiar@hotmail.com','priloaguiar@hotmail.comb'))
| C:\webRoot\Silverpop\CFC\Silverpop.cfc | 0 | hmcclub | | qUpdateUndeliverables | 0 |
UPDATE ghr_members
SET stale_flg = 1
WHERE lower(email1) IN ('alan0135@yahoo.com.my','zhangxianjiang@icmbc.com.cn','albajenning@optusnet.com.au','louise.ibanaz@yahoo.com.ph','rgrgrhtjyudgdfdg@126.com','afsd_ng@yahoo.com','zhangweijun@yahoo.com','ob@yahoo.com','khaw12234@yahoo.com','13708978656@139.com','crissysison@rocketmail.com.p','chienchuping@yahoo.com.tw','fjy92@263.net','lmv@yahoo.com','yangyubing@vip.163.com','fr_snti@yahoo.com.ph','146594@qq.com','tn@yahoo.com','chenty0766@sohu.com','lencite@263.net','vwong12345@yahoo.com','13853205575@139.com','sinhua@yahoo.com','joelle168@yahoo.com.cn','beautiful.rain@leto.eonet.ne.jp','16569848@qq.com','whs@yahoo.com','liujing_bj@chinastock.com','kaicheing@yahoo.com','thelmalagrimas@yahoo.com.ph','mei@qq.com','sandypery@yahoo.com.ph','pfmary@163.com','jeri3jer@hotmail.com','113678414@163.com','24997804@qq.com','13924972738@139.com','hywan2@163.com','at23@yahoo.com','13823116362@139.com','ganhong@hotmail.com','wuqi@yahoo.com','loewiov@163.net','rebeccachung333@yahoo.com.hk','jwkboy@yahoo.com.hk','summerueml@hotmail.com','pyhpan3388@yahoo.com','13906023559@139.com','jnszpxw@163.com','atty_victor@yahoo.c','yuyongchun156@163.com','zgql_mmsq@sohu.com','rgaoz@ford.com','lilylihome@hotmail.com','liangyuehong@sohu.com','zhupeijing11@126.com','5239432912323@qq.com','huasheng@136.com','shizss@263.net','15986694828@139.com','shengcai777@136.com','13827480321@139.com','trisica-ph@hotmail.com','luoxiaogang145@sohu.com','zhangxi145@126.com','huangshufen@sohu.com','yongguangsu@163.com','ubt104@gmail.com','panlilei@sohu.com','hlm0501@126.com','zhangajun156@126.com','linlin-0377@126.com','13666651879@139.com','liuzhouming126@126.com','13757179349@139.com','13957166606@139.com','dongyuewu111@beijingdics.com','yuuie00@163.com','13306537071@139.com','wangzheng@163.net','cjesly@163.com','13802237859@139.com','g.christophe321@alice.fr','malei145@yahoo.com.cn','lin-lin-0377@163.com','1390119@139.com','chenpeng147@sohu.com','chenxinying145@163.com','wukai88@136.com','mrlarrypowel@yahoo.co.uk','luismiguel70@yahoo.es','pablo@poctalum.net','xepasal@gmail.com','luisnadov@hotmail.com','richardmanby@silversattime.com','carlos@vnexport.es','eeeesette@tiscali.it','crifin@cnstacurva.com','15810365717@139.om','xiaozou-aimeili@hotmail.com','sgtabolilla@hotmail.com','ricardobianchini@terra.com.br4','julio.llamo@klingspon.es','norelisalva123@hotmail.com','yponcean@hotmail.com','williiam_0084@hotmail.com','alessandraprest@yahoo.it','gtalleri@gmail.com.br3','linavillaverde2@hotmail.com','carmennovel@hotmail.com','zrsardinha@hotmail.com.br','maf.ichasoan@planet.t','flesprin@gmail.com','djorlan@hotmail.com','rpmerimo@yahoo.es','alba-cabo@hotmail.com','gnrybpm@yahoo.com','lanvic11@hotmail.com','abaggefilho@terra.com.br3','silvia@nacscosmeticos.com.br1','ignaciolajarza@yahoo.es','abaggefilho@terra1.com.br','vlinkgo@hotmail.com','lrsardinha@hotmail.com.br','magdag27@hotmail.com','sanchiz@botegascastano.com','mmorfila@ibsalut.caib','simona.catanero@tin.it','abaggefilho@terra.com.br.6','ministerioevangelicoraulynjante@hotmail.com','iguasi@vesitges.com','bellisimabillon@gmail.com','ministerioevangelicoraulynjante2@hotmail.com','ministerioevangelicoraulynjante3@hotmail.com','massibi79@hotmail.it','j.hanlet@hotmail.com','m@h.com.br','lyerly@aol.com','alex.jdunning@btinternet.com','pamirom9@hotmail.com','anaelirr@yahoo.com','beatriz51515@hotmail.com','erodriguez@blindeca.com','terry@abtec-eng.co','judithmartinez@prensa.com','judithmartinez@aprensa.hn','peter@abtec-eng.co','cvillarreal3049@students.leredo.edu','marcode@br.com.br','hilton@br.com.br4','mauroalm@br.com.br4','velascosvastiduos@hotmail.com','bogotamonica@yahoo.com.co','jmanzano@inciativasbcn.com','campomarta1@hotmail.com','gregorreece@mail.com','hilton@br.com.br5','hilton@br.com.br6','jjstivel@senado.gov.br','ciro.santalucia@terra.com.br6','alberto10@globo.com6','claramoun1@yahoo.com','alberto10@globo.com7','josejoaojr@copperfrigu.com.br','avedolin@yahoo.com.br9','cgm.godoijunior@hotmail.com','alberto10@globo.com9','marconde@br.com.br9','alberto10@globo.com4','ciro.santalucia@terra.com.br9','ciro.santalucia@terra.com.br4','avedolin@yahoo.com.br1','victornavas@cable.net.com','pablo@villamichele.net','eaustin@flowtrinidad.net','claramoun12@yahoo.com','marconde@br.com.br1','alejandro@morbidoni.com','amauricgalvao@hotmail.com4','avedolin@yahoo.com.br3','claramunt2@yahoo.com','alberto10@globo.com8','silvia@netsite.com.br.3','novaes@hotmail.com.r','cordycom@gmail.com','rene@bauance.com.br','silvia@netsoite.com.b','durval@marrj.com.br','luisio728@yahoo.com','aaamaya_mendoza@hotmail.com','marisela@mora.com','sarahn.ackbarali@hotmail.com','dleitzalar@yahoo.com','rene@bauance.com.br5','rosales1@yahoo.com','flavia@studio.cerri.com.br','aliyya_shakeer@hotmail.com','fmofarreje@hotmail.com.br','krcsilva@gmail.com.br','riancerdeira@gmail.com.br','marthairma@yahoo.com.mx','sharon_deronique@hotmail.com','atendimento@kamiline.com.br1','novaes@hotmail.com.br6','victoralfaro0216@yahoo.com','apgsantos@gmail.com.br','fmofarreje@hotmail.com','angelica-mar@uol.com.br1','angelica-mar@uol.com.br2','elijay60@gmail.com','priloaguiar@hotmail.com','priloaguiar@hotmail.comb')
| C:\webRoot\Silverpop\CFC\Silverpop.cfc | 0 | vhr_members | | qUpdateBatch | 0 |
UPDATE members_stale_flg_batches
SET status = 1
WHERE list_id = 11341444
| C:\webRoot\Silverpop\CFC\Silverpop.cfc | 0 | hmcclub | | qUserId | 0 |
SELECT account_id
FROM cm_silverpop_users
WHERE user_id = 'gorlap2@clubhotel.com'
| C:\webRoot\Silverpop\CFC\Silverpop.cfc | 1 | hmcclub | | qUserId | 0 |
SELECT silverpop_ftp_pwd
FROM cm_silverpop_users
WHERE user_id = 'gorlap2@clubhotel.com'
| C:\webRoot\Silverpop\CFC\Silverpop.cfc | 1 | hmcclub | | qUpdateUndeliverables | 0 |
UPDATE members
SET stale_flg = 1
WHERE lower(email1) IN ('alan0135@yahoo.com.my','zhangxianjiang@icmbc.com.cn','albajenning@optusnet.com.au','louise.ibanaz@yahoo.com.ph','rgrgrhtjyudgdfdg@126.com','afsd_ng@yahoo.com','zhangweijun@yahoo.com','ob@yahoo.com','khaw12234@yahoo.com','13708978656@139.com','crissysison@rocketmail.com.p','chienchuping@yahoo.com.tw','fjy92@263.net','lmv@yahoo.com','yangyubing@vip.163.com','fr_snti@yahoo.com.ph','146594@qq.com','tn@yahoo.com','chenty0766@sohu.com','lencite@263.net','vwong12345@yahoo.com','13853205575@139.com','sinhua@yahoo.com','joelle168@yahoo.com.cn','beautiful.rain@leto.eonet.ne.jp','16569848@qq.com','whs@yahoo.com','liujing_bj@chinastock.com','kaicheing@yahoo.com','thelmalagrimas@yahoo.com.ph','mei@qq.com','sandypery@yahoo.com.ph','pfmary@163.com','jeri3jer@hotmail.com','113678414@163.com','24997804@qq.com','13924972738@139.com','hywan2@163.com','at23@yahoo.com','13823116362@139.com','ganhong@hotmail.com','wuqi@yahoo.com','loewiov@163.net','rebeccachung333@yahoo.com.hk','jwkboy@yahoo.com.hk','summerueml@hotmail.com','pyhpan3388@yahoo.com','13906023559@139.com','jnszpxw@163.com','atty_victor@yahoo.c','yuyongchun156@163.com','zgql_mmsq@sohu.com','rgaoz@ford.com','lilylihome@hotmail.com','liangyuehong@sohu.com','zhupeijing11@126.com','5239432912323@qq.com','huasheng@136.com','shizss@263.net','15986694828@139.com','shengcai777@136.com','13827480321@139.com','trisica-ph@hotmail.com','luoxiaogang145@sohu.com','zhangxi145@126.com','huangshufen@sohu.com','yongguangsu@163.com','ubt104@gmail.com','panlilei@sohu.com','hlm0501@126.com','zhangajun156@126.com','linlin-0377@126.com','13666651879@139.com','liuzhouming126@126.com','13757179349@139.com','13957166606@139.com','dongyuewu111@beijingdics.com','yuuie00@163.com','13306537071@139.com','wangzheng@163.net','cjesly@163.com','13802237859@139.com','g.christophe321@alice.fr','malei145@yahoo.com.cn','lin-lin-0377@163.com','1390119@139.com','chenpeng147@sohu.com','chenxinying145@163.com','wukai88@136.com','mrlarrypowel@yahoo.co.uk','luismiguel70@yahoo.es','pablo@poctalum.net','xepasal@gmail.com','luisnadov@hotmail.com','richardmanby@silversattime.com','carlos@vnexport.es','eeeesette@tiscali.it','crifin@cnstacurva.com','15810365717@139.om','xiaozou-aimeili@hotmail.com','sgtabolilla@hotmail.com','ricardobianchini@terra.com.br4','julio.llamo@klingspon.es','norelisalva123@hotmail.com','yponcean@hotmail.com','williiam_0084@hotmail.com','alessandraprest@yahoo.it','gtalleri@gmail.com.br3','linavillaverde2@hotmail.com','carmennovel@hotmail.com','zrsardinha@hotmail.com.br','maf.ichasoan@planet.t','flesprin@gmail.com','djorlan@hotmail.com','rpmerimo@yahoo.es','alba-cabo@hotmail.com','gnrybpm@yahoo.com','lanvic11@hotmail.com','abaggefilho@terra.com.br3','silvia@nacscosmeticos.com.br1','ignaciolajarza@yahoo.es','abaggefilho@terra1.com.br','vlinkgo@hotmail.com','lrsardinha@hotmail.com.br','magdag27@hotmail.com','sanchiz@botegascastano.com','mmorfila@ibsalut.caib','simona.catanero@tin.it','abaggefilho@terra.com.br.6','ministerioevangelicoraulynjante@hotmail.com','iguasi@vesitges.com','bellisimabillon@gmail.com','ministerioevangelicoraulynjante2@hotmail.com','ministerioevangelicoraulynjante3@hotmail.com','massibi79@hotmail.it','j.hanlet@hotmail.com','m@h.com.br','lyerly@aol.com','alex.jdunning@btinternet.com','pamirom9@hotmail.com','anaelirr@yahoo.com','beatriz51515@hotmail.com','erodriguez@blindeca.com','terry@abtec-eng.co','judithmartinez@prensa.com','judithmartinez@aprensa.hn','peter@abtec-eng.co','cvillarreal3049@students.leredo.edu','marcode@br.com.br','hilton@br.com.br4','mauroalm@br.com.br4','velascosvastiduos@hotmail.com','bogotamonica@yahoo.com.co','jmanzano@inciativasbcn.com','campomarta1@hotmail.com','gregorreece@mail.com','hilton@br.com.br5','hilton@br.com.br6','jjstivel@senado.gov.br','ciro.santalucia@terra.com.br6','alberto10@globo.com6','claramoun1@yahoo.com','alberto10@globo.com7','josejoaojr@copperfrigu.com.br','avedolin@yahoo.com.br9','cgm.godoijunior@hotmail.com','alberto10@globo.com9','marconde@br.com.br9','alberto10@globo.com4','ciro.santalucia@terra.com.br9','ciro.santalucia@terra.com.br4','avedolin@yahoo.com.br1','victornavas@cable.net.com','pablo@villamichele.net','eaustin@flowtrinidad.net','claramoun12@yahoo.com','marconde@br.com.br1','alejandro@morbidoni.com','amauricgalvao@hotmail.com4','avedolin@yahoo.com.br3','claramunt2@yahoo.com','alberto10@globo.com8','silvia@netsite.com.br.3','novaes@hotmail.com.r','cordycom@gmail.com','rene@bauance.com.br','silvia@netsoite.com.b','durval@marrj.com.br','luisio728@yahoo.com','aaamaya_mendoza@hotmail.com','marisela@mora.com','sarahn.ackbarali@hotmail.com','dleitzalar@yahoo.com','rene@bauance.com.br5','rosales1@yahoo.com','flavia@studio.cerri.com.br','aliyya_shakeer@hotmail.com','fmofarreje@hotmail.com.br','krcsilva@gmail.com.br','riancerdeira@gmail.com.br','marthairma@yahoo.com.mx','sharon_deronique@hotmail.com','atendimento@kamiline.com.br1','novaes@hotmail.com.br6','victoralfaro0216@yahoo.com','apgsantos@gmail.com.br','fmofarreje@hotmail.com','angelica-mar@uol.com.br1','angelica-mar@uol.com.br2','elijay60@gmail.com','priloaguiar@hotmail.com','priloaguiar@hotmail.comb')
| C:\webRoot\Silverpop\CFC\Silverpop.cfc | 0 | hmcclub | | qInsertStaleFlagUpdate | 0 |
INSERT INTO members_stale_flg_updates
(SELECT NULL AS UPD_ID,
MEMBER_ID,
1 AS STL_FLG,
SYSDATE AS DT,
'C' AS type
FROM members
WHERE lower(email1) IN ('alan0135@yahoo.com.my','zhangxianjiang@icmbc.com.cn','albajenning@optusnet.com.au','louise.ibanaz@yahoo.com.ph','rgrgrhtjyudgdfdg@126.com','afsd_ng@yahoo.com','zhangweijun@yahoo.com','ob@yahoo.com','khaw12234@yahoo.com','13708978656@139.com','crissysison@rocketmail.com.p','chienchuping@yahoo.com.tw','fjy92@263.net','lmv@yahoo.com','yangyubing@vip.163.com','fr_snti@yahoo.com.ph','146594@qq.com','tn@yahoo.com','chenty0766@sohu.com','lencite@263.net','vwong12345@yahoo.com','13853205575@139.com','sinhua@yahoo.com','joelle168@yahoo.com.cn','beautiful.rain@leto.eonet.ne.jp','16569848@qq.com','whs@yahoo.com','liujing_bj@chinastock.com','kaicheing@yahoo.com','thelmalagrimas@yahoo.com.ph','mei@qq.com','sandypery@yahoo.com.ph','pfmary@163.com','jeri3jer@hotmail.com','113678414@163.com','24997804@qq.com','13924972738@139.com','hywan2@163.com','at23@yahoo.com','13823116362@139.com','ganhong@hotmail.com','wuqi@yahoo.com','loewiov@163.net','rebeccachung333@yahoo.com.hk','jwkboy@yahoo.com.hk','summerueml@hotmail.com','pyhpan3388@yahoo.com','13906023559@139.com','jnszpxw@163.com','atty_victor@yahoo.c','yuyongchun156@163.com','zgql_mmsq@sohu.com','rgaoz@ford.com','lilylihome@hotmail.com','liangyuehong@sohu.com','zhupeijing11@126.com','5239432912323@qq.com','huasheng@136.com','shizss@263.net','15986694828@139.com','shengcai777@136.com','13827480321@139.com','trisica-ph@hotmail.com','luoxiaogang145@sohu.com','zhangxi145@126.com','huangshufen@sohu.com','yongguangsu@163.com','ubt104@gmail.com','panlilei@sohu.com','hlm0501@126.com','zhangajun156@126.com','linlin-0377@126.com','13666651879@139.com','liuzhouming126@126.com','13757179349@139.com','13957166606@139.com','dongyuewu111@beijingdics.com','yuuie00@163.com','13306537071@139.com','wangzheng@163.net','cjesly@163.com','13802237859@139.com','g.christophe321@alice.fr','malei145@yahoo.com.cn','lin-lin-0377@163.com','1390119@139.com','chenpeng147@sohu.com','chenxinying145@163.com','wukai88@136.com','mrlarrypowel@yahoo.co.uk','luismiguel70@yahoo.es','pablo@poctalum.net','xepasal@gmail.com','luisnadov@hotmail.com','richardmanby@silversattime.com','carlos@vnexport.es','eeeesette@tiscali.it','crifin@cnstacurva.com','15810365717@139.om','xiaozou-aimeili@hotmail.com','sgtabolilla@hotmail.com','ricardobianchini@terra.com.br4','julio.llamo@klingspon.es','norelisalva123@hotmail.com','yponcean@hotmail.com','williiam_0084@hotmail.com','alessandraprest@yahoo.it','gtalleri@gmail.com.br3','linavillaverde2@hotmail.com','carmennovel@hotmail.com','zrsardinha@hotmail.com.br','maf.ichasoan@planet.t','flesprin@gmail.com','djorlan@hotmail.com','rpmerimo@yahoo.es','alba-cabo@hotmail.com','gnrybpm@yahoo.com','lanvic11@hotmail.com','abaggefilho@terra.com.br3','silvia@nacscosmeticos.com.br1','ignaciolajarza@yahoo.es','abaggefilho@terra1.com.br','vlinkgo@hotmail.com','lrsardinha@hotmail.com.br','magdag27@hotmail.com','sanchiz@botegascastano.com','mmorfila@ibsalut.caib','simona.catanero@tin.it','abaggefilho@terra.com.br.6','ministerioevangelicoraulynjante@hotmail.com','iguasi@vesitges.com','bellisimabillon@gmail.com','ministerioevangelicoraulynjante2@hotmail.com','ministerioevangelicoraulynjante3@hotmail.com','massibi79@hotmail.it','j.hanlet@hotmail.com','m@h.com.br','lyerly@aol.com','alex.jdunning@btinternet.com','pamirom9@hotmail.com','anaelirr@yahoo.com','beatriz51515@hotmail.com','erodriguez@blindeca.com','terry@abtec-eng.co','judithmartinez@prensa.com','judithmartinez@aprensa.hn','peter@abtec-eng.co','cvillarreal3049@students.leredo.edu','marcode@br.com.br','hilton@br.com.br4','mauroalm@br.com.br4','velascosvastiduos@hotmail.com','bogotamonica@yahoo.com.co','jmanzano@inciativasbcn.com','campomarta1@hotmail.com','gregorreece@mail.com','hilton@br.com.br5','hilton@br.com.br6','jjstivel@senado.gov.br','ciro.santalucia@terra.com.br6','alberto10@globo.com6','claramoun1@yahoo.com','alberto10@globo.com7','josejoaojr@copperfrigu.com.br','avedolin@yahoo.com.br9','cgm.godoijunior@hotmail.com','alberto10@globo.com9','marconde@br.com.br9','alberto10@globo.com4','ciro.santalucia@terra.com.br9','ciro.santalucia@terra.com.br4','avedolin@yahoo.com.br1','victornavas@cable.net.com','pablo@villamichele.net','eaustin@flowtrinidad.net','claramoun12@yahoo.com','marconde@br.com.br1','alejandro@morbidoni.com','amauricgalvao@hotmail.com4','avedolin@yahoo.com.br3','claramunt2@yahoo.com','alberto10@globo.com8','silvia@netsite.com.br.3','novaes@hotmail.com.r','cordycom@gmail.com','rene@bauance.com.br','silvia@netsoite.com.b','durval@marrj.com.br','luisio728@yahoo.com','aaamaya_mendoza@hotmail.com','marisela@mora.com','sarahn.ackbarali@hotmail.com','dleitzalar@yahoo.com','rene@bauance.com.br5','rosales1@yahoo.com','flavia@studio.cerri.com.br','aliyya_shakeer@hotmail.com','fmofarreje@hotmail.com.br','krcsilva@gmail.com.br','riancerdeira@gmail.com.br','marthairma@yahoo.com.mx','sharon_deronique@hotmail.com','atendimento@kamiline.com.br1','novaes@hotmail.com.br6','victoralfaro0216@yahoo.com','apgsantos@gmail.com.br','fmofarreje@hotmail.com','angelica-mar@uol.com.br1','angelica-mar@uol.com.br2','elijay60@gmail.com','priloaguiar@hotmail.com','priloaguiar@hotmail.comb'))
| C:\webRoot\Silverpop\CFC\Silverpop.cfc | 0 | hmcclub | | qUpdateUndeliverables | 0 |
UPDATE ghr_members
SET stale_flg = 1
WHERE lower(email1) IN ('alan0135@yahoo.com.my','zhangxianjiang@icmbc.com.cn','albajenning@optusnet.com.au','louise.ibanaz@yahoo.com.ph','rgrgrhtjyudgdfdg@126.com','afsd_ng@yahoo.com','zhangweijun@yahoo.com','ob@yahoo.com','khaw12234@yahoo.com','13708978656@139.com','crissysison@rocketmail.com.p','chienchuping@yahoo.com.tw','fjy92@263.net','lmv@yahoo.com','yangyubing@vip.163.com','fr_snti@yahoo.com.ph','146594@qq.com','tn@yahoo.com','chenty0766@sohu.com','lencite@263.net','vwong12345@yahoo.com','13853205575@139.com','sinhua@yahoo.com','joelle168@yahoo.com.cn','beautiful.rain@leto.eonet.ne.jp','16569848@qq.com','whs@yahoo.com','liujing_bj@chinastock.com','kaicheing@yahoo.com','thelmalagrimas@yahoo.com.ph','mei@qq.com','sandypery@yahoo.com.ph','pfmary@163.com','jeri3jer@hotmail.com','113678414@163.com','24997804@qq.com','13924972738@139.com','hywan2@163.com','at23@yahoo.com','13823116362@139.com','ganhong@hotmail.com','wuqi@yahoo.com','loewiov@163.net','rebeccachung333@yahoo.com.hk','jwkboy@yahoo.com.hk','summerueml@hotmail.com','pyhpan3388@yahoo.com','13906023559@139.com','jnszpxw@163.com','atty_victor@yahoo.c','yuyongchun156@163.com','zgql_mmsq@sohu.com','rgaoz@ford.com','lilylihome@hotmail.com','liangyuehong@sohu.com','zhupeijing11@126.com','5239432912323@qq.com','huasheng@136.com','shizss@263.net','15986694828@139.com','shengcai777@136.com','13827480321@139.com','trisica-ph@hotmail.com','luoxiaogang145@sohu.com','zhangxi145@126.com','huangshufen@sohu.com','yongguangsu@163.com','ubt104@gmail.com','panlilei@sohu.com','hlm0501@126.com','zhangajun156@126.com','linlin-0377@126.com','13666651879@139.com','liuzhouming126@126.com','13757179349@139.com','13957166606@139.com','dongyuewu111@beijingdics.com','yuuie00@163.com','13306537071@139.com','wangzheng@163.net','cjesly@163.com','13802237859@139.com','g.christophe321@alice.fr','malei145@yahoo.com.cn','lin-lin-0377@163.com','1390119@139.com','chenpeng147@sohu.com','chenxinying145@163.com','wukai88@136.com','mrlarrypowel@yahoo.co.uk','luismiguel70@yahoo.es','pablo@poctalum.net','xepasal@gmail.com','luisnadov@hotmail.com','richardmanby@silversattime.com','carlos@vnexport.es','eeeesette@tiscali.it','crifin@cnstacurva.com','15810365717@139.om','xiaozou-aimeili@hotmail.com','sgtabolilla@hotmail.com','ricardobianchini@terra.com.br4','julio.llamo@klingspon.es','norelisalva123@hotmail.com','yponcean@hotmail.com','williiam_0084@hotmail.com','alessandraprest@yahoo.it','gtalleri@gmail.com.br3','linavillaverde2@hotmail.com','carmennovel@hotmail.com','zrsardinha@hotmail.com.br','maf.ichasoan@planet.t','flesprin@gmail.com','djorlan@hotmail.com','rpmerimo@yahoo.es','alba-cabo@hotmail.com','gnrybpm@yahoo.com','lanvic11@hotmail.com','abaggefilho@terra.com.br3','silvia@nacscosmeticos.com.br1','ignaciolajarza@yahoo.es','abaggefilho@terra1.com.br','vlinkgo@hotmail.com','lrsardinha@hotmail.com.br','magdag27@hotmail.com','sanchiz@botegascastano.com','mmorfila@ibsalut.caib','simona.catanero@tin.it','abaggefilho@terra.com.br.6','ministerioevangelicoraulynjante@hotmail.com','iguasi@vesitges.com','bellisimabillon@gmail.com','ministerioevangelicoraulynjante2@hotmail.com','ministerioevangelicoraulynjante3@hotmail.com','massibi79@hotmail.it','j.hanlet@hotmail.com','m@h.com.br','lyerly@aol.com','alex.jdunning@btinternet.com','pamirom9@hotmail.com','anaelirr@yahoo.com','beatriz51515@hotmail.com','erodriguez@blindeca.com','terry@abtec-eng.co','judithmartinez@prensa.com','judithmartinez@aprensa.hn','peter@abtec-eng.co','cvillarreal3049@students.leredo.edu','marcode@br.com.br','hilton@br.com.br4','mauroalm@br.com.br4','velascosvastiduos@hotmail.com','bogotamonica@yahoo.com.co','jmanzano@inciativasbcn.com','campomarta1@hotmail.com','gregorreece@mail.com','hilton@br.com.br5','hilton@br.com.br6','jjstivel@senado.gov.br','ciro.santalucia@terra.com.br6','alberto10@globo.com6','claramoun1@yahoo.com','alberto10@globo.com7','josejoaojr@copperfrigu.com.br','avedolin@yahoo.com.br9','cgm.godoijunior@hotmail.com','alberto10@globo.com9','marconde@br.com.br9','alberto10@globo.com4','ciro.santalucia@terra.com.br9','ciro.santalucia@terra.com.br4','avedolin@yahoo.com.br1','victornavas@cable.net.com','pablo@villamichele.net','eaustin@flowtrinidad.net','claramoun12@yahoo.com','marconde@br.com.br1','alejandro@morbidoni.com','amauricgalvao@hotmail.com4','avedolin@yahoo.com.br3','claramunt2@yahoo.com','alberto10@globo.com8','silvia@netsite.com.br.3','novaes@hotmail.com.r','cordycom@gmail.com','rene@bauance.com.br','silvia@netsoite.com.b','durval@marrj.com.br','luisio728@yahoo.com','aaamaya_mendoza@hotmail.com','marisela@mora.com','sarahn.ackbarali@hotmail.com','dleitzalar@yahoo.com','rene@bauance.com.br5','rosales1@yahoo.com','flavia@studio.cerri.com.br','aliyya_shakeer@hotmail.com','fmofarreje@hotmail.com.br','krcsilva@gmail.com.br','riancerdeira@gmail.com.br','marthairma@yahoo.com.mx','sharon_deronique@hotmail.com','atendimento@kamiline.com.br1','novaes@hotmail.com.br6','victoralfaro0216@yahoo.com','apgsantos@gmail.com.br','fmofarreje@hotmail.com','angelica-mar@uol.com.br1','angelica-mar@uol.com.br2','elijay60@gmail.com','priloaguiar@hotmail.com','priloaguiar@hotmail.comb')
| C:\webRoot\Silverpop\CFC\Silverpop.cfc | 0 | vhr_members | | qUpdateBatch | 0 |
UPDATE members_stale_flg_batches
SET status = 1
WHERE list_id = 11341445
| C:\webRoot\Silverpop\CFC\Silverpop.cfc | 0 | hmcclub |
|
| | timers | | Query | | Execution Time (ms) | 0 | | recordcount | 0 | | cached | No | | result | |
| | history | | Query | | Execution Time (ms) | 0 | | recordcount | 5 | | cached | No | | result | | id | level | | 12217 | 1 | | 12218 | 2 | | 12219 | 3 | | 12220 | 2 | | 12222 | 1 |
|
|
|
| | 6 | | Struct | | ITOTAL | | | RECORDED | | Date Time | {ts '2010-03-13 04:13:59'} |
| | IPADDRESS | | | CALLEDURL | | | DEBUGINFO | | Struct | | pages | | Query | | Execution Time (ms) | 0 | | recordcount | 2 | | cached | No | | result | | id | count | min | max | avg | app | load | query | total | src | | 12388 | 1 | 31 | 31 | 31 | 31 | 0 | 0 | 31 | C:\Program Files\Railo\webapps\ROOT\index.cfm | | 12389 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | C:\Program Files\Railo\webapps\ROOT\WEB-INF\railo\context\templates\debugging\debugging-2-console.cfm |
|
| | traces | | Query | | Execution Time (ms) | 0 | | recordcount | 0 | | cached | No | | result | | type | category | text | template | line | varname | varvalue | time |
|
| | queries | | Query | | Execution Time (ms) | 0 | | recordcount | 0 | | cached | No | | result | | name | time | sql | src | count | datasource |
|
| | timers | | Query | | Execution Time (ms) | 0 | | recordcount | 0 | | cached | No | | result | |
| | history | | Query | | Execution Time (ms) | 0 | | recordcount | 2 | | cached | No | | result | |
|
|
| | 7 | | Struct | | ITOTAL | | | RECORDED | | Date Time | {ts '2010-03-12 18:40:47'} |
| | IPADDRESS | | | CALLEDURL | | | DEBUGINFO | | Struct | | pages | | Query | | Execution Time (ms) | 0 | | recordcount | 2 | | cached | No | | result | | id | count | min | max | avg | app | load | query | total | src | | 11787 | 1 | 15 | 15 | 15 | 15 | 0 | 0 | 15 | C:\Program Files\Railo\webapps\ROOT\index.cfm | | 11788 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | C:\Program Files\Railo\webapps\ROOT\WEB-INF\railo\context\templates\debugging\debugging-2-console.cfm |
|
| | traces | | Query | | Execution Time (ms) | 0 | | recordcount | 0 | | cached | No | | result | | type | category | text | template | line | varname | varvalue | time |
|
| | queries | | Query | | Execution Time (ms) | 0 | | recordcount | 0 | | cached | No | | result | | name | time | sql | src | count | datasource |
|
| | timers | | Query | | Execution Time (ms) | 0 | | recordcount | 0 | | cached | No | | result | |
| | history | | Query | | Execution Time (ms) | 0 | | recordcount | 2 | | cached | No | | result | |
|
|
| | 8 | | Struct | | ITOTAL | | | RECORDED | | Date Time | {ts '2010-03-12 22:37:35'} |
| | IPADDRESS | | | CALLEDURL | | | DEBUGINFO | | Struct | | pages | | Query | | Execution Time (ms) | 0 | | recordcount | 2 | | cached | No | | result | | id | count | min | max | avg | app | load | query | total | src | | 11904 | 1 | 16 | 16 | 16 | 16 | 0 | 0 | 16 | C:\Program Files\Railo\webapps\ROOT\index.cfm | | 11905 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | C:\Program Files\Railo\webapps\ROOT\WEB-INF\railo\context\templates\debugging\debugging-2-console.cfm |
|
| | traces | | Query | | Execution Time (ms) | 0 | | recordcount | 0 | | cached | No | | result | | type | category | text | template | line | varname | varvalue | time |
|
| | queries | | Query | | Execution Time (ms) | 0 | | recordcount | 0 | | cached | No | | result | | name | time | sql | src | count | datasource |
|
| | timers | | Query | | Execution Time (ms) | 0 | | recordcount | 0 | | cached | No | | result | |
| | history | | Query | | Execution Time (ms) | 0 | | recordcount | 2 | | cached | No | | result | |
|
|
| | 9 | | Struct | | ITOTAL | | | RECORDED | | Date Time | {ts '2010-03-13 00:03:33'} |
| | IPADDRESS | | | CALLEDURL | | | DEBUGINFO | | Struct | | pages | | Query | | Execution Time (ms) | 0 | | recordcount | 2 | | cached | No | | result | | id | count | min | max | avg | app | load | query | total | src | | 11981 | 1 | 16 | 16 | 16 | 16 | 0 | 0 | 16 | C:\Program Files\Railo\webapps\ROOT\index.cfm | | 11982 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | C:\Program Files\Railo\webapps\ROOT\WEB-INF\railo\context\templates\debugging\debugging-2-console.cfm |
|
| | traces | | Query | | Execution Time (ms) | 0 | | recordcount | 0 | | cached | No | | result | | type | category | text | template | line | varname | varvalue | time |
|
| | queries | | Query | | Execution Time (ms) | 0 | | recordcount | 0 | | cached | No | | result | | name | time | sql | src | count | datasource |
|
| | timers | | Query | | Execution Time (ms) | 0 | | recordcount | 0 | | cached | No | | result | |
| | history | | Query | | Execution Time (ms) | 0 | | recordcount | 2 | | cached | No | | result | |
|
|
| | 10 | | Struct | | ITOTAL | | | RECORDED | | Date Time | {ts '2010-03-13 01:00:10'} |
| | IPADDRESS | | | CALLEDURL | | string | /Application/Silverpop/schChUndeliverables.cfm?RequestTimeout=300 |
| | DEBUGINFO | | Struct | | pages | | Query | | Execution Time (ms) | 0 | | recordcount | 5 | | cached | No | | result | | id | count | min | max | avg | app | load | query | total | src | | 12031 | 1 | 3703 | 3703 | 3703 | 3703 | 0 | 0 | 3703 | C:\webRoot\Silverpop\CFC\Silverpop.cfc$processChUndeliverables | | 12029 | 1 | 0 | 0 | 0 | 0 | 0 | 31 | 0 | C:\webRoot\Silverpop\CFC\Silverpop.cfc | | 12036 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | C:\Program Files\Railo\webapps\ROOT\WEB-INF\railo\context\templates\debugging\debugging-2-console.cfm | | 12028 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | C:\webRoot\Silverpop\schChUndeliverables.cfm | | 12030 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | C:\Program Files\Railo\webapps\ROOT\WEB-INF\railo\context\Component.cfc |
|
| | traces | | Query | | Execution Time (ms) | 0 | | recordcount | 0 | | cached | No | | result | | type | category | text | template | line | varname | varvalue | time |
|
| | queries | | Query | | Execution Time (ms) | 0 | | recordcount | 3 | | cached | No | | result | | name | time | sql | src | count | datasource | | qUserId | 31 |
SELECT account_id
FROM cm_silverpop_users
WHERE user_id = 'gorlap@clubhotel.com'
| C:\webRoot\Silverpop\CFC\Silverpop.cfc | 1 | hmcclub | | qUserId | 0 |
SELECT silverpop_marketer_pwd
FROM cm_silverpop_users
WHERE user_id = 'gorlap@clubhotel.com'
| C:\webRoot\Silverpop\CFC\Silverpop.cfc | 1 | hmcclub | | qInsertBatch | 0 |
INSERT INTO members_stale_flg_batches (list_id, file_path,list_type)
VALUES (11341334, '/download/Master Suppression List - Undeliverables - Mar 13 2010 01-00-08 AM.CSV', 'ch')
| C:\webRoot\Silverpop\CFC\Silverpop.cfc | 0 | hmcclub |
|
| | timers | | Query | | Execution Time (ms) | 0 | | recordcount | 0 | | cached | No | | result | |
| | history | | Query | | Execution Time (ms) | 0 | | recordcount | 5 | | cached | No | | result | | id | level | | 12028 | 1 | | 12029 | 2 | | 12030 | 3 | | 12031 | 2 | | 12036 | 1 |
|
|
|
|
| | DEBUGENTRYCOUNT | |
| | os | | Struct | | version | | | name | | | buildnumber | | | arch | | | additionalinformation | |
| | coldfusion | | Struct | | appserver | | | serialnumber | | | rootdir | | | productname | | | productlevel | | | productcontextcount | | | installkit | | | productversion | | | expiration | | Date Time | {ts '2010-03-08 16:02:39'} |
| | supportedlocales | | string | japanese (japan),spanish (peru),english,ja_JP_JP,spanish (panama),serbian (bosnia and herzegovina),macedonian,spanish (guatemala),arabic (united arab emirates),norwegian (norway),albanian (albania),bulgarian,arabic (iraq),arabic (yemen),hungarian,portuguese (portugal),greek (cyprus),arabic (qatar),macedonian (macedonia),swedish,german (switzerland),english (united states),finnish (finland),icelandic,czech,english (malta),slovenian (slovenia),slovak (slovakia),italian,turkish (turkey),chinese,thai,arabic (saudi arabia),norwegian,english (united kingdom),serbian (serbia and montenegro),lithuanian,romanian,english (new zealand),no_NO_NY,lithuanian (lithuania),spanish (nicaragua),dutch,irish (ireland),french (belgium),spanish (spain),arabic (lebanon),korean,french (canada),estonian (estonia),arabic (kuwait),spanish (united states),spanish (mexico),arabic (sudan),indonesian (indonesia),russian,latvian,spanish (uruguay),latvian (latvia),hebrew,portuguese (brazil),arabic (syria),croatian,estonian,spanish (dominican republic),french (switzerland),hindi (india),spanish (venezuela),arabic (bahrain),english (philippines),arabic (tunisia),finnish,german (austria),spanish,dutch (netherlands),spanish (ecuador),chinese (taiwan),arabic (jordan),belarusian,icelandic (iceland),spanish (colombia),spanish (costa rica),spanish (chile),arabic (egypt),english (south africa),thai (thailand),greek (greece),italian (italy),catalan,hungarian (hungary),french,english (ireland),ukrainian (ukraine),polish (poland),french (luxembourg),dutch (belgium),english (india),catalan (spain),arabic (morocco),spanish (bolivia),english (australia),serbian,chinese (singapore),portuguese,ukrainian,spanish (el salvador),russian (russia),korean (south korea),vietnamese,arabic (algeria),vietnamese (vietnam),albanian,arabic (libya),arabic,chinese (china),belarusian (belarus),chinese (hong kong),japanese,hebrew (israel),bulgarian (bulgaria),indonesian,maltese (malta),spanish (paraguay),slovenian,french (france),czech (czech republic),italian (switzerland),romanian (romania),spanish (puerto rico),english (canada),german (germany),irish,german (luxembourg),german,spanish (argentina),slovak,malay (malaysia),croatian (croatia),english (singapore),danish,maltese,polish,arabic (oman),turkish,th_TH_TH,greek,malay,swedish (sweden),danish (denmark),spanish (honduras) |
|
| | separator | |
|