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

Ne zamudite

Sobota, 30.5.2015

Vsi kupujemo, vsi prodajamo

Od 09.00 do 13.00, preddverje Mestne knjižnice Velenje

Sejem rabljenih knjig je najcenejša pot do knjige ali cd-ja.

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