Commons:Scrape OTRS

SQL

use commonswiki_p;
SELECT concat("M",page_id) AS MID, 
	'P6305',
	concat('"',REPLACE(el_to,'https://ticket.wikimedia.org/otrs/index.pl?Action=AgentTicketZoom&TicketNumber=',''),'"') AS OTRS,
    CONCAT("File:",page_title)
    #'/* extracted from {{PermissionOTRS}} template */'
FROM page
JOIN externallinks ON page_id=el_from AND el_to LIKE 'https://ticket.wikimedia.org/otrs/index.pl?Action=AgentTicketZoom&TicketNumber=%'
FROM categorylinks ON page_id=cl_from AND cl_to='Files_from_Bollywood_Hungama'
JOIN categorylinks ON page_id=cl_from AND cl_to='Files_with_PermissionOTRS_template_but_without_P6305_SDC_statement'
WHERE 
    page_namespace = 6 
limit 15000
SQL

Checking query status...
