| select count(*) from page where page_namespace=14 and page_is_redirect=0; |
10 months ago |
| select count(*) from page where page_namespace=2600 and page_is_redirect=0; |
10 months ago |
| select count(*) from page where page_namespace=2300 and page_is_redirect=0; |
10 months ago |
| select count(*) from page where page_namespace=828 and page_is_redirect=0; |
10 months ago |
| select count(*) from page where page_namespace=10 and page_is_redirect=0; |
10 months ago |
| select count(*) from page where page_namespace=101 and page_is_redirect=0; |
10 months ago |
| select count(*) from page where page_namespace=100 and page_is_redirect=0; |
10 months ago |
| select count(*) from page where page_namespace=3 and page_is_redirect=0; |
10 months ago |
| select count(*) from page where page_namespace=1 and page_is_redirect=0; |
10 months ago |
| select count(*) from page where page_namespace=0 and page_is_redirect=0; |
10 months ago |
| select count(*) from page where page_namespace=4 and page_is_redirect=0; |
10 months ago |
| select count(*) from page where page_namespace=2 and page_is_redirect=0; |
10 months ago |
| blank query |
10 months ago |
| select count(*) from page where page_namespace=2 and page_is_redirect=0; |
10 months ago |
| select count(*) from page where page_namespace=3 and page_is_redirect=0; |
10 months ago |
| select count(*) from page where page_namespace=4 and page_is_redirect=0; |
10 months ago |
| select count(*) from page where page_namespace=6 and page_is_redirect=0; |
10 months ago |
| select count(*) from page where page_namespace=8 and page_is_redirect=0; |
10 months ago |
| select count(*) from page where page_namespace=828 and page_is_redirect=0; |
10 months ago |
| select count(*) from page where page_namespace=14 and page_is_redirect=0; |
10 months ago |
| select count(*) from page where page_namespace=1 and page_is_redirect=0; |
10 months ago |
| select count(*) from page where page_namespace=1 and page_is_redirect=1; |
10 months ago |
| blank query |
10 months ago |
| select count(*) from page where page_namespace = 14 and page_is_redirect = 0; |
10 months ago |
| select count(*) from page where page_namespace == 14 and page_is_redirect == 0; |
10 months ago |
| blank query |
1 year ago |
| SELECT
p1.page_title
FROM
page AS p1
JOIN categorylinks ON cl_from =... |
1 year ago |
| SELECT
p1.page_title
FROM
page AS p1
JOIN categorylinks ON cl_from =... |
1 year ago |
| blank query |
1 year ago |
| select * from user_properties limit 20;
|
1 year ago |
| SHOW INDEX IN user_properties;
|
1 year ago |
| select * from user_properties group by up_property limit 10; |
1 year ago |
| select count(*) from user_properties group by up_property; |
1 year ago |
| select * from user_properties where up_property='skin' limit 10; |
1 year ago |
| select * from user_properties where up_property='skin' group by up_value limit 10; |
1 year ago |
| select * from user_properties where up_property='skin' limit 10 group by up_value; |
1 year ago |
| select * from user_properties limit 10; |
1 year ago |
| select count(*) from user_properties; |
1 year ago |
| select distinct count(*) from user_properties; |
1 year ago |
| select count(*) as cnt, up_value from user_properties; |
1 year ago |
| select count(*) as cnt, up_value from user_properties group by up_value; |
1 year ago |
| select count(*) as cnt, up_value from user_properties where... |
1 year ago |
| describe user_properties; |
1 year ago |
| select up_value, count(*) as c from user_properties group by up_value order... |
1 year ago |
| select up_value, count(*) as c from user_properties where up_property =... |
1 year ago |
| blank query |
1 year ago |
| blank query |
1 year ago |
| blank query |
1 year ago |
| select user_name, user_editcount, ipb_by_text from ipblocks
join user on... |
1 year ago |
| select user_name, user_editcount, ipb_by_text from ipblocks
join user on... |
1 year ago |
| use arwiki_p;
select user_name, user_editcount, ipb_by_text from... |
3 years ago |
| use arwiki_p;
select user_name, user_editcount, ipb_by_text from... |
5 years ago |
| use arwiki_p;
select user_name, user_editcount, ipb_by_text from... |
5 years ago |
| use arwiki_p;
select user_name, user_editcount, ipb_by_text from... |
5 years ago |
| use arwiki_p;
select user_name, user_editcount, ipb_by_text from... |
5 years ago |
| use arwiki_p; |
5 years ago |
| use arwiki_p; |
5 years ago |
| use arwiki_p; |
5 years ago |
| use arwiki_p; |
5 years ago |
| use arwiki_p; |
5 years ago |
| use arwiki_p; |
5 years ago |
| use arwiki_p;
select distinct
page_title, min(rev_timestamp)
from... |
5 years ago |
| use arwiki_p;
select distinct
page_title, min(rev_timestamp)
from... |
8 years ago |
| use arwikinews; |
8 years ago |
| sql arwikinews; |
8 years ago |
| sql arwikiversity; |
8 years ago |
| sql arwikiversity; |
8 years ago |
| select user_name from user where ucase (user_name) not like ucase ("%BOT")... |
8 years ago |
