Wikibooks:Elenchi generati offline/Perché: differenze tra le versioni
Contenuto cancellato Contenuto aggiunto
m Aggiorno elenco |
m left join |
||
Riga 5:
<source lang="sql">
SELECT CONCAT("# [[{{subst:#if:{{subst:ns:", page_namespace, "}}|{{subst:ns:", page_namespace, "}}:}}", page_title, "]]") FROM page
LEFT JOIN revision ON
LEFT JOIN text ON rev_text_id=old_id
WHERE old_text REGEXP "[Pp]erch(è|e')"
ORDER BY page_namespace, page_title;
| |||