[19.04.2011] UPOZORNĚNÍ: V pátek 22. 4. 2011 bude knihovna otevřena pouze do 16:00. Děkujeme za pochopení.
[10.03.2011] NOVINKA v knihovně - Přehled výzkumů 51 (650,- Kč v ČR, 35,- EUR pro zahraničí)
[29.11.2010] NOVINKA v knihovně - DVD Čas lovců (150,- Kč) a DVD Velká Morava (150,- Kč)
» SELECT articles.*, users.name, users.surname, users.login, users.email, cats.link AS catlink, artpages.pagetext AS pagetext FROM arub_articles AS articles LEFT JOIN arub_articles_categories AS cats ON cats.catid = articles.catid LEFT JOIN arub_users AS users ON users.userid = articles.userid LEFT JOIN arub_articles_pages AS artpages ON artpages.articleid = articles.articleid WHERE articles.status = 'live' AND articles.specialc = 1 AND articles.flag < 100 ORDER BY articles.livefrom DESC LIMIT 0, 19
» SELECT articles.*, users.name, users.surname, users.login, users.email, cats.link AS catlink, artpages.pagetext AS pagetext FROM arub_articles AS articles LEFT JOIN arub_articles_categories AS cats ON cats.catid = articles.catid LEFT JOIN arub_users AS users ON users.userid = articles.userid LEFT JOIN arub_articles_pages AS artpages ON artpages.articleid = articles.articleid WHERE articles.status = 'live' AND articles.specialc = 2 AND articles.flag < 100 ORDER BY articles.livefrom DESC LIMIT 0, 19
» SELECT articles.*, users.name, users.surname, users.login, users.email, cats.link AS catlink, artpages.pagetext AS pagetext FROM arub_articles AS articles LEFT JOIN arub_articles_categories AS cats ON cats.catid = articles.catid LEFT JOIN arub_users AS users ON users.userid = articles.userid LEFT JOIN arub_articles_pages AS artpages ON artpages.articleid = articles.articleid WHERE articles.catid = '57' AND articles.status = 'live' AND articles.flag < 100 ORDER BY articles.livefrom DESC LIMIT 0, 3
» SELECT articles.*, users.name, users.surname, users.login, users.email, cats.link AS catlink, artpages.pagetext AS pagetext FROM arub_articles AS articles LEFT JOIN arub_articles_categories AS cats ON cats.catid = articles.catid LEFT JOIN arub_users AS users ON users.userid = articles.userid LEFT JOIN arub_articles_pages AS artpages ON artpages.articleid = articles.articleid WHERE articles.catid = '58' AND articles.status = 'live' AND articles.flag < 100 ORDER BY articles.livefrom DESC LIMIT 0, 3
» SELECT articles.*, users.name, users.surname, users.login, users.email, cats.link AS catlink, artpages.pagetext AS pagetext FROM arub_articles AS articles LEFT JOIN arub_articles_categories AS cats ON cats.catid = articles.catid LEFT JOIN arub_users AS users ON users.userid = articles.userid LEFT JOIN arub_articles_pages AS artpages ON artpages.articleid = articles.articleid WHERE articles.catid = '58' AND articles.status = 'live' AND articles.specialc = 0 AND articles.flag < 100 ORDER BY articles.livefrom DESC LIMIT 1, 10
» SELECT articles.*, users.name, users.surname, users.login, users.email, cats.link AS catlink, artpages.pagetext AS pagetext FROM arub_articles AS articles LEFT JOIN arub_articles_categories AS cats ON cats.catid = articles.catid LEFT JOIN arub_users AS users ON users.userid = articles.userid LEFT JOIN arub_articles_pages AS artpages ON artpages.articleid = articles.articleid WHERE articles.catid != '51' AND articles.status = 'live' AND articles.specialc = 0 AND articles.flag < 100 ORDER BY articles.hits DESC LIMIT 1, 5
VDesign 2008 | Powered by PUBLIC08 EUROPEMC 2008
