Zasílání aktualit

» 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