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_patrolled, rc_timestamp, rc_user_text, rc_namespace, rc_title, rc_cur_id, rc_last_oldid, rc_source
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:%")

SQL

Checking query status...