Ideogram fotoaparata
_navigation/knj/title

Dobro je vedeti

SELECT TOP 1 a.ID, a.[Date], a.Title, a.XMLSource FROM NewsArticles a INNER JOIN NewsArticles_NewsGroups ag ON a.ID = ag.NewsArticlesID WHERE (a.[DateFrom] <= '2015-05-03' OR a.[DateFrom] IS NULL) AND (a.[DateTo] >= '2015-05-03' OR a.[DateTO] IS NULL) AND a.Status = 1 AND ag.NewsGroupsID = 16 AND a.[Date] >= '2015-05-03' ORDER BY a.Priority DESC, Date

Ne zamudite

Ponedeljek, 4.5.2015

Svetovna vojna v knjigah

Od 4. 5. do 15. 5. 2015, oddelek za odrasle v Mestni knjižnici Velenje

Spomin na 70. obletnico zmage nad fašizmom in nacizmom bodo v Knjižnici Velenje obudili z razstavo knjig o drugi svetovni vojni. Iz bogatega knjižničnega gradiva bodo izbrane knjige, ki pričajo in obujajo spomine na največjo morijo v zgodovini...

SELECT TOP 1 a.ID, a.[Date], a.Title, a.XMLSource FROM NewsArticles a INNER JOIN NewsArticles_NewsGroups ag ON a.ID = ag.NewsArticlesID WHERE (a.[DateFrom] <= '2015-05-03' OR a.[DateFrom] IS NULL) AND (a.[DateTo] >= '2015-05-03' OR a.[DateTO] IS NULL) AND a.Status = 1 AND ag.NewsGroupsID = 16 AND a.[Date] >= '2015-05-03' ORDER BY a.Priority DESC, Date

Za vas pripravljamo

SELECT TOP 7 a.ID, a.[Date], a.Title, a.XMLSource FROM NewsArticles a INNER JOIN NewsArticles_NewsGroups ag ON a.ID = ag.NewsArticlesID WHERE (a.[DateFrom] <= '2015-05-03' OR a.[DateFrom] IS NULL) AND (a.[DateTo] >= '2015-05-03' OR a.[DateTO] IS NULL) AND a.Status = 1 AND a.[Date] >= '2015-05-03' AND ag.NewsGroupsID = 16 ORDER BY a.Date, a.Priority DESC

 

Dogajalo se je - fotogalerija

SELECT TOP 6 a.ID, a.[Date], a.Title, a.XMLSource FROM NewsArticles a INNER JOIN NewsArticles_NewsGroups ag ON a.ID = ag.NewsArticlesID WHERE (a.[DateFrom] <= '2015-05-03' OR a.[DateFrom] IS NULL) AND (a.[DateTo] >= '2015-05-03' OR a.[DateTO] IS NULL) AND a.Status = 1 AND a.[Date] < '2015-05-03' AND ag.NewsGroupsID = 17ORDER BY a.Date DESC, a.Priority DESC

 

logotip knji&zcaron;nica velenje

Cobiss katalog

COBISS katalog     Spletni servis Moja knjižnica

E-knjige
mCOBISS
Izposoja, podaljšanje in rezervacija gradiva