Most valuable football clubs

  • Tags: FC Barcelona Manchester City Real Madrid Chelsea FC
  • Economic sectors Sports
  • Year: 2018

The team with the highest rankings at the end of each year is Spain's FC Barcelona, followed by Manchester City and Real Madrid, the latter proclaimed the world's best club in 2017.

(default) 51 queries took 47 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` = 'k7cju15nmg5p492d0uh62ajtv0' 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` = 1303 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` = (1303)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` = 1303 AND `StatisticsCountry`.`country_id` = `Country`.`id`) 002
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` = 1303 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` = 1303 AND `StatisticsTag`.`tag_id` = `Tag`.`id`) 443
10BEGIN000
11SELECT COUNT(*) AS `count` FROM `saas_statlat`.`statistics` AS `Statistic` WHERE `Statistic`.`id` = 1303110
12SELECT COUNT(*) AS `count` FROM `saas_statlat`.`statistics` AS `Statistic` WHERE `Statistic`.`id` = 1303110
13SELECT COUNT(*) AS `count` FROM `saas_statlat`.`statistics` AS `Statistic` WHERE `Statistic`.`id` = 1303110
14UPDATE `saas_statlat`.`statistics` SET `id` = 1303, `name` = 'Most valuable football clubs', `description` = '<p>The team with the highest rankings at the end of each year is Spain\'s FC Barcelona, followed by Manchester City and Real Madrid, the latter proclaimed the world\'s best club in 2017.</p>', `state` = 1, `created` = '2018-07-25 21:21:56', `modified` = '2018-07-25 16:21:56', `font_name` = 'Transfer Markt', `sector_id` = NULL, `font_url` = 'https://www.transfermarkt.com/spieler-statistik/wertvollstemannschaften/marktwertetop', `font_age` = '2018', `public` = 1, `labels` = '', `data` = '', `type` = 2, `zoho_url` = 'https://reports.zoho.com/open-view/1582398000000899835', `zoho_url_eng` = 'https://reports.zoho.com/open-view/1582398000000901134', `db_zoho` = 'ColombiaExcel', `report_zoho` = 'ColombiaExcel', `export_data` = '', `country_id` = NULL, `views` = 490, `downloads` = 0, `target_id` = 1302, `language_id` = 2, `destacado` = 1 WHERE `saas_statlat`.`statistics`.`id` = '1303'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` = 1303 AND `type` = 'Statistic' LIMIT 1110
17BEGIN000
18SELECT COUNT(*) AS `count` FROM `saas_statlat`.`searchs` AS `Search` WHERE `Search`.`id` = 1626110
19SELECT COUNT(*) AS `count` FROM `saas_statlat`.`searchs` AS `Search` WHERE `Search`.`id` = 1626110
20SELECT COUNT(*) AS `count` FROM `saas_statlat`.`searchs` AS `Search` WHERE `Search`.`id` = 1626110
21UPDATE `saas_statlat`.`searchs` SET `id` = 1626, `state` = 1, `target_id` = 1303, `type` = 'Statistic', `rate_total` = 0, `views` = 499, `name` = 'Most valuable football clubs', `description` = '<p>The team with the highest rankings at the end of each year is Spain\'s FC Barcelona, followed by Manchester City and Real Madrid, the latter proclaimed the world\'s best club in 2017.</p>', `font_age` = '2018', `language_id` = 2, `public` = 1, `countries` = '', `countries_eng` = '', `tags` = 'FC Barcelona,Manchester City,Real Madrid,Chelsea FC', `sectors_eng` = ' Commerce ', `sectors` = 'Comercio y establecimientos ', `downloads` = 0, `created` = '2018-06-09 09:59:04', `modified` = '2018-09-08 10:02:52', `subsectors` = 'Deporte', `subsectors_eng` = 'Sports' WHERE `saas_statlat`.`searchs`.`id` = '1626'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` = 28 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` = 8 AND `Sector`.`state` = 1661
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` IN (27, 28, 29, 30, 31, 32) AND `InfographicsSector`.`infographic_id` = `Infographic`.`id`) 31311
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` IN (27, 28, 29, 30, 31, 32) AND `MapsSector`.`map_id` = `Map`.`id`) 18181
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` IN (27, 28, 29, 30, 31, 32) 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` IN (27, 28, 29, 30, 31, 32) AND `StatisticsSector`.`statistic_id` = `Statistic`.`id`) 2782785
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` = 8 AND `Sector`.`state` = 1661
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` IN (27, 28, 29, 30, 31, 32) AND `InfographicsSector`.`infographic_id` = `Infographic`.`id`) 31311
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` IN (27, 28, 29, 30, 31, 32) AND `MapsSector`.`map_id` = `Map`.`id`) 18181
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` IN (27, 28, 29, 30, 31, 32) 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` IN (27, 28, 29, 30, 31, 32) AND `StatisticsSector`.`statistic_id` = `Statistic`.`id`) 2782785
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
39SELECT `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` = 1302 LIMIT 1111
40SELECT `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` = (1302)115
41SELECT `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` = 1302 AND `StatisticsCountry`.`country_id` = `Country`.`id`) 002
42SELECT `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` = 1302 AND `StatisticsSector`.`sector_id` = `Sector`.`id`) 112
43SELECT `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` = 1302 AND `StatisticsTag`.`tag_id` = `Tag`.`id`) 443
44SELECT `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`, `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 `Sector` LEFT JOIN `saas_statlat`.`sectors` AS `Sub_Sector` ON (`Sector`.`sector_id` = `Sub_Sector`.`id`) WHERE `Sector`.`id` = 8 LIMIT 1111
45SELECT `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` = (8)661
46SELECT `Expedient`.`id`, `Expedient`.`name`, `Expedient`.`description`, `Expedient`.`state`, `Expedient`.`file`, `Expedient`.`font_name`, `Expedient`.`created`, `Expedient`.`modified`, `Expedient`.`font_url`, `Expedient`.`font_age`, `Expedient`.`public`, `Expedient`.`views`, `Expedient`.`downloads`, `Expedient`.`language_id`, `Expedient`.`target_id`, `ExpedientsSector`.`id`, `ExpedientsSector`.`sector_id`, `ExpedientsSector`.`expedient_id` FROM `saas_statlat`.`expedients` AS `Expedient` JOIN `saas_statlat`.`expedients_sectors` AS `ExpedientsSector` ON (`ExpedientsSector`.`sector_id` = 8 AND `ExpedientsSector`.`expedient_id` = `Expedient`.`id`) 000
47SELECT `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` = 8 AND `InfographicsSector`.`infographic_id` = `Infographic`.`id`) 000
48SELECT `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` = 8 AND `MapsSector`.`map_id` = `Map`.`id`) 000
49SELECT `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` = 8 AND `MotiongraphicsSector`.`motiongraphic_id` = `Motiongraphic`.`id`) 000
50SELECT `Report`.`id`, `Report`.`name`, `Report`.`description`, `Report`.`file_url`, `Report`.`font_name`, `Report`.`state`, `Report`.`created`, `Report`.`modified`, `Report`.`font_url`, `Report`.`font_age`, `Report`.`views`, `Report`.`public`, `Report`.`downloads`, `Report`.`target_id`, `Report`.`language_id`, `ReportsSector`.`id`, `ReportsSector`.`report_id`, `ReportsSector`.`sector_id` FROM `saas_statlat`.`reports` AS `Report` JOIN `saas_statlat`.`reports_sectors` AS `ReportsSector` ON (`ReportsSector`.`sector_id` = 8 AND `ReportsSector`.`report_id` = `Report`.`id`) 000
51SELECT `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` = 8 AND `StatisticsSector`.`statistic_id` = `Statistic`.`id`) 000

Loading