Untitled query #17689

SQL

USE dewiki_p;
SELECT pl_title, COUNT(pl_title) AS cnt FROM pagelinks WHERE pl_from IN (SELECT page_id FROM page WHERE page_namespace=0 AND page_title IN ('Alan_Turing','Arthur_Harris','Anna_Seghers','Adolf_Hitler','Auschwitz-Erlass','Aggregat_4','Bismarck_(Schiff,_1939)','Carl_Schmitt','Charles_de_Gaulle','Chemische_Waffe','Claus_Schenk_Graf_von_Stauffenberg','Dave_Brubeck','Enrico_Fermi','Ernst_Thälmann','Enigma_(Maschine)','Ernst_Jünger','Erich_Kästner','Heinrich_Himmler','Hans_Bethe','Hirohito')) AND pl_title NOT IN (SELECT page_title FROM page WHERE page_namespace=0) GROUP BY pl_title ORDER BY cnt DESC;
SQL

Checking query status...
