Query Run
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