PREMIUM

ACCOUNTS

STARTING AT

$59.99
per month*
Duration: 12 months, annual invoice

Premium statistics
Exclusive

Get unlimited access with our premium accounts

Advantages of being Premium

  • Right to publish Statlat’s graphs
  • Download database of studies carried out by STATLAT.
  • Annual Sectorial reports.
  • Dossiers: relevant statistics of specific topics.
  • Annual personalized project.
  • Support
  • Additional Users
(default) 41 queries took 35 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT `Language`.`nomenclatura`, `Language`.`id` FROM `saas_statlat`.`languages` AS `Language` WHERE `state` = 1220
2SELECT `Session`.`id`, `Session`.`data`, `Session`.`expires`, `Session`.`user_id`, `Session`.`ip`, `Session`.`state` FROM `saas_statlat`.`cake_sessions` AS `Session` WHERE `Session`.`id` = 'rj0ouc1j45b55qsakafhqhldh7' LIMIT 1000
3SELECT `Language`.`id`, `Language`.`name`, `Language`.`nomenclatura`, `Language`.`state`, `Language`.`created`, `Language`.`modified` FROM `saas_statlat`.`languages` AS `Language` WHERE `Language`.`nomenclatura` = 'eng' LIMIT 1110
4SELECT `Language`.`id`, `Language`.`name`, `Language`.`nomenclatura`, `Language`.`state`, `Language`.`created`, `Language`.`modified` FROM `saas_statlat`.`languages` AS `Language` WHERE `Language`.`state` = 1220
5SELECT `Statistic`.`id`, `Statistic`.`name`, `Statistic`.`description`, `Statistic`.`state`, `Statistic`.`created`, `Statistic`.`modified`, `Statistic`.`font_name`, `Statistic`.`sector_id`, `Statistic`.`font_url`, `Statistic`.`font_age`, `Statistic`.`public`, `Statistic`.`labels`, `Statistic`.`data`, `Statistic`.`type`, `Statistic`.`zoho_url`, `Statistic`.`zoho_url_eng`, `Statistic`.`db_zoho`, `Statistic`.`report_zoho`, `Statistic`.`export_data`, `Statistic`.`country_id`, `Statistic`.`views`, `Statistic`.`downloads`, `Statistic`.`target_id`, `Statistic`.`language_id`, `Statistic`.`destacado`, `CountryMap`.`id`, `CountryMap`.`name`, `CountryMap`.`name_eng`, `CountryMap`.`state`, `CountryMap`.`created`, `CountryMap`.`modified`, `CountryMap`.`url`, `CountryMap`.`source`, `Parent`.`id`, `Parent`.`name`, `Parent`.`description`, `Parent`.`state`, `Parent`.`created`, `Parent`.`modified`, `Parent`.`font_name`, `Parent`.`sector_id`, `Parent`.`font_url`, `Parent`.`font_age`, `Parent`.`public`, `Parent`.`labels`, `Parent`.`data`, `Parent`.`type`, `Parent`.`zoho_url`, `Parent`.`zoho_url_eng`, `Parent`.`db_zoho`, `Parent`.`report_zoho`, `Parent`.`export_data`, `Parent`.`country_id`, `Parent`.`views`, `Parent`.`downloads`, `Parent`.`target_id`, `Parent`.`language_id`, `Parent`.`destacado`, `Language`.`id`, `Language`.`name`, `Language`.`nomenclatura`, `Language`.`state`, `Language`.`created`, `Language`.`modified` FROM `saas_statlat`.`statistics` AS `Statistic` LEFT JOIN `saas_statlat`.`countries` AS `CountryMap` ON (`Statistic`.`country_id` = `CountryMap`.`id`) LEFT JOIN `saas_statlat`.`statistics` AS `Parent` ON (`Statistic`.`target_id` = `Parent`.`id`) LEFT JOIN `saas_statlat`.`languages` AS `Language` ON (`Statistic`.`language_id` = `Language`.`id`) WHERE `Statistic`.`id` = 1034 LIMIT 1111
6SELECT `Children`.`id`, `Children`.`name`, `Children`.`description`, `Children`.`state`, `Children`.`created`, `Children`.`modified`, `Children`.`font_name`, `Children`.`sector_id`, `Children`.`font_url`, `Children`.`font_age`, `Children`.`public`, `Children`.`labels`, `Children`.`data`, `Children`.`type`, `Children`.`zoho_url`, `Children`.`zoho_url_eng`, `Children`.`db_zoho`, `Children`.`report_zoho`, `Children`.`export_data`, `Children`.`country_id`, `Children`.`views`, `Children`.`downloads`, `Children`.`target_id`, `Children`.`language_id`, `Children`.`destacado` FROM `saas_statlat`.`statistics` AS `Children` WHERE `Children`.`target_id` = (1034)005
7SELECT `Country`.`id`, `Country`.`name`, `Country`.`name_eng`, `Country`.`state`, `Country`.`created`, `Country`.`modified`, `Country`.`url`, `Country`.`source`, `StatisticsCountry`.`id`, `StatisticsCountry`.`statistic_id`, `StatisticsCountry`.`country_id` FROM `saas_statlat`.`countries` AS `Country` JOIN `saas_statlat`.`statistics_countries` AS `StatisticsCountry` ON (`StatisticsCountry`.`statistic_id` = 1034 AND `StatisticsCountry`.`country_id` = `Country`.`id`) 112
8SELECT `Sector`.`id`, `Sector`.`name`, `Sector`.`name_eng`, `Sector`.`description`, `Sector`.`description_eng`, `Sector`.`state`, `Sector`.`created`, `Sector`.`modified`, `Sector`.`sector_id`, `Sector`.`font_name`, `Sector`.`font_name_eng`, `Sector`.`font_url`, `Sector`.`font_age`, `Sector`.`image`, `Sector`.`banner`, `StatisticsSector`.`id`, `StatisticsSector`.`statistic_id`, `StatisticsSector`.`sector_id` FROM `saas_statlat`.`sectors` AS `Sector` JOIN `saas_statlat`.`statistics_sectors` AS `StatisticsSector` ON (`StatisticsSector`.`statistic_id` = 1034 AND `StatisticsSector`.`sector_id` = `Sector`.`id`) 112
9SELECT `Tag`.`id`, `Tag`.`name`, `Tag`.`state`, `Tag`.`created`, `Tag`.`modified`, `StatisticsTag`.`id`, `StatisticsTag`.`statistic_id`, `StatisticsTag`.`tag_id` FROM `saas_statlat`.`tags` AS `Tag` JOIN `saas_statlat`.`statistics_tags` AS `StatisticsTag` ON (`StatisticsTag`.`statistic_id` = 1034 AND `StatisticsTag`.`tag_id` = `Tag`.`id`) 553
10BEGIN000
11SELECT COUNT(*) AS `count` FROM `saas_statlat`.`statistics` AS `Statistic` WHERE `Statistic`.`id` = 1034110
12SELECT COUNT(*) AS `count` FROM `saas_statlat`.`statistics` AS `Statistic` WHERE `Statistic`.`id` = 1034110
13SELECT COUNT(*) AS `count` FROM `saas_statlat`.`statistics` AS `Statistic` WHERE `Statistic`.`id` = 1034110
14UPDATE `saas_statlat`.`statistics` SET `id` = 1034, `name` = 'Data and voice quality by mobile operator, Colombia', `description` = '<p>Download speed: This indicator identifies the speed at which a file is downloaded (photos, videos, documents). In Colombia, the highest Avantel speed values in Bogota, Medellin and Cartagena and, Tigo in Cali stand out.</p>\r\n<p>Average speed YouTube: This indicator reflects the speed at which a user downloads a video to YouTube. In Colombia, Avantel stands out in Cartagena, Medellin and Bogota, where the mobile operator scores the best of all the operators in these three cities. In Cali the fastest mobile operator is Tigo.</p>\r\n<p>Web Upload Time: This indicator allows you to identify the time it takes a user to fully load a web page. By 2016, Avantel is the mobile operator with the least amount of web upload time in Bogot&aacute;, Movistar in Cali, and ETB in Medell&iacute;n and Cartagena.</p>\r\n<p>Measured Delay-Latency-(ms): This indicator measures the communication time (round trip) between the servers that serve the pages included in the test (Google.com, Facebook.com, Youtube.com, Live.com, Yahoo.com, Wikipedia.org, ElTiempo.com and MercadoLibre.com) and the device that performed the measurement. The shortest times were in Bogot&aacute; and Medell&iacute;n for the mobile operator &Eacute;xito, and in Cali and Cartagena for Tigo.</p>', `state` = 1, `created` = '2018-07-25 12:09:58', `modified` = '2018-07-25 07:09:58', `font_name` = 'Comisión de Regulación de Comunicaciones', `sector_id` = NULL, `font_url` = 'https://www.crcom.gov.co/es/pagina/medicion-calidad-datos', `font_age` = '2016', `public` = 0, `labels` = '', `data` = '', `type` = 2, `zoho_url` = 'https://reports.zoho.com/open-view/1582398000000361152', `zoho_url_eng` = 'https://reports.zoho.com/open-view/1582398000000360532', `db_zoho` = 'ColombiaExcel', `report_zoho` = 'ColombiaExcel', `export_data` = '', `country_id` = NULL, `views` = 609, `downloads` = 0, `target_id` = 1033, `language_id` = 2, `destacado` = 1 WHERE `saas_statlat`.`statistics`.`id` = '1034'110
15COMMIT000
16SELECT `Search`.`id`, `Search`.`state`, `Search`.`target_id`, `Search`.`type`, `Search`.`rate_total`, `Search`.`views`, `Search`.`name`, `Search`.`description`, `Search`.`font_age`, `Search`.`language_id`, `Search`.`public`, `Search`.`countries`, `Search`.`countries_eng`, `Search`.`tags`, `Search`.`sectors_eng`, `Search`.`sectors`, `Search`.`downloads`, `Search`.`created`, `Search`.`modified`, `Search`.`subsectors`, `Search`.`subsectors_eng` FROM `saas_statlat`.`searchs` AS `Search` WHERE `target_id` = 1034 AND `type` = 'Statistic' LIMIT 1111
17BEGIN000
18SELECT COUNT(*) AS `count` FROM `saas_statlat`.`searchs` AS `Search` WHERE `Search`.`id` = 1233110
19SELECT COUNT(*) AS `count` FROM `saas_statlat`.`searchs` AS `Search` WHERE `Search`.`id` = 1233110
20SELECT COUNT(*) AS `count` FROM `saas_statlat`.`searchs` AS `Search` WHERE `Search`.`id` = 1233110
21UPDATE `saas_statlat`.`searchs` SET `id` = 1233, `state` = 1, `target_id` = 1034, `type` = 'Statistic', `rate_total` = 0, `views` = 620, `name` = 'Data and voice quality by mobile operator, Colombia', `description` = '<p>Download speed: This indicator identifies the speed at which a file is downloaded (photos, videos, documents). In Colombia, the highest Avantel speed values in Bogota, Medellin and Cartagena and, Tigo in Cali stand out.</p>\r\n<p>Average speed YouTube: This indicator reflects the speed at which a user downloads a video to YouTube. In Colombia, Avantel stands out in Cartagena, Medellin and Bogota, where the mobile operator scores the best of all the operators in these three cities. In Cali the fastest mobile operator is Tigo.</p>\r\n<p>Web Upload Time: This indicator allows you to identify the time it takes a user to fully load a web page. By 2016, Avantel is the mobile operator with the least amount of web upload time in Bogot&aacute;, Movistar in Cali, and ETB in Medell&iacute;n and Cartagena.</p>\r\n<p>Measured Delay-Latency-(ms): This indicator measures the communication time (round trip) between the servers that serve the pages included in the test (Google.com, Facebook.com, Youtube.com, Live.com, Yahoo.com, Wikipedia.org, ElTiempo.com and MercadoLibre.com) and the device that performed the measurement. The shortest times were in Bogot&aacute; and Medell&iacute;n for the mobile operator &Eacute;xito, and in Cali and Cartagena for Tigo.</p>', `font_age` = '2016', `language_id` = 2, `public` = 0, `countries` = 'Colombia', `countries_eng` = 'Colombia', `tags` = 'Mobile operator,Claro,Movistar,tigo,Avantel', `sectors_eng` = 'Technology and telecommunications', `sectors` = 'Tecnología y telecomunicaciones', `downloads` = 0, `created` = '2018-04-11 04:53:48', `modified` = '2018-09-08 10:01:32', `subsectors` = 'Innovación y electrodomésticos', `subsectors_eng` = 'Innovation and appliances' WHERE `saas_statlat`.`searchs`.`id` = '1233'110
22COMMIT000
23SELECT `Suscription`.`id`, `Suscription`.`plan_id`, `Suscription`.`payment_id`, `Suscription`.`date_ini`, `Suscription`.`date_end`, `Suscription`.`state`, `Suscription`.`created`, `Suscription`.`modified`, `Suscription`.`value_user`, `Suscription`.`user_id`, `Suscription`.`active`, `Plan`.`id`, `Plan`.`name`, `Plan`.`name_eng`, `Plan`.`description`, `Plan`.`description_eng`, `Plan`.`estadisticas`, `Plan`.`descarga_excel`, `Plan`.`descarga_pdf`, `Plan`.`descarga_png`, `Plan`.`descargas`, `Plan`.`variables`, `Plan`.`carpeta_marcadores`, `Plan`.`derecho_de_publicacion`, `Plan`.`informes_sectoriales`, `Plan`.`expedientes`, `Plan`.`estudio_anual_personalizado`, `Plan`.`soporte_email`, `Plan`.`soporte_telefonico`, `Plan`.`soporte_chat`, `Plan`.`users`, `Plan`.`price_user`, `Plan`.`price`, `Plan`.`price_discount`, `Plan`.`state`, `Plan`.`modified`, `Plan`.`created`, `Payment`.`id`, `Payment`.`value`, `Payment`.`state`, `Payment`.`date`, `Payment`.`created`, `Payment`.`modified`, `Payment`.`data_result`, `Payment`.`transaction_id`, `User`.`id`, `User`.`name`, `User`.`email`, `User`.`password`, `User`.`company`, `User`.`image`, `User`.`created`, `User`.`modified`, `User`.`state`, `User`.`hash_change_password`, `User`.`identification`, `User`.`white_label`, `User`.`role`, `User`.`logo`, `User`.`type_user`, `User`.`phone`, `User`.`ext`, `User`.`lang`, `User`.`address`, `User`.`position`, `User`.`user_id`, `User`.`platform`, `User`.`username`, `User`.`city_id`, `User`.`is_customer`, `User`.`terminos`, `User`.`datos`, `User`.`accepting_data_collection` FROM `saas_statlat`.`suscriptions` AS `Suscription` LEFT JOIN `saas_statlat`.`plans` AS `Plan` ON (`Suscription`.`plan_id` = `Plan`.`id`) LEFT JOIN `saas_statlat`.`payments` AS `Payment` ON (`Suscription`.`payment_id` = `Payment`.`id`) LEFT JOIN `saas_statlat`.`users` AS `User` ON (`Suscription`.`user_id` = `User`.`id`) WHERE `Suscription`.`user_id` IS NULL AND `Suscription`.`active` = 1 LIMIT 1111
24SELECT `Sector`.`id`, `Sector`.`name`, `Sector`.`name_eng`, `Sector`.`description`, `Sector`.`description_eng`, `Sector`.`state`, `Sector`.`created`, `Sector`.`modified`, `Sector`.`sector_id`, `Sector`.`font_name`, `Sector`.`font_name_eng`, `Sector`.`font_url`, `Sector`.`font_age`, `Sector`.`image`, `Sector`.`banner` FROM `saas_statlat`.`sectors` AS `Sector` WHERE `Sector`.`id` = 63 LIMIT 1110
25SELECT `Sector`.`id`, `Sector`.`name`, `Sector`.`name_eng`, `Sector`.`description`, `Sector`.`description_eng`, `Sector`.`state`, `Sector`.`created`, `Sector`.`modified`, `Sector`.`sector_id`, `Sector`.`font_name`, `Sector`.`font_name_eng`, `Sector`.`font_url`, `Sector`.`font_age`, `Sector`.`image`, `Sector`.`banner` FROM `saas_statlat`.`sectors` AS `Sector` WHERE `Sector`.`sector_id` = 4 AND `Sector`.`state` = 1111
26SELECT `Infographic`.`id`, `Infographic`.`name`, `Infographic`.`description`, `Infographic`.`font_name`, `Infographic`.`image`, `Infographic`.`sector_id`, `Infographic`.`state`, `Infographic`.`created`, `Infographic`.`modified`, `Infographic`.`font_age`, `Infographic`.`font_url`, `Infographic`.`public`, `Infographic`.`views`, `Infographic`.`downloads`, `Infographic`.`target_id`, `Infographic`.`language_id`, `InfographicsSector`.`id`, `InfographicsSector`.`sector_id`, `InfographicsSector`.`infographic_id` FROM `saas_statlat`.`infographics` AS `Infographic` JOIN `saas_statlat`.`infographics_sectors` AS `InfographicsSector` ON (`InfographicsSector`.`sector_id` = 63 AND `InfographicsSector`.`infographic_id` = `Infographic`.`id`) 441
27SELECT `Map`.`id`, `Map`.`name`, `Map`.`description`, `Map`.`db_zoho`, `Map`.`report_zoho`, `Map`.`labels`, `Map`.`data`, `Map`.`age`, `Map`.`filter`, `Map`.`state`, `Map`.`public`, `Map`.`created`, `Map`.`modified`, `Map`.`export_zoho`, `Map`.`downloads`, `Map`.`views`, `Map`.`font_name`, `Map`.`font_url`, `Map`.`target_id`, `Map`.`language_id`, `MapsSector`.`id`, `MapsSector`.`map_id`, `MapsSector`.`sector_id`, `MapsSector`.`created`, `MapsSector`.`modified` FROM `saas_statlat`.`maps` AS `Map` JOIN `saas_statlat`.`maps_sectors` AS `MapsSector` ON (`MapsSector`.`sector_id` = 63 AND `MapsSector`.`map_id` = `Map`.`id`) 881
28SELECT `Motiongraphic`.`id`, `Motiongraphic`.`name`, `Motiongraphic`.`description`, `Motiongraphic`.`iframe`, `Motiongraphic`.`font_name`, `Motiongraphic`.`sector_id`, `Motiongraphic`.`state`, `Motiongraphic`.`created`, `Motiongraphic`.`modified`, `Motiongraphic`.`font_url`, `Motiongraphic`.`font_age`, `Motiongraphic`.`public`, `Motiongraphic`.`views`, `Motiongraphic`.`target_id`, `Motiongraphic`.`language_id`, `MotiongraphicsSector`.`id`, `MotiongraphicsSector`.`sector_id`, `MotiongraphicsSector`.`motiongraphic_id` FROM `saas_statlat`.`motiongraphics` AS `Motiongraphic` JOIN `saas_statlat`.`motiongraphics_sectors` AS `MotiongraphicsSector` ON (`MotiongraphicsSector`.`sector_id` = 63 AND `MotiongraphicsSector`.`motiongraphic_id` = `Motiongraphic`.`id`) 000
29SELECT `Statistic`.`id`, `Statistic`.`name`, `Statistic`.`description`, `Statistic`.`state`, `Statistic`.`created`, `Statistic`.`modified`, `Statistic`.`font_name`, `Statistic`.`sector_id`, `Statistic`.`font_url`, `Statistic`.`font_age`, `Statistic`.`public`, `Statistic`.`labels`, `Statistic`.`data`, `Statistic`.`type`, `Statistic`.`zoho_url`, `Statistic`.`zoho_url_eng`, `Statistic`.`db_zoho`, `Statistic`.`report_zoho`, `Statistic`.`export_data`, `Statistic`.`country_id`, `Statistic`.`views`, `Statistic`.`downloads`, `Statistic`.`target_id`, `Statistic`.`language_id`, `Statistic`.`destacado`, `StatisticsSector`.`id`, `StatisticsSector`.`statistic_id`, `StatisticsSector`.`sector_id` FROM `saas_statlat`.`statistics` AS `Statistic` JOIN `saas_statlat`.`statistics_sectors` AS `StatisticsSector` ON (`StatisticsSector`.`sector_id` = 63 AND `StatisticsSector`.`statistic_id` = `Statistic`.`id`) 93932
30SELECT `Sector`.`id`, `Sector`.`name`, `Sector`.`name_eng`, `Sector`.`description`, `Sector`.`description_eng`, `Sector`.`state`, `Sector`.`created`, `Sector`.`modified`, `Sector`.`sector_id`, `Sector`.`font_name`, `Sector`.`font_name_eng`, `Sector`.`font_url`, `Sector`.`font_age`, `Sector`.`image`, `Sector`.`banner` FROM `saas_statlat`.`sectors` AS `Sector` WHERE `Sector`.`sector_id` = 4 AND `Sector`.`state` = 1111
31SELECT `Infographic`.`id`, `Infographic`.`name`, `Infographic`.`description`, `Infographic`.`font_name`, `Infographic`.`image`, `Infographic`.`sector_id`, `Infographic`.`state`, `Infographic`.`created`, `Infographic`.`modified`, `Infographic`.`font_age`, `Infographic`.`font_url`, `Infographic`.`public`, `Infographic`.`views`, `Infographic`.`downloads`, `Infographic`.`target_id`, `Infographic`.`language_id`, `InfographicsSector`.`id`, `InfographicsSector`.`sector_id`, `InfographicsSector`.`infographic_id` FROM `saas_statlat`.`infographics` AS `Infographic` JOIN `saas_statlat`.`infographics_sectors` AS `InfographicsSector` ON (`InfographicsSector`.`sector_id` = 63 AND `InfographicsSector`.`infographic_id` = `Infographic`.`id`) 441
32SELECT `Map`.`id`, `Map`.`name`, `Map`.`description`, `Map`.`db_zoho`, `Map`.`report_zoho`, `Map`.`labels`, `Map`.`data`, `Map`.`age`, `Map`.`filter`, `Map`.`state`, `Map`.`public`, `Map`.`created`, `Map`.`modified`, `Map`.`export_zoho`, `Map`.`downloads`, `Map`.`views`, `Map`.`font_name`, `Map`.`font_url`, `Map`.`target_id`, `Map`.`language_id`, `MapsSector`.`id`, `MapsSector`.`map_id`, `MapsSector`.`sector_id`, `MapsSector`.`created`, `MapsSector`.`modified` FROM `saas_statlat`.`maps` AS `Map` JOIN `saas_statlat`.`maps_sectors` AS `MapsSector` ON (`MapsSector`.`sector_id` = 63 AND `MapsSector`.`map_id` = `Map`.`id`) 881
33SELECT `Motiongraphic`.`id`, `Motiongraphic`.`name`, `Motiongraphic`.`description`, `Motiongraphic`.`iframe`, `Motiongraphic`.`font_name`, `Motiongraphic`.`sector_id`, `Motiongraphic`.`state`, `Motiongraphic`.`created`, `Motiongraphic`.`modified`, `Motiongraphic`.`font_url`, `Motiongraphic`.`font_age`, `Motiongraphic`.`public`, `Motiongraphic`.`views`, `Motiongraphic`.`target_id`, `Motiongraphic`.`language_id`, `MotiongraphicsSector`.`id`, `MotiongraphicsSector`.`sector_id`, `MotiongraphicsSector`.`motiongraphic_id` FROM `saas_statlat`.`motiongraphics` AS `Motiongraphic` JOIN `saas_statlat`.`motiongraphics_sectors` AS `MotiongraphicsSector` ON (`MotiongraphicsSector`.`sector_id` = 63 AND `MotiongraphicsSector`.`motiongraphic_id` = `Motiongraphic`.`id`) 000
34SELECT `Statistic`.`id`, `Statistic`.`name`, `Statistic`.`description`, `Statistic`.`state`, `Statistic`.`created`, `Statistic`.`modified`, `Statistic`.`font_name`, `Statistic`.`sector_id`, `Statistic`.`font_url`, `Statistic`.`font_age`, `Statistic`.`public`, `Statistic`.`labels`, `Statistic`.`data`, `Statistic`.`type`, `Statistic`.`zoho_url`, `Statistic`.`zoho_url_eng`, `Statistic`.`db_zoho`, `Statistic`.`report_zoho`, `Statistic`.`export_data`, `Statistic`.`country_id`, `Statistic`.`views`, `Statistic`.`downloads`, `Statistic`.`target_id`, `Statistic`.`language_id`, `Statistic`.`destacado`, `StatisticsSector`.`id`, `StatisticsSector`.`statistic_id`, `StatisticsSector`.`sector_id` FROM `saas_statlat`.`statistics` AS `Statistic` JOIN `saas_statlat`.`statistics_sectors` AS `StatisticsSector` ON (`StatisticsSector`.`sector_id` = 63 AND `StatisticsSector`.`statistic_id` = `Statistic`.`id`) 93932
35SELECT `Transaction`.`id`, `Transaction`.`user_id`, `Transaction`.`currency`, `Transaction`.`value`, `Transaction`.`payment`, `Transaction`.`reference_id`, `Transaction`.`id_generate`, `Transaction`.`state`, `Transaction`.`is_trial`, `Transaction`.`is_free`, `Transaction`.`created`, `Transaction`.`modified`, `Transaction`.`upgrade`, `Transaction`.`plan_id`, `Transaction`.`notify`, `Transaction`.`type_transaction`, `Transaction`.`number_users` FROM `saas_statlat`.`transactions` AS `Transaction` WHERE ((`Transaction`.`state` = 'PENDING') OR (`Transaction`.`state` = 'INPROCESS')) AND `Transaction`.`user_id` IS NULL AND `Transaction`.`notify` = 1 LIMIT 1001
36SELECT `User`.`id`, `User`.`name`, `User`.`email`, `User`.`password`, `User`.`company`, `User`.`image`, `User`.`created`, `User`.`modified`, `User`.`state`, `User`.`hash_change_password`, `User`.`identification`, `User`.`white_label`, `User`.`role`, `User`.`logo`, `User`.`type_user`, `User`.`phone`, `User`.`ext`, `User`.`lang`, `User`.`address`, `User`.`position`, `User`.`user_id`, `User`.`platform`, `User`.`username`, `User`.`city_id`, `User`.`is_customer`, `User`.`terminos`, `User`.`datos`, `User`.`accepting_data_collection` FROM `saas_statlat`.`users` AS `User` WHERE `User`.`id` IS NULL LIMIT 1000
37SELECT `Sector`.`id`, `Sector`.`name`, `Sector`.`name_eng`, `Sector`.`description`, `Sector`.`description_eng`, `Sector`.`state`, `Sector`.`created`, `Sector`.`modified`, `Sector`.`sector_id`, `Sector`.`font_name`, `Sector`.`font_name_eng`, `Sector`.`font_url`, `Sector`.`font_age`, `Sector`.`image`, `Sector`.`banner` FROM `saas_statlat`.`sectors` AS `Sector` WHERE `Sector`.`state` = 1 AND `Sector`.`sector_id` = 016161
38SELECT `Sub-Sector`.`id`, `Sub-Sector`.`name`, `Sub-Sector`.`name_eng`, `Sub-Sector`.`description`, `Sub-Sector`.`description_eng`, `Sub-Sector`.`state`, `Sub-Sector`.`created`, `Sub-Sector`.`modified`, `Sub-Sector`.`sector_id`, `Sub-Sector`.`font_name`, `Sub-Sector`.`font_name_eng`, `Sub-Sector`.`font_url`, `Sub-Sector`.`font_age`, `Sub-Sector`.`image`, `Sub-Sector`.`banner` FROM `saas_statlat`.`sectors` AS `Sub-Sector` WHERE `Sub-Sector`.`sector_id` IN (1, 4, 6, 7, 8, 9, 10, 12, 13, 14, 15, 16, 17, 18, 19, 64)46461
39SELECT `Suscription`.`id`, `Suscription`.`plan_id`, `Suscription`.`payment_id`, `Suscription`.`date_ini`, `Suscription`.`date_end`, `Suscription`.`state`, `Suscription`.`created`, `Suscription`.`modified`, `Suscription`.`value_user`, `Suscription`.`user_id`, `Suscription`.`active`, `Plan`.`id`, `Plan`.`name`, `Plan`.`name_eng`, `Plan`.`description`, `Plan`.`description_eng`, `Plan`.`estadisticas`, `Plan`.`descarga_excel`, `Plan`.`descarga_pdf`, `Plan`.`descarga_png`, `Plan`.`descargas`, `Plan`.`variables`, `Plan`.`carpeta_marcadores`, `Plan`.`derecho_de_publicacion`, `Plan`.`informes_sectoriales`, `Plan`.`expedientes`, `Plan`.`estudio_anual_personalizado`, `Plan`.`soporte_email`, `Plan`.`soporte_telefonico`, `Plan`.`soporte_chat`, `Plan`.`users`, `Plan`.`price_user`, `Plan`.`price`, `Plan`.`price_discount`, `Plan`.`state`, `Plan`.`modified`, `Plan`.`created`, `Payment`.`id`, `Payment`.`value`, `Payment`.`state`, `Payment`.`date`, `Payment`.`created`, `Payment`.`modified`, `Payment`.`data_result`, `Payment`.`transaction_id`, `User`.`id`, `User`.`name`, `User`.`email`, `User`.`password`, `User`.`company`, `User`.`image`, `User`.`created`, `User`.`modified`, `User`.`state`, `User`.`hash_change_password`, `User`.`identification`, `User`.`white_label`, `User`.`role`, `User`.`logo`, `User`.`type_user`, `User`.`phone`, `User`.`ext`, `User`.`lang`, `User`.`address`, `User`.`position`, `User`.`user_id`, `User`.`platform`, `User`.`username`, `User`.`city_id`, `User`.`is_customer`, `User`.`terminos`, `User`.`datos`, `User`.`accepting_data_collection` FROM `saas_statlat`.`suscriptions` AS `Suscription` LEFT JOIN `saas_statlat`.`plans` AS `Plan` ON (`Suscription`.`plan_id` = `Plan`.`id`) LEFT JOIN `saas_statlat`.`payments` AS `Payment` ON (`Suscription`.`payment_id` = `Payment`.`id`) LEFT JOIN `saas_statlat`.`users` AS `User` ON (`Suscription`.`user_id` = `User`.`id`) WHERE `Suscription`.`user_id` IS NULL AND `Suscription`.`active` = 1 LIMIT 1111
40SELECT `Statistic`.`id`, `Statistic`.`name`, `Statistic`.`description`, `Statistic`.`state`, `Statistic`.`created`, `Statistic`.`modified`, `Statistic`.`font_name`, `Statistic`.`sector_id`, `Statistic`.`font_url`, `Statistic`.`font_age`, `Statistic`.`public`, `Statistic`.`labels`, `Statistic`.`data`, `Statistic`.`type`, `Statistic`.`zoho_url`, `Statistic`.`zoho_url_eng`, `Statistic`.`db_zoho`, `Statistic`.`report_zoho`, `Statistic`.`export_data`, `Statistic`.`country_id`, `Statistic`.`views`, `Statistic`.`downloads`, `Statistic`.`target_id`, `Statistic`.`language_id`, `Statistic`.`destacado` FROM `saas_statlat`.`statistics` AS `Statistic` WHERE `Statistic`.`state` = 1 AND `Statistic`.`destacado` = 110106
41SELECT `Advertisement`.`id`, `Advertisement`.`name`, `Advertisement`.`image`, `Advertisement`.`url`, `Advertisement`.`text`, `Advertisement`.`state`, `Advertisement`.`priority`, `Advertisement`.`client`, `Advertisement`.`created`, `Advertisement`.`modified` FROM `saas_statlat`.`advertisements` AS `Advertisement` WHERE `Advertisement`.`state` = 1110

Loading