mainspace pages that have other namespace names

SQL

SELECT page_title FROM page WHERE page_namespace = 0 AND (page_title LIKE "Talk:%"
                                                       OR page_title LIKE "User:%"
                                                       OR page_title LIKE "User talk:%"
                                                       OR page_title LIKE "Wikipedia:%"
                                                       OR page_title LIKE "Wikipedia talk:%"
                                                       OR page_title LIKE "File:%"
                                                       OR page_title LIKE "File talk:%"
                                                       OR page_title LIKE "MediaWiki:%"
                                                       OR page_title LIKE "MediaWiki talk:%"
                                                       OR page_title LIKE "Template:%"
                                                       OR page_title LIKE "Template talk:%"
                                                       OR page_title LIKE "Help:%"
                                                       OR page_title LIKE "Help talk:%"
                                                       OR page_title LIKE "Category:%"
                                                       OR page_title LIKE "Category talk:%"
                                                       OR page_title LIKE "Portal:%"
                                                       OR page_title LIKE "Portal talk:%"
                                                       OR page_title LIKE "Draft:%"
                                                       OR page_title LIKE "Draft talk:%"
                                                       OR page_title LIKE "TimedText:%"
                                                       OR page_title LIKE "TimedText talk:%"
                                                       OR page_title LIKE "Module:%"
                                                       OR page_title LIKE "Module talk:%"
                                                       OR page_title LIKE "Book:%"
                                                       OR page_title LIKE "Book talk:%"
                                                       OR page_title LIKE "Course:%"
                                                       OR page_title LIKE "Course talk:%"
                                                       OR page_title LIKE "Institution:%"
                                                       OR page_title LIKE "Institution talk:%"
                                                       OR page_title LIKE "Education Program:%"
                                                       OR page_title LIKE "Education Program talk:%"
                                                       OR page_title LIKE "Flow:%"
                                                       OR page_title LIKE "Flow talk:%"
                                                       OR page_title LIKE "Gadget:%"
                                                       OR page_title LIKE "Gadget talk:%"
                                                       OR page_title LIKE "Gadget definition:%"
                                                       OR page_title LIKE "Gadget definition talk:%"
                                                       OR page_title LIKE "Topic:%"
                                                       OR page_title LIKE "Topic talk:%"
                                                       OR page_title LIKE "Special:%"
                                                       OR page_title LIKE "Special talk:%"
                                                       OR page_title LIKE "Media:%"
                                                       OR page_title LIKE "Media talk:%");
SQL

Checking query status...
