Untitled query #56805

SQL

SELECT page_namespace, page_title, pp_value AS displaytitle
FROM page, page_props
WHERE 
	page_namespace=0 AND
	page_id=pp_page AND 
    pp_propname='displaytitle' AND 
    /*pp_value=CONVERT(REPLACE(page_title,'_',' ') USING utf8mb4) OR */
    (
    	NOT (pp_value REGEXP '\\<i\\>' AND pp_value REGEXP '\\</i\\>' AND LENGTH(pp_value)=LENGTH(page_title)+7) AND
    	pp_value!=CONCAT(
      		LOWER(LEFT(CONVERT(page_title USING utf8mb4), 1)),
          	REPLACE(REPLACE(
              RIGHT(
                  CONVERT(REPLACE(page_title,'_',' ') USING utf8mb4),
                  CHAR_LENGTH(CONVERT(page_title USING utf8mb4))-1
              ), '&', '&amp;'), '\'', '&#39;'
            )
    	) AND
      	pp_value!=CONCAT('<i>',
      		REPLACE(REPLACE(
                  CONVERT(REPLACE(page_title,'_',' ') USING utf8mb4)
              , '&', '&amp;'), '\'', '&#39;'
            ),
    		'</i>'
        ) AND
    	pp_value!=CONCAT(
      		LOWER(LEFT(CONVERT(page_title USING utf8mb4), 1)),
          	REPLACE(REPLACE(
              RIGHT(
                  CONVERT(REPLACE(page_title,'_',' ') USING utf8mb4),
                  CHAR_LENGTH(CONVERT(page_title USING utf8mb4))-1
              ), '&', '&#38;'), '\'', '&#39;'
            )
    	) AND
      	pp_value!=CONCAT('<i>',
      		REPLACE(REPLACE(
                  CONVERT(REPLACE(page_title,'_',' ') USING utf8mb4)
              , '&', '&#38;'), '\'', '&#39;'
            ),
    		'</i>'
        )
	)
ORDER BY page_latest DESC
SQL

Checking query status...
