Commerce  Commerce

Traditional trade can be described as the exchange or purchase and sale of goods and services. It can be split in two ways: the wholesaler and the retailer. The last one is the one that most brands like the most, since it is the main bridge that communicates them directly to the final consumer.

The retail market, stands out for selling a variety of products to a large number of buyers. Among the main references in this sector are the well-known catalog sales (beauty and health products), franchises (restaurant chains) and shopping centers. The last ones are made up of large surface areas that offer all kinds of goods, starting with the basic products that make up the family shopping basket, going through clothes and ending with electronic devices. Supermarkets are recognized by the industry and consumers, as the main establishment of distribution of retail products.

Local stores are commercial establishments that are taking a large share in the Retail market. Their strategy is to offer low-cost products and private label brands which makes them highly attractive to consumers who are migrating from chain stores to these constantly growing models.

However, if we are taking about expanding and growing, e-commerce is the main actor since purchases and payments on the Internet are booming. Day after day digital consumers are increasing because they see many advantages such as the agility to buy from their Smartphones and receive the product in their homes. Companies, which are aggressively venturing into e-commerce also see the advantages in this type of market which seems to be more efficient than the traditional one. As an example, the increase in the supply of mobile devices apps and the growing traffic on the internet or the e-commerce giant Amazon who in September 2017 received a total of 183 million visitors on its website.

(default) 27 queries took 22 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` = 'adg7vdso3vfrdttaqqjsf57qi2' 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 `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
6SELECT `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
7SELECT `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
8SELECT `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
9SELECT `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
10SELECT `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
11SELECT `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
12SELECT `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`) 001
13SELECT `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
14SELECT `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
15SELECT `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
16SELECT `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
17SELECT `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
18SELECT `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
19SELECT `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
20SELECT `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
21SELECT `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
22SELECT `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
23SELECT `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
24SELECT `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
25SELECT `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
26SELECT `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
27SELECT `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