USE metawiki_p;
select user_name, length(user_name), user_editcount
from... |
7 years ago |
USE zhwikivoyage_p;
select user_name, length(user_name), user_editcount... |
7 years ago |
USE zhwiktionary_p;
select user_name, length(user_name), user_editcount... |
7 years ago |
SELECT COUNT(*) FROM zhwiki_p.page_props WHERE pp_propname = 'disambiguation'; |
7 years ago |
blank query |
7 years ago |
use zhwiki_p;
select gt_lat, gt_lon, gt_primary, gt_page_id, gt_name,... |
7 years ago |
blank query |
8 years ago |
use zhwiki_p;
select rev_user , rev_timestamp, rev_page, rev_id... |
8 years ago |
blank query |
8 years ago |
USE metawiki_p;
SELECT p1.page_namespace, p1.page_title
FROM redirect
INNER... |
8 years ago |
USE meta_p;
SELECT p1.page_namespace, p1.page_title
FROM redirect
INNER JOIN... |
8 years ago |