Untitled query #31260

SQL

SELECT page_title, page_is_redirect FROM page WHERE page_namespace = 0 AND (
  page_title LIKE 'Bitcoin:%'
OR page_title LIKE 'Ftp://%'
OR page_title LIKE 'Ftps://%'
OR page_title LIKE 'Geo:%'
OR page_title LIKE 'Git://%'
OR page_title LIKE 'Gopher://%'
OR page_title LIKE 'Http://%'
OR page_title LIKE 'Https://%'
OR page_title LIKE 'Irc://%'
OR page_title LIKE 'Ircs://%'
OR page_title LIKE 'Magnet:%'
OR page_title LIKE 'Mailto:%'
OR page_title LIKE 'Mms://%'
OR page_title LIKE 'News:%'
OR page_title LIKE 'Nntp://%'
OR page_title LIKE 'Redis://%'
OR page_title LIKE 'Sftp://%'
OR page_title LIKE 'Sip:%'
OR page_title LIKE 'Sips:%'
OR page_title LIKE 'Sms:%'
OR page_title LIKE 'Ssh://%'
OR page_title LIKE 'Svn://%'
OR page_title LIKE 'Tel:%'
OR page_title LIKE 'Telnet://%'
OR page_title LIKE 'Urn:%'
OR page_title LIKE 'Worldwind://%'
OR page_title LIKE 'Xmpp:%'
OR page_title LIKE '//%'
) ORDER BY page_is_redirect, page_title;
SQL

Checking query status...
