Untitled query #51835

SQL

use tewiki_p;

use tewiki_p;

SELECT DISTINCT page_title
FROM page 
where page_id not in (select pp_page from page_props where pp_propname='wikibase_item')
	AND (page_title LIKE "A%"
    OR page_title LIKE "B%"
    OR page_title LIKE "C%"
    OR page_title LIKE "D%"
    OR page_title LIKE "E%"
    OR page_title LIKE "F%"
    OR page_title LIKE "G%"
    OR page_title LIKE "H%"
    OR page_title LIKE "I%"
    OR page_title LIKE "J%"
    OR page_title LIKE "K%"
    OR page_title LIKE "L%"
    OR page_title LIKE "M%"
    OR page_title LIKE "N%"
    OR page_title LIKE "O%"
    OR page_title LIKE "P%"
    OR page_title LIKE "Q%"
    OR page_title LIKE "R%"
    OR page_title LIKE "S%"
    OR page_title LIKE "T%"
    OR page_title LIKE "U%"
    OR page_title LIKE "V%"
    OR page_title LIKE "W%"
    OR page_title LIKE "X%"
    OR page_title LIKE "Y%"
         OR page_title LIKE "Z%")
    and page_title not LIKE "%/%"
    and page.page_namespace = 10
    and page_is_redirect = 0
SQL

Checking query status...
