Test - Quarry

SQL

#USE ckbwiki_p;

# SELECT CONCAT('Category:', page_title) FROM page
#SELECT page_title FROM page

#WHERE page_is_redirect = 0				#Do not return redirect pages
#AND page_namespace != 2				#DO NOT return User namespace
#AND page_namespace = 0					#Returns articles only
#AND page_namespace % 2 = 0				#Returns non-talk pages
#ORDER BY page_title ASC

USE incubatorwiki_p;

SELECT REPLACE (page_title,'_',' ') AS 'Page title',
		page_namespace AS Namespace,
        page_is_redirect AS 'Redirect?'
FROM page

WHERE page_title RLIKE 'Wt/ckb/'

AND page_is_redirect = 0				#Do not return redirect pages
#AND page_namespace != 2				#DO NOT return User namespace
AND page_namespace = 0					#Returns Main namespace/articles only
#AND page_namespace % 2 = 0				#Returns non-talk pages

ORDER BY page_title ASC;
SQL

Checking query status...
