| #use lvwiki_p;
#select distinct user_name from user_groups join user on... |
6 years ago |
| use lvwiki_p;
select distinct user_name
from user_groups
join user on... |
6 years ago |
| use lvwiki_p;
select user_name
from user_groups
join user on... |
6 years ago |
| use lvwiki_p;
select distinct ug_group
from user_groups
#join user on... |
6 years ago |
| use lvwiki_p;
select *#distinct ug_group
from user_groups
join user on... |
6 years ago |
| use lvwiki_p;
select distinct ug_group
from user_groups
#join user_groups on... |
6 years ago |
| use lvwiki_p;
select *
from user_groups
#join user_groups on user_id=
limit 500; |
6 years ago |
| use lvwiki_p;
select *
from user_group
#join user_group on user_id=
limit 500; |
6 years ago |
| use lvwiki_p;
select *
from user
limit 500; |
6 years ago |
| use lvwiki_p;
select *
from users
limit 500; |
6 years ago |
| use lvwiki_p;
select *
from user_groups
limit 500; |
6 years ago |
| use lvwiki_p;
select *
from usergroups
limit 500; |
6 years ago |
| use lvwiki_p;
select page_namespace, page_title, rc_timestamp, rc_user_text,... |
6 years ago |
| use lvwiki_p;
select page_namespace, page_title, rc_timestamp, rc_user_text,... |
6 years ago |
| use lvwiki_p;
select page.*, rc_timestamp, rc_user_text, rc_title,... |
6 years ago |
| use lvwiki_p;
select rc_timestamp, rc_user_text, rc_title, rc_this_oldid,... |
6 years ago |
| use lvwiki_p;
select *
from recentchanges
where rc_type=6
order by... |
6 years ago |
| use lvwiki_p;
select *
from recentchanges
where rc_type=6
limit 500; |
6 years ago |
| use lvwiki_p;
select *
from recentchanges
limit 500; |
6 years ago |
