Wikipedia:Elenchi generati offline/Manuali dei template: differenze tra le versioni

Versione delle 23:42, 25 giu 2015

Versione attuale delle 14:37, 20 lug 2017

(Una versione intermedia di uno stesso utente non è mostrata)

Riga 4:

[[Categoria:Gestione template]]

== Query ==

<source lang=mysql>

SELECT CONCAT("# [[Template:", page_title, "]]")

FROM (SELECT REPLACE(page_title, '/man', '') AS page_title

FROM page

WHERE page_namespace = 10

AND page_title LIKE '%/man') AS t1

WHERE page_title NOT IN (SELECT page_title

FROM (SELECT p2.page_id AS page_id, p2.page_title AS page_title

FROM page AS p1, page AS p2

WHERE p1.page_title = CONCAT(p2.page_title, "/man")

AND p1.page_namespace = 10

AND p1.page_namespace = p2.page_namespace) AS p

JOIN templatelinks ON page_id = tl_from WHERE tl_title = "Man")

</source>