| use fawiki_p;
select
actor_name,
count(*) as total_edits,
100.0 *... |
4 years ago |
| use fawiki_p;
select
actor_name,
100.0 * sum(midnight) / count(*) as... |
4 years ago |
| use fawiki_p;
select
actor_name,
100.0 * sum(midnight) / count(*) as... |
4 years ago |
| use fawiki_p;
select
actor_name,
1.0 * sum(midnight) / count(*) as... |
4 years ago |
| use fawiki_p;
select
actor_name,
sum(midnight) / count(*) as... |
4 years ago |
| use fawiki_p;
select *
from page
where
page_title like '%حضرت%'
and... |
5 years ago |
| use fawiki_p;
select *
from page
where page_title like '%حضرت%' |
5 years ago |
| use fawiki_p;
SELECT /* SLOW OK */ CONCAT(':{{ns', CASE WHEN page_namespace... |
5 years ago |
| use fawiki_p;
SELECT /* SLOW OK */ CONCAT(':{{ns', case when page_namespace... |
5 years ago |
| use fawiki_p;
select distinct page_title from revision
join page
on rev_page... |
8 years ago |
| use fawiki_p;
select page_title from revision
join page
on rev_page =... |
8 years ago |
| use fawiki_p;
select page_title from revision
join page
on rev_page =... |
8 years ago |
| use fawiki_p;
select page_title from revision
join page
on rev_page =... |
8 years ago |
| use fawiki_p;
select page_title from revision
join page
on rev_page =... |
8 years ago |
| use fawiki_p;
select * from revision
join page
on rev_page = page_id
where... |
8 years ago |
| use fawiki_p;
select * from revision
join page
on rev_page = page_id
where... |
8 years ago |
| use fawiki_p;
select page_title, count(ll_lang) from page join category on... |
8 years ago |
