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