[30.06.2010] Ve dnech 30.6.-9.7.2010 bude knihovna z technických důvodů zavřená.
[31.05.2010] Výzva k podání nabídek - Skenování archivních materiálů ARÚB. Více informací zde.
[26.05.2010] Ve čtvrtek 17. června bude knihovna mimořádně otevřena v době 8,00-12,00 13,00-18,00. V pátek 18. června bude knihovna uzavřena. Děkujeme za pochopení.
» 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