Chemical products and raw materials  Chemical products and raw materials

Chemical products are very common substances that are currently used in the production of basic goods such as toothpaste or more specialized products such as fungicides in the agricultural sector. They cover a very wide market, so it is not surprising that the total amount of chemical shipments worldwide is worth approximately 5,000 million dollars.

The food industry, automotive, construction, oil, among others, depend largely on the chemical sector, because these substances are essential for the transformation of their products. A clear example is agricultural chemistry that allows, through the use of insecticides, herbicides, fungicides and fertilizers, a more efficient development of crops and therefore a higher quality of them. This leads to the chemical industry to be very strong worldwide. For example, Bayer that is a German company that ventures into the chemical-pharmaceutical market and whose profits were around 4,500 million euros in 2017. In terms of employment, the five main chemical companies of the planet employ around 367 thousand people, thus influencing the economy of many families and many countries.

Organic chemistry is also very influential in the global economy, since it is based on compounds derived from natural resources such as oil, gas and coal. And it is that raw materials, especially minerals and precious stones, stimulate world finances not only for their energy contribution but also for their capacity for transformation. Petrochemical derivatives such as plastic, dyes, detergents, coatings, among others, which have a daily use both in homes and companies, are a small sample of the importance of this sector in the world’s economy.

(default) 27 queries took 13 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` = 'n069jtojvslqtla30k9vg32pb0' 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` = 18 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` = (18)111
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` = 18 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` = 18 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` = 18 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` = 18 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` = 18 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` = 18 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` = 18 AND `Sector`.`state` = 1111
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` = 61 AND `InfographicsSector`.`infographic_id` = `Infographic`.`id`) 000
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` = 61 AND `MapsSector`.`map_id` = `Map`.`id`) 12121
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` = 61 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` = 61 AND `StatisticsSector`.`statistic_id` = `Statistic`.`id`) 85852
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` = 18 AND `Sector`.`state` = 1111
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` = 61 AND `InfographicsSector`.`infographic_id` = `Infographic`.`id`) 000
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` = 61 AND `MapsSector`.`map_id` = `Map`.`id`) 12121
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` = 61 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` = 61 AND `StatisticsSector`.`statistic_id` = `Statistic`.`id`) 85852
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