SQL
x
USE scowiki_p;
WHERE actor_name = "AmaryllisGardener"
FROM page
JOIN toolserver.namespace
ON page_namespace = ns_id
AND dbname = 'scowiki_p'
LEFT JOIN templatelinks
ON tl_from = page_id
WHERE page_len < 50
AND page_is_redirect = 0
AND page_namespace NOT IN (2, 3)
AND tl_from IS NULL
AND (SELECT
COUNT(DISTINCT rev_user_text)
FROM revision
WHERE rev_page = page_id) = 1
ORDER BY page_len ASC
SELECT DISTINCT p.page_title, p.page_len , r.rev_actor
FROM page p
LEFT JOIN revision_userindex r
ON r.rev_page = p.page_id
LIMIT 100
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.