| USE plwiki_p;
SELECT ar_namespace, count(*) FROM archive_userindex USE... |
4 years ago |
| USE plwiki_p;
SELECT ar_namespace, count(*) FROM archive_userindex USE... |
4 years ago |
| USE plwiki_p;
SELECT 'archive', 7, ar_namespace, count(*) FROM... |
4 years ago |
| USE plwiki_p;
describe archive_userindex |
4 years ago |
| USE plwiki_p;
(
SELECT 'revision', 7, page_namespace, count(*) FROM... |
4 years ago |
| USE plwiki_p;
(
SELECT 'revision', 7, page_namespace, count(*) FROM... |
4 years ago |
| USE plwiki_p;
(
SELECT 'revision', 7, page_namespace, count(*) FROM... |
4 years ago |
| USE plwiki_p;
(
SELECT 'revision', 7, page_namespace, count(*) FROM... |
4 years ago |
| USE plwiki_p;
------------------
-- pre-sysop... |
4 years ago |
| USE plwiki_p;
(
SELECT 'revision', 7, page_namespace, count(*) FROM... |
4 years ago |
| USE plwiki_p;
select count(*), page_namespace
from revision_actor_temp... |
4 years ago |
| USE plwiki_p;
select count(*), page_namespace
from revision_actor_temp... |
4 years ago |
| USE plwiki_p;
select count(*) from revision_actor_temp
where
--... |
4 years ago |
| USE plwiki_p;
select count(*) from revision
USE INDEX... |
4 years ago |
| USE plwiki_p;
select count(*) from revision
USE INDEX... |
4 years ago |
| USE plwiki_p;
select count(*) from revision
USE INDEX... |
4 years ago |
| USE plwiki_p;
select count(*) from revision
where
-- actor_id
rev_actor =... |
4 years ago |
| USE plwiki_p;
select count(*) from revision
USE INDEX... |
4 years ago |
| USE plwiki_p;
select count(*), page_namespace from revision
USE INDEX... |
4 years ago |
| USE plwiki_p;
select count(*), page_namespace from revision LEFT JOIN page... |
4 years ago |
| USE plwiki_p;
select count(*), ar_namespace, 'archive' from archive
where... |
4 years ago |
| USE plwiki_p;
select count(*), ar_namespace, 'archive' from archive
where... |
4 years ago |
| USE plwiki_p;
select count(*) from archive
where
-- actor_id
ar_actor =... |
4 years ago |
| USE plwiki_p;
select count(*) from revision
where
-- actor_id
rev_actor =... |
4 years ago |
| USE plwiki_p;
select count(*) from revisions
where
-- actor_id
rev_actor =... |
4 years ago |
| USE plwiki_p;
select count(*) from revisions where
--... |
4 years ago |
| USE plwiki_p;
SELECT * from user_properties
where up_property = 'gender'... |
4 years ago |
| USE plwiki_p;
SELECT * from user_properties
where up_property = 'gender'... |
4 years ago |
| USE plwiki_p;
SELECT user_id, user_name, user_registration, user_editcount... |
4 years ago |
| USE plwiki_p;
SELECT user_id, actor_id, actor_name
FROM user inner join... |
4 years ago |
| USE plwiki_p;
SELECT rev_actor, min(rev_timestamp)
FROM revision
WHERE... |
4 years ago |
| USE plwiki_p;
SELECT user_id, user_name, user_registration, user_editcount... |
4 years ago |
| USE plwiki_p;
SELECT user_id, actor_id, actor_name
FROM user left join... |
4 years ago |
| SELECT user_id, actor_id, actor_name
FROM user left join actor on user_id =... |
4 years ago |
| SELECT user_id, actor_id, actor_name
FROM user inner join actor on user_id =... |
4 years ago |
| SELECT user_id, user_name, user_registration, user_editcount
FROM... |
4 years ago |
| SELECT user_id, user_name, user_registration, user_editcount
FROM... |
4 years ago |
