Template:ISOdate usage

Fork of Template:Cc-by-sa-layout/styles.css usage by Mdaniels5757

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

SQL

SELECT p1.page_namespace, p1.page_title, COUNT(tl2.tl_target_id) AS cnt
FROM templatelinks AS tl1, page AS p1, linktarget AS lt2, templatelinks AS tl2
WHERE tl1.tl_from = p1.page_id
AND tl1.tl_target_id = 198 #Template:ISOdate
AND p1.page_namespace IN (2,10,828)
AND lt2.lt_id = tl2.tl_target_id
AND lt2.lt_namespace = p1.page_namespace
AND lt2.lt_title = p1.page_title
GROUP BY tl2.tl_target_id
ORDER BY cnt DESC

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