[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č)
[09.11.2010] Konference 2011-dne 25.-27.5. 2011 se bude konat v Mikulčicích Internationale Tagungen in Mikulčice 2011 (ITM 2011) na téma: Bewaffnung und Reiterausrüstung des 8. bis 10. Jahrhunderts in Mitteleuropa (Zur Form und Beigabensitte von Waffen und Reiterzubehör bei den mährischen Slawen und ihren Nachbarn)
» 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
