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 ('162','2','254795446516','2026-04-15 19:37:09','acc90e487e','1','1','5','','0','15.000','15.000','','','0','2','1','15.000','0','1','1','{\"shortcode\":\"24811\",\"key\":\"VIDSFLIX\"}','0','0','','{\"alta\":{\"peticion\":{\"shortCode\":\"24811\",\"phoneNumber\":\"254795446516\",\"keyword\":\"VIDSFLIX\",\"updateType\":\"Addition\",\"message\":\"Vidsflix 60155\",\"networkCode\":\"63902\"}}}')<br>
insert into adv_ke_msisdn (msisdn,servicios) values ('254795446516','{\"162\":\"162\"}')<br>
OK 13940592
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','254115980294','2026-04-15 19:37:09','f4dd1a223e','1','1','5','','0','0.000','0.000','','','0','2','1','0.000','0','1','1','{\"shortcode\":\"24811\",\"key\":\"YES\"}','0','0','','{\"alta\":{\"peticion\":{\"shortCode\":\"24811\",\"phoneNumber\":\"254115980294\",\"keyword\":\"YES\",\"updateType\":\"Addition\",\"message\":\"yes\",\"networkCode\":\"63902\"}}}')<br>
insert into adv_ke_msisdn (msisdn,servicios) values ('254115980294','[\"0\"]')<br>
OK 13940593
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','254713628583','2026-04-15 19:37:09','51286d95e3','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\":\"254713628583\",\"keyword\":\"OK\",\"updateType\":\"Addition\",\"message\":\"OK 778\",\"networkCode\":\"63902\"}}}')<br>
update adv_ke_msisdn set  servicios = '{\"113\":113,\"102\":\"102\",\"101\":\"101\",\"179\":\"179\",\"112\":\"112\"}'   where  msisdn = '254713628583' <br>
OK 13940594
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','254113830808','2026-04-15 19:37:09','1265746ee7','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\":\"254113830808\",\"keyword\":\"OK\",\"updateType\":\"Addition\",\"message\":\"OK 94496\",\"networkCode\":\"63902\"}}}')<br>
insert into adv_ke_msisdn (msisdn,servicios) values ('254113830808','{\"112\":\"112\"}')<br>
OK 13940595
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','254758503476','2026-04-15 19:37:09','4e342bbff6','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\":\"254758503476\",\"keyword\":\"OK\",\"updateType\":\"Addition\",\"message\":\"OK 70101\",\"networkCode\":\"63902\"}}}')<br>
insert into adv_ke_msisdn (msisdn,servicios) values ('254758503476','{\"112\":\"112\"}')<br>
OK 13940596
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 ('169','2','254722732521','2026-04-15 19:37:09','c0350a7b5a','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\":\"254722732521\",\"keyword\":\"ok\",\"updateType\":\"Addition\",\"message\":\"Ok\",\"networkCode\":\"63902\"}}}')<br>
update adv_ke_msisdn set  servicios = '{\"101\":101,\"130\":130,\"131\":131,\"132\":132,\"133\":133,\"169\":\"169\"}'   where  msisdn = '254722732521' <br>
OK 13940597
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','254745471053','2026-04-15 19:37:09','73c6aa4927','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\":\"254745471053\",\"keyword\":\"yes\",\"updateType\":\"Addition\",\"message\":\"Yes\",\"networkCode\":\"63902\"}}}')<br>
update adv_ke_msisdn set  servicios = '{\"113\":113,\"112\":112,\"104\":104,\"100\":100,\"102\":\"102\",\"167\":\"167\"}'   where  msisdn = '254745471053' <br>
OK 13940591