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','254727013564','2026-01-27 13:27:19','1939d7e73c','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\":\"254727013564\",\"keyword\":\"ok\",\"updateType\":\"Addition\",\"message\":\"OK\",\"networkCode\":\"63902\"}}}')<br>
update adv_ke_msisdn set  servicios = '{\"102\":\"102\",\"169\":\"169\"}'   where  msisdn = '254727013564' <br>
OK 13940582
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','254712474577','2026-01-27 13:27:19','c8dbd3fdd0','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\":\"254712474577\",\"keyword\":\"OK\",\"updateType\":\"Addition\",\"message\":\"OK 25763\",\"networkCode\":\"63902\"}}}')<br>
insert into adv_ke_msisdn (msisdn,servicios) values ('254712474577','{\"112\":\"112\"}')<br>
OK 13940589
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','254741109064','2026-01-27 13:27:19','e30629a36a','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\":\"254741109064\",\"keyword\":\"OK\",\"updateType\":\"Addition\",\"message\":\"OK 54053\",\"networkCode\":\"63902\"}}}')<br>
insert into adv_ke_msisdn (msisdn,servicios) values ('254741109064','{\"112\":\"112\"}')<br>
OK 13940588
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 ('167','2','254727529346','2026-01-27 13:27:19','0053833f27','1','1','5','','0','30.000','30.000','','','0','2','1','30.000','0','1','1','{\"shortcode\":\"22516\",\"key\":\"yes\"}','0','2','','{\"alta\":{\"peticion\":{\"shortCode\":\"22516\",\"phoneNumber\":\"254727529346\",\"keyword\":\"yes\",\"updateType\":\"Addition\",\"message\":\"Yes let us do it before expire\",\"networkCode\":\"63902\"}}}')<br>
update adv_ke_msisdn set  servicios = '{\"101\":101,\"100\":100,\"167\":\"167\"}'   where  msisdn = '254727529346' <br>
OK 13940586
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','254114030224','2026-01-27 13:27:19','938d15d2b3','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\":\"254114030224\",\"keyword\":\"Yes\",\"updateType\":\"Addition\",\"message\":\"Yes\",\"networkCode\":\"63902\"}}}')<br>
update adv_ke_msisdn set  servicios = '{\"113\":113,\"0\":\"0\"}'   where  msisdn = '254114030224' <br>
OK 13940587
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','254701440829','2026-01-27 13:27:19','0c77ff2597','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\":\"254701440829\",\"keyword\":\"OK\",\"updateType\":\"Addition\",\"message\":\"OK 23348\",\"networkCode\":\"63902\"}}}')<br>
insert into adv_ke_msisdn (msisdn,servicios) values ('254701440829','{\"112\":\"112\"}')<br>
OK 13940584
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','254707154145','2026-01-27 13:27:19','319a3e97a2','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\":\"254707154145\",\"keyword\":\"OK\",\"updateType\":\"Addition\",\"message\":\"OK 27595\",\"networkCode\":\"63902\"}}}')<br>
insert into adv_ke_msisdn (msisdn,servicios) values ('254707154145','{\"112\":\"112\"}')<br>
OK 13940583
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','254724265963','2026-01-27 13:27:19','4531748e32','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\":\"254724265963\",\"keyword\":\"OK\",\"updateType\":\"Addition\",\"message\":\"OK 85614\",\"networkCode\":\"63902\"}}}')<br>
insert into adv_ke_msisdn (msisdn,servicios) values ('254724265963','{\"112\":\"112\"}')<br>
OK 13940580
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 ('101','2','254745927404','2026-01-27 13:27:19','3727e4d9c5','1','1','5','','0','10.000','10.000','','','0','2','1','10.000','0','1','1','{\"shortcode\":\"22516\",\"key\":\"fun\"}','0','2','','{\"alta\":{\"peticion\":{\"shortCode\":\"22516\",\"phoneNumber\":\"254745927404\",\"keyword\":\"fun\",\"updateType\":\"Addition\",\"message\":\"Funny jokes\",\"networkCode\":\"63902\"}}}')<br>
insert into adv_ke_msisdn (msisdn,servicios) values ('254745927404','{\"101\":\"101\"}')<br>
OK 13940579
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','254795798828','2026-01-27 13:27:19','1ced0796b7','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\":\"254795798828\",\"keyword\":\"Yes\",\"updateType\":\"Addition\",\"message\":\"Yes\",\"networkCode\":\"63902\"}}}')<br>
insert into adv_ke_msisdn (msisdn,servicios) values ('254795798828','[\"0\"]')<br>
OK 13940578
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','254799371755','2026-01-27 13:27:19','e4f55a11c5','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\":\"254799371755\",\"keyword\":\"OK\",\"updateType\":\"Addition\",\"message\":\"OK 52618\",\"networkCode\":\"63902\"}}}')<br>
update adv_ke_msisdn set  servicios = '{\"101\":\"101\",\"112\":\"112\"}'   where  msisdn = '254799371755' <br>
OK 13940581