Untitled query #20672

Fork of Pages edited by Shakespeare Fan00 at enwikisource by BWolff (WMF)

This query is marked as a draft This query has been published by ShakespeareFan00.

SQL

USE enwikisource_p;
SELECT DISTINCT 

CONCAT(
/* clause 1 */
  IF( 
    INSTR( SUBSTRING_INDEX(p1.page_title, '/', 1 ) , "jpg" ) OR
    INSTR( SUBSTRING_INDEX(p1.page_title, '/', 1 ) , "png" ), "Page:", "Index:"),
  SUBSTRING_INDEX(p1.page_title, '/', 1 )) 
FROM page p1
INNER JOIN revision_userindex r1 ON r1.rev_page = p1.page_id
INNER JOIN categorylinks c ON c.cl_from = p1.page_id AND c.cl_to = 'Validated'
WHERE p1.page_namespace = 104
AND  r1.rev_user_text IN ( 'ShakespeareFan00', 'Sfan00_IMG')
ORDER BY p1.page_latest

SQL

Checking query status...