[DELETE FROM kasseler_sessions WHERE time < '1268245649']

[SELECT s.sid, s.uname, s.is_admin, s.ip, s.time, s.module, s.url, s.user_agent, s.country, u.uid, u.user_id, u.user_name, u.user_group, g.id, g.title, g.color FROM kasseler_sessions AS s LEFT JOIN kasseler_users AS u ON(s.uname=u.user_name) LEFT JOIN kasseler_groups AS g ON(u.user_group=g.id)]

[SELECT n.id, n.news_id, n.title, n.begin, n.author, n.date, n.view, n.comment, n.cid, n.status, n.language, n.show_group, n.rating, n.voted, n.tags, u.uid, u.user_id, u.user_name
            FROM kasseler_news AS n LEFT JOIN kasseler_users AS u ON (n.author = u.user_name)
            WHERE n.status='1' AND (n.language='russian' OR n.language='') AND UNIX_TIMESTAMP(n.date) <= UNIX_TIMESTAMP()
            ORDER BY n.date DESC LIMIT 0, 3]

[SELECT t.topic_id, t.topic_title, t.topic_poster_name, t.topic_views, t.topic_replies, p.poster_name 
    FROM kasseler_forum_topics AS t LEFT JOIN kasseler_forum_posts AS p ON (p.post_id=t.topic_last_post_id) 
    ORDER BY p.post_id DESC 
    LIMIT 10]

[SELECT id, files_id, title, hits FROM kasseler_files WHERE status='1' ORDER BY hits DESC LIMIT 10]

[SELECT DATE_FORMAT(date, '%d') FROM kasseler_calendar WHERE DATE_FORMAT(date, '%m')='03' AND DATE_FORMAT(date, '%Y')='2010' AND status='1']

[SELECT DATE_FORMAT(u.user_birthday, '%Y'), DATE_FORMAT(u.user_birthday, '%m'), DATE_FORMAT(u.user_birthday, '%d') AS day, u.uid, u.user_id, u.user_name, u.user_group, g.id, g.title, g.color FROM kasseler_users AS u LEFT JOIN kasseler_groups AS g ON(u.user_group=g.id) WHERE user_birthday <> '0000-00-00' AND DATE_FORMAT(user_birthday, '%m')='03' ORDER BY day]

[SELECT u.uid, u.user_id, c.cid, c.modul, c.date, c.name, c.comment, c.parentid,
        n.news_id, f.files_id, p.pages_id, m.media_id,
        n.title AS news_title, f.title AS files_title, p.title AS pages_title,
        m.title AS media_title
    FROM kasseler_comment AS c
    LEFT JOIN kasseler_users AS u ON (c.name=u.user_name) 
    LEFT JOIN kasseler_news  AS n ON (c.modul='news'  AND c.parentid=n.id) 
    LEFT JOIN kasseler_files AS f ON (c.modul='files' AND c.parentid=f.id) 
    LEFT JOIN kasseler_pages AS p ON (c.modul='pages' AND c.parentid=p.id) 
    LEFT JOIN kasseler_media AS m ON (c.modul='media' AND c.parentid=m.id) 
    ORDER BY c.date DESC 
    LIMIT 5]

[SELECT name, country, visit FROM kasseler_robot WHERE name<>'' ORDER BY visit DESC  LIMIT 10]