SELECT * FROM pre_common_syscache WHERE `cname` IN('announcements','onlinelist','forumlinks','heats','historyposts','onlinerecord','userstats','diytemplatenameforum','plugin','pluginlanguage_system','setting','style_default','cronnextrun');
SELECT * FROM pre_common_syscache WHERE `cname` IN('usergroup_7');
SELECT * FROM pre_common_session WHERE `sid`='Jrlckq';
SELECT ff.*, f.* FROM pre_forum_forum f LEFT JOIN pre_forum_forumfield ff ON ff.fid=f.fid WHERE f.fid=42;
SELECT * FROM pre_common_syscache WHERE `cname` IN('grids');
SELECT ff.*, f.* FROM pre_forum_forum f LEFT JOIN pre_forum_forumfield ff USING (fid) WHERE f.`fid`='42' ;
SELECT ff.*, f.* FROM pre_forum_forum f LEFT JOIN pre_forum_forumfield ff USING (fid) WHERE f.`fup`='42' AND f.`status`='1' AND f.`type`='forum' ORDER BY f.displayorder ;
SELECT fid, fup, name, threads, posts, todayposts, domain FROM pre_forum_forum WHERE status='1' AND fup IN ('44','60') AND type='sub' ORDER BY displayorder;
