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