| SELECT * FROM page WHERE page_is_redirect = 1 AND page_namespace = 1 |
2 weeks ago |
| SELECT *
FROM revision
JOIN page ON rev_page = rev_page
JOIN actor ON... |
3 weeks ago |
| SELECT *
FROM revision
JOIN page ON rev_page = rev_page
JOIN actor ON... |
3 weeks ago |
| SELECT *
FROM revision
JOIN page ON rev_page = rev_page
JOIN actor ON... |
3 weeks ago |
| SELECT *
FROM revision
JOIN page ON rev_page = rev_page
JOIN actor ON... |
3 weeks ago |
| SELECT *
FROM revision
JOIN page ON rev_page = rev_page
LIMIT 10; |
3 weeks ago |
| SELECT *
FROM revision
LIMIT 10; |
3 weeks ago |
| use wikidatawiki_p;
SELECT * FROM user_groups join user on user_id =... |
3 years ago |
| use hywiki_p;
SELECT * FROM user_groups join user on user_id = ug_user... |
3 years ago |
| use hywiki_p;
SELECT * FROM user_groups WHERE ug_group = 'bot' |
3 years ago |
| use hywiki_p;
SELECT ug_user FROM user_groups WHERE ug_group = 'bot' |
3 years ago |
| use hywiki_p;
select * from user_groups join user on ug_user = user_id... |
3 years ago |
| use hywiki_p;
select * from user_groups join user on ug_user = user_id... |
3 years ago |
| use hywiki_p;
select * from user_groups join user on ug_user = user_id... |
3 years ago |
| use hywiki_p;
select * from user_groups limit 19; |
3 years ago |
| user hywiki_p;
select * from user_groups limit 19; |
3 years ago |
| user hywiki_p;
select * from user_groups limit 19 |
3 years ago |
| user hywiki_p;
select * from user_groups limit 19 |
3 years ago |
| use wikidatawiki_p;
select count(ips_site_id), ips_item_id from... |
4 years ago |
| use wikidatawiki_p;
select count(ips_site_id), ips_item_id from... |
4 years ago |
| use wikidatawiki_p;
select count(ips_site_id) from wb_items_per_site
group... |
4 years ago |
| use wikidatawiki_p;
select count(ips_site_id) from wb_items_per_site
group... |
4 years ago |
| use wikidatawiki_p;
select * from wb_items_per_site limit 10 |
4 years ago |
| user wikidatawiki_p;
select * from wb_items_per_site limit 10 |
4 years ago |
| USE hywiki_p;
SELECT DISTINCT
cl_to
FROM categorylinks AS cat
JOIN page AS... |
7 years ago |
