Geeklog Forums

$sql = "SELECT s.sid, t.tid, s.title AS title, s.date, s.group_id, s.owner_id, s.perm_owner, s.perm_group, s.perm_members, s.perm_anon, t.topic, s.introtext ,s.bodytext, '0' as cid
                FROM {$_TABLES['stories']} AS s, {$_TABLES['topic_assignments']} AS a, {$_TABLES['topics']} AS t
                WHERE a.type = 'article'
                AND s.title <> ''
                AND (s.sid = a.id)
                AND (s.draft_flag =0)
                AND (s.date <=CURRENT_TIMESTAMP)
                AND (s.featured =0)
                AND (a.tid = t.tid)
                order by date desc LIMIT {$offset} , {$numrows}
                ";

SELECT s.*, UNIX_TIMESTAMP(s.date) AS unixdate, UNIX_TIMESTAMP(s.expire) as expireunix, u.uid, u.username, u.fullname, u.photo
FROM gl_stories AS s, gl_topic_assignments AS ta, gl_users AS u, gl_topics AS t
WHERE (s.uid = u.uid) AND (ta.tid = t.tid) AND ta.type = 'article' AND ta.id = s.sid AND (date <= NOW()) AND (draft_flag = 0) AND frontpage = 1 AND ta.tdefault = 1 AND (s.perm_anon >= 2) AND (ta.tid IN ('General','Geeklog'))
GROUP BY s.sid, s.uid, s.draft_flag, s.date, s.modified, s.title, s.page_title, s.introtext, s.bodytext, s.text_version, s.hits, s.numemails, s.comments, s.comment_expire, s.trackbacks, s.related, s.featured, s.show_topic_icon, s.commentcode, s.structured_data_type, s.trackbackcode, s.statuscode, s.expire, s.postmode, s.advanced_editor_mode, s.frontpage, s.meta_description, s.meta_keywords, s.cache_time, s.owner_id, s.group_id, s.perm_owner, s.perm_group, s.perm_members, s.perm_anon, expireunix, u.uid, u.username, u.fullname, u.photo, date
ORDER BY featured DESC, date DESC LIMIT 0, 6
 

SELECT sid, title
FROM gl_stories, gl_topic_assignments ta
WHERE (date >= (date_sub(NOW(), INTERVAL 86400 SECOND))) AND (date <= NOW()) AND (draft_flag = 0) AND ta.type = 'article' AND ta.id = sid AND (perm_anon >= 2) AND (ta.tid IN ('General','Geeklog'))
GROUP BY sid, title, date
ORDER BY date DESC