WP:FAKEARTICLE

SQL

SELECT 
	CASE
        WHEN page.page_namespace = 2
        THEN CONCAT('User:', page.page_title)
        WHEN page.page_namespace = 3
        THEN CONCAT('User Talk:', page.page_title)
    END AS ''
FROM page
JOIN revision ON revision.rev_id = page.page_latest
JOIN actor ON revision.rev_actor = actor.actor_id
JOIN user ON actor.actor_user = user.user_id
WHERE page.page_namespace in (2)
AND page.page_title NOT LIKE '%/%'
AND page.page_len > 750
AND user.user_id IN (SELECT user_id
                     FROM (SELECT user_id,
                           SUM(userspace) AS userspace_total,
                           SUM(usertalk) AS usertalk_total,
                           SUM(other) AS other_total,
                           COUNT(rev_id) AS total
                           FROM (SELECT user.user_id,
                                 revision_userindex.rev_id,
                                 CASE
                                 WHEN page.page_namespace = 2 THEN 1
                                 ELSE 0
                                 END AS userspace,
                                 CASE
                                 WHEN page.page_namespace = 3 THEN 1
                                 ELSE 0
                                 END AS usertalk,
                                 CASE
                                 WHEN page.page_namespace NOT IN (2,3) THEN 1
                                 ELSE 0
                                 END AS other
                                 FROM user
                                 JOIN actor On user.user_id = actor.actor_user
                                 JOIN revision_userindex ON revision_userindex.rev_actor = actor.actor_id
                                 JOIN page ON revision_userindex.rev_page = page.page_id) AS user_revs
                           GROUP BY user_id
                           HAVING total < 500 AND (usespace_total + usertalk_total) / total > 0.9
                          )
LIMIT 50;
SQL

Checking query status...
