WARNING: Extension runkit is not installed we cannot used the function runkit_constant_redefine !!!
Weather Almanac of Iferiane Agadir 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.021 Seconds
Execution Time Create Page ...: 0.021 Seconds
Execution Time End Create Page: 0.021 Seconds
Execution Time InitializeComponent ...: 0.021 Seconds
Execution Time End InitializeComponent ...: 0.021 Seconds
Execution Time Load ...: 0.021 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 = 'agadir'
AND lc.city = 'iferiane'
[Execution Time: 0.001 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='1403149' [Execution Time: 0.001 Seconds]
SELECT city_code, name_en FROM geo_db_af.af_city2 WHERE city_code IN (1403230,1412048,1411369,1399994,1412336,1396325,1399497,1395444,1415442,1415441,1406278,1400095,1400094,1400027,1390921,1400769,1416304,1400893,1400702,1416306,1414662) [Execution Time: 0.001 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='1403149' [Execution Time: 0.001 Seconds]
SELECT COUNT(*) FROM `meteo_af`.`af_news` WHERE code_ville in (1403149, 1403230, 1412048, 1411369, 1399994, 1412336, 1396325, 1399497, 1395444, 1415442, 1415441, 1406278, 1400095, 1400094, 1400027, 1390921, 1400769, 1416304, 1400893, 1400702, 1416306, 1414662) [Execution Time: 0.001 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='1403149' [Execution Time: 0.001 Seconds]
SELECT COUNT(*) FROM `meteo_af`.`af_news` WHERE code_ville in (1403149, 1403230, 1412048, 1411369, 1399994, 1412336, 1396325, 1399497, 1395444, 1415442, 1415441, 1406278, 1400095, 1400094, 1400027, 1390921, 1400769, 1416304, 1400893, 1400702, 1416306, 1414662) [Execution Time: 0.001 Seconds]
SELECT SUM(rate) / count(*) city_rate, count(*) nb_rate FROM meteo_af.af_city_rate WHERE latitude=30.1333333 AND longitude=-9.6 [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=30.42018 and longitude=-9.59815
UNION
SELECT date date, max max, min min
FROM meteo_af.af_meteo_histo_old
WHERE latitude=30.42018 and longitude=-9.59815
) 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=30.42018 and longitude=-9.59815 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=30.42018 and longitude=-9.59815 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='01' [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.358 Seconds
Execution Time Variables ...: 0.358 Seconds
Execution Time End Variables: 0.358 Seconds
Execution Time Callback ...: 0.358 Seconds
Execution Time End Callback: 0.358 Seconds
Execution Time Loaded ...: 0.358 Seconds
Execution Time End Loaded: 0.358 Seconds
Execution Time Page Header ...: 0.358 Seconds
Execution Time End Page Header ...: 0.358 Seconds
Execution Time Render ...: 0.358 Seconds
Execution Time End Render: 0.365 Seconds