Untitled query #31260

SQL

SELECT page_title FROM page WHERE page_namespace = 0 AND (
  page_title COLLATE UTF8_GENERAL_CI LIKE 'bitcoin:%'
OR page_title COLLATE UTF8_GENERAL_CI LIKE 'ftp://%'
OR page_title COLLATE UTF8_GENERAL_CI LIKE 'ftps://%'
OR page_title COLLATE UTF8_GENERAL_CI LIKE 'geo:%'
OR page_title COLLATE UTF8_GENERAL_CI LIKE 'git://%'
OR page_title COLLATE UTF8_GENERAL_CI LIKE 'gopher://%'
OR page_title COLLATE UTF8_GENERAL_CI LIKE 'http://%'
OR page_title COLLATE UTF8_GENERAL_CI LIKE 'https://%'
OR page_title COLLATE UTF8_GENERAL_CI LIKE 'irc://%'
OR page_title COLLATE UTF8_GENERAL_CI LIKE 'ircs://%'
OR page_title COLLATE UTF8_GENERAL_CI LIKE 'magnet:%'
OR page_title COLLATE UTF8_GENERAL_CI LIKE 'mailto:%'
OR page_title COLLATE UTF8_GENERAL_CI LIKE 'mms://%'
OR page_title COLLATE UTF8_GENERAL_CI LIKE 'news:%'
OR page_title COLLATE UTF8_GENERAL_CI LIKE 'nntp://%'
OR page_title COLLATE UTF8_GENERAL_CI LIKE 'redis://%'
OR page_title COLLATE UTF8_GENERAL_CI LIKE 'sftp://%'
OR page_title COLLATE UTF8_GENERAL_CI LIKE 'sip:%'
OR page_title COLLATE UTF8_GENERAL_CI LIKE 'sips:%'
OR page_title COLLATE UTF8_GENERAL_CI LIKE 'sms:%'
OR page_title COLLATE UTF8_GENERAL_CI LIKE 'ssh://%'
OR page_title COLLATE UTF8_GENERAL_CI LIKE 'svn://%'
OR page_title COLLATE UTF8_GENERAL_CI LIKE 'tel:%'
OR page_title COLLATE UTF8_GENERAL_CI LIKE 'telnet://%'
OR page_title COLLATE UTF8_GENERAL_CI LIKE 'urn:%'
OR page_title COLLATE UTF8_GENERAL_CI LIKE 'worldwind://%'
OR page_title COLLATE UTF8_GENERAL_CI LIKE 'xmpp:%'
OR page_title COLLATE UTF8_GENERAL_CI LIKE '//%'
);
SQL

Checking query status...
