SELECT * FROM cache_store WHERE cs_key IN ( 'systemvars','login_methods','vnums','app_cache','navigation_tabs','module_cache','hooks','useragents','useragentgroups','skinsets','outputformats','skin_remap','group_cache','settings','lang_data','banfilters','stats','badwords','bbcode','mediatag','profilefields','rss_output_cache','rss_export','meta_tags','ipseo_acronyms','report_cache','report_plugins','ranks','reputation_levels','moderators' )

DELETE FROM sessions WHERE ip_address='54.224.172.145'

SELECT * FROM skin_cache WHERE cache_set_id=4 AND cache_type IN ('css', 'replacements')

SELECT count(*) as cnt FROM member_status_updates s LEFT JOIN members m ON ( m.member_id=s.status_author_id )
LEFT JOIN profile_portal pp ON ( pp.pp_member_id=m.member_id ) WHERE s.status_member_id=299 OR s.status_author_id=299 AND s.status_approved=1 AND (s.status_approved=1 OR s.status_member_id=0)

SELECT s.*,m.*,pp.* FROM member_status_updates s LEFT JOIN members m ON ( m.member_id=s.status_author_id )
LEFT JOIN profile_portal pp ON ( pp.pp_member_id=m.member_id ) WHERE s.status_member_id=299 OR s.status_author_id=299 AND s.status_approved=1 AND (s.status_approved=1 OR s.status_member_id=0) ORDER BY s.status_date desc LIMIT 0,15