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 ('0','0','254706130334','2025-05-09 16:06:50','ae6630821f','1','1','5','','0','0.000','0.000','','','0','2','1','0.000','0','1','1','{\"shortcode\":\"23536\",\"key\":\"Go\"}','0','0','','{\"alta\":{\"peticion\":{\"shortCode\":\"23536\",\"phoneNumber\":\"254706130334\",\"keyword\":\"Go\",\"updateType\":\"Addition\",\"networkCode\":\"63902\"}}}')<br>
update adv_ke_msisdn set  servicios = '{\"101\":101,\"162\":\"162\",\"163\":\"163\",\"0\":\"0\"}'   where  msisdn = '254706130334' <br>
OK 13940405
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','254742905781','2025-05-09 16:06:50','6312f09186','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\":\"254742905781\",\"keyword\":\"sociflygo\",\"updateType\":\"Addition\",\"networkCode\":\"63902\"}}}')<br>
update adv_ke_msisdn set  servicios = '{\"3\":\"3\",\"130\":\"130\"}'   where  msisdn = '254742905781' <br>
OK 13940406
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','254115200268','2025-05-09 16:06:50','ffb4096326','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\":\"254115200268\",\"keyword\":\"VIDSFLIX\",\"updateType\":\"Addition\",\"networkCode\":\"63902\"}}}')<br>
insert into adv_ke_msisdn (msisdn,servicios) values ('254115200268','{\"162\":\"162\"}')<br>
OK 13940404