zhwiki: embedded /sandbox

SQL

SELECT page_title, tl_from
FROM page
LEFT JOIN templatelinks ON page_namespace = tl_namespace AND page_title = tl_title
WHERE page_namespace = 10
	AND page_title LIKE "%/sandbox";
 
SELECT COUNT(*)
FROM page
LEFT JOIN templatelinks ON page_namespace = tl_namespace AND page_title = tl_title
WHERE page_namespace = 10
	AND page_title LIKE "%/sandbox"
	AND tl_from IS NULL;

SELECT COUNT(*)
FROM page
LEFT JOIN templatelinks ON page_namespace = tl_namespace AND page_title = tl_title
WHERE page_namespace = 10
	AND page_title LIKE "%/sandbox"
	AND tl_from IS NOT NULL;
SQL

Checking query status...
