WARNING: Extension runkit is not installed we cannot used the function runkit_constant_redefine !!!
Pogoda kalendarzowa w Sale`imoa Samoa
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.022 Seconds
Execution Time Create Page ...: 0.022 Seconds
Execution Time End Create Page: 0.022 Seconds
Execution Time InitializeComponent ...: 0.022 Seconds
Execution Time End InitializeComponent ...: 0.022 Seconds
Execution Time Load ...: 0.022 Seconds
SELECT DISTINCT c.city_code, c.latitude, c.longitude, c.format_name, c.name, c.name_pl, 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_pl, c.pic_json, c.pic_json_validated, c.nb_news
FROM geo_db_au.au_link_city lc
INNER JOIN geo_db_au.au_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 = 'ws'
AND lc.ctr IN ('FJ','FM','PG','SB','TO','VU','AU','CK','KI','MH','NR','NU','NZ','PW','WS','PF','TV','TK','CC','MP','NF','NC','PN')
AND lc.region = 'samoa'
AND lc.city = 'sale-imoa'
[Execution Time: 0 Seconds]
SELECT `au_proximity_city`.`city_code`, `au_proximity_city`.`city_code_1`, `au_proximity_city`.`city_1`, `au_proximity_city`.`region_1`, `au_proximity_city`.`city_code_2`, `au_proximity_city`.`city_2`, `au_proximity_city`.`region_2`, `au_proximity_city`.`city_code_3`, `au_proximity_city`.`city_3`, `au_proximity_city`.`region_3`, `au_proximity_city`.`city_code_4`, `au_proximity_city`.`city_4`, `au_proximity_city`.`region_4`, `au_proximity_city`.`city_code_5`, `au_proximity_city`.`city_5`, `au_proximity_city`.`region_5`, `au_proximity_city`.`city_code_6`, `au_proximity_city`.`city_6`, `au_proximity_city`.`region_6`, `au_proximity_city`.`city_code_7`, `au_proximity_city`.`city_7`, `au_proximity_city`.`region_7`, `au_proximity_city`.`city_code_8`, `au_proximity_city`.`city_8`, `au_proximity_city`.`region_8`, `au_proximity_city`.`city_code_9`, `au_proximity_city`.`city_9`, `au_proximity_city`.`region_9`, `au_proximity_city`.`city_code_10`, `au_proximity_city`.`city_10`, `au_proximity_city`.`region_10`, `au_proximity_city`.`city_code_11`, `au_proximity_city`.`city_11`, `au_proximity_city`.`region_11`, `au_proximity_city`.`city_code_12`, `au_proximity_city`.`city_12`, `au_proximity_city`.`region_12`, `au_proximity_city`.`city_code_13`, `au_proximity_city`.`city_13`, `au_proximity_city`.`region_13`, `au_proximity_city`.`city_code_14`, `au_proximity_city`.`city_14`, `au_proximity_city`.`region_14`, `au_proximity_city`.`city_code_15`, `au_proximity_city`.`city_15`, `au_proximity_city`.`region_15`, `au_proximity_city`.`city_code_16`, `au_proximity_city`.`city_16`, `au_proximity_city`.`region_16`, `au_proximity_city`.`city_code_17`, `au_proximity_city`.`city_17`, `au_proximity_city`.`region_17`, `au_proximity_city`.`city_code_18`, `au_proximity_city`.`city_18`, `au_proximity_city`.`region_18`, `au_proximity_city`.`city_code_19`, `au_proximity_city`.`city_19`, `au_proximity_city`.`region_19`, `au_proximity_city`.`city_code_20`, `au_proximity_city`.`city_20`, `au_proximity_city`.`region_20`, `au_proximity_city`.`city_code_21`, `au_proximity_city`.`city_21`, `au_proximity_city`.`region_21` FROM `geo_db_au`.`au_proximity_city` WHERE city_code='2637210' [Execution Time: 0 Seconds]
SELECT city_code, name_pl FROM geo_db_au.au_city2 WHERE city_code IN (2637016,2637101,2637046,2637100,2637114,2637215,2637305,2637129,2637290,2637279,2637099,2637147) [Execution Time: 0 Seconds]
SELECT `au_proximity_city`.`city_code`, `au_proximity_city`.`city_code_1`, `au_proximity_city`.`city_1`, `au_proximity_city`.`region_1`, `au_proximity_city`.`city_code_2`, `au_proximity_city`.`city_2`, `au_proximity_city`.`region_2`, `au_proximity_city`.`city_code_3`, `au_proximity_city`.`city_3`, `au_proximity_city`.`region_3`, `au_proximity_city`.`city_code_4`, `au_proximity_city`.`city_4`, `au_proximity_city`.`region_4`, `au_proximity_city`.`city_code_5`, `au_proximity_city`.`city_5`, `au_proximity_city`.`region_5`, `au_proximity_city`.`city_code_6`, `au_proximity_city`.`city_6`, `au_proximity_city`.`region_6`, `au_proximity_city`.`city_code_7`, `au_proximity_city`.`city_7`, `au_proximity_city`.`region_7`, `au_proximity_city`.`city_code_8`, `au_proximity_city`.`city_8`, `au_proximity_city`.`region_8`, `au_proximity_city`.`city_code_9`, `au_proximity_city`.`city_9`, `au_proximity_city`.`region_9`, `au_proximity_city`.`city_code_10`, `au_proximity_city`.`city_10`, `au_proximity_city`.`region_10`, `au_proximity_city`.`city_code_11`, `au_proximity_city`.`city_11`, `au_proximity_city`.`region_11`, `au_proximity_city`.`city_code_12`, `au_proximity_city`.`city_12`, `au_proximity_city`.`region_12`, `au_proximity_city`.`city_code_13`, `au_proximity_city`.`city_13`, `au_proximity_city`.`region_13`, `au_proximity_city`.`city_code_14`, `au_proximity_city`.`city_14`, `au_proximity_city`.`region_14`, `au_proximity_city`.`city_code_15`, `au_proximity_city`.`city_15`, `au_proximity_city`.`region_15`, `au_proximity_city`.`city_code_16`, `au_proximity_city`.`city_16`, `au_proximity_city`.`region_16`, `au_proximity_city`.`city_code_17`, `au_proximity_city`.`city_17`, `au_proximity_city`.`region_17`, `au_proximity_city`.`city_code_18`, `au_proximity_city`.`city_18`, `au_proximity_city`.`region_18`, `au_proximity_city`.`city_code_19`, `au_proximity_city`.`city_19`, `au_proximity_city`.`region_19`, `au_proximity_city`.`city_code_20`, `au_proximity_city`.`city_20`, `au_proximity_city`.`region_20`, `au_proximity_city`.`city_code_21`, `au_proximity_city`.`city_21`, `au_proximity_city`.`region_21` FROM `geo_db_au`.`au_proximity_city` WHERE city_code='2637210' [Execution Time: 0 Seconds]
SELECT COUNT(*) FROM `meteo_au`.`au_news` WHERE code_ville in (2637210, 2637016, 2637101, 2637046, 2637100, 2637114, 2637215, 2637305, 2637129, 2637290, 2637279, 2637099, 2637147) [Execution Time: 0 Seconds]
SELECT `au_proximity_city`.`city_code`, `au_proximity_city`.`city_code_1`, `au_proximity_city`.`city_1`, `au_proximity_city`.`region_1`, `au_proximity_city`.`city_code_2`, `au_proximity_city`.`city_2`, `au_proximity_city`.`region_2`, `au_proximity_city`.`city_code_3`, `au_proximity_city`.`city_3`, `au_proximity_city`.`region_3`, `au_proximity_city`.`city_code_4`, `au_proximity_city`.`city_4`, `au_proximity_city`.`region_4`, `au_proximity_city`.`city_code_5`, `au_proximity_city`.`city_5`, `au_proximity_city`.`region_5`, `au_proximity_city`.`city_code_6`, `au_proximity_city`.`city_6`, `au_proximity_city`.`region_6`, `au_proximity_city`.`city_code_7`, `au_proximity_city`.`city_7`, `au_proximity_city`.`region_7`, `au_proximity_city`.`city_code_8`, `au_proximity_city`.`city_8`, `au_proximity_city`.`region_8`, `au_proximity_city`.`city_code_9`, `au_proximity_city`.`city_9`, `au_proximity_city`.`region_9`, `au_proximity_city`.`city_code_10`, `au_proximity_city`.`city_10`, `au_proximity_city`.`region_10`, `au_proximity_city`.`city_code_11`, `au_proximity_city`.`city_11`, `au_proximity_city`.`region_11`, `au_proximity_city`.`city_code_12`, `au_proximity_city`.`city_12`, `au_proximity_city`.`region_12`, `au_proximity_city`.`city_code_13`, `au_proximity_city`.`city_13`, `au_proximity_city`.`region_13`, `au_proximity_city`.`city_code_14`, `au_proximity_city`.`city_14`, `au_proximity_city`.`region_14`, `au_proximity_city`.`city_code_15`, `au_proximity_city`.`city_15`, `au_proximity_city`.`region_15`, `au_proximity_city`.`city_code_16`, `au_proximity_city`.`city_16`, `au_proximity_city`.`region_16`, `au_proximity_city`.`city_code_17`, `au_proximity_city`.`city_17`, `au_proximity_city`.`region_17`, `au_proximity_city`.`city_code_18`, `au_proximity_city`.`city_18`, `au_proximity_city`.`region_18`, `au_proximity_city`.`city_code_19`, `au_proximity_city`.`city_19`, `au_proximity_city`.`region_19`, `au_proximity_city`.`city_code_20`, `au_proximity_city`.`city_20`, `au_proximity_city`.`region_20`, `au_proximity_city`.`city_code_21`, `au_proximity_city`.`city_21`, `au_proximity_city`.`region_21` FROM `geo_db_au`.`au_proximity_city` WHERE city_code='2637210' [Execution Time: 0 Seconds]
SELECT COUNT(*) FROM `meteo_au`.`au_news` WHERE code_ville in (2637210, 2637016, 2637101, 2637046, 2637100, 2637114, 2637215, 2637305, 2637129, 2637290, 2637279, 2637099, 2637147) [Execution Time: 0 Seconds]
SELECT SUM(rate) / count(*) city_rate, count(*) nb_rate FROM meteo_au.au_city_rate WHERE latitude=-13.8 AND longitude=-171.8666667 [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_au.au_meteo_histo
WHERE latitude=-13.83333 and longitude=-171.76666
UNION
SELECT date date, max max, min min
FROM meteo_au.au_meteo_histo_old
WHERE latitude=-13.83333 and longitude=-171.76666
) X
GROUP BY month(X.date)
ORDER BY month(X.date) ASC [Execution Time: 0.005 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_au.au_meteo_histo
WHERE latitude=-13.83333 and longitude=-171.76666 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_au.au_meteo_histo_old
WHERE latitude=-13.83333 and longitude=-171.76666 and month(date) = 10
) X
GROUP BY day(X.date)
ORDER BY day(X.date) ASC [Execution Time: 0.002 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='ws' AND code_region='00' [Execution Time: 0.001 Seconds]
SELECT `nameday`.`country_code`, `nameday`.`month`, `nameday`.`day`, `nameday`.`name` FROM `meteo`.`nameday` WHERE country_code='PL' AND month=10 AND day=19 [Execution Time: 0.001 Seconds]
Execution Time End Load ...: 0.446 Seconds
Execution Time Variables ...: 0.446 Seconds
Execution Time End Variables: 0.446 Seconds
Execution Time Callback ...: 0.446 Seconds
Execution Time End Callback: 0.447 Seconds
Execution Time Loaded ...: 0.447 Seconds
Execution Time End Loaded: 0.447 Seconds
Execution Time Page Header ...: 0.447 Seconds
Execution Time End Page Header ...: 0.447 Seconds
Execution Time Render ...: 0.447 Seconds
Execution Time End Render: 0.46 Seconds