Untitled query #48435

SQL

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
SQL

Checking query status...
