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 ('112','2','254714809826','2025-12-08 20:28:36','6c72372f0a','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\":\"254714809826\",\"keyword\":\"OK\",\"updateType\":\"Addition\",\"message\":\"OK 25467\",\"networkCode\":\"63902\"}}}')
update adv_ke_msisdn set servicios = '{\"100\":\"100\",\"101\":\"101\",\"112\":\"112\"}' where msisdn = '254714809826'
OK 13940576 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','254729947083','2025-12-08 20:28:36','1ca2e9d88f','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\":\"254729947083\",\"keyword\":\"ok\",\"updateType\":\"Addition\",\"message\":\"Ok\",\"networkCode\":\"63902\"}}}')
update adv_ke_msisdn set servicios = '{\"101\":101,\"102\":102,\"103\":103,\"112\":112,\"113\":113,\"169\":\"169\"}' where msisdn = '254729947083'
OK 13940575 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','254114321674','2025-12-08 20:28:36','8a3bc3bbe3','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\":\"254114321674\",\"keyword\":\"OK\",\"updateType\":\"Addition\",\"message\":\"Ok\",\"networkCode\":\"63902\"}}}')
update adv_ke_msisdn set servicios = '{\"103\":103,\"17\":17,\"18\":18,\"130\":130,\"112\":\"112\",\"100\":100,\"101\":101}' where msisdn = '254114321674'
OK 13940574 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','254799645361','2025-12-08 20:28:36','9c42f6005e','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\":\"254799645361\",\"keyword\":\"YES\",\"updateType\":\"Addition\",\"message\":\"Yes,\",\"networkCode\":\"63902\"}}}')
insert into adv_ke_msisdn (msisdn,servicios) values ('254799645361','[\"0\"]')
OK 13940572 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','254710573095','2025-12-08 20:28:36','f01ec17f0f','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\":\"254710573095\",\"keyword\":\"OK\",\"updateType\":\"Addition\",\"message\":\"OK 46258\",\"networkCode\":\"63902\"}}}')
insert into adv_ke_msisdn (msisdn,servicios) values ('254710573095','{\"112\":\"112\"}')
OK 13940571 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','254798416733','2025-12-08 20:28:36','34e7e58089','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\":\"254798416733\",\"keyword\":\"OK\",\"updateType\":\"Addition\",\"message\":\"OK 97532\",\"networkCode\":\"63902\"}}}')
insert into adv_ke_msisdn (msisdn,servicios) values ('254798416733','{\"112\":\"112\"}')
OK 13940570 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 ('130','2','254717026934','2025-12-08 20:28:36','2c523d15b4','1','1','5','','0','11.000','11.000','','','0','2','1','11.000','0','1','1','{\"shortcode\":\"24811\",\"key\":\"sociflygo\"}','0','0','','{\"alta\":{\"peticion\":{\"shortCode\":\"24811\",\"phoneNumber\":\"254717026934\",\"keyword\":\"sociflygo\",\"updateType\":\"Addition\",\"message\":\"sociflygo 88675\",\"networkCode\":\"63902\"}}}')
insert into adv_ke_msisdn (msisdn,servicios) values ('254717026934','{\"130\":\"130\"}')
OK 13940569 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','254792433090','2025-12-08 20:28:36','8e3862bf39','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\":\"254792433090\",\"keyword\":\"YES\",\"updateType\":\"Addition\",\"message\":\"Yes\",\"networkCode\":\"63902\"}}}')
update adv_ke_msisdn set servicios = '{\"163\":\"163\",\"0\":\"0\"}' where msisdn = '254792433090'
OK 13940567 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 ('3','2','254715867713','2025-12-08 20:28:36','d95571c481','1','1','5','','0','10.000','10.000','','','0','2','1','10.000','0','1','1','{\"shortcode\":\"40071\",\"key\":\"get\"}','0','0','','{\"alta\":{\"peticion\":{\"shortCode\":\"40071\",\"phoneNumber\":\"254715867713\",\"keyword\":\"get\",\"updateType\":\"Addition\",\"message\":\"Get car\",\"networkCode\":\"63902\"}}}')
update adv_ke_msisdn set servicios = '{\"17\":17,\"3\":\"3\"}' where msisdn = '254715867713'
OK 13940573 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 ('16','2','254725321897','2025-12-08 20:28:36','aa79271a48','1','1','5','','0','10.000','10.000','','','0','2','1','10.000','0','1','1','{\"shortcode\":\"40071\",\"key\":\"yes\"}','0','0','','{\"alta\":{\"peticion\":{\"shortCode\":\"40071\",\"phoneNumber\":\"254725321897\",\"keyword\":\"yes\",\"updateType\":\"Addition\",\"message\":\"Yes niambie\",\"networkCode\":\"63902\"}}}')
insert into adv_ke_msisdn (msisdn,servicios) values ('254725321897','{\"16\":\"16\"}')
OK 13940566 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','254713357227','2025-12-08 20:28:36','68903d8c34','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\":\"254713357227\",\"keyword\":\"yes\",\"updateType\":\"Addition\",\"message\":\"Yes\",\"networkCode\":\"63902\"}}}')
update adv_ke_msisdn set servicios = '{\"101\":101,\"113\":113,\"130\":130,\"131\":131,\"132\":132,\"133\":133,\"112\":112,\"167\":\"167\"}' where msisdn = '254713357227'
OK 13940564 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 ('16','2','254722849708','2025-12-08 20:28:36','f40cee7999','1','1','5','','0','10.000','10.000','','','0','2','1','10.000','0','1','1','{\"shortcode\":\"40071\",\"key\":\"yes\"}','0','0','','{\"alta\":{\"peticion\":{\"shortCode\":\"40071\",\"phoneNumber\":\"254722849708\",\"keyword\":\"yes\",\"updateType\":\"Addition\",\"message\":\"Yes\",\"networkCode\":\"63902\"}}}')
insert into adv_ke_msisdn (msisdn,servicios) values ('254722849708','{\"16\":\"16\"}')
OK 13940563 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','254723494394','2025-12-08 20:28:36','010f6fe68f','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\":\"254723494394\",\"keyword\":\"YES\",\"updateType\":\"Addition\",\"message\":\"Yes\",\"networkCode\":\"63902\"}}}')
update adv_ke_msisdn set servicios = '{\"161\":\"161\",\"162\":\"162\",\"163\":\"163\",\"164\":\"164\",\"0\":\"0\"}' where msisdn = '254723494394'
OK 13940562 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','254718576521','2025-12-08 20:28:36','0f66b0fa7d','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\":\"254718576521\",\"keyword\":\"Yes\",\"updateType\":\"Addition\",\"message\":\"Yes\",\"networkCode\":\"63902\"}}}')
update adv_ke_msisdn set servicios = '{\"113\":113,\"112\":112,\"0\":\"0\"}' where msisdn = '254718576521'
OK 13940561 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','254745997246','2025-12-08 20:28:36','9bc3cc803d','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\":\"254745997246\",\"keyword\":\"YES\",\"updateType\":\"Addition\",\"message\":\"yes\",\"networkCode\":\"63902\"}}}')
update adv_ke_msisdn set servicios = '{\"17\":17,\"130\":130,\"0\":\"0\"}' where msisdn = '254745997246'
OK 13940560 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','254721644383','2025-12-08 20:28:36','4ea28978ea','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\":\"254721644383\",\"keyword\":\"OK\",\"updateType\":\"Addition\",\"message\":\"OK 74032\",\"networkCode\":\"63902\"}}}')
insert into adv_ke_msisdn (msisdn,servicios) values ('254721644383','{\"112\":\"112\"}')
OK 13940559 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','254728132408','2025-12-08 20:28:36','6cd5802710','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\":\"254728132408\",\"keyword\":\"ok\",\"updateType\":\"Addition\",\"message\":\"Ok\",\"networkCode\":\"63902\"}}}')
update adv_ke_msisdn set servicios = '{\"103\":\"103\",\"113\":\"113\",\"169\":\"169\"}' where msisdn = '254728132408'
OK 13940556 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','254702299062','2025-12-08 20:28:36','6b3e1902bb','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\":\"254702299062\",\"keyword\":\"Yes\",\"updateType\":\"Addition\",\"message\":\"Yes\",\"networkCode\":\"63902\"}}}')
update adv_ke_msisdn set servicios = '{\"101\":101,\"0\":\"0\"}' where msisdn = '254702299062'
OK 13940557 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 ('16','2','254798174443','2025-12-08 20:28:36','6fb5eb6a7a','1','1','5','','0','10.000','10.000','','','0','2','1','10.000','0','1','1','{\"shortcode\":\"40071\",\"key\":\"yes\"}','0','0','','{\"alta\":{\"peticion\":{\"shortCode\":\"40071\",\"phoneNumber\":\"254798174443\",\"keyword\":\"yes\",\"updateType\":\"Addition\",\"message\":\"Yes\",\"networkCode\":\"63902\"}}}')
insert into adv_ke_msisdn (msisdn,servicios) values ('254798174443','{\"16\":\"16\"}')
OK 13940558 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 ('162','2','254712795241','2025-12-08 20:28:36','b858ea037a','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\":\"254712795241\",\"keyword\":\"VIDSFLIX\",\"updateType\":\"Addition\",\"message\":\"Vidsflix 56821\",\"networkCode\":\"63902\"}}}')
insert into adv_ke_msisdn (msisdn,servicios) values ('254712795241','{\"162\":\"162\"}')
OK 13940555