[23.09.2009] Pozvánka na konferenci 0IS3 / Conference OIS3 - preliminary circular Více informací zde. See more.
[16.09.2009] Od 18. září do 2. října bude archiv Archeologického ústavu AV ČR Brno uzavřen z technických důvodů. Za případné komplikace se omlouváme a děkujeme za pochopení. Mgr. Olga Palečková, vedoucí archivu
» 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
