Untitled query #32687

use lvwiki_p;
select page_namespace, page_title, rc_timestamp, rc_user_text, rc_title, rc_this_oldid, rc_params
from recentchanges
join page on rc_cur_id=page_id
where rc_type=6 and page_namespace=0 and rc_params like '%"added";b:0%'
	and 
order by rc_timestamp desc
limit 500;

SQL

#use lvwiki_p;
#select distinct user_name from user_groups join user on user_id=ug_user
#where user_name="Wert"
#join user_groups on user_id=ug_user

#limit 500;



use lvwiki_p;
select page_namespace, page_title, rc_timestamp, rc_user_text, rc_title, rc_this_oldid, rc_params
from recentchanges
join page on rc_cur_id=page_id
where rc_type=6 and page_namespace=0 and rc_params like '%"added";b:0%'
	and rc_user_text not in (select distinct user_name from user_groups join user on user_id=ug_user)
order by rc_timestamp desc
limit 500;

SQL

Checking query status...