Обновления статусов

Пользователь: last_visit: 1674804558 / Сегодня, 11:29

Пользователь: uagent_key: __NONE__

Пользователь: uagent_type:

Пользователь: uagent_version: 0

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','report_cache','report_plugins','ranks','reputation_levels','moderators','mdt_messages','mdt_messages_forums','nexus_ads','support_departments' )

DELETE FROM sessions WHERE ip_address='18.232.31.206'

SELECT * FROM skin_cache WHERE cache_set_id=9 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_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_approved=1 OR s.status_member_id=0) ORDER BY s.status_date desc LIMIT 0,15

SELECT m.*, m.member_id as my_member_id,p.*,pp.*,g.* FROM members m LEFT JOIN pfields_content p ON ( p.member_id=m.member_id ) LEFT JOIN profile_portal pp ON ( pp.pp_member_id=m.member_id ) LEFT JOIN groups g ON ( g.g_id=m.member_group_id ) WHERE m.member_id IN (1)