b - Quarry

SQL

/*
SELECT COUNT(*)
FROM recentchanges
JOIN actor on rc_actor = actor_id
WHERE actor_name = 'Ahmad Kanik'
AND rc_source = 'mw.edit';
*/
/*
SELECT p.page_title, pp.pp_value
FROM page p
JOIN page_props pp
ON p.page_id = pp.pp_page
WHERE p.page_is_redirect = 1
AND pp.pp_propname = 'wikibase_item';
*/
SELECT *
FROM page
JOIN page_props
LIMIT 20;

SELECT
  page_namespace,
  page_title,
  page_len
FROM page
LEFT JOIN user
WHERE page_namespace IN (2,3)
AND page_is_redirect = 0
AND page_title NOT LIKE "%/%"
AND user_name IS NULL;
SQL

Checking query status...
