ieroču ip adrese

vēl vajag - kopējais labojums pa lapām + salīdzinājums ar pašreizējo


use lvwiki_p;
select rc_this_oldid, rc_patrolled, rc_timestamp, rc_user_text, rc_namespace, rc_title, rc_cur_id, rc_last_oldid, rc_source
from recentchanges
where rc_user=0# and rc_namespace in (0,14,10)
	and rc_user_text like "2408:8214:1C00:%"
    and rc_title in (select page_title from page where page_is_redirect=0 and page_namespace=rc_namespace)



use lvwiki_p;
select *#rc_this_oldid, rc_patrolled, rc_timestamp, rc_user_text, rc_namespace, rc_title, rc_cur_id, rc_last_oldid, rc_source
from recentchanges
where #rc_user=0# and rc_namespace in (0,14,10)
	#and rc_user_text like "2408:8214:1C00:%"
   rc_title="10,5_cm_FlaK_38/39"
#https://lv.wikipedia.org/w/index.php?title=10,5_cm_FlaK_38/39&diff=3027107&oldid=2632790
diff - rc_this_oldid jaunākajam labojumam
oldid = rc_last_oldid vecākajam ip adreses labojumam

SQL

use lvwiki_p;
select rc_this_oldid, rc_last_oldid, rc_title, rc_namespace#rc_this_oldid, rc_patrolled, rc_timestamp, rc_user_text, rc_namespace, rc_title, rc_cur_id, rc_last_oldid, rc_source
#["rc_id", "rc_timestamp", "rc_user", "rc_user_text", "rc_actor", "rc_namespace", "rc_title", "rc_comment_id", "rc_comment",
#"rc_minor", "rc_bot", "rc_new", "rc_cur_id", "rc_this_oldid", "rc_last_oldid", "rc_type", "rc_source", "rc_patrolled", "rc_ip",
#"rc_old_len", "rc_new_len", "rc_deleted", "rc_logid", "rc_log_type", "rc_log_action", "rc_params"]
from recentchanges rc1
where exists (select * from recentchanges rc2
              	where rc2.rc_cur_id=rc1.rc_cur_id and rc2.rc_user=0 and rc2.rc_namespace in (0,14,10)
              and rc2.rc_user_text like "2408:8214:1C00:%")
      and rc1.rc_type in (0,1)

SQL

Checking query status...