Prüfung auf No1-Hits

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

Gesucht werden Interpreten welche einen Link auf die No 1 Hitlisten haben, aber auf diesen Seiten kein Link zurück zum Interpreten existiert.

Siehe: https://de.wikipedia.org/w/index.php?title=Wikipedia:Bots/Anfragen&oldid=179988907#Wartungsliste

Alternative Query mit weit mehr Treffern: https://quarry.wmflabs.org/query/28965

SQL

USE dewiki_p;
SELECT interpretPage.page_title as Interpret, hitPage.page_title as 'Nummer 1 Seite'
  FROM page AS hitPage,
       pagelinks,
       page AS interpretPage
 WHERE hitPage.page_title LIKE "Liste_der_Nummer-eins-Hits_in_%"
   AND hitPage.page_namespace = 0
   AND interpretPage.page_id = pagelinks.pl_from
   AND interpretPage.page_title = "Kate_Winslet"
   AND interpretPage.page_namespace = 0
 LIMIT 10

By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.

Submit Query Stop Query

All SQL code is licensed under CC0 License.

SQL

Checking query status...