| -- 直近30日の編集 (アカウント・日付別)
/* まあまあ時間がかかるのでコメントアウト
SELECT U.user_name as `user`,... |
3 years ago |
| use enwiki_p;
-- 直近30日の編集 (アカウント・日付別)
/* まあまあ時間がかかるのでコメントアウト
SELECT... |
4 years ago |
| use enwiki_p;
-- 直近30日の編集 (アカウント・日付別)
/* まあまあ時間がかかるのでコメントアウト
SELECT... |
4 years ago |
| use enwiki_p;
-- 直近30日の編集 (アカウント・日付別)
SELECT U.user_name as `user`,... |
4 years ago |
| use enwiki_p;
-- 直近30日の編集 (アカウント・日付別)
SELECT U.user_name as `user`,... |
4 years ago |
| use enwiki_p;
-- 直近30日の編集 (アカウント・日付別)
SELECT U.user_name as `user`,... |
4 years ago |
| use jawiki_p;
-- 直近30日の編集 (アカウント・日付別)
SELECT U.user_name as `user`,... |
4 years ago |
| use jawiki_p;
SELECT U.user_name as `user`, LEFT(RC.rc_timestamp, 8) as... |
4 years ago |
| use jawiki_p;
SELECT U.user_name as `user`, LEFT(RC.rc_timestamp, 8) as... |
4 years ago |
| use jawiki_p;
SELECT U.user_name as `user`, LEFT(RC.rc_timestamp, 8) as... |
4 years ago |
| use jawiki_p;
SELECT U.user_name as `user`, LEFT(RC.rc_timestamp, 8) as... |
4 years ago |
| use jawiki_p;
SELECT U.user_name as `user`, LEFT(RC.rc_timestamp, 8) as... |
4 years ago |
| use jawiki_p;
SELECT *
FROM `recentchanges` as RC, `actor` as A,... |
4 years ago |
| use jawiki_p;
SELECT *
FROM `recentchanges` as RC, `actor` as A,... |
4 years ago |
| use jawiki_p;
SELECT *
FROM `recentchanges` as RC, `actor` as A,... |
4 years ago |
| use jawiki_p;
SELECT *
FROM `recentchanges` as RC, `actor` as A,... |
4 years ago |
| use jawiki_p;
SELECT *
FROM `change_tag` as CT, `change_tag_def` as CTD,... |
4 years ago |
| use jawiki_p;
SELECT *
FROM `change_tag` as CT, `change_tag_def` as CTD,... |
4 years ago |
| use jawiki_p;
SELECT *
FROM `change_tag` as CT, `change_tag_def` as CTD,... |
4 years ago |
| use jawiki_p;
SELECT *
FROM `change_tag` as CT, `change_tag_def` as CTD,... |
4 years ago |
| use jawiki_p;
SELECT *
FROM change_tag_def;
SELECT *
FROM `change_tag` as... |
4 years ago |
| use jawiki_p;
SELECT *
FROM change_tag_def;
SELECT *
FROM `change_tag` as... |
4 years ago |
| use jawiki_p;
SELECT *
FROM change_tag_def;
SELECT COUNT(*)
FROM... |
4 years ago |
| use jawiki_p;
SELECT *
FROM change_tag_def;
SELECT U.user_name,... |
4 years ago |
| use jawiki_p;
SELECT *
FROM change_tag_def;
SELECT U.user_name,... |
4 years ago |
| use jawiki_p;
SELECT *
FROM change_tag_def;
SELECT U.user_name,... |
4 years ago |
| use jawiki_p;
SELECT *
FROM change_tag_def;
SELECT *
FROM `user` as U,... |
4 years ago |
| use jawiki_p;
SELECT *
FROM change_tag_def;
SELECT COUNT(*) as `rollbacker... |
4 years ago |
| use jawiki_p;
SELECT *
FROM change_tag;
SELECT COUNT(*) as `rollbacker in... |
4 years ago |
| use jawiki_p;
SELECT *
FROM change_tag;
SELECT COUNT(*) as `rollbacker in... |
4 years ago |
| use jawiki_p;
SELECT *
FROM change_tag;
SELECT COUNT(*) as `rollbacker in... |
4 years ago |
| use jawiki_p;
SELECT *
FROM change_tag;
SELECT COUNT(*) as `rollbacker in... |
4 years ago |
| use jawiki_p;
SELECT *
FROM change_tag;
SELECT COUNT(*) as `rollbacker in... |
4 years ago |
| use jawiki_p;
SELECT *
FROM change_tag;
SELECT COUNT(*) as `rollbacker in... |
4 years ago |
| use jawiki_p;
SELECT *
FROM change_tag;
SELECT COUNT(*) as `rollbacker in... |
4 years ago |
| use jawiki_p;
SELECT *
FROM change_tag;
SELECT COUNT(*) as `rollbacker in... |
4 years ago |
| use jawiki_p;
-- jawp
SELECT COUNT(*) as `rollbacker in jawp`
FROM `user`... |
4 years ago |
| use jawiki_p;
-- jawp
SELECT U.user_name, UG.*
FROM `user` as U,... |
4 years ago |
| use jawiki_p;
SELECT DISTINCT `ug_group` FROM `user_groups`;
SELECT... |
4 years ago |
| use jawiki_p;
SELECT DISTINCT `ug_group` FROM `user_groups`;
SELECT... |
4 years ago |
| use jawiki_p;
SELECT DISTINCT `ug_group` FROM `user_groups`;
SELECT *
FROM... |
4 years ago |
| use jawiki_p;
SELECT DISTINCT `ug_group` FROM `user_groups`;
SELECT *
FROM... |
4 years ago |
| use jawiki_p;
SELECT *
FROM `user` as U, `user_groups` as UG
WHERE 1 =... |
4 years ago |
| use jawiki_p;
SELECT *
FROM `user` as U, `user_properties` as UP
WHERE 1 =... |
4 years ago |
| use jawiki_p;
SELECT *
FROM `user` as U
WHERE 1 = 1
and U.user_id <=... |
4 years ago |
| use jawiki_p;
SELECT *
FROM `user` as U
WHERE U.user_id <= 3000; |
4 years ago |
