Wikipedia:Elenchi generati offline/Attori e registi senza IMDB

Voci di attori e registi sprovvisti del template {{IMDB}}.

Query[modifica wikitesto]

SELECT DISTINCT CONCAT("# [[", page_title, "]]")
FROM page
JOIN categorylinks ON cl_from = page_id
WHERE page_namespace = 0
AND page_is_redirect = 0
AND (cl_to LIKE 'Attori%'
OR cl_to LIKE 'Registi%')
AND page_id NOT IN (
SELECT tl_from
FROM templatelinks
WHERE tl_title = 'IMDB'
OR tl_title = 'Imdb'
OR tl_title = 'IMDb'
OR tl_title = 'Collegamenti_cinema'
AND tl_namespace = 10)
ORDER BY page_title