1.INICIOinsert into mira_usuarios (id_servicio,id_agregador,phone,fecha_alta,pass_access,suscrito,activo,network,idtrack,subid,bolsa_cobro,cobrado_15_dias,idc,id_publisher,id_producto,modo_pixel_pagado,intentos_cobros_hoy,d1,tipo_optin_cobro,max_cobros_dia,id_pais,shortcode,usuario_externo,id_marcablanca,gclid,log) values ('169','2','254704521696','2025-07-13 12:52:30','0f016b84ca','1','1','5','','0','30.000','30.000','','','0','2','1','30.000','0','1','1','{\"shortcode\":\"22516\",\"key\":\"ok\"}','0','2','','{\"alta\":{\"peticion\":{\"shortCode\":\"22516\",\"phoneNumber\":\"254704521696\",\"keyword\":\"ok\",\"updateType\":\"Addition\",\"message\":\"Okay\",\"networkCode\":\"63902\"}}}')<br>
update adv_ke_msisdn set  servicios = '{\"101\":\"101\",\"169\":\"169\"}'   where  msisdn = '254704521696' <br>
OK 13940447
insert into mira_usuarios (id_servicio,id_agregador,phone,fecha_alta,pass_access,suscrito,activo,network,idtrack,subid,bolsa_cobro,cobrado_15_dias,idc,id_publisher,id_producto,modo_pixel_pagado,intentos_cobros_hoy,d1,tipo_optin_cobro,max_cobros_dia,id_pais,shortcode,usuario_externo,id_marcablanca,gclid,log) values ('112','2','254729469422','2025-07-13 12:52:30','db861416da','1','1','5','','0','10.000','10.000','','','0','2','1','10.000','0','1','1','{\"shortcode\":\"23536\",\"key\":\"OK\"}','0','2','','{\"alta\":{\"peticion\":{\"shortCode\":\"23536\",\"phoneNumber\":\"254729469422\",\"keyword\":\"OK\",\"updateType\":\"Addition\",\"message\":\"OK 83734\",\"networkCode\":\"63902\"}}}')<br>
insert into adv_ke_msisdn (msisdn,servicios) values ('254729469422','{\"112\":\"112\"}')<br>
OK 13940448
insert into mira_usuarios (id_servicio,id_agregador,phone,fecha_alta,pass_access,suscrito,activo,network,idtrack,subid,bolsa_cobro,cobrado_15_dias,idc,id_publisher,id_producto,modo_pixel_pagado,intentos_cobros_hoy,d1,tipo_optin_cobro,max_cobros_dia,id_pais,shortcode,usuario_externo,id_marcablanca,gclid,log) values ('112','2','254794712613','2025-07-13 12:52:30','035968ca98','1','1','5','','0','10.000','10.000','','','0','2','1','10.000','0','1','1','{\"shortcode\":\"23536\",\"key\":\"OK\"}','0','2','','{\"alta\":{\"peticion\":{\"shortCode\":\"23536\",\"phoneNumber\":\"254794712613\",\"keyword\":\"OK\",\"updateType\":\"Addition\",\"message\":\"OK 75791\",\"networkCode\":\"63902\"}}}')<br>
insert into adv_ke_msisdn (msisdn,servicios) values ('254794712613','{\"112\":\"112\"}')<br>
OK 13940449
insert into mira_usuarios (id_servicio,id_agregador,phone,fecha_alta,pass_access,suscrito,activo,network,idtrack,subid,bolsa_cobro,cobrado_15_dias,idc,id_publisher,id_producto,modo_pixel_pagado,intentos_cobros_hoy,d1,tipo_optin_cobro,max_cobros_dia,id_pais,shortcode,usuario_externo,id_marcablanca,gclid,log) values ('112','2','254714537796','2025-07-13 12:52:30','59723bec3c','1','1','5','','0','10.000','10.000','','','0','2','1','10.000','0','1','1','{\"shortcode\":\"23536\",\"key\":\"OK\"}','0','2','','{\"alta\":{\"peticion\":{\"shortCode\":\"23536\",\"phoneNumber\":\"254714537796\",\"keyword\":\"OK\",\"updateType\":\"Addition\",\"message\":\"OK 36964\",\"networkCode\":\"63902\"}}}')<br>
insert into adv_ke_msisdn (msisdn,servicios) values ('254714537796','{\"112\":\"112\"}')<br>
OK 13940450
insert into mira_usuarios (id_servicio,id_agregador,phone,fecha_alta,pass_access,suscrito,activo,network,idtrack,subid,bolsa_cobro,cobrado_15_dias,idc,id_publisher,id_producto,modo_pixel_pagado,intentos_cobros_hoy,d1,tipo_optin_cobro,max_cobros_dia,id_pais,shortcode,usuario_externo,id_marcablanca,gclid,log) values ('112','2','254792126384','2025-07-13 12:52:30','61dec22d4e','1','1','5','','0','10.000','10.000','','','0','2','1','10.000','0','1','1','{\"shortcode\":\"23536\",\"key\":\"OK\"}','0','2','','{\"alta\":{\"peticion\":{\"shortCode\":\"23536\",\"phoneNumber\":\"254792126384\",\"keyword\":\"OK\",\"updateType\":\"Addition\",\"message\":\"OK 97247\",\"networkCode\":\"63902\"}}}')<br>
insert into adv_ke_msisdn (msisdn,servicios) values ('254792126384','{\"112\":\"112\"}')<br>
OK 13940451
insert into mira_usuarios (id_servicio,id_agregador,phone,fecha_alta,pass_access,suscrito,activo,network,idtrack,subid,bolsa_cobro,cobrado_15_dias,idc,id_publisher,id_producto,modo_pixel_pagado,intentos_cobros_hoy,d1,tipo_optin_cobro,max_cobros_dia,id_pais,shortcode,usuario_externo,id_marcablanca,gclid,log) values ('112','2','254117072749','2025-07-13 12:52:30','b85ede7c3a','1','1','5','','0','10.000','10.000','','','0','2','1','10.000','0','1','1','{\"shortcode\":\"23536\",\"key\":\"OK\"}','0','2','','{\"alta\":{\"peticion\":{\"shortCode\":\"23536\",\"phoneNumber\":\"254117072749\",\"keyword\":\"OK\",\"updateType\":\"Addition\",\"message\":\"OK 30208\",\"networkCode\":\"63902\"}}}')<br>
insert into adv_ke_msisdn (msisdn,servicios) values ('254117072749','{\"112\":\"112\"}')<br>
OK 13940452
insert into mira_usuarios (id_servicio,id_agregador,phone,fecha_alta,pass_access,suscrito,activo,network,idtrack,subid,bolsa_cobro,cobrado_15_dias,idc,id_publisher,id_producto,modo_pixel_pagado,intentos_cobros_hoy,d1,tipo_optin_cobro,max_cobros_dia,id_pais,shortcode,usuario_externo,id_marcablanca,gclid,log) values ('112','2','254114902550','2025-07-13 12:52:30','49cab9a6b1','1','1','5','','0','10.000','10.000','','','0','2','1','10.000','0','1','1','{\"shortcode\":\"23536\",\"key\":\"OK\"}','0','2','','{\"alta\":{\"peticion\":{\"shortCode\":\"23536\",\"phoneNumber\":\"254114902550\",\"keyword\":\"OK\",\"updateType\":\"Addition\",\"message\":\"OK 74069\",\"networkCode\":\"63902\"}}}')<br>
insert into adv_ke_msisdn (msisdn,servicios) values ('254114902550','{\"112\":\"112\"}')<br>
OK 13940453
insert into mira_usuarios (id_servicio,id_agregador,phone,fecha_alta,pass_access,suscrito,activo,network,idtrack,subid,bolsa_cobro,cobrado_15_dias,idc,id_publisher,id_producto,modo_pixel_pagado,intentos_cobros_hoy,d1,tipo_optin_cobro,max_cobros_dia,id_pais,shortcode,usuario_externo,id_marcablanca,gclid,log) values ('112','2','254117711758','2025-07-13 12:52:30','826314f397','1','1','5','','0','10.000','10.000','','','0','2','1','10.000','0','1','1','{\"shortcode\":\"23536\",\"key\":\"OK\"}','0','2','','{\"alta\":{\"peticion\":{\"shortCode\":\"23536\",\"phoneNumber\":\"254117711758\",\"keyword\":\"OK\",\"updateType\":\"Addition\",\"message\":\"OK 51157\",\"networkCode\":\"63902\"}}}')<br>
insert into adv_ke_msisdn (msisdn,servicios) values ('254117711758','{\"112\":\"112\"}')<br>
OK 13940454
insert into mira_usuarios (id_servicio,id_agregador,phone,fecha_alta,pass_access,suscrito,activo,network,idtrack,subid,bolsa_cobro,cobrado_15_dias,idc,id_publisher,id_producto,modo_pixel_pagado,intentos_cobros_hoy,d1,tipo_optin_cobro,max_cobros_dia,id_pais,shortcode,usuario_externo,id_marcablanca,gclid,log) values ('112','2','254742062154','2025-07-13 12:52:30','7cf34d1f94','1','1','5','','0','10.000','10.000','','','0','2','1','10.000','0','1','1','{\"shortcode\":\"23536\",\"key\":\"OK\"}','0','2','','{\"alta\":{\"peticion\":{\"shortCode\":\"23536\",\"phoneNumber\":\"254742062154\",\"keyword\":\"OK\",\"updateType\":\"Addition\",\"message\":\"OK 65113\",\"networkCode\":\"63902\"}}}')<br>
insert into adv_ke_msisdn (msisdn,servicios) values ('254742062154','{\"112\":\"112\"}')<br>
OK 13940455
insert into mira_usuarios (id_servicio,id_agregador,phone,fecha_alta,pass_access,suscrito,activo,network,idtrack,subid,bolsa_cobro,cobrado_15_dias,idc,id_publisher,id_producto,modo_pixel_pagado,intentos_cobros_hoy,d1,tipo_optin_cobro,max_cobros_dia,id_pais,shortcode,usuario_externo,id_marcablanca,gclid,log) values ('112','2','254740763858','2025-07-13 12:52:30','8ff33a58ce','1','1','5','','0','10.000','10.000','','','0','2','1','10.000','0','1','1','{\"shortcode\":\"23536\",\"key\":\"OK\"}','0','2','','{\"alta\":{\"peticion\":{\"shortCode\":\"23536\",\"phoneNumber\":\"254740763858\",\"keyword\":\"OK\",\"updateType\":\"Addition\",\"message\":\"OK 15896\",\"networkCode\":\"63902\"}}}')<br>
insert into adv_ke_msisdn (msisdn,servicios) values ('254740763858','{\"112\":\"112\"}')<br>
OK 13940456
insert into mira_usuarios (id_servicio,id_agregador,phone,fecha_alta,pass_access,suscrito,activo,network,idtrack,subid,bolsa_cobro,cobrado_15_dias,idc,id_publisher,id_producto,modo_pixel_pagado,intentos_cobros_hoy,d1,tipo_optin_cobro,max_cobros_dia,id_pais,shortcode,usuario_externo,id_marcablanca,gclid,log) values ('112','2','254741111007','2025-07-13 12:52:30','4e383c0f91','1','1','5','','0','10.000','10.000','','','0','2','1','10.000','0','1','1','{\"shortcode\":\"23536\",\"key\":\"OK\"}','0','2','','{\"alta\":{\"peticion\":{\"shortCode\":\"23536\",\"phoneNumber\":\"254741111007\",\"keyword\":\"OK\",\"updateType\":\"Addition\",\"message\":\"OK 18500\",\"networkCode\":\"63902\"}}}')<br>
insert into adv_ke_msisdn (msisdn,servicios) values ('254741111007','{\"112\":\"112\"}')<br>
OK 13940457
insert into mira_usuarios (id_servicio,id_agregador,phone,fecha_alta,pass_access,suscrito,activo,network,idtrack,subid,bolsa_cobro,cobrado_15_dias,idc,id_publisher,id_producto,modo_pixel_pagado,intentos_cobros_hoy,d1,tipo_optin_cobro,max_cobros_dia,id_pais,shortcode,usuario_externo,id_marcablanca,gclid,log) values ('112','2','254796383404','2025-07-13 12:52:30','7e9951a251','1','1','5','','0','10.000','10.000','','','0','2','1','10.000','0','1','1','{\"shortcode\":\"23536\",\"key\":\"OK\"}','0','2','','{\"alta\":{\"peticion\":{\"shortCode\":\"23536\",\"phoneNumber\":\"254796383404\",\"keyword\":\"OK\",\"updateType\":\"Addition\",\"message\":\"OK 85199\",\"networkCode\":\"63902\"}}}')<br>
insert into adv_ke_msisdn (msisdn,servicios) values ('254796383404','{\"112\":\"112\"}')<br>
OK 13940458
insert into mira_usuarios (id_servicio,id_agregador,phone,fecha_alta,pass_access,suscrito,activo,network,idtrack,subid,bolsa_cobro,cobrado_15_dias,idc,id_publisher,id_producto,modo_pixel_pagado,intentos_cobros_hoy,d1,tipo_optin_cobro,max_cobros_dia,id_pais,shortcode,usuario_externo,id_marcablanca,gclid,log) values ('112','2','254742132253','2025-07-13 12:52:30','9a0bdf83c4','1','1','5','','0','10.000','10.000','','','0','2','1','10.000','0','1','1','{\"shortcode\":\"23536\",\"key\":\"OK\"}','0','2','','{\"alta\":{\"peticion\":{\"shortCode\":\"23536\",\"phoneNumber\":\"254742132253\",\"keyword\":\"OK\",\"updateType\":\"Addition\",\"message\":\"OK 34442\",\"networkCode\":\"63902\"}}}')<br>
insert into adv_ke_msisdn (msisdn,servicios) values ('254742132253','{\"112\":\"112\"}')<br>
OK 13940459
insert into mira_usuarios (id_servicio,id_agregador,phone,fecha_alta,pass_access,suscrito,activo,network,idtrack,subid,bolsa_cobro,cobrado_15_dias,idc,id_publisher,id_producto,modo_pixel_pagado,intentos_cobros_hoy,d1,tipo_optin_cobro,max_cobros_dia,id_pais,shortcode,usuario_externo,id_marcablanca,gclid,log) values ('112','2','254740729839','2025-07-13 12:52:30','b795169446','1','1','5','','0','10.000','10.000','','','0','2','1','10.000','0','1','1','{\"shortcode\":\"23536\",\"key\":\"OK\"}','0','2','','{\"alta\":{\"peticion\":{\"shortCode\":\"23536\",\"phoneNumber\":\"254740729839\",\"keyword\":\"OK\",\"updateType\":\"Addition\",\"message\":\"OK 33271\",\"networkCode\":\"63902\"}}}')<br>
update adv_ke_msisdn set  servicios = '{\"17\":17,\"112\":\"112\"}'   where  msisdn = '254740729839' <br>
OK 13940460
insert into mira_usuarios (id_servicio,id_agregador,phone,fecha_alta,pass_access,suscrito,activo,network,idtrack,subid,bolsa_cobro,cobrado_15_dias,idc,id_publisher,id_producto,modo_pixel_pagado,intentos_cobros_hoy,d1,tipo_optin_cobro,max_cobros_dia,id_pais,shortcode,usuario_externo,id_marcablanca,gclid,log) values ('112','2','254713110354','2025-07-13 12:52:30','da3774528f','1','1','5','','0','10.000','10.000','','','0','2','1','10.000','0','1','1','{\"shortcode\":\"23536\",\"key\":\"OK\"}','0','2','','{\"alta\":{\"peticion\":{\"shortCode\":\"23536\",\"phoneNumber\":\"254713110354\",\"keyword\":\"OK\",\"updateType\":\"Addition\",\"message\":\"OK 18931\",\"networkCode\":\"63902\"}}}')<br>
insert into adv_ke_msisdn (msisdn,servicios) values ('254713110354','{\"112\":\"112\"}')<br>
OK 13940461
insert into mira_usuarios (id_servicio,id_agregador,phone,fecha_alta,pass_access,suscrito,activo,network,idtrack,subid,bolsa_cobro,cobrado_15_dias,idc,id_publisher,id_producto,modo_pixel_pagado,intentos_cobros_hoy,d1,tipo_optin_cobro,max_cobros_dia,id_pais,shortcode,usuario_externo,id_marcablanca,gclid,log) values ('112','2','254796182099','2025-07-13 12:52:30','cb4a8d0c37','1','1','5','','0','10.000','10.000','','','0','2','1','10.000','0','1','1','{\"shortcode\":\"23536\",\"key\":\"OK\"}','0','2','','{\"alta\":{\"peticion\":{\"shortCode\":\"23536\",\"phoneNumber\":\"254796182099\",\"keyword\":\"OK\",\"updateType\":\"Addition\",\"message\":\"OK 13270\",\"networkCode\":\"63902\"}}}')<br>
insert into adv_ke_msisdn (msisdn,servicios) values ('254796182099','{\"112\":\"112\"}')<br>
OK 13940462
insert into mira_usuarios (id_servicio,id_agregador,phone,fecha_alta,pass_access,suscrito,activo,network,idtrack,subid,bolsa_cobro,cobrado_15_dias,idc,id_publisher,id_producto,modo_pixel_pagado,intentos_cobros_hoy,d1,tipo_optin_cobro,max_cobros_dia,id_pais,shortcode,usuario_externo,id_marcablanca,gclid,log) values ('112','2','254743186782','2025-07-13 12:52:30','4c44634b49','1','1','5','','0','10.000','10.000','','','0','2','1','10.000','0','1','1','{\"shortcode\":\"23536\",\"key\":\"OK\"}','0','2','','{\"alta\":{\"peticion\":{\"shortCode\":\"23536\",\"phoneNumber\":\"254743186782\",\"keyword\":\"OK\",\"updateType\":\"Addition\",\"message\":\"OK 11659TIKTOK\",\"networkCode\":\"63902\"}}}')<br>
insert into adv_ke_msisdn (msisdn,servicios) values ('254743186782','{\"112\":\"112\"}')<br>
OK 13940464
insert into mira_usuarios (id_servicio,id_agregador,phone,fecha_alta,pass_access,suscrito,activo,network,idtrack,subid,bolsa_cobro,cobrado_15_dias,idc,id_publisher,id_producto,modo_pixel_pagado,intentos_cobros_hoy,d1,tipo_optin_cobro,max_cobros_dia,id_pais,shortcode,usuario_externo,id_marcablanca,gclid,log) values ('0','0','254706590706','2025-07-13 12:52:30','07b1212125','1','1','5','','0','0.000','0.000','','','0','2','1','0.000','0','1','1','{\"shortcode\":\"23536\",\"key\":\"Yes\"}','0','0','','{\"alta\":{\"peticion\":{\"shortCode\":\"23536\",\"phoneNumber\":\"254706590706\",\"keyword\":\"Yes\",\"updateType\":\"Addition\",\"message\":\"Yes\",\"networkCode\":\"63902\"}}}')<br>
update adv_ke_msisdn set  servicios = '{\"3\":3,\"18\":18,\"17\":17,\"130\":130,\"112\":112,\"0\":\"0\"}'   where  msisdn = '254706590706' <br>
OK 13940446