zhwiki: All infoboxes

SQL

USE zhwiki_p;
SELECT page_id, page_title
FROM page
WHERE page_namespace = 10
	AND page_is_redirect = 0
	AND page_title LIKE "%Infobox%"
    AND NOT page_title LIKE "%/%";

SELECT page_id, page_title
FROM page
WHERE page_namespace = 10
	AND page_is_redirect = 0
	AND page_title LIKE "%資訊框%"
    AND NOT page_title LIKE "%/%";

SELECT page_id, page_title
FROM page
WHERE page_namespace = 10
	AND page_is_redirect = 0
	AND page_title LIKE "%信息框%"
    AND NOT page_title LIKE "%/%";
# 0/1       main   2/3   user       4/5     wp      6/7     file  8/9     mediawiki 10/11  template
# 12/13     help   14/15 cat        100/101 portal  118/119 draft 710/711 timedtext 828/829 module
# 2300/2301 gadget 2302/2303 g. def -1      special -2 media
SQL

Checking query status...
