-------------------------------------------------------- -- DDL for Table TEST_COMMENTS_CATEGORY -------------------------------------------------------- CREATE TABLE "TEST_COMMENTS_CATEGORY" ( "ID" NUMBER, "CATEGORY_NAME" VARCHAR2(256 CHAR), "INSTANCE_INDEX" NUMBER ) ; REM INSERTING into TEST_COMMENTS_CATEGORY SET DEFINE OFF; Insert into TEST_COMMENTS_CATEGORY (ID,CATEGORY_NAME,INSTANCE_INDEX) values ('1','Category1','0'); Insert into TEST_COMMENTS_CATEGORY (ID,CATEGORY_NAME,INSTANCE_INDEX) values ('3','Category2','0'); Insert into TEST_COMMENTS_CATEGORY (ID,CATEGORY_NAME,INSTANCE_INDEX) values ('7','Category3','1'); Insert into TEST_COMMENTS_CATEGORY (ID,CATEGORY_NAME,INSTANCE_INDEX) values ('2','Category4','0'); Insert into TEST_COMMENTS_CATEGORY (ID,CATEGORY_NAME,INSTANCE_INDEX) values ('4','Category5','1'); Insert into TEST_COMMENTS_CATEGORY (ID,CATEGORY_NAME,INSTANCE_INDEX) values ('5','Category6','1'); Insert into TEST_COMMENTS_CATEGORY (ID,CATEGORY_NAME,INSTANCE_INDEX) values ('6','Category7','1'); Insert into TEST_COMMENTS_CATEGORY (ID,CATEGORY_NAME,INSTANCE_INDEX) values ('8','Category8','2'); Insert into TEST_COMMENTS_CATEGORY (ID,CATEGORY_NAME,INSTANCE_INDEX) values ('9','Category9','2'); Insert into TEST_COMMENTS_CATEGORY (ID,CATEGORY_NAME,INSTANCE_INDEX) values ('10','Category10','2'); Insert into TEST_COMMENTS_CATEGORY (ID,CATEGORY_NAME,INSTANCE_INDEX) values ('11','Category11','2'); Insert into TEST_COMMENTS_CATEGORY (ID,CATEGORY_NAME,INSTANCE_INDEX) values ('9999','Category12',null); -------------------------------------------------------- -- DDL for Table TEST_USERS_EMAIL_LIST -------------------------------------------------------- CREATE TABLE "TEST_USERS_EMAIL_LIST" ( "ID" NUMBER, "EMAIL" VARCHAR2(256 CHAR), "AFF" VARCHAR2(256 CHAR), "PERIOD_OF_TIME" VARCHAR2(256 CHAR), "DTEVENT" TIMESTAMP (6), "EVENT" VARCHAR2(20 CHAR), "SEND" NUMBER, "COMMENT_TEXT" VARCHAR2(2000 CHAR), "USER_LAST_CHANGE" VARCHAR2(256 CHAR), "ID_CATEGORY" NUMBER, "ID_COMMENT" NUMBER, "NOTIFICATION_FREQUENCY" VARCHAR2(20 CHAR), "ID_AFF" NUMBER ) ; REM INSERTING into TEST_USERS_EMAIL_LIST SET DEFINE OFF; Insert into TEST_USERS_EMAIL_LIST (ID,EMAIL,AFF,PERIOD_OF_TIME,DTEVENT,EVENT,SEND,COMMENT_TEXT,USER_LAST_CHANGE,ID_CATEGORY,ID_COMMENT,NOTIFICATION_FREQUENCY,ID_AFF) values ('1287','test@email.com','India','Q4 2020, Q4 2020',to_timestamp('20/11/23 06:00:10,516722000','RR/MM/DD HH24:MI:SSXFF'),'COMM_INSERT','0','TEST TExt','TEST TExt','3','511','Weekly','138'); Insert into TEST_USERS_EMAIL_LIST (ID,EMAIL,AFF,PERIOD_OF_TIME,DTEVENT,EVENT,SEND,COMMENT_TEXT,USER_LAST_CHANGE,ID_CATEGORY,ID_COMMENT,NOTIFICATION_FREQUENCY,ID_AFF) values ('1288','test@email.com','Malaysia','Q4 2020',to_timestamp('20/11/23 06:00:10,516722000','RR/MM/DD HH24:MI:SSXFF'),'COMM_INSERT','0','TEST TExt','TEST TExt','3','486','Weekly','154'); Insert into TEST_USERS_EMAIL_LIST (ID,EMAIL,AFF,PERIOD_OF_TIME,DTEVENT,EVENT,SEND,COMMENT_TEXT,USER_LAST_CHANGE,ID_CATEGORY,ID_COMMENT,NOTIFICATION_FREQUENCY,ID_AFF) values ('1168','test@email.com','United Kingdom','Q4 2020',to_timestamp('20/11/23 06:00:10,516722000','RR/MM/DD HH24:MI:SSXFF'),'COMM_INSERT','0','TEST TExt','TEST TExt','1','506','Weekly','177'); Insert into TEST_USERS_EMAIL_LIST (ID,EMAIL,AFF,PERIOD_OF_TIME,DTEVENT,EVENT,SEND,COMMENT_TEXT,USER_LAST_CHANGE,ID_CATEGORY,ID_COMMENT,NOTIFICATION_FREQUENCY,ID_AFF) values ('1169','test@email.com','United Kingdom','Q4 2020',to_timestamp('20/11/23 06:00:10,516722000','RR/MM/DD HH24:MI:SSXFF'),'COMM_INSERT','0','TEST TExt','TEST TExt','1','506','Weekly','177'); Insert into TEST_USERS_EMAIL_LIST (ID,EMAIL,AFF,PERIOD_OF_TIME,DTEVENT,EVENT,SEND,COMMENT_TEXT,USER_LAST_CHANGE,ID_CATEGORY,ID_COMMENT,NOTIFICATION_FREQUENCY,ID_AFF) values ('1170','test@email.com','India','Q4 2020, Q4 2020',to_timestamp('20/11/23 06:00:10,516722000','RR/MM/DD HH24:MI:SSXFF'),'COMM_INSERT','0','TEST TExt','TEST TExt','3','510','Weekly','138'); Insert into TEST_USERS_EMAIL_LIST (ID,EMAIL,AFF,PERIOD_OF_TIME,DTEVENT,EVENT,SEND,COMMENT_TEXT,USER_LAST_CHANGE,ID_CATEGORY,ID_COMMENT,NOTIFICATION_FREQUENCY,ID_AFF) values ('1171','test@email.com','India','Q4 2020, Q4 2020',to_timestamp('20/11/23 06:00:10,516722000','RR/MM/DD HH24:MI:SSXFF'),'COMM_INSERT','0','TEST TExt','TEST TExt','3','511','Weekly','138'); Insert into TEST_USERS_EMAIL_LIST (ID,EMAIL,AFF,PERIOD_OF_TIME,DTEVENT,EVENT,SEND,COMMENT_TEXT,USER_LAST_CHANGE,ID_CATEGORY,ID_COMMENT,NOTIFICATION_FREQUENCY,ID_AFF) values ('1172','test@email.com','South Africa SR','Q4 2020, Q4 2020, Q4 2020, Q4 2020, Q4 2020, Q4 2020, Q4 2020, Q4 2020, Q4 2020, Q4 2020, Q4 2020, Q4 2020, Q4 2020',to_timestamp('20/11/23 06:00:10,516722000','RR/MM/DD HH24:MI:SSXFF'),'COMM_INSERT','0','TEST TExt','TEST TExt','3','519','Weekly','169'); Insert into TEST_USERS_EMAIL_LIST (ID,EMAIL,AFF,PERIOD_OF_TIME,DTEVENT,EVENT,SEND,COMMENT_TEXT,USER_LAST_CHANGE,ID_CATEGORY,ID_COMMENT,NOTIFICATION_FREQUENCY,ID_AFF) values ('1173','test@email.com','Tunisia','Q4 2020',to_timestamp('20/11/23 06:00:10,516722000','RR/MM/DD HH24:MI:SSXFF'),'COMM_INSERT','0','TEST TExt','TEST TExt','3','512','Weekly','174'); Insert into TEST_USERS_EMAIL_LIST (ID,EMAIL,AFF,PERIOD_OF_TIME,DTEVENT,EVENT,SEND,COMMENT_TEXT,USER_LAST_CHANGE,ID_CATEGORY,ID_COMMENT,NOTIFICATION_FREQUENCY,ID_AFF) values ('1174','test@email.com','Turkmenistan','Q4 2020',to_timestamp('20/11/23 06:00:10,516722000','RR/MM/DD HH24:MI:SSXFF'),'COMM_INSERT','0','TEST TExt','TEST TExt','2','509','Weekly','180'); Insert into TEST_USERS_EMAIL_LIST (ID,EMAIL,AFF,PERIOD_OF_TIME,DTEVENT,EVENT,SEND,COMMENT_TEXT,USER_LAST_CHANGE,ID_CATEGORY,ID_COMMENT,NOTIFICATION_FREQUENCY,ID_AFF) values ('1175','test@email.com','South Africa SR','Q4 2020, Q4 2020, Q4 2020, Q4 2020, Q4 2020, Q4 2020, Q4 2020, Q4 2020, Q4 2020, Q4 2020, Q4 2020, Q4 2020, Q4 2020',to_timestamp('20/11/23 06:00:10,516722000','RR/MM/DD HH24:MI:SSXFF'),'COMM_INSERT','0','TEST TExt','TEST TExt','3','519','Weekly','169'); Insert into TEST_USERS_EMAIL_LIST (ID,EMAIL,AFF,PERIOD_OF_TIME,DTEVENT,EVENT,SEND,COMMENT_TEXT,USER_LAST_CHANGE,ID_CATEGORY,ID_COMMENT,NOTIFICATION_FREQUENCY,ID_AFF) values ('1176','test@email.com','India','Q4 2020, Q4 2020',to_timestamp('20/11/23 06:00:10,516722000','RR/MM/DD HH24:MI:SSXFF'),'COMM_INSERT','0','TEST TExt','TEST TExt','3','510','Weekly','138'); Insert into TEST_USERS_EMAIL_LIST (ID,EMAIL,AFF,PERIOD_OF_TIME,DTEVENT,EVENT,SEND,COMMENT_TEXT,USER_LAST_CHANGE,ID_CATEGORY,ID_COMMENT,NOTIFICATION_FREQUENCY,ID_AFF) values ('1177','test@email.com','India','Q4 2020, Q4 2020',to_timestamp('20/11/23 06:00:10,516722000','RR/MM/DD HH24:MI:SSXFF'),'COMM_INSERT','0','TEST TExt','TEST TExt','3','511','Weekly','138'); Insert into TEST_USERS_EMAIL_LIST (ID,EMAIL,AFF,PERIOD_OF_TIME,DTEVENT,EVENT,SEND,COMMENT_TEXT,USER_LAST_CHANGE,ID_CATEGORY,ID_COMMENT,NOTIFICATION_FREQUENCY,ID_AFF) values ('1178','test@email.com','Malaysia','Q4 2020',to_timestamp('20/11/23 06:00:10,516722000','RR/MM/DD HH24:MI:SSXFF'),'COMM_INSERT','0','TEST TExt','TEST TExt','3','486','Weekly','154'); Insert into TEST_USERS_EMAIL_LIST (ID,EMAIL,AFF,PERIOD_OF_TIME,DTEVENT,EVENT,SEND,COMMENT_TEXT,USER_LAST_CHANGE,ID_CATEGORY,ID_COMMENT,NOTIFICATION_FREQUENCY,ID_AFF) values ('1179','test@email.com','South Africa SR','Q4 2020, Q4 2020, Q4 2020, Q4 2020, Q4 2020, Q4 2020, Q4 2020, Q4 2020, Q4 2020, Q4 2020, Q4 2020, Q4 2020, Q4 2020',to_timestamp('20/11/23 06:00:10,516722000','RR/MM/DD HH24:MI:SSXFF'),'COMM_INSERT','0','TEST TExt','TEST TExt','3','519','Weekly','169'); Insert into TEST_USERS_EMAIL_LIST (ID,EMAIL,AFF,PERIOD_OF_TIME,DTEVENT,EVENT,SEND,COMMENT_TEXT,USER_LAST_CHANGE,ID_CATEGORY,ID_COMMENT,NOTIFICATION_FREQUENCY,ID_AFF) values ('1180','test@email.com','Tunisia','Q4 2020',to_timestamp('20/11/23 06:00:10,516722000','RR/MM/DD HH24:MI:SSXFF'),'COMM_INSERT','0','TEST TExt','TEST TExt','3','512','Weekly','174'); Insert into TEST_USERS_EMAIL_LIST (ID,EMAIL,AFF,PERIOD_OF_TIME,DTEVENT,EVENT,SEND,COMMENT_TEXT,USER_LAST_CHANGE,ID_CATEGORY,ID_COMMENT,NOTIFICATION_FREQUENCY,ID_AFF) values ('1181','test@email.com','Turkey','Q4 2020',to_timestamp('20/11/23 06:00:10,516722000','RR/MM/DD HH24:MI:SSXFF'),'COMM_INSERT','0','TEST TExt','TEST TExt','1','508','Weekly','101'); Insert into TEST_USERS_EMAIL_LIST (ID,EMAIL,AFF,PERIOD_OF_TIME,DTEVENT,EVENT,SEND,COMMENT_TEXT,USER_LAST_CHANGE,ID_CATEGORY,ID_COMMENT,NOTIFICATION_FREQUENCY,ID_AFF) values ('1182','test@email.com','Turkmenistan','Q4 2020',to_timestamp('20/11/23 06:00:10,516722000','RR/MM/DD HH24:MI:SSXFF'),'COMM_INSERT','0','TEST TExt','TEST TExt','2','509','Weekly','180'); Insert into TEST_USERS_EMAIL_LIST (ID,EMAIL,AFF,PERIOD_OF_TIME,DTEVENT,EVENT,SEND,COMMENT_TEXT,USER_LAST_CHANGE,ID_CATEGORY,ID_COMMENT,NOTIFICATION_FREQUENCY,ID_AFF) values ('1183','test@email.com','India','Q4 2020, Q4 2020',to_timestamp('20/11/23 06:00:10,516722000','RR/MM/DD HH24:MI:SSXFF'),'COMM_INSERT','0','TEST TExt','TEST TExt','3','510','Weekly','138'); Insert into TEST_USERS_EMAIL_LIST (ID,EMAIL,AFF,PERIOD_OF_TIME,DTEVENT,EVENT,SEND,COMMENT_TEXT,USER_LAST_CHANGE,ID_CATEGORY,ID_COMMENT,NOTIFICATION_FREQUENCY,ID_AFF) values ('1184','test@email.com','India','Q4 2020, Q4 2020',to_timestamp('20/11/23 06:00:10,516722000','RR/MM/DD HH24:MI:SSXFF'),'COMM_INSERT','0','TEST TExt','TEST TExt','3','511','Weekly','138'); Insert into TEST_USERS_EMAIL_LIST (ID,EMAIL,AFF,PERIOD_OF_TIME,DTEVENT,EVENT,SEND,COMMENT_TEXT,USER_LAST_CHANGE,ID_CATEGORY,ID_COMMENT,NOTIFICATION_FREQUENCY,ID_AFF) values ('1185','test@email.com','Malaysia','Q4 2020',to_timestamp('20/11/23 06:00:10,516722000','RR/MM/DD HH24:MI:SSXFF'),'COMM_INSERT','0','TEST TExt','TEST TExt','3','486','Weekly','154'); Insert into TEST_USERS_EMAIL_LIST (ID,EMAIL,AFF,PERIOD_OF_TIME,DTEVENT,EVENT,SEND,COMMENT_TEXT,USER_LAST_CHANGE,ID_CATEGORY,ID_COMMENT,NOTIFICATION_FREQUENCY,ID_AFF) values ('1186','test@email.com','Brazil','Q4 2020',to_timestamp('20/11/23 06:00:10,516722000','RR/MM/DD HH24:MI:SSXFF'),'COMM_INSERT','0','TEST TExt','TEST TExt','1','495','Weekly','108'); Insert into TEST_USERS_EMAIL_LIST (ID,EMAIL,AFF,PERIOD_OF_TIME,DTEVENT,EVENT,SEND,COMMENT_TEXT,USER_LAST_CHANGE,ID_CATEGORY,ID_COMMENT,NOTIFICATION_FREQUENCY,ID_AFF) values ('1187','test@email.com','Brazil','Q4 2020',to_timestamp('20/11/23 06:00:10,516722000','RR/MM/DD HH24:MI:SSXFF'),'COMM_INSERT','0','TEST TExt','TEST TExt','2','491','Weekly','108'); Insert into TEST_USERS_EMAIL_LIST (ID,EMAIL,AFF,PERIOD_OF_TIME,DTEVENT,EVENT,SEND,COMMENT_TEXT,USER_LAST_CHANGE,ID_CATEGORY,ID_COMMENT,NOTIFICATION_FREQUENCY,ID_AFF) values ('1188','test@email.com','Brazil','Q4 2020',to_timestamp('20/11/23 06:00:10,516722000','RR/MM/DD HH24:MI:SSXFF'),'COMM_INSERT','0','TEST TExt','TEST TExt','2','492','Weekly','108'); Insert into TEST_USERS_EMAIL_LIST (ID,EMAIL,AFF,PERIOD_OF_TIME,DTEVENT,EVENT,SEND,COMMENT_TEXT,USER_LAST_CHANGE,ID_CATEGORY,ID_COMMENT,NOTIFICATION_FREQUENCY,ID_AFF) values ('1189','test@email.com','Brazil','Q4 2020',to_timestamp('20/11/23 06:00:10,516722000','RR/MM/DD HH24:MI:SSXFF'),'COMM_INSERT','0','TEST TExt','TEST TExt','2','493','Weekly','108'); Insert into TEST_USERS_EMAIL_LIST (ID,EMAIL,AFF,PERIOD_OF_TIME,DTEVENT,EVENT,SEND,COMMENT_TEXT,USER_LAST_CHANGE,ID_CATEGORY,ID_COMMENT,NOTIFICATION_FREQUENCY,ID_AFF) values ('1190','test@email.com','Brazil','Q4 2020',to_timestamp('20/11/23 06:00:10,516722000','RR/MM/DD HH24:MI:SSXFF'),'COMM_INSERT','0','TEST TExt','TEST TExt','2','494','Weekly','108'); Insert into TEST_USERS_EMAIL_LIST (ID,EMAIL,AFF,PERIOD_OF_TIME,DTEVENT,EVENT,SEND,COMMENT_TEXT,USER_LAST_CHANGE,ID_CATEGORY,ID_COMMENT,NOTIFICATION_FREQUENCY,ID_AFF) values ('1191','test@email.com','Brazil','Q4 2020',to_timestamp('20/11/23 06:00:10,516722000','RR/MM/DD HH24:MI:SSXFF'),'COMM_INSERT','0','TEST TExt','TEST TExt','2','490','Weekly','108'); Insert into TEST_USERS_EMAIL_LIST (ID,EMAIL,AFF,PERIOD_OF_TIME,DTEVENT,EVENT,SEND,COMMENT_TEXT,USER_LAST_CHANGE,ID_CATEGORY,ID_COMMENT,NOTIFICATION_FREQUENCY,ID_AFF) values ('1192','test@email.com','Brazil','Q4 2020',to_timestamp('20/11/23 06:00:10,516722000','RR/MM/DD HH24:MI:SSXFF'),'COMM_INSERT','0','TEST TExt','TEST TExt','2','489','Weekly','108'); Insert into TEST_USERS_EMAIL_LIST (ID,EMAIL,AFF,PERIOD_OF_TIME,DTEVENT,EVENT,SEND,COMMENT_TEXT,USER_LAST_CHANGE,ID_CATEGORY,ID_COMMENT,NOTIFICATION_FREQUENCY,ID_AFF) values ('1193','test@email.com','Brazil','Q4 2020',to_timestamp('20/11/23 06:00:10,516722000','RR/MM/DD HH24:MI:SSXFF'),'COMM_INSERT','0','TEST TExt','TEST TExt','3','496','Weekly','108'); Insert into TEST_USERS_EMAIL_LIST (ID,EMAIL,AFF,PERIOD_OF_TIME,DTEVENT,EVENT,SEND,COMMENT_TEXT,USER_LAST_CHANGE,ID_CATEGORY,ID_COMMENT,NOTIFICATION_FREQUENCY,ID_AFF) values ('1194','test@email.com','Brazil','Q4 2020',to_timestamp('20/11/23 06:00:10,516722000','RR/MM/DD HH24:MI:SSXFF'),'COMM_INSERT','0','TEST TExt','TEST TExt','5','518','Weekly','108'); Insert into TEST_USERS_EMAIL_LIST (ID,EMAIL,AFF,PERIOD_OF_TIME,DTEVENT,EVENT,SEND,COMMENT_TEXT,USER_LAST_CHANGE,ID_CATEGORY,ID_COMMENT,NOTIFICATION_FREQUENCY,ID_AFF) values ('1195','test@email.com','Chile','Q4 2020',to_timestamp('20/11/23 06:00:10,516722000','RR/MM/DD HH24:MI:SSXFF'),'COMM_INSERT','0','TEST TExt','TEST TExt','3','513','Weekly','123'); Insert into TEST_USERS_EMAIL_LIST (ID,EMAIL,AFF,PERIOD_OF_TIME,DTEVENT,EVENT,SEND,COMMENT_TEXT,USER_LAST_CHANGE,ID_CATEGORY,ID_COMMENT,NOTIFICATION_FREQUENCY,ID_AFF) values ('1196','test@email.com','Colombia','Q4 2020',to_timestamp('20/11/23 06:00:10,516722000','RR/MM/DD HH24:MI:SSXFF'),'COMM_INSERT','0','TEST TExt','TEST TExt','2','505','Weekly','110'); Insert into TEST_USERS_EMAIL_LIST (ID,EMAIL,AFF,PERIOD_OF_TIME,DTEVENT,EVENT,SEND,COMMENT_TEXT,USER_LAST_CHANGE,ID_CATEGORY,ID_COMMENT,NOTIFICATION_FREQUENCY,ID_AFF) values ('1197','test@email.com','India','Q4 2020, Q4 2020',to_timestamp('20/11/23 06:00:10,516722000','RR/MM/DD HH24:MI:SSXFF'),'COMM_INSERT','0','TEST TExt','TEST TExt','3','510','Weekly','138'); Insert into TEST_USERS_EMAIL_LIST (ID,EMAIL,AFF,PERIOD_OF_TIME,DTEVENT,EVENT,SEND,COMMENT_TEXT,USER_LAST_CHANGE,ID_CATEGORY,ID_COMMENT,NOTIFICATION_FREQUENCY,ID_AFF) values ('1198','test@email.com','Norway','Nov 2020',to_timestamp('20/11/21 18:29:51,138833000','RR/MM/DD HH24:MI:SSXFF'),'COMM_INSERT','0','TEST TExt','TEST TExt','9999','487','Weekly','159'); Insert into TEST_USERS_EMAIL_LIST (ID,EMAIL,AFF,PERIOD_OF_TIME,DTEVENT,EVENT,SEND,COMMENT_TEXT,USER_LAST_CHANGE,ID_CATEGORY,ID_COMMENT,NOTIFICATION_FREQUENCY,ID_AFF) values ('1334','test@email.com','Chile','Nov 2020',to_timestamp('20/11/25 22:00:19,145186000','RR/MM/DD HH24:MI:SSXFF'),'COMM_INSERT','0','TEST TExt','TEST TExt','9999','523','Daily','123'); Insert into TEST_USERS_EMAIL_LIST (ID,EMAIL,AFF,PERIOD_OF_TIME,DTEVENT,EVENT,SEND,COMMENT_TEXT,USER_LAST_CHANGE,ID_CATEGORY,ID_COMMENT,NOTIFICATION_FREQUENCY,ID_AFF) values ('1335','test@email.com','Colombia','Nov 2020',to_timestamp('20/11/25 22:00:19,145186000','RR/MM/DD HH24:MI:SSXFF'),'COMM_INSERT','0','TEST TExt','TEST TExt','9999','524','Daily','110'); Insert into TEST_USERS_EMAIL_LIST (ID,EMAIL,AFF,PERIOD_OF_TIME,DTEVENT,EVENT,SEND,COMMENT_TEXT,USER_LAST_CHANGE,ID_CATEGORY,ID_COMMENT,NOTIFICATION_FREQUENCY,ID_AFF) values ('1336','test@email.com','Costa Rica SR','Nov 2020',to_timestamp('20/11/25 22:00:19,145186000','RR/MM/DD HH24:MI:SSXFF'),'COMM_INSERT','0','TEST TExt','TEST TExt','9999','525','Daily','125'); Insert into TEST_USERS_EMAIL_LIST (ID,EMAIL,AFF,PERIOD_OF_TIME,DTEVENT,EVENT,SEND,COMMENT_TEXT,USER_LAST_CHANGE,ID_CATEGORY,ID_COMMENT,NOTIFICATION_FREQUENCY,ID_AFF) values ('1337','test@email.com','Ecuador','Nov 2020',to_timestamp('20/11/25 22:00:19,145186000','RR/MM/DD HH24:MI:SSXFF'),'COMM_INSERT','0','TEST TExt','TEST TExt','9999','526','Daily','129'); Insert into TEST_USERS_EMAIL_LIST (ID,EMAIL,AFF,PERIOD_OF_TIME,DTEVENT,EVENT,SEND,COMMENT_TEXT,USER_LAST_CHANGE,ID_CATEGORY,ID_COMMENT,NOTIFICATION_FREQUENCY,ID_AFF) values ('1338','test@email.com','Mexico','Nov 2020',to_timestamp('20/11/25 22:00:19,145186000','RR/MM/DD HH24:MI:SSXFF'),'COMM_INSERT','0','TEST TExt','TEST TExt','9999','527','Daily','155'); Insert into TEST_USERS_EMAIL_LIST (ID,EMAIL,AFF,PERIOD_OF_TIME,DTEVENT,EVENT,SEND,COMMENT_TEXT,USER_LAST_CHANGE,ID_CATEGORY,ID_COMMENT,NOTIFICATION_FREQUENCY,ID_AFF) values ('1339','test@email.com','Peru','Nov 2020',to_timestamp('20/11/25 22:00:19,145186000','RR/MM/DD HH24:MI:SSXFF'),'COMM_INSERT','0','TEST TExt','TEST TExt','9999','528','Daily','160'); Insert into TEST_USERS_EMAIL_LIST (ID,EMAIL,AFF,PERIOD_OF_TIME,DTEVENT,EVENT,SEND,COMMENT_TEXT,USER_LAST_CHANGE,ID_CATEGORY,ID_COMMENT,NOTIFICATION_FREQUENCY,ID_AFF) values ('1340','test@email.com','Thailand','Q4 2020, Q4 2020, Q4 2020, Q4 2020',to_timestamp('20/11/25 22:00:19,145186000','RR/MM/DD HH24:MI:SSXFF'),'COMM_INSERT','0','TEST TExt','TEST TExt','1','530','Daily','173'); Insert into TEST_USERS_EMAIL_LIST (ID,EMAIL,AFF,PERIOD_OF_TIME,DTEVENT,EVENT,SEND,COMMENT_TEXT,USER_LAST_CHANGE,ID_CATEGORY,ID_COMMENT,NOTIFICATION_FREQUENCY,ID_AFF) values ('1341','test@email.com','Uruguay','Nov 2020',to_timestamp('20/11/25 22:00:19,145186000','RR/MM/DD HH24:MI:SSXFF'),'COMM_INSERT','0','TEST TExt','TEST TExt','9999','529','Daily','178'); Insert into TEST_USERS_EMAIL_LIST (ID,EMAIL,AFF,PERIOD_OF_TIME,DTEVENT,EVENT,SEND,COMMENT_TEXT,USER_LAST_CHANGE,ID_CATEGORY,ID_COMMENT,NOTIFICATION_FREQUENCY,ID_AFF) values ('1342','test@email.com','United Kingdom','Q4 2020, Q4 2020, Q4 2020',to_timestamp('20/12/01 09:41:13,197620000','RR/MM/DD HH24:MI:SSXFF'),'COMM_INSERT','0','TEST TExt','TEST TExt','11','533','Weekly','177'); Insert into TEST_USERS_EMAIL_LIST (ID,EMAIL,AFF,PERIOD_OF_TIME,DTEVENT,EVENT,SEND,COMMENT_TEXT,USER_LAST_CHANGE,ID_CATEGORY,ID_COMMENT,NOTIFICATION_FREQUENCY,ID_AFF) values ('1343','test@email.com','Switzerland','Q4 2020, Q4 2020',to_timestamp('20/12/01 09:41:13,197620000','RR/MM/DD HH24:MI:SSXFF'),'COMM_INSERT','0','TEST TExt','TEST TExt','1','538','Weekly','109'); Insert into TEST_USERS_EMAIL_LIST (ID,EMAIL,AFF,PERIOD_OF_TIME,DTEVENT,EVENT,SEND,COMMENT_TEXT,USER_LAST_CHANGE,ID_CATEGORY,ID_COMMENT,NOTIFICATION_FREQUENCY,ID_AFF) values ('1344','test@email.com','United Kingdom','Q4 2020, Q4 2020, Q4 2020',to_timestamp('20/12/01 09:41:13,197620000','RR/MM/DD HH24:MI:SSXFF'),'COMM_INSERT','0','TEST TExt','TEST TExt','11','533','Weekly','177'); Insert into TEST_USERS_EMAIL_LIST (ID,EMAIL,AFF,PERIOD_OF_TIME,DTEVENT,EVENT,SEND,COMMENT_TEXT,USER_LAST_CHANGE,ID_CATEGORY,ID_COMMENT,NOTIFICATION_FREQUENCY,ID_AFF) values ('1345','test@email.com','Switzerland','Nov 2020',to_timestamp('20/12/01 09:41:13,197620000','RR/MM/DD HH24:MI:SSXFF'),'COMM_INSERT','0','TEST TExt','TEST TExt','9999','531','Weekly','109'); Insert into TEST_USERS_EMAIL_LIST (ID,EMAIL,AFF,PERIOD_OF_TIME,DTEVENT,EVENT,SEND,COMMENT_TEXT,USER_LAST_CHANGE,ID_CATEGORY,ID_COMMENT,NOTIFICATION_FREQUENCY,ID_AFF) values ('1346','test@email.com','Switzerland','Q4 2020, Q4 2020',to_timestamp('20/12/01 09:41:13,197620000','RR/MM/DD HH24:MI:SSXFF'),'COMM_INSERT','0','TEST TExt','TEST TExt','1','538','Weekly','109'); Insert into TEST_USERS_EMAIL_LIST (ID,EMAIL,AFF,PERIOD_OF_TIME,DTEVENT,EVENT,SEND,COMMENT_TEXT,USER_LAST_CHANGE,ID_CATEGORY,ID_COMMENT,NOTIFICATION_FREQUENCY,ID_AFF) values ('1347','test@email.com','United Kingdom','Q4 2020, Q4 2020, Q4 2020',to_timestamp('20/12/01 09:41:13,197620000','RR/MM/DD HH24:MI:SSXFF'),'COMM_INSERT','0','TEST TExt','TEST TExt','11','533','Weekly','177'); Insert into TEST_USERS_EMAIL_LIST (ID,EMAIL,AFF,PERIOD_OF_TIME,DTEVENT,EVENT,SEND,COMMENT_TEXT,USER_LAST_CHANGE,ID_CATEGORY,ID_COMMENT,NOTIFICATION_FREQUENCY,ID_AFF) values ('1348','test@email.com','Belarus','Q4 2020',to_timestamp('20/12/01 09:41:13,197620000','RR/MM/DD HH24:MI:SSXFF'),'COMM_INSERT','0','TEST TExt','TEST TExt','11','536','Weekly','118'); Insert into TEST_USERS_EMAIL_LIST (ID,EMAIL,AFF,PERIOD_OF_TIME,DTEVENT,EVENT,SEND,COMMENT_TEXT,USER_LAST_CHANGE,ID_CATEGORY,ID_COMMENT,NOTIFICATION_FREQUENCY,ID_AFF) values ('1349','test@email.com','Georgia','Q4 2020',to_timestamp('20/12/01 09:41:13,197620000','RR/MM/DD HH24:MI:SSXFF'),'COMM_INSERT','0','TEST TExt','TEST TExt','11','539','Weekly','133'); Insert into TEST_USERS_EMAIL_LIST (ID,EMAIL,AFF,PERIOD_OF_TIME,DTEVENT,EVENT,SEND,COMMENT_TEXT,USER_LAST_CHANGE,ID_CATEGORY,ID_COMMENT,NOTIFICATION_FREQUENCY,ID_AFF) values ('1350','test@email.com','Iran','Q4 2020',to_timestamp('20/12/01 09:41:13,197620000','RR/MM/DD HH24:MI:SSXFF'),'COMM_INSERT','0','TEST TExt','TEST TExt','11','537','Weekly','142'); Insert into TEST_USERS_EMAIL_LIST (ID,EMAIL,AFF,PERIOD_OF_TIME,DTEVENT,EVENT,SEND,COMMENT_TEXT,USER_LAST_CHANGE,ID_CATEGORY,ID_COMMENT,NOTIFICATION_FREQUENCY,ID_AFF) values ('1351','test@email.com','Serbia & Montenegro','Q4 2020, Q4 2020',to_timestamp('20/12/01 09:41:13,197620000','RR/MM/DD HH24:MI:SSXFF'),'COMM_INSERT','0','TEST TExt','TEST TExt','3','535','Weekly','165'); Insert into TEST_USERS_EMAIL_LIST (ID,EMAIL,AFF,PERIOD_OF_TIME,DTEVENT,EVENT,SEND,COMMENT_TEXT,USER_LAST_CHANGE,ID_CATEGORY,ID_COMMENT,NOTIFICATION_FREQUENCY,ID_AFF) values ('1352','test@email.com','Argentina','Q4 2020',to_timestamp('20/12/01 09:41:13,197620000','RR/MM/DD HH24:MI:SSXFF'),'COMM_INSERT','0','TEST TExt','TEST TExt','10','532','Weekly','115'); Insert into TEST_USERS_EMAIL_LIST (ID,EMAIL,AFF,PERIOD_OF_TIME,DTEVENT,EVENT,SEND,COMMENT_TEXT,USER_LAST_CHANGE,ID_CATEGORY,ID_COMMENT,NOTIFICATION_FREQUENCY,ID_AFF) values ('1353','test@email.com','Belarus','Q4 2020',to_timestamp('20/12/01 09:41:13,197620000','RR/MM/DD HH24:MI:SSXFF'),'COMM_INSERT','0','TEST TExt','TEST TExt','11','536','Weekly','118'); Insert into TEST_USERS_EMAIL_LIST (ID,EMAIL,AFF,PERIOD_OF_TIME,DTEVENT,EVENT,SEND,COMMENT_TEXT,USER_LAST_CHANGE,ID_CATEGORY,ID_COMMENT,NOTIFICATION_FREQUENCY,ID_AFF) values ('1354','test@email.com','Georgia','Q4 2020',to_timestamp('20/12/01 09:41:13,197620000','RR/MM/DD HH24:MI:SSXFF'),'COMM_INSERT','0','TEST TExt','TEST TExt','11','539','Weekly','133'); Insert into TEST_USERS_EMAIL_LIST (ID,EMAIL,AFF,PERIOD_OF_TIME,DTEVENT,EVENT,SEND,COMMENT_TEXT,USER_LAST_CHANGE,ID_CATEGORY,ID_COMMENT,NOTIFICATION_FREQUENCY,ID_AFF) values ('1355','test@email.com','Iran','Q4 2020',to_timestamp('20/12/01 09:41:13,197620000','RR/MM/DD HH24:MI:SSXFF'),'COMM_INSERT','0','TEST TExt','TEST TExt','11','537','Weekly','142'); Insert into TEST_USERS_EMAIL_LIST (ID,EMAIL,AFF,PERIOD_OF_TIME,DTEVENT,EVENT,SEND,COMMENT_TEXT,USER_LAST_CHANGE,ID_CATEGORY,ID_COMMENT,NOTIFICATION_FREQUENCY,ID_AFF) values ('1356','test@email.com','Serbia & Montenegro','Q4 2020, Q4 2020',to_timestamp('20/12/01 09:41:13,197620000','RR/MM/DD HH24:MI:SSXFF'),'COMM_INSERT','0','TEST TExt','TEST TExt','3','535','Weekly','165'); Insert into TEST_USERS_EMAIL_LIST (ID,EMAIL,AFF,PERIOD_OF_TIME,DTEVENT,EVENT,SEND,COMMENT_TEXT,USER_LAST_CHANGE,ID_CATEGORY,ID_COMMENT,NOTIFICATION_FREQUENCY,ID_AFF) values ('1357','test@email.com','Switzerland','Q4 2020, Q4 2020',to_timestamp('20/12/01 09:41:13,197620000','RR/MM/DD HH24:MI:SSXFF'),'COMM_INSERT','0','TEST TExt','TEST TExt','1','538','Weekly','109'); Insert into TEST_USERS_EMAIL_LIST (ID,EMAIL,AFF,PERIOD_OF_TIME,DTEVENT,EVENT,SEND,COMMENT_TEXT,USER_LAST_CHANGE,ID_CATEGORY,ID_COMMENT,NOTIFICATION_FREQUENCY,ID_AFF) values ('1358','test@email.com','Thailand','Q4 2020, Q4 2020, Q4 2020, Q4 2020',to_timestamp('20/12/01 09:41:13,197620000','RR/MM/DD HH24:MI:SSXFF'),'COMM_INSERT','0','TEST TExt','TEST TExt','1','534','Weekly','173'); Insert into TEST_USERS_EMAIL_LIST (ID,EMAIL,AFF,PERIOD_OF_TIME,DTEVENT,EVENT,SEND,COMMENT_TEXT,USER_LAST_CHANGE,ID_CATEGORY,ID_COMMENT,NOTIFICATION_FREQUENCY,ID_AFF) values ('1359','test@email.com','United Kingdom','Q4 2020, Q4 2020, Q4 2020',to_timestamp('20/12/01 09:41:13,197620000','RR/MM/DD HH24:MI:SSXFF'),'COMM_INSERT','0','TEST TExt','TEST TExt','11','533','Weekly','177'); Insert into TEST_USERS_EMAIL_LIST (ID,EMAIL,AFF,PERIOD_OF_TIME,DTEVENT,EVENT,SEND,COMMENT_TEXT,USER_LAST_CHANGE,ID_CATEGORY,ID_COMMENT,NOTIFICATION_FREQUENCY,ID_AFF) values ('1360','test@email.com','Thailand','Q4 2020, Q4 2020, Q4 2020, Q4 2020',to_timestamp('20/12/01 09:41:13,197620000','RR/MM/DD HH24:MI:SSXFF'),'COMM_INSERT','0','TEST TExt','TEST TExt','1','534','Weekly','173'); Insert into TEST_USERS_EMAIL_LIST (ID,EMAIL,AFF,PERIOD_OF_TIME,DTEVENT,EVENT,SEND,COMMENT_TEXT,USER_LAST_CHANGE,ID_CATEGORY,ID_COMMENT,NOTIFICATION_FREQUENCY,ID_AFF) values ('1361','test@email.com','Serbia & Montenegro','Q4 2020, Q4 2020',to_timestamp('20/12/01 09:41:13,197620000','RR/MM/DD HH24:MI:SSXFF'),'COMM_INSERT','0','TEST TExt','TEST TExt','3','535','Weekly','165'); Insert into TEST_USERS_EMAIL_LIST (ID,EMAIL,AFF,PERIOD_OF_TIME,DTEVENT,EVENT,SEND,COMMENT_TEXT,USER_LAST_CHANGE,ID_CATEGORY,ID_COMMENT,NOTIFICATION_FREQUENCY,ID_AFF) values ('1362','test@email.com','Switzerland','Q4 2020, Q4 2020',to_timestamp('20/12/01 09:41:13,197620000','RR/MM/DD HH24:MI:SSXFF'),'COMM_INSERT','0','TEST TExt','TEST TExt','1','538','Weekly','109'); Insert into TEST_USERS_EMAIL_LIST (ID,EMAIL,AFF,PERIOD_OF_TIME,DTEVENT,EVENT,SEND,COMMENT_TEXT,USER_LAST_CHANGE,ID_CATEGORY,ID_COMMENT,NOTIFICATION_FREQUENCY,ID_AFF) values ('1363','test@email.com','Thailand','Q4 2020, Q4 2020, Q4 2020, Q4 2020',to_timestamp('20/12/01 09:41:13,197620000','RR/MM/DD HH24:MI:SSXFF'),'COMM_INSERT','0','TEST TExt','TEST TExt','1','534','Weekly','173'); Insert into TEST_USERS_EMAIL_LIST (ID,EMAIL,AFF,PERIOD_OF_TIME,DTEVENT,EVENT,SEND,COMMENT_TEXT,USER_LAST_CHANGE,ID_CATEGORY,ID_COMMENT,NOTIFICATION_FREQUENCY,ID_AFF) values ('1364','test@email.com','Belarus','Q4 2020',to_timestamp('20/12/01 09:41:13,197620000','RR/MM/DD HH24:MI:SSXFF'),'COMM_INSERT','0','TEST TExt','TEST TExt','11','536','Weekly','118'); Insert into TEST_USERS_EMAIL_LIST (ID,EMAIL,AFF,PERIOD_OF_TIME,DTEVENT,EVENT,SEND,COMMENT_TEXT,USER_LAST_CHANGE,ID_CATEGORY,ID_COMMENT,NOTIFICATION_FREQUENCY,ID_AFF) values ('1365','test@email.com','Georgia','Q4 2020',to_timestamp('20/12/01 09:41:13,197620000','RR/MM/DD HH24:MI:SSXFF'),'COMM_INSERT','0','TEST TExt','TEST TExt','11','539','Weekly','133'); Insert into TEST_USERS_EMAIL_LIST (ID,EMAIL,AFF,PERIOD_OF_TIME,DTEVENT,EVENT,SEND,COMMENT_TEXT,USER_LAST_CHANGE,ID_CATEGORY,ID_COMMENT,NOTIFICATION_FREQUENCY,ID_AFF) values ('1366','test@email.com','Mexico','Q4 2020',to_timestamp('20/11/23 06:00:10,516722000','RR/MM/DD HH24:MI:SSXFF'),'COMM_INSERT','0','TEST TExt','TEST TExt','2','507','Weekly','155'); Insert into TEST_USERS_EMAIL_LIST (ID,EMAIL,AFF,PERIOD_OF_TIME,DTEVENT,EVENT,SEND,COMMENT_TEXT,USER_LAST_CHANGE,ID_CATEGORY,ID_COMMENT,NOTIFICATION_FREQUENCY,ID_AFF) values ('1367','test@email.com','Peru','Q4 2020',to_timestamp('20/11/23 06:00:10,516722000','RR/MM/DD HH24:MI:SSXFF'),'COMM_INSERT','0','TEST TExt','TEST TExt','1','504','Weekly','160'); Insert into TEST_USERS_EMAIL_LIST (ID,EMAIL,AFF,PERIOD_OF_TIME,DTEVENT,EVENT,SEND,COMMENT_TEXT,USER_LAST_CHANGE,ID_CATEGORY,ID_COMMENT,NOTIFICATION_FREQUENCY,ID_AFF) values ('1368','test@email.com','South Africa SR','Q4 2020, Q4 2020, Q4 2020, Q4 2020, Q4 2020, Q4 2020, Q4 2020, Q4 2020, Q4 2020, Q4 2020, Q4 2020, Q4 2020, Q4 2020',to_timestamp('20/11/23 06:00:10,516722000','RR/MM/DD HH24:MI:SSXFF'),'COMM_INSERT','0','TEST TExt','TEST TExt','3','519','Weekly','169'); Insert into TEST_USERS_EMAIL_LIST (ID,EMAIL,AFF,PERIOD_OF_TIME,DTEVENT,EVENT,SEND,COMMENT_TEXT,USER_LAST_CHANGE,ID_CATEGORY,ID_COMMENT,NOTIFICATION_FREQUENCY,ID_AFF) values ('1369','test@email.com','Tunisia','Q4 2020',to_timestamp('20/11/23 06:00:10,516722000','RR/MM/DD HH24:MI:SSXFF'),'COMM_INSERT','0','TEST TExt','TEST TExt','3','512','Weekly','174'); Insert into TEST_USERS_EMAIL_LIST (ID,EMAIL,AFF,PERIOD_OF_TIME,DTEVENT,EVENT,SEND,COMMENT_TEXT,USER_LAST_CHANGE,ID_CATEGORY,ID_COMMENT,NOTIFICATION_FREQUENCY,ID_AFF) values ('1370','test@email.com','Turkey','Q4 2020',to_timestamp('20/11/23 06:00:10,516722000','RR/MM/DD HH24:MI:SSXFF'),'COMM_INSERT','0','TEST TExt','TEST TExt','1','508','Weekly','101'); Insert into TEST_USERS_EMAIL_LIST (ID,EMAIL,AFF,PERIOD_OF_TIME,DTEVENT,EVENT,SEND,COMMENT_TEXT,USER_LAST_CHANGE,ID_CATEGORY,ID_COMMENT,NOTIFICATION_FREQUENCY,ID_AFF) values ('1371','test@email.com','Turkmenistan','Q4 2020',to_timestamp('20/11/23 06:00:10,516722000','RR/MM/DD HH24:MI:SSXFF'),'COMM_INSERT','0','TEST TExt','TEST TExt','2','509','Weekly','180'); Insert into TEST_USERS_EMAIL_LIST (ID,EMAIL,AFF,PERIOD_OF_TIME,DTEVENT,EVENT,SEND,COMMENT_TEXT,USER_LAST_CHANGE,ID_CATEGORY,ID_COMMENT,NOTIFICATION_FREQUENCY,ID_AFF) values ('1372','test@email.com','United Kingdom','Q4 2020',to_timestamp('20/11/23 06:00:10,516722000','RR/MM/DD HH24:MI:SSXFF'),'COMM_INSERT','0','TEST TExt','TEST TExt','1','506','Weekly','177'); Insert into TEST_USERS_EMAIL_LIST (ID,EMAIL,AFF,PERIOD_OF_TIME,DTEVENT,EVENT,SEND,COMMENT_TEXT,USER_LAST_CHANGE,ID_CATEGORY,ID_COMMENT,NOTIFICATION_FREQUENCY,ID_AFF) values ('1373','test@email.com','Uruguay','Q4 2020, Q3 2020, Q4 2020, Q3 2020, Q4 2020, Q3 2020',to_timestamp('20/11/23 06:00:10,516722000','RR/MM/DD HH24:MI:SSXFF'),'COMM_INSERT','0','TEST TExt','TEST TExt','2','498','Weekly','178'); Insert into TEST_USERS_EMAIL_LIST (ID,EMAIL,AFF,PERIOD_OF_TIME,DTEVENT,EVENT,SEND,COMMENT_TEXT,USER_LAST_CHANGE,ID_CATEGORY,ID_COMMENT,NOTIFICATION_FREQUENCY,ID_AFF) values ('1374','test@email.com','Uruguay','Q4 2020, Q3 2020, Q4 2020, Q3 2020, Q4 2020, Q3 2020',to_timestamp('20/11/23 06:00:10,516722000','RR/MM/DD HH24:MI:SSXFF'),'COMM_INSERT','0','TEST TExt','TEST TExt','2','497','Weekly','178'); Insert into TEST_USERS_EMAIL_LIST (ID,EMAIL,AFF,PERIOD_OF_TIME,DTEVENT,EVENT,SEND,COMMENT_TEXT,USER_LAST_CHANGE,ID_CATEGORY,ID_COMMENT,NOTIFICATION_FREQUENCY,ID_AFF) values ('1375','test@email.com','Uruguay','Q4 2020, Q3 2020, Q4 2020, Q3 2020, Q4 2020, Q3 2020',to_timestamp('20/11/23 06:00:10,516722000','RR/MM/DD HH24:MI:SSXFF'),'COMM_INSERT','0','TEST TExt','TEST TExt','2','500','Weekly','178'); Insert into TEST_USERS_EMAIL_LIST (ID,EMAIL,AFF,PERIOD_OF_TIME,DTEVENT,EVENT,SEND,COMMENT_TEXT,USER_LAST_CHANGE,ID_CATEGORY,ID_COMMENT,NOTIFICATION_FREQUENCY,ID_AFF) values ('1376','test@email.com','Uruguay','Q4 2020, Q3 2020, Q4 2020, Q3 2020, Q4 2020, Q3 2020',to_timestamp('20/11/23 06:00:10,516722000','RR/MM/DD HH24:MI:SSXFF'),'COMM_INSERT','0','TEST TExt','TEST TExt','2','499','Weekly','178'); Insert into TEST_USERS_EMAIL_LIST (ID,EMAIL,AFF,PERIOD_OF_TIME,DTEVENT,EVENT,SEND,COMMENT_TEXT,USER_LAST_CHANGE,ID_CATEGORY,ID_COMMENT,NOTIFICATION_FREQUENCY,ID_AFF) values ('1377','test@email.com','Uruguay','Q4 2020, Q3 2020, Q4 2020, Q3 2020, Q4 2020, Q3 2020',to_timestamp('20/11/23 06:00:10,516722000','RR/MM/DD HH24:MI:SSXFF'),'COMM_INSERT','0','TEST TExt','TEST TExt','5','501','Weekly','178'); Insert into TEST_USERS_EMAIL_LIST (ID,EMAIL,AFF,PERIOD_OF_TIME,DTEVENT,EVENT,SEND,COMMENT_TEXT,USER_LAST_CHANGE,ID_CATEGORY,ID_COMMENT,NOTIFICATION_FREQUENCY,ID_AFF) values ('1378','test@email.com','Uruguay','Q4 2020, Q3 2020, Q4 2020, Q3 2020, Q4 2020, Q3 2020',to_timestamp('20/11/23 06:00:10,516722000','RR/MM/DD HH24:MI:SSXFF'),'COMM_INSERT','0','TEST TExt','TEST TExt','8','503','Weekly','178'); Insert into TEST_USERS_EMAIL_LIST (ID,EMAIL,AFF,PERIOD_OF_TIME,DTEVENT,EVENT,SEND,COMMENT_TEXT,USER_LAST_CHANGE,ID_CATEGORY,ID_COMMENT,NOTIFICATION_FREQUENCY,ID_AFF) values ('1379','test@email.com','Uruguay','Q4 2020, Q3 2020, Q4 2020, Q3 2020, Q4 2020, Q3 2020',to_timestamp('20/11/23 06:00:10,516722000','RR/MM/DD HH24:MI:SSXFF'),'COMM_INSERT','0','TEST TExt','TEST TExt','8','502','Weekly','178'); Insert into TEST_USERS_EMAIL_LIST (ID,EMAIL,AFF,PERIOD_OF_TIME,DTEVENT,EVENT,SEND,COMMENT_TEXT,USER_LAST_CHANGE,ID_CATEGORY,ID_COMMENT,NOTIFICATION_FREQUENCY,ID_AFF) values ('1430','test@email.com','Finland','Nov 2020',to_timestamp('20/11/23 06:00:10,516722000','RR/MM/DD HH24:MI:SSXFF'),'COMM_UPDATE','0','TEST TExt','TEST TExt','9999','488','Weekly','131'); Insert into TEST_USERS_EMAIL_LIST (ID,EMAIL,AFF,PERIOD_OF_TIME,DTEVENT,EVENT,SEND,COMMENT_TEXT,USER_LAST_CHANGE,ID_CATEGORY,ID_COMMENT,NOTIFICATION_FREQUENCY,ID_AFF) values ('1431','test@email.com','Ireland','Jul 2020',to_timestamp('20/11/23 06:00:10,516722000','RR/MM/DD HH24:MI:SSXFF'),'COMM_UPDATE','0','TEST TExt','TEST TExt','9999','361','Weekly','143'); Insert into TEST_USERS_EMAIL_LIST (ID,EMAIL,AFF,PERIOD_OF_TIME,DTEVENT,EVENT,SEND,COMMENT_TEXT,USER_LAST_CHANGE,ID_CATEGORY,ID_COMMENT,NOTIFICATION_FREQUENCY,ID_AFF) values ('1432','test@email.com','Norway','Nov 2020',to_timestamp('20/11/23 06:00:10,516722000','RR/MM/DD HH24:MI:SSXFF'),'COMM_UPDATE','0','TEST TExt','TEST TExt','9999','487','Weekly','159'); Insert into TEST_USERS_EMAIL_LIST (ID,EMAIL,AFF,PERIOD_OF_TIME,DTEVENT,EVENT,SEND,COMMENT_TEXT,USER_LAST_CHANGE,ID_CATEGORY,ID_COMMENT,NOTIFICATION_FREQUENCY,ID_AFF) values ('1433','test@email.com','Sweden','Mar 2020',to_timestamp('20/11/23 06:00:10,516722000','RR/MM/DD HH24:MI:SSXFF'),'COMM_UPDATE','0','TEST TExt','TEST TExt','9999','76','Weekly','171'); Insert into TEST_USERS_EMAIL_LIST (ID,EMAIL,AFF,PERIOD_OF_TIME,DTEVENT,EVENT,SEND,COMMENT_TEXT,USER_LAST_CHANGE,ID_CATEGORY,ID_COMMENT,NOTIFICATION_FREQUENCY,ID_AFF) values ('1434','test@email.com','Sweden','May 2020',to_timestamp('20/11/23 06:00:10,516722000','RR/MM/DD HH24:MI:SSXFF'),'COMM_UPDATE','0','TEST TExt','TEST TExt','9999','252','Weekly','171'); Insert into TEST_USERS_EMAIL_LIST (ID,EMAIL,AFF,PERIOD_OF_TIME,DTEVENT,EVENT,SEND,COMMENT_TEXT,USER_LAST_CHANGE,ID_CATEGORY,ID_COMMENT,NOTIFICATION_FREQUENCY,ID_AFF) values ('1435','test@email.com','United Arab Emirates','Q4 2020',to_timestamp('20/11/24 22:00:15,950326000','RR/MM/DD HH24:MI:SSXFF'),'COMM_INSERT','0','TEST TExt','TEST TExt','10','520','Daily','176'); Insert into TEST_USERS_EMAIL_LIST (ID,EMAIL,AFF,PERIOD_OF_TIME,DTEVENT,EVENT,SEND,COMMENT_TEXT,USER_LAST_CHANGE,ID_CATEGORY,ID_COMMENT,NOTIFICATION_FREQUENCY,ID_AFF) values ('1436','test@email.com','Argentina','Q4 2020',to_timestamp('20/11/26 22:00:21,401626000','RR/MM/DD HH24:MI:SSXFF'),'COMM_INSERT','0','TEST TExt','TEST TExt','10','532','Daily','115'); Insert into TEST_USERS_EMAIL_LIST (ID,EMAIL,AFF,PERIOD_OF_TIME,DTEVENT,EVENT,SEND,COMMENT_TEXT,USER_LAST_CHANGE,ID_CATEGORY,ID_COMMENT,NOTIFICATION_FREQUENCY,ID_AFF) values ('1437','test@email.com','Argentina','Q4 2020',to_timestamp('20/11/26 22:00:21,401626000','RR/MM/DD HH24:MI:SSXFF'),'COMM_INSERT','0','TEST TExt','TEST TExt','10','532','Daily','115'); Insert into TEST_USERS_EMAIL_LIST (ID,EMAIL,AFF,PERIOD_OF_TIME,DTEVENT,EVENT,SEND,COMMENT_TEXT,USER_LAST_CHANGE,ID_CATEGORY,ID_COMMENT,NOTIFICATION_FREQUENCY,ID_AFF) values ('1438','test@email.com','Switzerland','Nov 2020',to_timestamp('20/11/26 22:00:21,401626000','RR/MM/DD HH24:MI:SSXFF'),'COMM_INSERT','0','TEST TExt','TEST TExt','9999','531','Daily','109'); Insert into TEST_USERS_EMAIL_LIST (ID,EMAIL,AFF,PERIOD_OF_TIME,DTEVENT,EVENT,SEND,COMMENT_TEXT,USER_LAST_CHANGE,ID_CATEGORY,ID_COMMENT,NOTIFICATION_FREQUENCY,ID_AFF) values ('1439','test@email.com','United Kingdom','Q4 2020, Q4 2020, Q4 2020',to_timestamp('20/11/26 22:00:21,401626000','RR/MM/DD HH24:MI:SSXFF'),'COMM_INSERT','0','TEST TExt','TEST TExt','11','533','Daily','177'); Insert into TEST_USERS_EMAIL_LIST (ID,EMAIL,AFF,PERIOD_OF_TIME,DTEVENT,EVENT,SEND,COMMENT_TEXT,USER_LAST_CHANGE,ID_CATEGORY,ID_COMMENT,NOTIFICATION_FREQUENCY,ID_AFF) values ('1440','test@email.com','Switzerland','Q4 2020, Q4 2020',to_timestamp('20/12/01 09:41:13,197620000','RR/MM/DD HH24:MI:SSXFF'),'COMM_INSERT','0','TEST TExt','TEST TExt','1','538','Weekly','109'); Insert into TEST_USERS_EMAIL_LIST (ID,EMAIL,AFF,PERIOD_OF_TIME,DTEVENT,EVENT,SEND,COMMENT_TEXT,USER_LAST_CHANGE,ID_CATEGORY,ID_COMMENT,NOTIFICATION_FREQUENCY,ID_AFF) values ('1441','test@email.com','United Kingdom','Q4 2020, Q4 2020, Q4 2020',to_timestamp('20/12/01 09:41:13,197620000','RR/MM/DD HH24:MI:SSXFF'),'COMM_INSERT','0','TEST TExt','TEST TExt','11','533','Weekly','177'); Insert into TEST_USERS_EMAIL_LIST (ID,EMAIL,AFF,PERIOD_OF_TIME,DTEVENT,EVENT,SEND,COMMENT_TEXT,USER_LAST_CHANGE,ID_CATEGORY,ID_COMMENT,NOTIFICATION_FREQUENCY,ID_AFF) values ('1442','test@email.com','United Kingdom','Q4 2020, Q4 2020, Q4 2020',to_timestamp('20/12/01 09:41:13,197620000','RR/MM/DD HH24:MI:SSXFF'),'COMM_INSERT','0','TEST TExt','TEST TExt','11','533','Weekly','177'); Insert into TEST_USERS_EMAIL_LIST (ID,EMAIL,AFF,PERIOD_OF_TIME,DTEVENT,EVENT,SEND,COMMENT_TEXT,USER_LAST_CHANGE,ID_CATEGORY,ID_COMMENT,NOTIFICATION_FREQUENCY,ID_AFF) values ('1443','test@email.com','Serbia & Montenegro','Q4 2020, Q4 2020',to_timestamp('20/12/01 09:41:13,197620000','RR/MM/DD HH24:MI:SSXFF'),'COMM_INSERT','0','TEST TExt','TEST TExt','3','535','Weekly','165'); Insert into TEST_USERS_EMAIL_LIST (ID,EMAIL,AFF,PERIOD_OF_TIME,DTEVENT,EVENT,SEND,COMMENT_TEXT,USER_LAST_CHANGE,ID_CATEGORY,ID_COMMENT,NOTIFICATION_FREQUENCY,ID_AFF) values ('1444','test@email.com','Thailand','Q4 2020, Q4 2020, Q4 2020, Q4 2020',to_timestamp('20/12/01 09:41:13,197620000','RR/MM/DD HH24:MI:SSXFF'),'COMM_INSERT','0','TEST TExt','TEST TExt','1','534','Weekly','173'); Insert into TEST_USERS_EMAIL_LIST (ID,EMAIL,AFF,PERIOD_OF_TIME,DTEVENT,EVENT,SEND,COMMENT_TEXT,USER_LAST_CHANGE,ID_CATEGORY,ID_COMMENT,NOTIFICATION_FREQUENCY,ID_AFF) values ('1445','test@email.com','Belarus','Q4 2020',to_timestamp('20/12/01 09:41:13,197620000','RR/MM/DD HH24:MI:SSXFF'),'COMM_INSERT','0','TEST TExt','TEST TExt','11','536','Weekly','118'); Insert into TEST_USERS_EMAIL_LIST (ID,EMAIL,AFF,PERIOD_OF_TIME,DTEVENT,EVENT,SEND,COMMENT_TEXT,USER_LAST_CHANGE,ID_CATEGORY,ID_COMMENT,NOTIFICATION_FREQUENCY,ID_AFF) values ('1446','test@email.com','Georgia','Q4 2020',to_timestamp('20/12/01 09:41:13,197620000','RR/MM/DD HH24:MI:SSXFF'),'COMM_INSERT','0','TEST TExt','TEST TExt','11','539','Weekly','133'); Insert into TEST_USERS_EMAIL_LIST (ID,EMAIL,AFF,PERIOD_OF_TIME,DTEVENT,EVENT,SEND,COMMENT_TEXT,USER_LAST_CHANGE,ID_CATEGORY,ID_COMMENT,NOTIFICATION_FREQUENCY,ID_AFF) values ('1447','test@email.com','Iran','Q4 2020',to_timestamp('20/12/01 09:41:13,197620000','RR/MM/DD HH24:MI:SSXFF'),'COMM_INSERT','0','TEST TExt','TEST TExt','11','537','Weekly','142'); Insert into TEST_USERS_EMAIL_LIST (ID,EMAIL,AFF,PERIOD_OF_TIME,DTEVENT,EVENT,SEND,COMMENT_TEXT,USER_LAST_CHANGE,ID_CATEGORY,ID_COMMENT,NOTIFICATION_FREQUENCY,ID_AFF) values ('1448','test@email.com','Serbia & Montenegro','Q4 2020, Q4 2020',to_timestamp('20/12/01 09:41:13,197620000','RR/MM/DD HH24:MI:SSXFF'),'COMM_INSERT','0','TEST TExt','TEST TExt','3','535','Weekly','165'); Insert into TEST_USERS_EMAIL_LIST (ID,EMAIL,AFF,PERIOD_OF_TIME,DTEVENT,EVENT,SEND,COMMENT_TEXT,USER_LAST_CHANGE,ID_CATEGORY,ID_COMMENT,NOTIFICATION_FREQUENCY,ID_AFF) values ('1449','test@email.com','Thailand','Q4 2020, Q4 2020, Q4 2020, Q4 2020',to_timestamp('20/12/01 09:41:13,197620000','RR/MM/DD HH24:MI:SSXFF'),'COMM_INSERT','0','TEST TExt','TEST TExt','1','534','Weekly','173'); Insert into TEST_USERS_EMAIL_LIST (ID,EMAIL,AFF,PERIOD_OF_TIME,DTEVENT,EVENT,SEND,COMMENT_TEXT,USER_LAST_CHANGE,ID_CATEGORY,ID_COMMENT,NOTIFICATION_FREQUENCY,ID_AFF) values ('1450','test@email.com','Thailand','Q4 2020, Q4 2020, Q4 2020, Q4 2020',to_timestamp('20/12/01 09:41:13,197620000','RR/MM/DD HH24:MI:SSXFF'),'COMM_INSERT','0','TEST TExt','TEST TExt','1','534','Weekly','173'); Insert into TEST_USERS_EMAIL_LIST (ID,EMAIL,AFF,PERIOD_OF_TIME,DTEVENT,EVENT,SEND,COMMENT_TEXT,USER_LAST_CHANGE,ID_CATEGORY,ID_COMMENT,NOTIFICATION_FREQUENCY,ID_AFF) values ('1451','test@email.com','Argentina','Q4 2020',to_timestamp('20/12/01 09:41:13,197620000','RR/MM/DD HH24:MI:SSXFF'),'COMM_INSERT','0','TEST TExt','TEST TExt','10','532','Weekly','115'); Insert into TEST_USERS_EMAIL_LIST (ID,EMAIL,AFF,PERIOD_OF_TIME,DTEVENT,EVENT,SEND,COMMENT_TEXT,USER_LAST_CHANGE,ID_CATEGORY,ID_COMMENT,NOTIFICATION_FREQUENCY,ID_AFF) values ('1452','test@email.com','Belarus','Q4 2020',to_timestamp('20/12/01 09:41:13,197620000','RR/MM/DD HH24:MI:SSXFF'),'COMM_INSERT','0','TEST TExt','TEST TExt','11','536','Weekly','118'); Insert into TEST_USERS_EMAIL_LIST (ID,EMAIL,AFF,PERIOD_OF_TIME,DTEVENT,EVENT,SEND,COMMENT_TEXT,USER_LAST_CHANGE,ID_CATEGORY,ID_COMMENT,NOTIFICATION_FREQUENCY,ID_AFF) values ('1453','test@email.com','Georgia','Q4 2020',to_timestamp('20/12/01 09:41:13,197620000','RR/MM/DD HH24:MI:SSXFF'),'COMM_INSERT','0','TEST TExt','TEST TExt','11','539','Weekly','133'); Insert into TEST_USERS_EMAIL_LIST (ID,EMAIL,AFF,PERIOD_OF_TIME,DTEVENT,EVENT,SEND,COMMENT_TEXT,USER_LAST_CHANGE,ID_CATEGORY,ID_COMMENT,NOTIFICATION_FREQUENCY,ID_AFF) values ('1454','test@email.com','Iran','Q4 2020',to_timestamp('20/12/01 09:41:13,197620000','RR/MM/DD HH24:MI:SSXFF'),'COMM_INSERT','0','TEST TExt','TEST TExt','11','537','Weekly','142'); Insert into TEST_USERS_EMAIL_LIST (ID,EMAIL,AFF,PERIOD_OF_TIME,DTEVENT,EVENT,SEND,COMMENT_TEXT,USER_LAST_CHANGE,ID_CATEGORY,ID_COMMENT,NOTIFICATION_FREQUENCY,ID_AFF) values ('1455','test@email.com','Serbia & Montenegro','Q4 2020, Q4 2020',to_timestamp('20/12/01 09:41:13,197620000','RR/MM/DD HH24:MI:SSXFF'),'COMM_INSERT','0','TEST TExt','TEST TExt','3','535','Weekly','165'); Insert into TEST_USERS_EMAIL_LIST (ID,EMAIL,AFF,PERIOD_OF_TIME,DTEVENT,EVENT,SEND,COMMENT_TEXT,USER_LAST_CHANGE,ID_CATEGORY,ID_COMMENT,NOTIFICATION_FREQUENCY,ID_AFF) values ('1456','test@email.com','Switzerland','Q4 2020, Q4 2020',to_timestamp('20/12/01 09:41:13,197620000','RR/MM/DD HH24:MI:SSXFF'),'COMM_INSERT','0','TEST TExt','TEST TExt','1','538','Weekly','109'); Insert into TEST_USERS_EMAIL_LIST (ID,EMAIL,AFF,PERIOD_OF_TIME,DTEVENT,EVENT,SEND,COMMENT_TEXT,USER_LAST_CHANGE,ID_CATEGORY,ID_COMMENT,NOTIFICATION_FREQUENCY,ID_AFF) values ('1457','test@email.com','Thailand','Q4 2020, Q4 2020, Q4 2020, Q4 2020',to_timestamp('20/12/01 09:41:13,197620000','RR/MM/DD HH24:MI:SSXFF'),'COMM_INSERT','0','TEST TExt','TEST TExt','1','534','Weekly','173'); Insert into TEST_USERS_EMAIL_LIST (ID,EMAIL,AFF,PERIOD_OF_TIME,DTEVENT,EVENT,SEND,COMMENT_TEXT,USER_LAST_CHANGE,ID_CATEGORY,ID_COMMENT,NOTIFICATION_FREQUENCY,ID_AFF) values ('1380','test@email.com','Uruguay','Q4 2020, Q4 2020, Q4 2020',to_timestamp('20/11/23 06:00:10,516722000','RR/MM/DD HH24:MI:SSXFF'),'COMM_INSERT','0','TEST TExt','TEST TExt','3','516','Weekly','178'); Insert into TEST_USERS_EMAIL_LIST (ID,EMAIL,AFF,PERIOD_OF_TIME,DTEVENT,EVENT,SEND,COMMENT_TEXT,USER_LAST_CHANGE,ID_CATEGORY,ID_COMMENT,NOTIFICATION_FREQUENCY,ID_AFF) values ('1381','test@email.com','Uruguay','Q4 2020, Q4 2020, Q4 2020',to_timestamp('20/11/23 06:00:10,516722000','RR/MM/DD HH24:MI:SSXFF'),'COMM_INSERT','0','TEST TExt','TEST TExt','5','514','Weekly','178'); Insert into TEST_USERS_EMAIL_LIST (ID,EMAIL,AFF,PERIOD_OF_TIME,DTEVENT,EVENT,SEND,COMMENT_TEXT,USER_LAST_CHANGE,ID_CATEGORY,ID_COMMENT,NOTIFICATION_FREQUENCY,ID_AFF) values ('1382','test@email.com','Uruguay','Q4 2020, Q4 2020, Q4 2020',to_timestamp('20/11/23 06:00:10,516722000','RR/MM/DD HH24:MI:SSXFF'),'COMM_INSERT','0','TEST TExt','TEST TExt','6','517','Weekly','178'); Insert into TEST_USERS_EMAIL_LIST (ID,EMAIL,AFF,PERIOD_OF_TIME,DTEVENT,EVENT,SEND,COMMENT_TEXT,USER_LAST_CHANGE,ID_CATEGORY,ID_COMMENT,NOTIFICATION_FREQUENCY,ID_AFF) values ('1383','test@email.com','Uruguay','Q4 2020, Q4 2020, Q4 2020',to_timestamp('20/11/23 06:00:10,516722000','RR/MM/DD HH24:MI:SSXFF'),'COMM_INSERT','0','TEST TExt','TEST TExt','8','515','Weekly','178'); Insert into TEST_USERS_EMAIL_LIST (ID,EMAIL,AFF,PERIOD_OF_TIME,DTEVENT,EVENT,SEND,COMMENT_TEXT,USER_LAST_CHANGE,ID_CATEGORY,ID_COMMENT,NOTIFICATION_FREQUENCY,ID_AFF) values ('1384','test@email.com','Brazil','Q4 2020',to_timestamp('20/11/23 06:00:10,516722000','RR/MM/DD HH24:MI:SSXFF'),'COMM_INSERT','0','TEST TExt','TEST TExt','1','495','Weekly','108'); Insert into TEST_USERS_EMAIL_LIST (ID,EMAIL,AFF,PERIOD_OF_TIME,DTEVENT,EVENT,SEND,COMMENT_TEXT,USER_LAST_CHANGE,ID_CATEGORY,ID_COMMENT,NOTIFICATION_FREQUENCY,ID_AFF) values ('1385','test@email.com','Brazil','Q4 2020',to_timestamp('20/11/23 06:00:10,516722000','RR/MM/DD HH24:MI:SSXFF'),'COMM_INSERT','0','TEST TExt','TEST TExt','3','496','Weekly','108'); Insert into TEST_USERS_EMAIL_LIST (ID,EMAIL,AFF,PERIOD_OF_TIME,DTEVENT,EVENT,SEND,COMMENT_TEXT,USER_LAST_CHANGE,ID_CATEGORY,ID_COMMENT,NOTIFICATION_FREQUENCY,ID_AFF) values ('1386','test@email.com','Chile','Q4 2020',to_timestamp('20/11/23 06:00:10,516722000','RR/MM/DD HH24:MI:SSXFF'),'COMM_INSERT','0','TEST TExt','TEST TExt','3','513','Weekly','123'); Insert into TEST_USERS_EMAIL_LIST (ID,EMAIL,AFF,PERIOD_OF_TIME,DTEVENT,EVENT,SEND,COMMENT_TEXT,USER_LAST_CHANGE,ID_CATEGORY,ID_COMMENT,NOTIFICATION_FREQUENCY,ID_AFF) values ('1387','test@email.com','India','Q4 2020, Q4 2020',to_timestamp('20/11/23 06:00:10,516722000','RR/MM/DD HH24:MI:SSXFF'),'COMM_INSERT','0','TEST TExt','TEST TExt','3','510','Weekly','138'); Insert into TEST_USERS_EMAIL_LIST (ID,EMAIL,AFF,PERIOD_OF_TIME,DTEVENT,EVENT,SEND,COMMENT_TEXT,USER_LAST_CHANGE,ID_CATEGORY,ID_COMMENT,NOTIFICATION_FREQUENCY,ID_AFF) values ('1388','test@email.com','India','Q4 2020, Q4 2020',to_timestamp('20/11/23 06:00:10,516722000','RR/MM/DD HH24:MI:SSXFF'),'COMM_INSERT','0','TEST TExt','TEST TExt','3','511','Weekly','138'); Insert into TEST_USERS_EMAIL_LIST (ID,EMAIL,AFF,PERIOD_OF_TIME,DTEVENT,EVENT,SEND,COMMENT_TEXT,USER_LAST_CHANGE,ID_CATEGORY,ID_COMMENT,NOTIFICATION_FREQUENCY,ID_AFF) values ('1389','test@email.com','Malaysia','Q4 2020',to_timestamp('20/11/23 06:00:10,516722000','RR/MM/DD HH24:MI:SSXFF'),'COMM_INSERT','0','TEST TExt','TEST TExt','3','486','Weekly','154'); Insert into TEST_USERS_EMAIL_LIST (ID,EMAIL,AFF,PERIOD_OF_TIME,DTEVENT,EVENT,SEND,COMMENT_TEXT,USER_LAST_CHANGE,ID_CATEGORY,ID_COMMENT,NOTIFICATION_FREQUENCY,ID_AFF) values ('1390','test@email.com','Peru','Q4 2020',to_timestamp('20/11/23 06:00:10,516722000','RR/MM/DD HH24:MI:SSXFF'),'COMM_INSERT','0','TEST TExt','TEST TExt','1','504','Weekly','160'); Insert into TEST_USERS_EMAIL_LIST (ID,EMAIL,AFF,PERIOD_OF_TIME,DTEVENT,EVENT,SEND,COMMENT_TEXT,USER_LAST_CHANGE,ID_CATEGORY,ID_COMMENT,NOTIFICATION_FREQUENCY,ID_AFF) values ('1391','test@email.com','South Africa SR','Q4 2020, Q4 2020, Q4 2020, Q4 2020, Q4 2020, Q4 2020, Q4 2020, Q4 2020, Q4 2020, Q4 2020, Q4 2020, Q4 2020, Q4 2020',to_timestamp('20/11/23 06:00:10,516722000','RR/MM/DD HH24:MI:SSXFF'),'COMM_INSERT','0','TEST TExt','TEST TExt','3','519','Weekly','169'); Insert into TEST_USERS_EMAIL_LIST (ID,EMAIL,AFF,PERIOD_OF_TIME,DTEVENT,EVENT,SEND,COMMENT_TEXT,USER_LAST_CHANGE,ID_CATEGORY,ID_COMMENT,NOTIFICATION_FREQUENCY,ID_AFF) values ('1392','test@email.com','Tunisia','Q4 2020',to_timestamp('20/11/23 06:00:10,516722000','RR/MM/DD HH24:MI:SSXFF'),'COMM_INSERT','0','TEST TExt','TEST TExt','3','512','Weekly','174'); Insert into TEST_USERS_EMAIL_LIST (ID,EMAIL,AFF,PERIOD_OF_TIME,DTEVENT,EVENT,SEND,COMMENT_TEXT,USER_LAST_CHANGE,ID_CATEGORY,ID_COMMENT,NOTIFICATION_FREQUENCY,ID_AFF) values ('1393','test@email.com','Turkey','Q4 2020',to_timestamp('20/11/23 06:00:10,516722000','RR/MM/DD HH24:MI:SSXFF'),'COMM_INSERT','0','TEST TExt','TEST TExt','1','508','Weekly','101'); Insert into TEST_USERS_EMAIL_LIST (ID,EMAIL,AFF,PERIOD_OF_TIME,DTEVENT,EVENT,SEND,COMMENT_TEXT,USER_LAST_CHANGE,ID_CATEGORY,ID_COMMENT,NOTIFICATION_FREQUENCY,ID_AFF) values ('1394','test@email.com','United Kingdom','Q4 2020',to_timestamp('20/11/23 06:00:10,516722000','RR/MM/DD HH24:MI:SSXFF'),'COMM_INSERT','0','TEST TExt','TEST TExt','1','506','Weekly','177'); Insert into TEST_USERS_EMAIL_LIST (ID,EMAIL,AFF,PERIOD_OF_TIME,DTEVENT,EVENT,SEND,COMMENT_TEXT,USER_LAST_CHANGE,ID_CATEGORY,ID_COMMENT,NOTIFICATION_FREQUENCY,ID_AFF) values ('1395','test@email.com','Uruguay','Q4 2020, Q4 2020, Q4 2020',to_timestamp('20/11/23 06:00:10,516722000','RR/MM/DD HH24:MI:SSXFF'),'COMM_INSERT','0','TEST TExt','TEST TExt','3','516','Weekly','178'); Insert into TEST_USERS_EMAIL_LIST (ID,EMAIL,AFF,PERIOD_OF_TIME,DTEVENT,EVENT,SEND,COMMENT_TEXT,USER_LAST_CHANGE,ID_CATEGORY,ID_COMMENT,NOTIFICATION_FREQUENCY,ID_AFF) values ('1396','test@email.com','Brazil','Q4 2020',to_timestamp('20/11/23 06:00:10,516722000','RR/MM/DD HH24:MI:SSXFF'),'COMM_INSERT','0','TEST TExt','TEST TExt','2','491','Weekly','108'); Insert into TEST_USERS_EMAIL_LIST (ID,EMAIL,AFF,PERIOD_OF_TIME,DTEVENT,EVENT,SEND,COMMENT_TEXT,USER_LAST_CHANGE,ID_CATEGORY,ID_COMMENT,NOTIFICATION_FREQUENCY,ID_AFF) values ('1397','test@email.com','Brazil','Q4 2020',to_timestamp('20/11/23 06:00:10,516722000','RR/MM/DD HH24:MI:SSXFF'),'COMM_INSERT','0','TEST TExt','TEST TExt','2','492','Weekly','108'); Insert into TEST_USERS_EMAIL_LIST (ID,EMAIL,AFF,PERIOD_OF_TIME,DTEVENT,EVENT,SEND,COMMENT_TEXT,USER_LAST_CHANGE,ID_CATEGORY,ID_COMMENT,NOTIFICATION_FREQUENCY,ID_AFF) values ('1398','test@email.com','Brazil','Q4 2020',to_timestamp('20/11/23 06:00:10,516722000','RR/MM/DD HH24:MI:SSXFF'),'COMM_INSERT','0','TEST TExt','TEST TExt','2','493','Weekly','108'); Insert into TEST_USERS_EMAIL_LIST (ID,EMAIL,AFF,PERIOD_OF_TIME,DTEVENT,EVENT,SEND,COMMENT_TEXT,USER_LAST_CHANGE,ID_CATEGORY,ID_COMMENT,NOTIFICATION_FREQUENCY,ID_AFF) values ('1399','test@email.com','Brazil','Q4 2020',to_timestamp('20/11/23 06:00:10,516722000','RR/MM/DD HH24:MI:SSXFF'),'COMM_INSERT','0','TEST TExt','TEST TExt','2','494','Weekly','108'); Insert into TEST_USERS_EMAIL_LIST (ID,EMAIL,AFF,PERIOD_OF_TIME,DTEVENT,EVENT,SEND,COMMENT_TEXT,USER_LAST_CHANGE,ID_CATEGORY,ID_COMMENT,NOTIFICATION_FREQUENCY,ID_AFF) values ('1400','test@email.com','Brazil','Q4 2020',to_timestamp('20/11/23 06:00:10,516722000','RR/MM/DD HH24:MI:SSXFF'),'COMM_INSERT','0','TEST TExt','TEST TExt','2','490','Weekly','108'); Insert into TEST_USERS_EMAIL_LIST (ID,EMAIL,AFF,PERIOD_OF_TIME,DTEVENT,EVENT,SEND,COMMENT_TEXT,USER_LAST_CHANGE,ID_CATEGORY,ID_COMMENT,NOTIFICATION_FREQUENCY,ID_AFF) values ('1401','test@email.com','Brazil','Q4 2020',to_timestamp('20/11/23 06:00:10,516722000','RR/MM/DD HH24:MI:SSXFF'),'COMM_INSERT','0','TEST TExt','TEST TExt','2','489','Weekly','108'); Insert into TEST_USERS_EMAIL_LIST (ID,EMAIL,AFF,PERIOD_OF_TIME,DTEVENT,EVENT,SEND,COMMENT_TEXT,USER_LAST_CHANGE,ID_CATEGORY,ID_COMMENT,NOTIFICATION_FREQUENCY,ID_AFF) values ('1402','test@email.com','Colombia','Q4 2020',to_timestamp('20/11/23 06:00:10,516722000','RR/MM/DD HH24:MI:SSXFF'),'COMM_INSERT','0','TEST TExt','TEST TExt','2','505','Weekly','110'); Insert into TEST_USERS_EMAIL_LIST (ID,EMAIL,AFF,PERIOD_OF_TIME,DTEVENT,EVENT,SEND,COMMENT_TEXT,USER_LAST_CHANGE,ID_CATEGORY,ID_COMMENT,NOTIFICATION_FREQUENCY,ID_AFF) values ('1403','test@email.com','Mexico','Q4 2020',to_timestamp('20/11/23 06:00:10,516722000','RR/MM/DD HH24:MI:SSXFF'),'COMM_INSERT','0','TEST TExt','TEST TExt','2','507','Weekly','155'); Insert into TEST_USERS_EMAIL_LIST (ID,EMAIL,AFF,PERIOD_OF_TIME,DTEVENT,EVENT,SEND,COMMENT_TEXT,USER_LAST_CHANGE,ID_CATEGORY,ID_COMMENT,NOTIFICATION_FREQUENCY,ID_AFF) values ('1404','test@email.com','Turkmenistan','Q4 2020',to_timestamp('20/11/23 06:00:10,516722000','RR/MM/DD HH24:MI:SSXFF'),'COMM_INSERT','0','TEST TExt','TEST TExt','2','509','Weekly','180'); Insert into TEST_USERS_EMAIL_LIST (ID,EMAIL,AFF,PERIOD_OF_TIME,DTEVENT,EVENT,SEND,COMMENT_TEXT,USER_LAST_CHANGE,ID_CATEGORY,ID_COMMENT,NOTIFICATION_FREQUENCY,ID_AFF) values ('1405','test@email.com','Uruguay','Q4 2020, Q3 2020, Q4 2020, Q3 2020, Q4 2020, Q3 2020',to_timestamp('20/11/23 06:00:10,516722000','RR/MM/DD HH24:MI:SSXFF'),'COMM_INSERT','0','TEST TExt','TEST TExt','2','498','Weekly','178'); Insert into TEST_USERS_EMAIL_LIST (ID,EMAIL,AFF,PERIOD_OF_TIME,DTEVENT,EVENT,SEND,COMMENT_TEXT,USER_LAST_CHANGE,ID_CATEGORY,ID_COMMENT,NOTIFICATION_FREQUENCY,ID_AFF) values ('1406','test@email.com','Uruguay','Q4 2020, Q3 2020, Q4 2020, Q3 2020, Q4 2020, Q3 2020',to_timestamp('20/11/23 06:00:10,516722000','RR/MM/DD HH24:MI:SSXFF'),'COMM_INSERT','0','TEST TExt','TEST TExt','2','497','Weekly','178'); Insert into TEST_USERS_EMAIL_LIST (ID,EMAIL,AFF,PERIOD_OF_TIME,DTEVENT,EVENT,SEND,COMMENT_TEXT,USER_LAST_CHANGE,ID_CATEGORY,ID_COMMENT,NOTIFICATION_FREQUENCY,ID_AFF) values ('1407','test@email.com','Uruguay','Q4 2020, Q3 2020, Q4 2020, Q3 2020, Q4 2020, Q3 2020',to_timestamp('20/11/23 06:00:10,516722000','RR/MM/DD HH24:MI:SSXFF'),'COMM_INSERT','0','TEST TExt','TEST TExt','2','500','Weekly','178'); Insert into TEST_USERS_EMAIL_LIST (ID,EMAIL,AFF,PERIOD_OF_TIME,DTEVENT,EVENT,SEND,COMMENT_TEXT,USER_LAST_CHANGE,ID_CATEGORY,ID_COMMENT,NOTIFICATION_FREQUENCY,ID_AFF) values ('1408','test@email.com','Uruguay','Q4 2020, Q3 2020, Q4 2020, Q3 2020, Q4 2020, Q3 2020',to_timestamp('20/11/23 06:00:10,516722000','RR/MM/DD HH24:MI:SSXFF'),'COMM_INSERT','0','TEST TExt','TEST TExt','2','499','Weekly','178'); Insert into TEST_USERS_EMAIL_LIST (ID,EMAIL,AFF,PERIOD_OF_TIME,DTEVENT,EVENT,SEND,COMMENT_TEXT,USER_LAST_CHANGE,ID_CATEGORY,ID_COMMENT,NOTIFICATION_FREQUENCY,ID_AFF) values ('1409','test@email.com','India','Q4 2020, Q4 2020',to_timestamp('20/11/23 06:00:10,516722000','RR/MM/DD HH24:MI:SSXFF'),'COMM_INSERT','0','TEST TExt','TEST TExt','3','510','Weekly','138'); Insert into TEST_USERS_EMAIL_LIST (ID,EMAIL,AFF,PERIOD_OF_TIME,DTEVENT,EVENT,SEND,COMMENT_TEXT,USER_LAST_CHANGE,ID_CATEGORY,ID_COMMENT,NOTIFICATION_FREQUENCY,ID_AFF) values ('1410','test@email.com','India','Q4 2020, Q4 2020',to_timestamp('20/11/23 06:00:10,516722000','RR/MM/DD HH24:MI:SSXFF'),'COMM_INSERT','0','TEST TExt','TEST TExt','3','511','Weekly','138'); Insert into TEST_USERS_EMAIL_LIST (ID,EMAIL,AFF,PERIOD_OF_TIME,DTEVENT,EVENT,SEND,COMMENT_TEXT,USER_LAST_CHANGE,ID_CATEGORY,ID_COMMENT,NOTIFICATION_FREQUENCY,ID_AFF) values ('1411','test@email.com','Turkmenistan','Q4 2020',to_timestamp('20/11/23 06:00:10,516722000','RR/MM/DD HH24:MI:SSXFF'),'COMM_INSERT','0','TEST TExt','TEST TExt','2','509','Weekly','180'); Insert into TEST_USERS_EMAIL_LIST (ID,EMAIL,AFF,PERIOD_OF_TIME,DTEVENT,EVENT,SEND,COMMENT_TEXT,USER_LAST_CHANGE,ID_CATEGORY,ID_COMMENT,NOTIFICATION_FREQUENCY,ID_AFF) values ('1412','test@email.com','Tunisia','Q4 2020',to_timestamp('20/11/23 06:00:10,516722000','RR/MM/DD HH24:MI:SSXFF'),'SUBCOMM_INSERT','0','TEST TExt','TEST TExt','3','512','Weekly','174'); Insert into TEST_USERS_EMAIL_LIST (ID,EMAIL,AFF,PERIOD_OF_TIME,DTEVENT,EVENT,SEND,COMMENT_TEXT,USER_LAST_CHANGE,ID_CATEGORY,ID_COMMENT,NOTIFICATION_FREQUENCY,ID_AFF) values ('1413','test@email.com','Tunisia','Q4 2020',to_timestamp('20/11/23 06:00:10,516722000','RR/MM/DD HH24:MI:SSXFF'),'SUBCOMM_INSERT','0','TEST TExt','TEST TExt','3','512','Weekly','174'); Insert into TEST_USERS_EMAIL_LIST (ID,EMAIL,AFF,PERIOD_OF_TIME,DTEVENT,EVENT,SEND,COMMENT_TEXT,USER_LAST_CHANGE,ID_CATEGORY,ID_COMMENT,NOTIFICATION_FREQUENCY,ID_AFF) values ('1414','test@email.com','Brazil','Q2 2020',to_timestamp('20/11/23 06:00:10,516722000','RR/MM/DD HH24:MI:SSXFF'),'SUBCOMM_INSERT','0','TEST TExt','TEST TExt','3','313','Weekly','108'); Insert into TEST_USERS_EMAIL_LIST (ID,EMAIL,AFF,PERIOD_OF_TIME,DTEVENT,EVENT,SEND,COMMENT_TEXT,USER_LAST_CHANGE,ID_CATEGORY,ID_COMMENT,NOTIFICATION_FREQUENCY,ID_AFF) values ('1415','test@email.com','Brazil','Q4 2020',to_timestamp('20/11/23 06:00:10,516722000','RR/MM/DD HH24:MI:SSXFF'),'SUBCOMM_INSERT','0','TEST TExt','TEST TExt','2','493','Weekly','108'); Insert into TEST_USERS_EMAIL_LIST (ID,EMAIL,AFF,PERIOD_OF_TIME,DTEVENT,EVENT,SEND,COMMENT_TEXT,USER_LAST_CHANGE,ID_CATEGORY,ID_COMMENT,NOTIFICATION_FREQUENCY,ID_AFF) values ('1416','test@email.com','Brazil','Q4 2020',to_timestamp('20/11/23 06:00:10,516722000','RR/MM/DD HH24:MI:SSXFF'),'SUBCOMM_INSERT','0','TEST TExt','TEST TExt','2','489','Weekly','108'); Insert into TEST_USERS_EMAIL_LIST (ID,EMAIL,AFF,PERIOD_OF_TIME,DTEVENT,EVENT,SEND,COMMENT_TEXT,USER_LAST_CHANGE,ID_CATEGORY,ID_COMMENT,NOTIFICATION_FREQUENCY,ID_AFF) values ('1417','test@email.com','Brazil','Q4 2020',to_timestamp('20/11/23 06:00:10,516722000','RR/MM/DD HH24:MI:SSXFF'),'SUBCOMM_INSERT','0','TEST TExt','TEST TExt','3','496','Weekly','108'); Insert into TEST_USERS_EMAIL_LIST (ID,EMAIL,AFF,PERIOD_OF_TIME,DTEVENT,EVENT,SEND,COMMENT_TEXT,USER_LAST_CHANGE,ID_CATEGORY,ID_COMMENT,NOTIFICATION_FREQUENCY,ID_AFF) values ('1418','test@email.com','Tunisia','Q4 2020',to_timestamp('20/11/23 06:00:10,516722000','RR/MM/DD HH24:MI:SSXFF'),'SUBCOMM_INSERT','0','TEST TExt','TEST TExt','3','512','Weekly','174'); Insert into TEST_USERS_EMAIL_LIST (ID,EMAIL,AFF,PERIOD_OF_TIME,DTEVENT,EVENT,SEND,COMMENT_TEXT,USER_LAST_CHANGE,ID_CATEGORY,ID_COMMENT,NOTIFICATION_FREQUENCY,ID_AFF) values ('1419','test@email.com','Tunisia','Q4 2020',to_timestamp('20/11/23 06:00:10,516722000','RR/MM/DD HH24:MI:SSXFF'),'SUBCOMM_INSERT','0','TEST TExt','TEST TExt','3','512','Weekly','174'); Insert into TEST_USERS_EMAIL_LIST (ID,EMAIL,AFF,PERIOD_OF_TIME,DTEVENT,EVENT,SEND,COMMENT_TEXT,USER_LAST_CHANGE,ID_CATEGORY,ID_COMMENT,NOTIFICATION_FREQUENCY,ID_AFF) values ('1420','test@email.com','Brazil','Q2 2020',to_timestamp('20/11/23 06:00:10,516722000','RR/MM/DD HH24:MI:SSXFF'),'SUBCOMM_INSERT','0','TEST TExt','TEST TExt','3','313','Weekly','108'); Insert into TEST_USERS_EMAIL_LIST (ID,EMAIL,AFF,PERIOD_OF_TIME,DTEVENT,EVENT,SEND,COMMENT_TEXT,USER_LAST_CHANGE,ID_CATEGORY,ID_COMMENT,NOTIFICATION_FREQUENCY,ID_AFF) values ('1421','test@email.com','Brazil','Q4 2020',to_timestamp('20/11/23 06:00:10,516722000','RR/MM/DD HH24:MI:SSXFF'),'SUBCOMM_INSERT','0','TEST TExt','TEST TExt','2','493','Weekly','108'); Insert into TEST_USERS_EMAIL_LIST (ID,EMAIL,AFF,PERIOD_OF_TIME,DTEVENT,EVENT,SEND,COMMENT_TEXT,USER_LAST_CHANGE,ID_CATEGORY,ID_COMMENT,NOTIFICATION_FREQUENCY,ID_AFF) values ('1422','test@email.com','Brazil','Q4 2020',to_timestamp('20/11/23 06:00:10,516722000','RR/MM/DD HH24:MI:SSXFF'),'SUBCOMM_INSERT','0','TEST TExt','TEST TExt','2','489','Weekly','108'); Insert into TEST_USERS_EMAIL_LIST (ID,EMAIL,AFF,PERIOD_OF_TIME,DTEVENT,EVENT,SEND,COMMENT_TEXT,USER_LAST_CHANGE,ID_CATEGORY,ID_COMMENT,NOTIFICATION_FREQUENCY,ID_AFF) values ('1423','test@email.com','Brazil','Q4 2020',to_timestamp('20/11/23 06:00:10,516722000','RR/MM/DD HH24:MI:SSXFF'),'SUBCOMM_INSERT','0','TEST TExt','TEST TExt','3','496','Weekly','108'); Insert into TEST_USERS_EMAIL_LIST (ID,EMAIL,AFF,PERIOD_OF_TIME,DTEVENT,EVENT,SEND,COMMENT_TEXT,USER_LAST_CHANGE,ID_CATEGORY,ID_COMMENT,NOTIFICATION_FREQUENCY,ID_AFF) values ('1424','test@email.com','Tunisia','Q4 2020',to_timestamp('20/11/23 06:00:10,516722000','RR/MM/DD HH24:MI:SSXFF'),'SUBCOMM_INSERT','0','TEST TExt','TEST TExt','3','512','Weekly','174'); Insert into TEST_USERS_EMAIL_LIST (ID,EMAIL,AFF,PERIOD_OF_TIME,DTEVENT,EVENT,SEND,COMMENT_TEXT,USER_LAST_CHANGE,ID_CATEGORY,ID_COMMENT,NOTIFICATION_FREQUENCY,ID_AFF) values ('1425','test@email.com','Brazil','Q2 2020',to_timestamp('20/11/23 06:00:10,516722000','RR/MM/DD HH24:MI:SSXFF'),'SUBCOMM_INSERT','0','TEST TExt','TEST TExt','3','313','Weekly','108'); Insert into TEST_USERS_EMAIL_LIST (ID,EMAIL,AFF,PERIOD_OF_TIME,DTEVENT,EVENT,SEND,COMMENT_TEXT,USER_LAST_CHANGE,ID_CATEGORY,ID_COMMENT,NOTIFICATION_FREQUENCY,ID_AFF) values ('1426','test@email.com','Brazil','Q4 2020',to_timestamp('20/11/23 06:00:10,516722000','RR/MM/DD HH24:MI:SSXFF'),'SUBCOMM_INSERT','0','TEST TExt','TEST TExt','3','496','Weekly','108'); Insert into TEST_USERS_EMAIL_LIST (ID,EMAIL,AFF,PERIOD_OF_TIME,DTEVENT,EVENT,SEND,COMMENT_TEXT,USER_LAST_CHANGE,ID_CATEGORY,ID_COMMENT,NOTIFICATION_FREQUENCY,ID_AFF) values ('1427','test@email.com','Tunisia','Q4 2020',to_timestamp('20/11/23 06:00:10,516722000','RR/MM/DD HH24:MI:SSXFF'),'SUBCOMM_INSERT','0','TEST TExt','TEST TExt','3','512','Weekly','174'); Insert into TEST_USERS_EMAIL_LIST (ID,EMAIL,AFF,PERIOD_OF_TIME,DTEVENT,EVENT,SEND,COMMENT_TEXT,USER_LAST_CHANGE,ID_CATEGORY,ID_COMMENT,NOTIFICATION_FREQUENCY,ID_AFF) values ('1428','test@email.com','Brazil','Q4 2020',to_timestamp('20/11/23 06:00:10,516722000','RR/MM/DD HH24:MI:SSXFF'),'SUBCOMM_INSERT','0','TEST TExt','TEST TExt','2','493','Weekly','108'); Insert into TEST_USERS_EMAIL_LIST (ID,EMAIL,AFF,PERIOD_OF_TIME,DTEVENT,EVENT,SEND,COMMENT_TEXT,USER_LAST_CHANGE,ID_CATEGORY,ID_COMMENT,NOTIFICATION_FREQUENCY,ID_AFF) values ('1429','test@email.com','Brazil','Q4 2020',to_timestamp('20/11/23 06:00:10,516722000','RR/MM/DD HH24:MI:SSXFF'),'SUBCOMM_INSERT','0','TEST TExt','TEST TExt','2','489','Weekly','108'); Insert into TEST_USERS_EMAIL_LIST (ID,EMAIL,AFF,PERIOD_OF_TIME,DTEVENT,EVENT,SEND,COMMENT_TEXT,USER_LAST_CHANGE,ID_CATEGORY,ID_COMMENT,NOTIFICATION_FREQUENCY,ID_AFF) values ('1289','test@email.com','Mexico','Q4 2020',to_timestamp('20/11/23 06:00:10,516722000','RR/MM/DD HH24:MI:SSXFF'),'COMM_INSERT','0','TEST TExt','TEST TExt','2','507','Weekly','155'); Insert into TEST_USERS_EMAIL_LIST (ID,EMAIL,AFF,PERIOD_OF_TIME,DTEVENT,EVENT,SEND,COMMENT_TEXT,USER_LAST_CHANGE,ID_CATEGORY,ID_COMMENT,NOTIFICATION_FREQUENCY,ID_AFF) values ('1290','test@email.com','Peru','Q4 2020',to_timestamp('20/11/23 06:00:10,516722000','RR/MM/DD HH24:MI:SSXFF'),'COMM_INSERT','0','TEST TExt','TEST TExt','1','504','Weekly','160'); Insert into TEST_USERS_EMAIL_LIST (ID,EMAIL,AFF,PERIOD_OF_TIME,DTEVENT,EVENT,SEND,COMMENT_TEXT,USER_LAST_CHANGE,ID_CATEGORY,ID_COMMENT,NOTIFICATION_FREQUENCY,ID_AFF) values ('1291','test@email.com','South Africa SR','Q4 2020, Q4 2020, Q4 2020, Q4 2020, Q4 2020, Q4 2020, Q4 2020, Q4 2020, Q4 2020, Q4 2020, Q4 2020, Q4 2020, Q4 2020',to_timestamp('20/11/23 06:00:10,516722000','RR/MM/DD HH24:MI:SSXFF'),'COMM_INSERT','0','TEST TExt','TEST TExt','3','519','Weekly','169'); Insert into TEST_USERS_EMAIL_LIST (ID,EMAIL,AFF,PERIOD_OF_TIME,DTEVENT,EVENT,SEND,COMMENT_TEXT,USER_LAST_CHANGE,ID_CATEGORY,ID_COMMENT,NOTIFICATION_FREQUENCY,ID_AFF) values ('1292','test@email.com','Tunisia','Q4 2020',to_timestamp('20/11/23 06:00:10,516722000','RR/MM/DD HH24:MI:SSXFF'),'COMM_INSERT','0','TEST TExt','TEST TExt','3','512','Weekly','174'); Insert into TEST_USERS_EMAIL_LIST (ID,EMAIL,AFF,PERIOD_OF_TIME,DTEVENT,EVENT,SEND,COMMENT_TEXT,USER_LAST_CHANGE,ID_CATEGORY,ID_COMMENT,NOTIFICATION_FREQUENCY,ID_AFF) values ('1293','test@email.com','Turkey','Q4 2020',to_timestamp('20/11/23 06:00:10,516722000','RR/MM/DD HH24:MI:SSXFF'),'COMM_INSERT','0','TEST TExt','TEST TExt','1','508','Weekly','101'); Insert into TEST_USERS_EMAIL_LIST (ID,EMAIL,AFF,PERIOD_OF_TIME,DTEVENT,EVENT,SEND,COMMENT_TEXT,USER_LAST_CHANGE,ID_CATEGORY,ID_COMMENT,NOTIFICATION_FREQUENCY,ID_AFF) values ('1294','test@email.com','Turkmenistan','Q4 2020',to_timestamp('20/11/23 06:00:10,516722000','RR/MM/DD HH24:MI:SSXFF'),'COMM_INSERT','0','TEST TExt','TEST TExt','2','509','Weekly','180'); Insert into TEST_USERS_EMAIL_LIST (ID,EMAIL,AFF,PERIOD_OF_TIME,DTEVENT,EVENT,SEND,COMMENT_TEXT,USER_LAST_CHANGE,ID_CATEGORY,ID_COMMENT,NOTIFICATION_FREQUENCY,ID_AFF) values ('1295','test@email.com','United Kingdom','Q4 2020',to_timestamp('20/11/23 06:00:10,516722000','RR/MM/DD HH24:MI:SSXFF'),'COMM_INSERT','0','TEST TExt','TEST TExt','1','506','Weekly','177'); Insert into TEST_USERS_EMAIL_LIST (ID,EMAIL,AFF,PERIOD_OF_TIME,DTEVENT,EVENT,SEND,COMMENT_TEXT,USER_LAST_CHANGE,ID_CATEGORY,ID_COMMENT,NOTIFICATION_FREQUENCY,ID_AFF) values ('1296','test@email.com','Uruguay','Q4 2020, Q3 2020, Q4 2020, Q3 2020, Q4 2020, Q3 2020',to_timestamp('20/11/23 06:00:10,516722000','RR/MM/DD HH24:MI:SSXFF'),'COMM_INSERT','0','TEST TExt','TEST TExt','2','498','Weekly','178'); Insert into TEST_USERS_EMAIL_LIST (ID,EMAIL,AFF,PERIOD_OF_TIME,DTEVENT,EVENT,SEND,COMMENT_TEXT,USER_LAST_CHANGE,ID_CATEGORY,ID_COMMENT,NOTIFICATION_FREQUENCY,ID_AFF) values ('1297','test@email.com','Uruguay','Q4 2020, Q3 2020, Q4 2020, Q3 2020, Q4 2020, Q3 2020',to_timestamp('20/11/23 06:00:10,516722000','RR/MM/DD HH24:MI:SSXFF'),'COMM_INSERT','0','TEST TExt','TEST TExt','2','497','Weekly','178'); Insert into TEST_USERS_EMAIL_LIST (ID,EMAIL,AFF,PERIOD_OF_TIME,DTEVENT,EVENT,SEND,COMMENT_TEXT,USER_LAST_CHANGE,ID_CATEGORY,ID_COMMENT,NOTIFICATION_FREQUENCY,ID_AFF) values ('1298','test@email.com','Uruguay','Q4 2020, Q3 2020, Q4 2020, Q3 2020, Q4 2020, Q3 2020',to_timestamp('20/11/23 06:00:10,516722000','RR/MM/DD HH24:MI:SSXFF'),'COMM_INSERT','0','TEST TExt','TEST TExt','2','500','Weekly','178'); Insert into TEST_USERS_EMAIL_LIST (ID,EMAIL,AFF,PERIOD_OF_TIME,DTEVENT,EVENT,SEND,COMMENT_TEXT,USER_LAST_CHANGE,ID_CATEGORY,ID_COMMENT,NOTIFICATION_FREQUENCY,ID_AFF) values ('1299','test@email.com','Uruguay','Q4 2020, Q3 2020, Q4 2020, Q3 2020, Q4 2020, Q3 2020',to_timestamp('20/11/23 06:00:10,516722000','RR/MM/DD HH24:MI:SSXFF'),'COMM_INSERT','0','TEST TExt','TEST TExt','2','499','Weekly','178'); Insert into TEST_USERS_EMAIL_LIST (ID,EMAIL,AFF,PERIOD_OF_TIME,DTEVENT,EVENT,SEND,COMMENT_TEXT,USER_LAST_CHANGE,ID_CATEGORY,ID_COMMENT,NOTIFICATION_FREQUENCY,ID_AFF) values ('1300','test@email.com','Uruguay','Q4 2020, Q3 2020, Q4 2020, Q3 2020, Q4 2020, Q3 2020',to_timestamp('20/11/23 06:00:10,516722000','RR/MM/DD HH24:MI:SSXFF'),'COMM_INSERT','0','TEST TExt','TEST TExt','5','501','Weekly','178'); Insert into TEST_USERS_EMAIL_LIST (ID,EMAIL,AFF,PERIOD_OF_TIME,DTEVENT,EVENT,SEND,COMMENT_TEXT,USER_LAST_CHANGE,ID_CATEGORY,ID_COMMENT,NOTIFICATION_FREQUENCY,ID_AFF) values ('1301','test@email.com','Uruguay','Q4 2020, Q3 2020, Q4 2020, Q3 2020, Q4 2020, Q3 2020',to_timestamp('20/11/23 06:00:10,516722000','RR/MM/DD HH24:MI:SSXFF'),'COMM_INSERT','0','TEST TExt','TEST TExt','8','503','Weekly','178'); Insert into TEST_USERS_EMAIL_LIST (ID,EMAIL,AFF,PERIOD_OF_TIME,DTEVENT,EVENT,SEND,COMMENT_TEXT,USER_LAST_CHANGE,ID_CATEGORY,ID_COMMENT,NOTIFICATION_FREQUENCY,ID_AFF) values ('1302','test@email.com','Uruguay','Q4 2020, Q3 2020, Q4 2020, Q3 2020, Q4 2020, Q3 2020',to_timestamp('20/11/23 06:00:10,516722000','RR/MM/DD HH24:MI:SSXFF'),'COMM_INSERT','0','TEST TExt','TEST TExt','8','502','Weekly','178'); Insert into TEST_USERS_EMAIL_LIST (ID,EMAIL,AFF,PERIOD_OF_TIME,DTEVENT,EVENT,SEND,COMMENT_TEXT,USER_LAST_CHANGE,ID_CATEGORY,ID_COMMENT,NOTIFICATION_FREQUENCY,ID_AFF) values ('1303','test@email.com','Uruguay','Q4 2020, Q4 2020, Q4 2020',to_timestamp('20/11/23 06:00:10,516722000','RR/MM/DD HH24:MI:SSXFF'),'COMM_INSERT','0','TEST TExt','TEST TExt','3','516','Weekly','178'); Insert into TEST_USERS_EMAIL_LIST (ID,EMAIL,AFF,PERIOD_OF_TIME,DTEVENT,EVENT,SEND,COMMENT_TEXT,USER_LAST_CHANGE,ID_CATEGORY,ID_COMMENT,NOTIFICATION_FREQUENCY,ID_AFF) values ('1304','test@email.com','Uruguay','Q4 2020, Q4 2020, Q4 2020',to_timestamp('20/11/23 06:00:10,516722000','RR/MM/DD HH24:MI:SSXFF'),'COMM_INSERT','0','TEST TExt','TEST TExt','5','514','Weekly','178'); Insert into TEST_USERS_EMAIL_LIST (ID,EMAIL,AFF,PERIOD_OF_TIME,DTEVENT,EVENT,SEND,COMMENT_TEXT,USER_LAST_CHANGE,ID_CATEGORY,ID_COMMENT,NOTIFICATION_FREQUENCY,ID_AFF) values ('1305','test@email.com','Uruguay','Q4 2020, Q4 2020, Q4 2020',to_timestamp('20/11/23 06:00:10,516722000','RR/MM/DD HH24:MI:SSXFF'),'COMM_INSERT','0','TEST TExt','TEST TExt','6','517','Weekly','178'); Insert into TEST_USERS_EMAIL_LIST (ID,EMAIL,AFF,PERIOD_OF_TIME,DTEVENT,EVENT,SEND,COMMENT_TEXT,USER_LAST_CHANGE,ID_CATEGORY,ID_COMMENT,NOTIFICATION_FREQUENCY,ID_AFF) values ('1306','test@email.com','Uruguay','Q4 2020, Q4 2020, Q4 2020',to_timestamp('20/11/23 06:00:10,516722000','RR/MM/DD HH24:MI:SSXFF'),'COMM_INSERT','0','TEST TExt','TEST TExt','8','515','Weekly','178'); Insert into TEST_USERS_EMAIL_LIST (ID,EMAIL,AFF,PERIOD_OF_TIME,DTEVENT,EVENT,SEND,COMMENT_TEXT,USER_LAST_CHANGE,ID_CATEGORY,ID_COMMENT,NOTIFICATION_FREQUENCY,ID_AFF) values ('1307','test@email.com','United Kingdom','Q4 2020',to_timestamp('20/11/23 06:00:10,516722000','RR/MM/DD HH24:MI:SSXFF'),'COMM_INSERT','0','TEST TExt','TEST TExt','1','506','Weekly','177'); Insert into TEST_USERS_EMAIL_LIST (ID,EMAIL,AFF,PERIOD_OF_TIME,DTEVENT,EVENT,SEND,COMMENT_TEXT,USER_LAST_CHANGE,ID_CATEGORY,ID_COMMENT,NOTIFICATION_FREQUENCY,ID_AFF) values ('1308','test@email.com','Finland','Nov 2020',to_timestamp('20/11/23 06:00:10,516722000','RR/MM/DD HH24:MI:SSXFF'),'COMM_INSERT','0','TEST TExt','TEST TExt','9999','488','Weekly','131'); Insert into TEST_USERS_EMAIL_LIST (ID,EMAIL,AFF,PERIOD_OF_TIME,DTEVENT,EVENT,SEND,COMMENT_TEXT,USER_LAST_CHANGE,ID_CATEGORY,ID_COMMENT,NOTIFICATION_FREQUENCY,ID_AFF) values ('1309','test@email.com','Norway','Nov 2020',to_timestamp('20/11/23 06:00:10,516722000','RR/MM/DD HH24:MI:SSXFF'),'COMM_INSERT','0','TEST TExt','TEST TExt','9999','487','Weekly','159'); Insert into TEST_USERS_EMAIL_LIST (ID,EMAIL,AFF,PERIOD_OF_TIME,DTEVENT,EVENT,SEND,COMMENT_TEXT,USER_LAST_CHANGE,ID_CATEGORY,ID_COMMENT,NOTIFICATION_FREQUENCY,ID_AFF) values ('1310','test@email.com','United Kingdom','Q4 2020',to_timestamp('20/11/23 06:00:10,516722000','RR/MM/DD HH24:MI:SSXFF'),'COMM_INSERT','0','TEST TExt','TEST TExt','1','506','Weekly','177'); Insert into TEST_USERS_EMAIL_LIST (ID,EMAIL,AFF,PERIOD_OF_TIME,DTEVENT,EVENT,SEND,COMMENT_TEXT,USER_LAST_CHANGE,ID_CATEGORY,ID_COMMENT,NOTIFICATION_FREQUENCY,ID_AFF) values ('1311','test@email.com','India','Q4 2020, Q4 2020',to_timestamp('20/11/23 06:00:10,516722000','RR/MM/DD HH24:MI:SSXFF'),'COMM_INSERT','0','TEST TExt','TEST TExt','3','510','Weekly','138'); Insert into TEST_USERS_EMAIL_LIST (ID,EMAIL,AFF,PERIOD_OF_TIME,DTEVENT,EVENT,SEND,COMMENT_TEXT,USER_LAST_CHANGE,ID_CATEGORY,ID_COMMENT,NOTIFICATION_FREQUENCY,ID_AFF) values ('1312','test@email.com','India','Q4 2020, Q4 2020',to_timestamp('20/11/23 06:00:10,516722000','RR/MM/DD HH24:MI:SSXFF'),'COMM_INSERT','0','TEST TExt','TEST TExt','3','511','Weekly','138'); Insert into TEST_USERS_EMAIL_LIST (ID,EMAIL,AFF,PERIOD_OF_TIME,DTEVENT,EVENT,SEND,COMMENT_TEXT,USER_LAST_CHANGE,ID_CATEGORY,ID_COMMENT,NOTIFICATION_FREQUENCY,ID_AFF) values ('1313','test@email.com','South Africa SR','Q4 2020, Q4 2020, Q4 2020, Q4 2020, Q4 2020, Q4 2020, Q4 2020, Q4 2020, Q4 2020, Q4 2020, Q4 2020, Q4 2020, Q4 2020',to_timestamp('20/11/23 06:00:10,516722000','RR/MM/DD HH24:MI:SSXFF'),'COMM_INSERT','0','TEST TExt','TEST TExt','3','519','Weekly','169'); Insert into TEST_USERS_EMAIL_LIST (ID,EMAIL,AFF,PERIOD_OF_TIME,DTEVENT,EVENT,SEND,COMMENT_TEXT,USER_LAST_CHANGE,ID_CATEGORY,ID_COMMENT,NOTIFICATION_FREQUENCY,ID_AFF) values ('1314','test@email.com','Tunisia','Q4 2020',to_timestamp('20/11/23 06:00:10,516722000','RR/MM/DD HH24:MI:SSXFF'),'COMM_INSERT','0','TEST TExt','TEST TExt','3','512','Weekly','174'); Insert into TEST_USERS_EMAIL_LIST (ID,EMAIL,AFF,PERIOD_OF_TIME,DTEVENT,EVENT,SEND,COMMENT_TEXT,USER_LAST_CHANGE,ID_CATEGORY,ID_COMMENT,NOTIFICATION_FREQUENCY,ID_AFF) values ('1315','test@email.com','Turkey','Q4 2020',to_timestamp('20/11/23 06:00:10,516722000','RR/MM/DD HH24:MI:SSXFF'),'COMM_INSERT','0','TEST TExt','TEST TExt','1','508','Weekly','101'); Insert into TEST_USERS_EMAIL_LIST (ID,EMAIL,AFF,PERIOD_OF_TIME,DTEVENT,EVENT,SEND,COMMENT_TEXT,USER_LAST_CHANGE,ID_CATEGORY,ID_COMMENT,NOTIFICATION_FREQUENCY,ID_AFF) values ('1316','test@email.com','Turkmenistan','Q4 2020',to_timestamp('20/11/23 06:00:10,516722000','RR/MM/DD HH24:MI:SSXFF'),'COMM_INSERT','0','TEST TExt','TEST TExt','2','509','Weekly','180'); Insert into TEST_USERS_EMAIL_LIST (ID,EMAIL,AFF,PERIOD_OF_TIME,DTEVENT,EVENT,SEND,COMMENT_TEXT,USER_LAST_CHANGE,ID_CATEGORY,ID_COMMENT,NOTIFICATION_FREQUENCY,ID_AFF) values ('1317','test@email.com','Brazil','Q4 2020',to_timestamp('20/11/23 06:00:10,516722000','RR/MM/DD HH24:MI:SSXFF'),'COMM_INSERT','0','TEST TExt','TEST TExt','1','495','Weekly','108'); Insert into TEST_USERS_EMAIL_LIST (ID,EMAIL,AFF,PERIOD_OF_TIME,DTEVENT,EVENT,SEND,COMMENT_TEXT,USER_LAST_CHANGE,ID_CATEGORY,ID_COMMENT,NOTIFICATION_FREQUENCY,ID_AFF) values ('1318','test@email.com','Brazil','Q4 2020',to_timestamp('20/11/23 06:00:10,516722000','RR/MM/DD HH24:MI:SSXFF'),'COMM_INSERT','0','TEST TExt','TEST TExt','2','491','Weekly','108'); Insert into TEST_USERS_EMAIL_LIST (ID,EMAIL,AFF,PERIOD_OF_TIME,DTEVENT,EVENT,SEND,COMMENT_TEXT,USER_LAST_CHANGE,ID_CATEGORY,ID_COMMENT,NOTIFICATION_FREQUENCY,ID_AFF) values ('1319','test@email.com','Brazil','Q4 2020',to_timestamp('20/11/23 06:00:10,516722000','RR/MM/DD HH24:MI:SSXFF'),'COMM_INSERT','0','TEST TExt','TEST TExt','2','492','Weekly','108'); Insert into TEST_USERS_EMAIL_LIST (ID,EMAIL,AFF,PERIOD_OF_TIME,DTEVENT,EVENT,SEND,COMMENT_TEXT,USER_LAST_CHANGE,ID_CATEGORY,ID_COMMENT,NOTIFICATION_FREQUENCY,ID_AFF) values ('1320','test@email.com','Brazil','Q4 2020',to_timestamp('20/11/23 06:00:10,516722000','RR/MM/DD HH24:MI:SSXFF'),'COMM_INSERT','0','TEST TExt','TEST TExt','2','493','Weekly','108'); Insert into TEST_USERS_EMAIL_LIST (ID,EMAIL,AFF,PERIOD_OF_TIME,DTEVENT,EVENT,SEND,COMMENT_TEXT,USER_LAST_CHANGE,ID_CATEGORY,ID_COMMENT,NOTIFICATION_FREQUENCY,ID_AFF) values ('1321','test@email.com','Brazil','Q4 2020',to_timestamp('20/11/23 06:00:10,516722000','RR/MM/DD HH24:MI:SSXFF'),'COMM_INSERT','0','TEST TExt','TEST TExt','2','494','Weekly','108'); Insert into TEST_USERS_EMAIL_LIST (ID,EMAIL,AFF,PERIOD_OF_TIME,DTEVENT,EVENT,SEND,COMMENT_TEXT,USER_LAST_CHANGE,ID_CATEGORY,ID_COMMENT,NOTIFICATION_FREQUENCY,ID_AFF) values ('1322','test@email.com','Brazil','Q4 2020',to_timestamp('20/11/23 06:00:10,516722000','RR/MM/DD HH24:MI:SSXFF'),'COMM_INSERT','0','TEST TExt','TEST TExt','2','490','Weekly','108'); Insert into TEST_USERS_EMAIL_LIST (ID,EMAIL,AFF,PERIOD_OF_TIME,DTEVENT,EVENT,SEND,COMMENT_TEXT,USER_LAST_CHANGE,ID_CATEGORY,ID_COMMENT,NOTIFICATION_FREQUENCY,ID_AFF) values ('1323','test@email.com','Brazil','Q4 2020',to_timestamp('20/11/23 06:00:10,516722000','RR/MM/DD HH24:MI:SSXFF'),'COMM_INSERT','0','TEST TExt','TEST TExt','2','489','Weekly','108'); Insert into TEST_USERS_EMAIL_LIST (ID,EMAIL,AFF,PERIOD_OF_TIME,DTEVENT,EVENT,SEND,COMMENT_TEXT,USER_LAST_CHANGE,ID_CATEGORY,ID_COMMENT,NOTIFICATION_FREQUENCY,ID_AFF) values ('1324','test@email.com','Brazil','Q4 2020',to_timestamp('20/11/23 06:00:10,516722000','RR/MM/DD HH24:MI:SSXFF'),'COMM_INSERT','0','TEST TExt','TEST TExt','3','496','Weekly','108'); Insert into TEST_USERS_EMAIL_LIST (ID,EMAIL,AFF,PERIOD_OF_TIME,DTEVENT,EVENT,SEND,COMMENT_TEXT,USER_LAST_CHANGE,ID_CATEGORY,ID_COMMENT,NOTIFICATION_FREQUENCY,ID_AFF) values ('1325','test@email.com','Brazil','Q4 2020',to_timestamp('20/11/23 06:00:10,516722000','RR/MM/DD HH24:MI:SSXFF'),'COMM_INSERT','0','TEST TExt','TEST TExt','5','518','Weekly','108'); Insert into TEST_USERS_EMAIL_LIST (ID,EMAIL,AFF,PERIOD_OF_TIME,DTEVENT,EVENT,SEND,COMMENT_TEXT,USER_LAST_CHANGE,ID_CATEGORY,ID_COMMENT,NOTIFICATION_FREQUENCY,ID_AFF) values ('1326','test@email.com','Chile','Q4 2020',to_timestamp('20/11/23 06:00:10,516722000','RR/MM/DD HH24:MI:SSXFF'),'COMM_INSERT','0','TEST TExt','TEST TExt','3','513','Weekly','123'); Insert into TEST_USERS_EMAIL_LIST (ID,EMAIL,AFF,PERIOD_OF_TIME,DTEVENT,EVENT,SEND,COMMENT_TEXT,USER_LAST_CHANGE,ID_CATEGORY,ID_COMMENT,NOTIFICATION_FREQUENCY,ID_AFF) values ('1327','test@email.com','Colombia','Q4 2020',to_timestamp('20/11/23 06:00:10,516722000','RR/MM/DD HH24:MI:SSXFF'),'COMM_INSERT','0','TEST TExt','TEST TExt','2','505','Weekly','110'); Insert into TEST_USERS_EMAIL_LIST (ID,EMAIL,AFF,PERIOD_OF_TIME,DTEVENT,EVENT,SEND,COMMENT_TEXT,USER_LAST_CHANGE,ID_CATEGORY,ID_COMMENT,NOTIFICATION_FREQUENCY,ID_AFF) values ('1328','test@email.com','India','Q4 2020, Q4 2020',to_timestamp('20/11/23 06:00:10,516722000','RR/MM/DD HH24:MI:SSXFF'),'COMM_INSERT','0','TEST TExt','TEST TExt','3','510','Weekly','138'); Insert into TEST_USERS_EMAIL_LIST (ID,EMAIL,AFF,PERIOD_OF_TIME,DTEVENT,EVENT,SEND,COMMENT_TEXT,USER_LAST_CHANGE,ID_CATEGORY,ID_COMMENT,NOTIFICATION_FREQUENCY,ID_AFF) values ('1329','test@email.com','India','Q4 2020, Q4 2020',to_timestamp('20/11/23 06:00:10,516722000','RR/MM/DD HH24:MI:SSXFF'),'COMM_INSERT','0','TEST TExt','TEST TExt','3','511','Weekly','138'); Insert into TEST_USERS_EMAIL_LIST (ID,EMAIL,AFF,PERIOD_OF_TIME,DTEVENT,EVENT,SEND,COMMENT_TEXT,USER_LAST_CHANGE,ID_CATEGORY,ID_COMMENT,NOTIFICATION_FREQUENCY,ID_AFF) values ('1330','test@email.com','Malaysia','Q4 2020',to_timestamp('20/11/23 06:00:10,516722000','RR/MM/DD HH24:MI:SSXFF'),'COMM_INSERT','0','TEST TExt','TEST TExt','3','486','Weekly','154'); Insert into TEST_USERS_EMAIL_LIST (ID,EMAIL,AFF,PERIOD_OF_TIME,DTEVENT,EVENT,SEND,COMMENT_TEXT,USER_LAST_CHANGE,ID_CATEGORY,ID_COMMENT,NOTIFICATION_FREQUENCY,ID_AFF) values ('1331','test@email.com','Thailand','Q4 2020, Q4 2020, Q4 2020, Q4 2020',to_timestamp('20/11/25 22:00:19,145186000','RR/MM/DD HH24:MI:SSXFF'),'COMM_INSERT','0','TEST TExt','TEST TExt','1','530','Daily','173'); Insert into TEST_USERS_EMAIL_LIST (ID,EMAIL,AFF,PERIOD_OF_TIME,DTEVENT,EVENT,SEND,COMMENT_TEXT,USER_LAST_CHANGE,ID_CATEGORY,ID_COMMENT,NOTIFICATION_FREQUENCY,ID_AFF) values ('1332','test@email.com','Argentina','Nov 2020',to_timestamp('20/11/25 22:00:19,145186000','RR/MM/DD HH24:MI:SSXFF'),'COMM_INSERT','0','TEST TExt','TEST TExt','9999','521','Daily','115'); Insert into TEST_USERS_EMAIL_LIST (ID,EMAIL,AFF,PERIOD_OF_TIME,DTEVENT,EVENT,SEND,COMMENT_TEXT,USER_LAST_CHANGE,ID_CATEGORY,ID_COMMENT,NOTIFICATION_FREQUENCY,ID_AFF) values ('1333','test@email.com','Brazil','Nov 2020',to_timestamp('20/11/25 22:00:19,145186000','RR/MM/DD HH24:MI:SSXFF'),'COMM_INSERT','0','TEST TExt','TEST TExt','9999','522','Daily','108'); -------------------------------------------------------- -- Constraints for Table TEST_USERS_EMAIL_LIST -------------------------------------------------------- ALTER TABLE "TEST_USERS_EMAIL_LIST" MODIFY ("ID" NOT NULL ENABLE); ; ------QUERY WHICH GIVES PROBLEMS ------- with CommentAggr as ( SELECT EMAIL,AFF,ID_AFF,ID_CATEGORY,CATEGORY_NAME,ID_COMMENT, tab_to_string(CAST(COLLECT(to_char(USERS_EMAIL_LIST.ID)) AS t_varchar2_tab)) AS IDS from TEST_USERS_EMAIL_LIST USERS_EMAIL_LIST join TEST_COMMENTS_CATEGORY CAT on CAT.id=ID_CATEGORY --where USERS_EMAIL_LIST.id=1311 group by EMAIL,AFF,ID_AFF,ID_CATEGORY,CATEGORY_NAME,ID_COMMENT order by AFF,ID_COMMENT ), CategoryAgg as ( select EMAIL,AFF,ID_AFF,ID_CATEGORY,CATEGORY_NAME,tab_to_string(CAST(COLLECT(IDS) AS t_varchar2_tab)) AS IDS, tab_to_string(CAST(COLLECT( to_char(ID_COMMENT)) AS t_varchar2_tab)) ||'\n' as EmailBody from CommentAggr group by EMAIL,AFF,ID_AFF,ID_CATEGORY,CATEGORY_NAME ) select EMAIL,tab_to_string(CAST(COLLECT(IDS) AS t_varchar2_tab)) AS IDS, 'Dear User \nPlease find below list of actions according to Your subscription: \n'|| ( replace( (tab_to_string(CAST(COLLECT('\n'|| AFF||' - '||CATEGORY_NAME||'\n'||'https://tetettetetetetetet/'|| case when ID_CATEGORY=9999 then 'asadaasaaaaaa' else 'tttttaaaaaaaa' end||'?:embed=y&:linktarget=_self&:subscriptions=no&:alerts=no&:customViews=no&:showShareOptions=false&:tabs=no&:toolbar=bottom&ID_AFFILIATE='||ID_AFF|| case when ID_CATEGORY=9999 then '' else chr(38) ||'CategoryId='||ID_CATEGORY end ||'&PersonLoggedIn~na=1' ||' \n'|| 'Comment IDs:' ||' \n'|| EmailBody) AS t_varchar2_tab)) ) ,',',' ') ) ||'\n'||'Best Regards,' ||'\n'||'Team Power' as EmailBody from CategoryAgg group by EMAIL