zhwiki: Pages which title contains －

Fork of zhwiki: Pages which title contains Taiwan by Ericliu1912

This query is marked as a draft This query has been published by Ericliu1912.

SQL

USE zhwiki_p;
SELECT page_id, page_title
FROM page
WHERE page_namespace = 0
	AND page_is_redirect = 0
	AND page_title LIKE "%－%";
    
WHERE page_namespace = 0
	AND page_is_redirect = 1
	AND page_title LIKE "%－%";
    
WHERE NOT page_namespace = 0
	AND page_is_redirect = 0
	AND 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...