WARNING: Extension runkit is not installed we cannot used the function runkit_constant_redefine !!!
Weather Almanac of Douar Cheninat Safi Morocco
JavaScript is turned off in your web browser. Turn it on to take full advantage of this site, then refresh the page.
DEBUG Page almanac.php: Execution Time Init WSP ...: 0 Seconds
Execution Time End Init WSP: 0.013 Seconds
Execution Time Create Page ...: 0.013 Seconds
Execution Time End Create Page: 0.013 Seconds
Execution Time InitializeComponent ...: 0.013 Seconds
Execution Time End InitializeComponent ...: 0.013 Seconds
Execution Time Load ...: 0.013 Seconds
SELECT DISTINCT c.city_code, c.latitude, c.longitude, c.format_name, c.name, c.name_en, c.population, c.elevation, lc.region_name, lc.latitude_30, lc.longitude_30, lc.population_30, lc.latitude_120, lc.longitude_120, lc.population_120, lc.is_proximity_city, c.is_geonames_data, c.parent_city_code, c.is_duplicate_url_detected, c.is_histo_rate_migrate, r.code_region, r.is_geoname_data, r.big_geoname_id, r.name_en, c.pic_json, c.pic_json_validated, c.nb_news
FROM geo_db_af.af_link_city lc
INNER JOIN geo_db_af.af_city2 c ON c.city_code=lc.city_code
INNER JOIN geo_db.region r ON r.code_country=c.country_code AND r.code_region=c.code_region
WHERE lc.ctr = 'ma'
AND lc.ctr IN ('AO','BF','BI','BJ','BW','CF','CG','CI','CM','DJ','DZ','EG','ET','GA','GH','GM','GN','GQ','GW','KE','LR','LS','LY','MA','ML','MR','MW','MZ','NA','NE','NG','RW','SD','SS','SL','SN','SO','ST','SZ','TD','TG','TN','TZ','UG','ZA','ZM','CD','ZW','MG','KM','MU','SC','ER','CV','YT','EH','SH','RE')
AND lc.region = 'safi'
AND lc.city = 'douar-cheninat'
[Execution Time: 0 Seconds]
SELECT `af_proximity_city`.`city_code`, `af_proximity_city`.`city_code_1`, `af_proximity_city`.`city_1`, `af_proximity_city`.`region_1`, `af_proximity_city`.`city_code_2`, `af_proximity_city`.`city_2`, `af_proximity_city`.`region_2`, `af_proximity_city`.`city_code_3`, `af_proximity_city`.`city_3`, `af_proximity_city`.`region_3`, `af_proximity_city`.`city_code_4`, `af_proximity_city`.`city_4`, `af_proximity_city`.`region_4`, `af_proximity_city`.`city_code_5`, `af_proximity_city`.`city_5`, `af_proximity_city`.`region_5`, `af_proximity_city`.`city_code_6`, `af_proximity_city`.`city_6`, `af_proximity_city`.`region_6`, `af_proximity_city`.`city_code_7`, `af_proximity_city`.`city_7`, `af_proximity_city`.`region_7`, `af_proximity_city`.`city_code_8`, `af_proximity_city`.`city_8`, `af_proximity_city`.`region_8`, `af_proximity_city`.`city_code_9`, `af_proximity_city`.`city_9`, `af_proximity_city`.`region_9`, `af_proximity_city`.`city_code_10`, `af_proximity_city`.`city_10`, `af_proximity_city`.`region_10`, `af_proximity_city`.`city_code_11`, `af_proximity_city`.`city_11`, `af_proximity_city`.`region_11`, `af_proximity_city`.`city_code_12`, `af_proximity_city`.`city_12`, `af_proximity_city`.`region_12`, `af_proximity_city`.`city_code_13`, `af_proximity_city`.`city_13`, `af_proximity_city`.`region_13`, `af_proximity_city`.`city_code_14`, `af_proximity_city`.`city_14`, `af_proximity_city`.`region_14`, `af_proximity_city`.`city_code_15`, `af_proximity_city`.`city_15`, `af_proximity_city`.`region_15`, `af_proximity_city`.`city_code_16`, `af_proximity_city`.`city_16`, `af_proximity_city`.`region_16`, `af_proximity_city`.`city_code_17`, `af_proximity_city`.`city_17`, `af_proximity_city`.`region_17`, `af_proximity_city`.`city_code_18`, `af_proximity_city`.`city_18`, `af_proximity_city`.`region_18`, `af_proximity_city`.`city_code_19`, `af_proximity_city`.`city_19`, `af_proximity_city`.`region_19`, `af_proximity_city`.`city_code_20`, `af_proximity_city`.`city_20`, `af_proximity_city`.`region_20`, `af_proximity_city`.`city_code_21`, `af_proximity_city`.`city_21`, `af_proximity_city`.`region_21` FROM `geo_db_af`.`af_proximity_city` WHERE city_code='1397026' [Execution Time: 0 Seconds]
SELECT city_code, name_en FROM geo_db_af.af_city2 WHERE city_code IN (1398161,1406519,1398825,1406521,1406158,1398110,1417285,1406150,1398835,1409155,1409171,1417279) [Execution Time: 0 Seconds]
SELECT `af_proximity_city`.`city_code`, `af_proximity_city`.`city_code_1`, `af_proximity_city`.`city_1`, `af_proximity_city`.`region_1`, `af_proximity_city`.`city_code_2`, `af_proximity_city`.`city_2`, `af_proximity_city`.`region_2`, `af_proximity_city`.`city_code_3`, `af_proximity_city`.`city_3`, `af_proximity_city`.`region_3`, `af_proximity_city`.`city_code_4`, `af_proximity_city`.`city_4`, `af_proximity_city`.`region_4`, `af_proximity_city`.`city_code_5`, `af_proximity_city`.`city_5`, `af_proximity_city`.`region_5`, `af_proximity_city`.`city_code_6`, `af_proximity_city`.`city_6`, `af_proximity_city`.`region_6`, `af_proximity_city`.`city_code_7`, `af_proximity_city`.`city_7`, `af_proximity_city`.`region_7`, `af_proximity_city`.`city_code_8`, `af_proximity_city`.`city_8`, `af_proximity_city`.`region_8`, `af_proximity_city`.`city_code_9`, `af_proximity_city`.`city_9`, `af_proximity_city`.`region_9`, `af_proximity_city`.`city_code_10`, `af_proximity_city`.`city_10`, `af_proximity_city`.`region_10`, `af_proximity_city`.`city_code_11`, `af_proximity_city`.`city_11`, `af_proximity_city`.`region_11`, `af_proximity_city`.`city_code_12`, `af_proximity_city`.`city_12`, `af_proximity_city`.`region_12`, `af_proximity_city`.`city_code_13`, `af_proximity_city`.`city_13`, `af_proximity_city`.`region_13`, `af_proximity_city`.`city_code_14`, `af_proximity_city`.`city_14`, `af_proximity_city`.`region_14`, `af_proximity_city`.`city_code_15`, `af_proximity_city`.`city_15`, `af_proximity_city`.`region_15`, `af_proximity_city`.`city_code_16`, `af_proximity_city`.`city_16`, `af_proximity_city`.`region_16`, `af_proximity_city`.`city_code_17`, `af_proximity_city`.`city_17`, `af_proximity_city`.`region_17`, `af_proximity_city`.`city_code_18`, `af_proximity_city`.`city_18`, `af_proximity_city`.`region_18`, `af_proximity_city`.`city_code_19`, `af_proximity_city`.`city_19`, `af_proximity_city`.`region_19`, `af_proximity_city`.`city_code_20`, `af_proximity_city`.`city_20`, `af_proximity_city`.`region_20`, `af_proximity_city`.`city_code_21`, `af_proximity_city`.`city_21`, `af_proximity_city`.`region_21` FROM `geo_db_af`.`af_proximity_city` WHERE city_code='1397026' [Execution Time: 0 Seconds]
SELECT COUNT(*) FROM `meteo_af`.`af_news` WHERE code_ville in (1397026, 1398161, 1406519, 1398825, 1406521, 1406158, 1398110, 1417285, 1406150, 1398835, 1409155, 1409171, 1417279) [Execution Time: 0 Seconds]
SELECT `af_proximity_city`.`city_code`, `af_proximity_city`.`city_code_1`, `af_proximity_city`.`city_1`, `af_proximity_city`.`region_1`, `af_proximity_city`.`city_code_2`, `af_proximity_city`.`city_2`, `af_proximity_city`.`region_2`, `af_proximity_city`.`city_code_3`, `af_proximity_city`.`city_3`, `af_proximity_city`.`region_3`, `af_proximity_city`.`city_code_4`, `af_proximity_city`.`city_4`, `af_proximity_city`.`region_4`, `af_proximity_city`.`city_code_5`, `af_proximity_city`.`city_5`, `af_proximity_city`.`region_5`, `af_proximity_city`.`city_code_6`, `af_proximity_city`.`city_6`, `af_proximity_city`.`region_6`, `af_proximity_city`.`city_code_7`, `af_proximity_city`.`city_7`, `af_proximity_city`.`region_7`, `af_proximity_city`.`city_code_8`, `af_proximity_city`.`city_8`, `af_proximity_city`.`region_8`, `af_proximity_city`.`city_code_9`, `af_proximity_city`.`city_9`, `af_proximity_city`.`region_9`, `af_proximity_city`.`city_code_10`, `af_proximity_city`.`city_10`, `af_proximity_city`.`region_10`, `af_proximity_city`.`city_code_11`, `af_proximity_city`.`city_11`, `af_proximity_city`.`region_11`, `af_proximity_city`.`city_code_12`, `af_proximity_city`.`city_12`, `af_proximity_city`.`region_12`, `af_proximity_city`.`city_code_13`, `af_proximity_city`.`city_13`, `af_proximity_city`.`region_13`, `af_proximity_city`.`city_code_14`, `af_proximity_city`.`city_14`, `af_proximity_city`.`region_14`, `af_proximity_city`.`city_code_15`, `af_proximity_city`.`city_15`, `af_proximity_city`.`region_15`, `af_proximity_city`.`city_code_16`, `af_proximity_city`.`city_16`, `af_proximity_city`.`region_16`, `af_proximity_city`.`city_code_17`, `af_proximity_city`.`city_17`, `af_proximity_city`.`region_17`, `af_proximity_city`.`city_code_18`, `af_proximity_city`.`city_18`, `af_proximity_city`.`region_18`, `af_proximity_city`.`city_code_19`, `af_proximity_city`.`city_19`, `af_proximity_city`.`region_19`, `af_proximity_city`.`city_code_20`, `af_proximity_city`.`city_20`, `af_proximity_city`.`region_20`, `af_proximity_city`.`city_code_21`, `af_proximity_city`.`city_21`, `af_proximity_city`.`region_21` FROM `geo_db_af`.`af_proximity_city` WHERE city_code='1397026' [Execution Time: 0 Seconds]
SELECT COUNT(*) FROM `meteo_af`.`af_news` WHERE code_ville in (1397026, 1398161, 1406519, 1398825, 1406521, 1406158, 1398110, 1417285, 1406150, 1398835, 1409155, 1409171, 1417279) [Execution Time: 0 Seconds]
SELECT SUM(rate) / count(*) city_rate, count(*) nb_rate FROM meteo_af.af_city_rate WHERE latitude=32.4166667 AND longitude=-9.2166667 [Execution Time: 0 Seconds]
SELECT month(X.date) month, round(max(X.max)) avg_max, round(min(X.min)) avg_min, round((avg(X.max)+avg(X.min))/2) avg
FROM (
SELECT date date, max max, min min
FROM meteo_af.af_meteo_histo
WHERE latitude=32.29939 and longitude=-9.23718
UNION
SELECT date date, max max, min min
FROM meteo_af.af_meteo_histo_old
WHERE latitude=32.29939 and longitude=-9.23718
) X
GROUP BY month(X.date)
ORDER BY month(X.date) ASC [Execution Time: 0.001 Seconds]
SELECT day(X.date) day,concat(round(avg(X.max)), '°C') avg_max, concat(round(avg(X.min)), '°C') avg_min, concat(round((avg(X.max)+avg(X.min))/2), '°C') avg, concat(max(X.max), '°C / ', min(X.min), '°C') record, concat(round(avg(X.cloud_cover)), '%') avg_cloud_cover, concat(round(avg(X.humidity)), '%') avg_humidity, concat(round(avg(X.precipitation)), ' mm') avg_precipitation, concat(round(avg(X.wind_speed)), ' Km/h') record_wind_speed FROM (
SELECT date date, max max, min min,
cloud_cover cloud_cover, humidity humidity,
precipitation precipitation, wind_speed wind_speed
FROM meteo_af.af_meteo_histo
WHERE latitude=32.29939 and longitude=-9.23718 and month(date) = 10
UNION
SELECT date date, max max, min min,
cloud_cover cloud_cover, humidity humidity,
precipitation precipitation, wind_speed wind_speed
FROM meteo_af.af_meteo_histo_old
WHERE latitude=32.29939 and longitude=-9.23718 and month(date) = 10
) X
GROUP BY day(X.date)
ORDER BY day(X.date) ASC [Execution Time: 0.001 Seconds]
SELECT `region_big_city`.`code_country`, `region_big_city`.`code_region`, `region_big_city`.`city_code_1`, `region_big_city`.`city_code_2`, `region_big_city`.`city_code_3`, `region_big_city`.`city_code_4`, `region_big_city`.`city_code_5`, `region_big_city`.`city_code_6`, `region_big_city`.`city_code_7`, `region_big_city`.`city_code_8`, `region_big_city`.`city_code_9`, `region_big_city`.`city_code_10`, `region_big_city`.`city_code_11`, `region_big_city`.`city_code_12`, `region_big_city`.`city_code_13`, `region_big_city`.`city_code_14`, `region_big_city`.`city_code_15`, `region_big_city`.`city_code_16`, `region_big_city`.`city_code_17`, `region_big_city`.`city_code_18`, `region_big_city`.`city_code_19`, `region_big_city`.`city_code_20`, `region_big_city`.`city_code_21` FROM `geo_db`.`region_big_city` WHERE code_country='ma' AND code_region='25' [Execution Time: 0 Seconds]
SELECT `nameday`.`country_code`, `nameday`.`month`, `nameday`.`day`, `nameday`.`name` FROM `meteo`.`nameday` WHERE country_code='EN' AND month=10 AND day=19 [Execution Time: 0 Seconds]
Execution Time End Load ...: 0.207 Seconds
Execution Time Variables ...: 0.208 Seconds
Execution Time End Variables: 0.208 Seconds
Execution Time Callback ...: 0.208 Seconds
Execution Time End Callback: 0.208 Seconds
Execution Time Loaded ...: 0.208 Seconds
Execution Time End Loaded: 0.208 Seconds
Execution Time Page Header ...: 0.208 Seconds
Execution Time End Page Header ...: 0.208 Seconds
Execution Time Render ...: 0.208 Seconds
Execution Time End Render: 0.215 Seconds