SELECT actor_name, COUNT(*) as articles_created
FROM revision r
... |
1 year ago |
SELECT actor_name, COUNT(*) as articles_created
FROM revision r
... |
1 year ago |
SELECT actor_name, COUNT(*) as articles_created
FROM revision r
... |
1 year ago |
SELECT actor_name, COUNT(*) as articles_created
FROM revision r
... |
1 year ago |
SELECT actor_name, COUNT(*) as articles_created
FROM revision r
... |
1 year ago |
SELECT actor_name, COUNT(*) as q_user_editcount
FROM revision r
... |
1 year ago |
SELECT actor_name, COUNT(*) as q_user_editcount
FROM revision r
... |
1 year ago |
SELECT actor_name, COUNT(*) as q_user_editcount
FROM revision r
... |
1 year ago |
blank query |
1 year ago |
use arwiki_p; |
1 year ago |
use arwiki_p; |
3 years ago |
use arwiki_p;
select * from templatelinks
where tl_namespace=10
and tl_from... |
3 years ago |
use arwiki_p;
select * from templatelinks
where tl_namespace=0
and tl_from =... |
3 years ago |
use arwiki_p;
select * from templatelinks
where tl_namespace=0
and tl_from =... |
3 years ago |
use arwiki_p;
select * from templatelinks
where tl_namespace=0
and tl_from =... |
3 years ago |
use arwiki_p;
select * from templatelinks
where tl_namespace=0
and tl_from =... |
3 years ago |
use arwiki_p;
select * from templatelinks
where tl_namespace=10
and tl_from... |
3 years ago |
use arwiki_p;
select * from templatelinks
where tl_namespace=10
and tl_from... |
3 years ago |
use arwiki_p;
select * from templatelinks
where tl_namespace=10
and tl_from... |
3 years ago |
use arwiki_p;
select * from templatelinks where tl_namespace=10 and tl_from... |
3 years ago |
use arwiki_p;
|
3 years ago |
use arwiki_p;
SELECT *
FROM page join templatelinks
on page_id = tl_from
and... |
3 years ago |
use arwiki_p;
SELECT *
FROM page join templatelinks
on page_id = tl_from
and... |
3 years ago |
use arwiki_p;
SELECT *
FROM page join templatelinks
on page_id = tl_from
and... |
3 years ago |
use arwiki_p;
SELECT *
FROM page join templatelinks
on page_id = tl_from
and... |
3 years ago |
use arwiki_p;
SELECT page_title, page_namespace
FROM page join... |
3 years ago |
use arwiki_p;
SELECT page_title, page_namespace
FROM page join... |
3 years ago |
use arwiki_p;
SELECT page_title, page_namespace
FROM page join... |
3 years ago |
use arwiki_p;
|
3 years ago |
use arwiki_p;
SELECT count(*) FROM templatelinks
WHERE tl_title = 'تصنيف كومنز'; |
3 years ago |
use arwiki_p;
SELECT count(*) FROM templatelinks
WHERE tl_title = 'تصنيف... |
3 years ago |
use arwiki_p;
SELECT
page_id,
page_is_redirect,
page_title
... |
3 years ago |
use arwiki_p;
SELECT
page_id,
page_is_redirect,
page_title
... |
3 years ago |
use arwiki_p;
SELECT
page_id,
page_is_redirect,
page_title
... |
3 years ago |
use arwiki_p;
|
3 years ago |
use arwiki_p;
SELECT
page_title
FROM page
JOIN templatelinks
ON... |
3 years ago |
use arwiki_p;
SELECT
COUNT(*)
FROM page
JOIN templatelinks
ON page_title... |
3 years ago |
use arwiki_p;
SELECT
COUNT(*)
FROM page
JOIN templatelinks
ON page_title... |
3 years ago |
use arwiki_p;
SELECT
COUNT(*)
FROM page
JOIN templatelinks
ON page_title... |
3 years ago |
/*
use arwiki_p;
SELECT
COUNT(*)
FROM page
JOIN templatelinks
ON... |
3 years ago |
use arwiki_p;
SELECT
COUNT(*)
FROM page
JOIN templatelinks
ON page_title =... |
3 years ago |
use arzwiki_p;
select page_id, page_namespace, page_title, page_touched ... |
3 years ago |
use arwikiversity_p;
select page_id, page_namespace, page_title,... |
3 years ago |
use arwikinews_p;
select page_id, page_namespace, page_title, page_touched ... |
3 years ago |
use arwikisource_p;
select page_id, page_namespace, page_title, page_touched... |
3 years ago |
use arwikiquote_p;
select page_id, page_namespace, page_title, page_touched ... |
3 years ago |
use arwikibooks_p;
select page_id, page_namespace, page_title, page_touched ... |
3 years ago |
use arwiktionary_p;
select page_id, page_namespace, page_title, page_touched... |
3 years ago |
use arzwiki_p;
select page_id, page_namespace, page_title, page_touched ... |
3 years ago |
use arywiki_p;
select page_id, page_namespace, page_title, page_touched ... |
3 years ago |
use arwiki_p;
select page_id, page_namespace, page_title, page_touched from... |
3 years ago |
use arwiki_p;
select count(*) from page where page_namespace=10 and... |
3 years ago |
use arwiktionary_p;
select count(*) from page where page_namespace=14; |
4 years ago |
use arwikisource_p;
select count(*) from page where page_namespace=14; |
4 years ago |
use arwikibooks_p;
select * from page where page_id =4; |
4 years ago |
use arywiki_p;
select * from page where page_id =114; |
4 years ago |
select * from cognate_sites limit 10; |
4 years ago |
describe cognate_sites; |
4 years ago |
use enwiktionary_p;
describe cognate_sites; |
4 years ago |
SELECT
p1.page_namespace,
/*ns_name,*/
p1.page_title
FROM redirect AS... |
4 years ago |
SELECT
p1.page_namespace,
ns_name,
p1.page_title
FROM redirect AS... |
4 years ago |
SELECT
p1.page_namespace,
ns_name,
p1.page_title
FROM redirect AS... |
4 years ago |
use arzwiki_p;
#select concat("# [[:User talk:", actor_name, "]]") from... |
4 years ago |
use arzwiki_p;
#select concat("# [[:User talk:", actor_name, "]]") from... |
4 years ago |
use arzwiki_p;
select concat("# [[:User talk:", actor_name, "]]") from... |
4 years ago |
use arzwiki_p;
select concat("# [[:User talk:", actor_name, "]]") from... |
4 years ago |
use arzwiki_p;
select distinct * from actor
where actor_user is null
order... |
4 years ago |
use arzwiki_p;
select distinct * from actor, revision
#on actor_user =... |
4 years ago |
use arzwiki_p;
select * from actor, revision
#on actor_user = rev_user
where... |
4 years ago |
use arzwiki_p;
select * from actor join revision
on actor_user =... |
4 years ago |
use arzwiki_p;
select * from actor
where actor_user is not null
limit 50
;
|
4 years ago |
use arwiki_p;
#describe flaggedpages;
#describe flaggedrevs
select * from... |
5 years ago |
use arwiki_p;
#describe flaggedpages;
describe flaggedrevs
#select * from... |
5 years ago |
use arwiki_p;
#describe flaggedpages;
describe flaggedpage_pending;
select *... |
5 years ago |
use arwiki_p;
#describe flaggedpages;
describe flaggedpage_pending;
select *... |
5 years ago |
use arwiki_p;
#describe flaggedpages;
describe flaggedpage_pending;
#select... |
5 years ago |
use arwiki_p;
#describe flaggedpages;
select * from flaggedpages join page... |
5 years ago |
use arwiki_p;
#describe flaggedpages;
select * from flaggedpages join page... |
5 years ago |
use arwiki_p;
#describe flaggedpages;
select * from flaggedpages join page... |
5 years ago |
use arwiki_p;
#describe flaggedpages;
select * from flaggedpages join page... |
5 years ago |
use arwiki_p;
#describe flaggedpages;
select * from flaggedpages join page... |
5 years ago |
use arwiki_p;
#describe flaggedpages;
select * from flaggedpages join page... |
5 years ago |
use arwiki_p;
#describe flaggedpages;
select * from flaggedpages join page... |
5 years ago |
use arwiki_p;
#describe flaggedpages;
select * from flaggedpages limit 50;
|
5 years ago |
use arwiki_p;
describe flaggedpages;
|
5 years ago |