Vertippte Vorlage Unsigned

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

SQL

SELECT F.page_namespace, F.page_title, lt_title
  FROM page AS F, templatelinks, linktarget LEFT JOIN page AS P
                                              ON P.page_title = lt_title
                                             AND P.page_namespace = lt_namespace
 WHERE tl_target_id = lt_id
   AND lt_namespace = 10
   AND tl_from_namespace != 0
   AND F.page_id = tl_from
   AND P.page_title IS NULL
   AND (lt_title LIKE "Uns%" OR lt_title LIKE "%ned" OR lt_title LIKE "%sig%")
   AND lt_title != 'Unsinn'
   AND lt_title NOT LIKE 'Unsourced%'
 ORDER BY lt_title

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...