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-02-01' OR a.[DateFrom] IS NULL) AND (a.[DateTo] >= '2015-02-01' OR a.[DateTO] IS NULL) AND a.Status = 1 AND ag.NewsGroupsID = 16 AND a.[Date] >= '2015-02-01' ORDER BY a.Priority DESC, Date
 
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-02-01' OR a.[DateFrom] IS NULL) AND (a.[DateTo] >= '2015-02-01' OR a.[DateTO] IS NULL) AND a.Status = 1 AND ag.NewsGroupsID = 16 AND a.[Date] >= '2015-02-01' 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-02-01' OR a.[DateFrom] IS NULL) AND (a.[DateTo] >= '2015-02-01' OR a.[DateTO] IS NULL) AND a.Status = 1 AND a.[Date] >= '2015-02-01' 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-02-01' OR a.[DateFrom] IS NULL) AND (a.[DateTo] >= '2015-02-01' OR a.[DateTO] IS NULL) AND a.Status = 1 AND a.[Date] < '2015-02-01' 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
Brezžično omrežje

Odpiralni čas

Poletni delovni čas
Mestna knjižnica Velenje
Mestna knjižnica Šoštanj
Knjižnica Šmartno ob Paki
Izdelava spletnih strani: AV studio