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) 38 queries took 34 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` = '6420lvtnapuh031gce4r7ijt87' 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` = 1561 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` = (1561)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` = 1561 AND `StatisticsCountry`.`country_id` = `Country`.`id`) 21212
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` = 1561 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` = 1561 AND `StatisticsTag`.`tag_id` = `Tag`.`id`) 223
10BEGIN000
11SELECT COUNT(*) AS `count` FROM `saas_statlat`.`statistics` AS `Statistic` WHERE `Statistic`.`id` = 1561110
12SELECT COUNT(*) AS `count` FROM `saas_statlat`.`statistics` AS `Statistic` WHERE `Statistic`.`id` = 1561110
13SELECT COUNT(*) AS `count` FROM `saas_statlat`.`statistics` AS `Statistic` WHERE `Statistic`.`id` = 1561110
14UPDATE `saas_statlat`.`statistics` SET `id` = 1561, `name` = 'Credit card ownership, America', `description` = '<p>The percentage of respondents who report having a credit card.</p>', `state` = 1, `created` = '2018-10-10 09:57:28', `modified` = '2018-10-10 09:57:28', `font_name` = 'World Bank', `sector_id` = NULL, `font_url` = 'https://tcdata360.worldbank.org/indicators/h83ea0f24?country=BRA&indicator=3360&countries=MEX,SUR,CRI,GRD,VEN,PAN,LCA,ARG,COL,DMA,VCT,ATG,DOM,PER,VIR,ECU,CUB,CHL,BRB,JAM,KNA,BLZ,PRY,GUY,URY,USA,CAN&viz=line_chart&years=2011,2017&compareBy=region', `font_age` = '2017', `public` = 0, `labels` = '', `data` = '', `type` = 2, `zoho_url` = 'https://reports.zoho.com/open-view/1582398000002056123', `zoho_url_eng` = 'https://reports.zoho.com/open-view/1582398000002049285', `db_zoho` = 'ColombiaExcel', `report_zoho` = 'ColombiaExcel', `export_data` = '', `country_id` = NULL, `views` = 469, `downloads` = 0, `target_id` = 1560, `language_id` = 2, `destacado` = 1 WHERE `saas_statlat`.`statistics`.`id` = '1561'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` = 1561 AND `type` = 'Statistic' LIMIT 1110
17BEGIN000
18SELECT COUNT(*) AS `count` FROM `saas_statlat`.`searchs` AS `Search` WHERE `Search`.`id` = 1932110
19SELECT COUNT(*) AS `count` FROM `saas_statlat`.`searchs` AS `Search` WHERE `Search`.`id` = 1932110
20SELECT COUNT(*) AS `count` FROM `saas_statlat`.`searchs` AS `Search` WHERE `Search`.`id` = 1932110
21UPDATE `saas_statlat`.`searchs` SET `id` = 1932, `state` = 1, `target_id` = 1561, `type` = 'Statistic', `rate_total` = 0, `views` = 469, `name` = 'Credit card ownership, America', `description` = '<p>The percentage of respondents who report having a credit card.</p>', `font_age` = '2017', `language_id` = 2, `public` = 0, `countries` = 'Argentina,Bolivia,Brasil,Canadá,Chile,Colombia,Costa Rica,Ecuador,El Salvador,Estados Unidos,Guatemala,Haití,Honduras,México,Nicaragua,Panamá,Paraguay,Perú,República Dominicana,Uruguay,Venezuela', `countries_eng` = 'Argentina,Bolivia,Brazil,Canada,Chile,Colombia,Costa Rica,Ecuador,El Salvador,United States,Guatemala,Haiti,Honduras,Mexico,Nicaragua,Panama,Paraguay,Peru,Dominican Republic,Uruguay,Venezuela', `tags` = 'Card,Credit Card', `sectors_eng` = 'Finance', `sectors` = 'Finanzas', `downloads` = 0, `created` = '2018-10-10 09:57:28', `modified` = '2018-10-10 09:57:28', `subsectors` = 'Finanzas.', `subsectors_eng` = 'Finance' WHERE `saas_statlat`.`searchs`.`id` = '1932'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` = 38 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` = 13 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` = 38 AND `InfographicsSector`.`infographic_id` = `Infographic`.`id`) 000
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` = 38 AND `MapsSector`.`map_id` = `Map`.`id`) 35351
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` = 38 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` = 38 AND `StatisticsSector`.`statistic_id` = `Statistic`.`id`) 4224227
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` = 13 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` = 38 AND `InfographicsSector`.`infographic_id` = `Infographic`.`id`) 000
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` = 38 AND `MapsSector`.`map_id` = `Map`.`id`) 35351
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` = 38 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` = 38 AND `StatisticsSector`.`statistic_id` = `Statistic`.`id`) 4224227
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 `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
38SELECT `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