Ciekawe Tematy
archiwum Geodety
wiadomości
newsletter
kontakt
reklama
wyszukiwanie zaawansowane
REKLAMA
publikacje
REKLAMA
»»
Wyszukiwanie zaawansowane »
Wyszukiwanie zaawansowane
poszukiwane frazy
rozdzielane przecinkami
tylko całe wyrazy
rok
1995
1996
1997
1998
1999
2000
2001
2002
2003
2004
2005
2006
2007
2008
2009
2010
2011
2012
2013
2014
2015
2016
2017
2018
2019
2020
2021
2022
2023
wiadomości
GEODETA na geoforum.pl
internetowe archiwum GEODETY
Geowiedza
Geodezja, GNSS, GIS, Mapy, Teledetekcja, Narzędzia, Prawo, Wojsko
Out of resources when opening file '/var/tmp/MYoIb0We' (Errcode: 24)
select distinct n.id_news_pl as id , CONVERT(n.title using utf8) as title , CONVERT(n.short_text using utf8) as description ,n.date, 80000 as sort_order , CONVERT('news' using utf8) as type , CONVERT(n.link using utf8) as link from zzz_news_pl n left join `zzz_news_category` c2 on n.id_news_category=c2.id_news_category where 1=1 and date>='2010-04-14' and n.id_news_pl in (select id_news_pl from zzz_news_pl n2 where n2.id_departament='200' and n2.is_visible=1 and ( n2.is_visible=1 and n2.id_departament='200' and (n2.show_date_from<=NOW() or n2.show_date_from is null) and (n2.show_date_to>=NOW() or n2.show_date_to is null) ) ) union select distinct n.id_news_pl as id , CONVERT(n.title using utf8) as title , CONVERT(n.description_html using utf8) as description ,n.date, 70000 as sort_order , CONVERT('news' using utf8) as type , CONVERT(n.link using utf8) as link from zzz_news_pl n left join `zzz_news_category` c2 on n.id_news_category=c2.id_news_category where 1=1 and date<'2010-04-14' and n.id_news_pl in (select id_news_pl from zzz_news_pl n2 where n2.id_departament='200' and n2.is_visible=1 and ( n2.is_visible=1 and n2.id_departament='200' and (n2.show_date_from<=NOW() or n2.show_date_from is null) and (n2.show_date_to>=NOW() or n2.show_date_to is null) ) ) order by sort_order desc, date desc, title