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-09-04' OR a.[DateFrom] IS NULL) AND (a.[DateTo] >= '2015-09-04' OR a.[DateTO] IS NULL) AND a.Status = 1 AND ag.NewsGroupsID = 16 AND a.[Date] >= '2015-09-04' ORDER BY a.Priority DESC, Date

Ne zamudite

Petek, 4.9.2015

Bralka meseca

Od 4. 9. 2015 do 30. 9. 2015, steklena dvojčka Mestne knjižnice Velenje

Bralka meseca septembra bo letošnja Pikina ambasadorka, gospa Katarina Čas. V vitrinah Steklenih dvojčkov bo razstavljen izbor njenega najljubšega gradiva. Razstavo pripravlja Stanka Ledinek.

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-09-04' OR a.[DateFrom] IS NULL) AND (a.[DateTo] >= '2015-09-04' OR a.[DateTO] IS NULL) AND a.Status = 1 AND ag.NewsGroupsID = 16 AND a.[Date] >= '2015-09-04' 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-09-04' OR a.[DateFrom] IS NULL) AND (a.[DateTo] >= '2015-09-04' OR a.[DateTO] IS NULL) AND a.Status = 1 AND a.[Date] >= '2015-09-04' 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-09-04' OR a.[DateFrom] IS NULL) AND (a.[DateTo] >= '2015-09-04' OR a.[DateTO] IS NULL) AND a.Status = 1 AND a.[Date] < '2015-09-04' 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