Gebruiker:Annabel/queries/3

Pagina's zonder link

mysql -hsql-s3 --skip-column-names nlwiktionary_p > /home/annabel/public_html/links.txt <<EOF
SELECT CONCAT('# [[', page_title, ']]')
FROM nlwiktionary_p.page AS Tabelleke1
LEFT JOIN nlwiktionary_p.pagelinks AS Tabelleke2
ON (Tabelleke1.page_id = Tabelleke2.pl_from)
WHERE Tabelleke2.pl_from IS NULL
AND Tabelleke1.page_namespace = 0
EOF