@Bawolff Thank you for suggesting Toolforge . I got approval for shell access able to query.
Only concern is I am unable to query some of the question that I mentioned in the list. I would like to have queries for them.
I tried few queries but not sure those are right. I would like you to check this queries
Wikipedia pages without images ?
SELECT page_title
FROM page
LEFT JOIN imagelinks ON il_from=page_id
WHERE page_namespace=0 AND page_is_redirect=0 AND il_from IS NULL
LIMIT 200;
What is the total number of Wikidata Items connected to articles on Wikipedia?
USE wikidatawiki_p;
SELECT CONCAT("Q",ips_item_id), CONCAT("Lml"), CONCAT('"',ips_site_page,'"')
FROM wb_items_per_site
WHERE ips_site_id='hiwiki' AND NOT EXISTS (
SELECT 1 FROM wb_terms WHERE CONCAT("Q", ips_item_id) = term_full_entity_id AND term_type = "label" AND term_language='hi' LIMIT 1
);
What is the total number of articles on Wikipedia that are marked as stubs?
I don't what to take size of article to consider as it as stub one so i did like this it might be wrong
select page_title, page_len from page where page_len < '2000' and page_namespace = 0 and page_is_redirect = 0;
What is the total number of articles on Wikipedia that have infoboxes?
not done
SELECT page_title
FROM page, imagelinks
WHERE page_namespace = 0
AND page_is_redirect = 0
AND page_id NOT IN (
SELECT il_from
FROM imagelinks
WHERE il_from_namespace = 0
GROUP BY(il_from)
)
AND (
NOT EXISTS(
SELECT
1
FROM commonswiki_p.page
WHERE page_title = il_to
AND page_namespace = 6
)
)
What is the total number of articles on Wikipedia that have at least one media element (picture or video)?
SELECT page_title FROM page LEFT JOIN imagelinks ON il_from=page_id WHERE page_namespace=0 AND page_is_redirect=0 AND page_len > 10 AND il_from IS NOT NULL;
What is the Average edits per page
I am to get this number from stats page
unable to query the remaining I need some help in this.
What is the total number of articles on Wikipedia that have more than one media element (picture or video)?
select count(*) from
(SELECT page_title , count(*) as cou
FROM page
LEFT JOIN imagelinks ON il_from=page_id
WHERE page_namespace=0 AND page_is_redirect=0 AND il_from IS not NULL GROUP BY il_from having cou > 1) as tit;
What is the total number of dead-end articles on Wikipedia?
SELECT count(*)
FROM page
LEFT JOIN pagelinks ON pl_from=page_id
WHERE page_namespace=0 AND page_is_redirect=0 AND pl_from IS NULL ;
