| USE plwiki_p;
SHOW INDEX FROM archive_userindex; |
4 years ago |
| USE plwiki_p;
SELECT page_namespace, count(*)
FROM revision_actor_temp... |
4 years ago |
| USE plwiki_p;
SELECT *
FROM revision_actor_temp
LEFT JOIN page on... |
4 years ago |
| USE plwiki_p;
SELECT *
FROM revision_actor_temp
LEFT JOIN page on... |
4 years ago |
| USE plwiki_p;
SELECT page_namespace, count(*)
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(page_namespace), page_namespace
from... |
4 years ago |
| USE plwiki_p;
SELECT log_title, log_timestamp, user_id,... |
4 years ago |
| USE plwiki_p;
CREATE TEMPORARY TABLE admin_stats... |
4 years ago |
| USE plwiki_p;
CREATE TEMPORARY TABLE #admin_stats... |
4 years ago |
| USE plwiki_p;
CREATE TEMPORARY TABLE admin_stats... |
4 years ago |
| USE plwiki_p;
CREATE TEMPORARY TABLE admin_stats... |
4 years ago |
| CREATE TEMPORARY TABLE admin_stats... |
4 years ago |
| SELECT *
FROM user left join actor on user_id = actor_user
WHERE user_name... |
4 years ago |
| SELECT user_id, actor_id, actor_name
FROM user left join actor on user_id =... |
4 years ago |
