Files with a single transclusion of [[template:Category_definition:_Object]]

Fork of Files_with_PermissionOTRS_template_but_without_P6305_SDC_statement by Jarekt

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

SQL

use commonswiki_p;
select concat("File:",page_title), tl_title, concat("M",page_id) AS MID, "P6305",
	concat('"X',REPLACE(el_to,'https://ticket.wikimedia.org/otrs/index.pl?Action=AgentTicketZoom&TicketNumber=',''),'"') AS OTRS
FROM page
join templatelinks on page_id=tl_from and tl_namespace = 10  AND tl_title in (#"Landtagsprojekt_Erfurt",
                                                                              "Landtagsprojekt_Hessen"
                                                                              "Landtagsprojekt_Niederösterreich", 
                                                                              "Landtagsprojekt_Nordrhein-Westfalen",
                                                                              "Landtagsprojekt_Sachsen-Anhalt",
                                                                              "Landtagsprojekt_Sachsen",
                                                                              "Landtagsprojekt_Salzburg", 
                                                                              "WIKI_loves_parliaments/Bremische_Bürgerschaft")
JOIN externallinks ON page_id=el_from AND el_to LIKE 'https://ticket.wikimedia.org/otrs/index.pl?Action=AgentTicketZoom&TicketNumber=%'

SQL

Checking query status...