Media and marketing Media and marketing

Communication has always been a tool for interaction between members of society allowing mutual learning through the exchange of information and knowledge. From a simple conversation, a letter, listening to the radio, to advertisements and social networks. The last one is a new way to communicate with each other. And it is precisely the media, which have evolved the most over time.

For years, radio and television have been the most popular ways of informing and entertaining the population, but nowadays in the digital age other types of media have been positioning themselves in people's preferences. Social networks and digital platforms generate new interaction dynamics. YouTube channels, streaming entertainment companies such as Netflix and instant messaging applications such as WhatsApp not only impact the way we are informed, entertain and communicate, but also the commercial models of the industry. As an example, the music industry which has different digital applications - Spotify or Deezer – and through them it spreads and promotes artist’s work.

Marketing then appears as an ideal tool to meet the needs of the consumer and thus satisfy them. What kind of music do people listen to? What movies do they watch? What product are they interested on? In summary, marketing allows us to anticipate the needs of society and sometimes even create them. Advertising thus becomes a leading actor to stimulate consumption through different means of communication.

As a matter of fact, the United States spent $ 190,835 million on advertising during the year 2016, and the Asia-Pacific region spent about $ 176,000 million. It is evident that in the most populated regions and therefore more potential customers, advertising expending is significantly important.

(default) 27 queries took 15 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` = 'ldd7pd117mpbojqvudc4ektoq6' 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` = 1 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` = (1)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` = 1 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` = 1 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` = 1 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` = 1 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` = 1 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` = 1 AND `StatisticsSector`.`statistic_id` = `Statistic`.`id`) 000
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` = 1 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 (53, 54, 55, 56, 57, 58) AND `InfographicsSector`.`infographic_id` = `Infographic`.`id`) 12121
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 (53, 54, 55, 56, 57, 58) AND `MapsSector`.`map_id` = `Map`.`id`) 221
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 (53, 54, 55, 56, 57, 58) 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 (53, 54, 55, 56, 57, 58) AND `StatisticsSector`.`statistic_id` = `Statistic`.`id`) 1241242
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` = 1 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 (53, 54, 55, 56, 57, 58) AND `InfographicsSector`.`infographic_id` = `Infographic`.`id`) 12121
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 (53, 54, 55, 56, 57, 58) AND `MapsSector`.`map_id` = `Map`.`id`) 221
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 (53, 54, 55, 56, 57, 58) 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 (53, 54, 55, 56, 57, 58) AND `StatisticsSector`.`statistic_id` = `Statistic`.`id`) 1241242
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