Untitled query #67878

SQL

USE dewiki_p;
SELECT CONCAT('[[', REPLACE(p.page_title, '_', ' '), ']]') as Artikel, CONCAT('[[:Kategorie:', REPLACE(cl_to, '_', ' '), ']]') AS Kategorie
FROM page AS p
INNER JOIN categorylinks ON p.page_id = cl_from
INNER JOIN page AS catpage ON catpage.page_namespace = 14
  AND catpage.page_title = cl_to
INNER JOIN page_props ON pp_page = catpage.page_id AND pp_propname = 'hiddencat'
WHERE p.page_namespace = 0
  AND p.page_title in ('Abmessungen','Abnutzungskrieg','ABOD_Verlag','Das_Abonnement','Abraxas','Abreicherung','Abreicherungsgrad','Absa Salla (Stadt)','Absage','Absakowo');
SQL

Checking query status...
