|
select * from user_newtalk
limit 500
|
6 years ago |
|
select * from user_newtalk
limit 500
|
6 years ago |
| use enwiki_p;
select * from user_newtalk
limit 500
|
6 years ago |
| use enwiki_p;
select * from user_newtalk limit 500
|
6 years ago |
| use enwiki_p;
select * from user_former_groups limit 500
|
6 years ago |
| use enwiki_p;
select * from user_former_groups
|
6 years ago |
| use enwiki_p;
select * from user_groups where ug_expiry is not null LIMIT 10 |
6 years ago |
| use enwiki_p;
select * from user_groups LIMIT 500 |
6 years ago |
| USE enwiki_p;
select distinct u.*,
(SELECT GROUP_CONCAT(up_property... |
6 years ago |
| use enwiki_p;
select * from user_properties LIMIT 500 |
6 years ago |
| USE enwiki_p;
select distinct u.*,
(SELECT GROUP_CONCAT(up_property... |
6 years ago |
| USE enwiki_p;
select distinct u.*,
(SELECT GROUP_CONCAT(up_property... |
6 years ago |
| use enwiki_p;
select * from user where user_real_name <> '' LIMIT 100 |
6 years ago |
| use enwiki_p;
select * from user where user_real_name is not null LIMIT 100 |
6 years ago |
