SET NAMES 'utf8'
SET CHARACTER SET 'utf8'
SET character_set_connection = utf8
SET collation_connection = utf8_general_ci
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','attachtypes','multimod','moderators','announcements','report_cache','report_plugins','ranks','reputation_levels','chatting','birthdays','calendar_events','calendars','support_staff','support_departments','support_statuses','donation_goals','blog_stats','blogmods','idm_cats','idm_mods','mdt_messages','mdt_messages_forums','nexus_ads' )
DELETE FROM sessions WHERE ip_address='3.236.24.215'
SELECT f.*,p.* FROM forums f LEFT JOIN permission_index p ON ( p.perm_type='forum' AND p.app='forums' AND p.perm_type_id=f.id )
SELECT * FROM skin_cache WHERE cache_set_id=9 AND cache_type IN ('css', 'replacements')
SELECT m.*, m.member_id as my_member_id,pp.* FROM members m LEFT JOIN profile_portal pp ON ( pp.pp_member_id=m.member_id ) WHERE m.member_id IN (1)
SELECT s.id, s.member_id, s.member_name, s.seo_name, s.login_type, s.running_time, s.member_group, s.uagent_type,m.member_banned FROM sessions s LEFT JOIN members m ON ( m.member_id=s.member_id ) WHERE running_time > 1679545144
UPDATE members SET dp3_rs_hashcode='ed176fcfbd6f4c42aa1adf94f0edabb9' WHERE member_id=0
SELECT COUNT( i.i_inviter_id ) as refs, sum(i.i_user_points_taken) as sumpoints,m.members_display_name, m.member_id, m.members_seo_name, m.member_group_id FROM dp3_rs_referrals i LEFT JOIN members m ON ( i.i_inviter_id = m.member_id ) WHERE i.i_inviter_id > 0 AND i.i_status = "used" GROUP BY i.i_inviter_id ORDER BY refs DESC, m.joined ASC LIMIT 0,5
SELECT pp.pp_member_id, pp.pp_reputation_points,m.members_display_name, m.member_id, m.members_seo_name, m.member_group_id FROM profile_portal pp LEFT JOIN members m ON ( m.member_id=pp.pp_member_id ) WHERE pp_reputation_points > 0 ORDER BY pp_reputation_points DESC LIMIT 0,5
SELECT tid, title, title_seo FROM topics WHERE forum_id in(1,2,3) AND approved=1 ORDER BY start_date DESC LIMIT 0,10
SELECT * FROM nexus_ads WHERE ad_id=1
UPDATE nexus_ads SET ad_impressions=ad_impressions+1 WHERE ad_id=1
SELECT t.tid, t.title as topic_title, t.title_seo, t.start_date, t.starter_id, t.starter_name, t.moved_to, t.views, t.posts, t.topic_answered_pid,m.*,pp.* FROM topics t LEFT JOIN members m ON ( m.member_id=t.starter_id )
LEFT JOIN profile_portal pp ON ( m.member_id=pp.pp_member_id ) WHERE t.tid IN (193,192,191,190,189,145,144,131)
SHUTDOWN: INSERT INTO sessions (`id`,`member_name`,`member_id`,`member_group`,`login_type`,`running_time`,`ip_address`,`browser`,`in_error`,`current_appcomponent`,`current_module`,`current_section`,`location_1_type`,`location_1_id`,`location_2_type`,`location_2_id`,`location_3_type`,`location_3_id`,`uagent_key`,`uagent_version`,`uagent_type`,`uagent_bypass`) VALUES('1c71d4b6ca5296a695889aa7de58f626','',0,2,0,1679546044,'3.236.24.215','CCBot/2.0 (https://commoncrawl.org/faq/)',0,'forums','','','',0,'',0,'',0,'__NONE__',0,'',0)