MediaWiki documentation by Chad

SQL

USE mediawikiwiki_p;
-- Pages created in (Main) namespace
SELECT
 page_title
FROM revision
JOIN page ON rev_page=page_id
WHERE rev_user='16891'
AND rev_parent_id=0
AND page_namespace=0
UNION
-- Pages created in Manual namespace
SELECT
 CONCAT('Manual:', page_title) as page_title
FROM revision
JOIN page ON rev_page=page_id
WHERE rev_user='16891'
AND rev_parent_id=0
AND page_namespace=100
UNION
-- Pages with a revision making a large size difference
SELECT page_title FROM (
  SELECT
   IF(page_namespace=0,page_title,CONCAT('Manual:',page_title)) as page_title,
   r1.rev_len,
   (SELECT rev_len FROM revision_userindex r2 WHERE r2.rev_id = r1.rev_parent_id) _parent_len
  FROM revision_userindex r1
  LEFT JOIN page ON r1.rev_page=page_id
  WHERE r1.rev_user = '16891'
  AND r1.rev_parent_id != '0'
  AND page_namespace IN (0, 100)
  AND r1.comment NOT LIKE 'Reverted %'
  HAVING (CAST(_parent_len as signed)-CAST(r1.rev_len as signed)) < -1000
) _big_revs
SQL

Checking query status...
