icon-closeicon-commentsKurir_icon_fonts_template-38Kurir_icon_fonts_template-37icon-downicon-galleryicon-homeicon-nexticon-previcon-reacticon-searchicon-soc-fbicon-soc-gplusicon-soc-insicon-soc-mailicon-soc-rssicon-soc-twittericon-soc-vibericon-soc-wupicon-soc-ytKurir_icon_fonts_template-34Kurir_icon_fonts_template-33icon-totopicon_reactsoc-viber

Najnovije vesti

Vremenska prognoza

Šabac

19°C
  • 1016 hPa
    Pritisak
  • 43%
    Vlaga
  • 2 m/sJ
    Vetar
  • Utorak

    18°C
    8°C

    Pritisak 1017 hPa
    Vetar 4 m/s SI
  • Sreda

    15°C
    8°C

    Pritisak 1013 hPa
    Vetar 2 m/s SI
  • Cetvrtak

    14°C
    7°C

    Pritisak 1020 hPa
    Vetar 7 m/s SI

Warning: Cannot execute SQL query. in /nfs/kurir-dev/www/core/database.php on line 120


Unknown column 'N0122' in 'where clause'

SQL:

SELECT country.alias,country.region_code,country.local_name,city.local_name AS name,city.alias as city_alias,observation.*,forecast.temp_max,forecast.temp_min
FROM weather_country as country
INNER JOIN weather_city as city ON country.country_id = city.country_id
LEFT JOIN weather_forecast as forecast ON city.city_id = forecast.city_id
INNER JOIN weather_observation as observation ON city.city_id = observation.city_id
WHERE observation.date = ( SELECT MAX(date) FROM weather_observation)
AND forecast.date = observation.date AND city.country_id = 10 AND city.city_id NOT IN (N0122)
GROUP BY city.name
ORDER BY city.name;