Gebruiker:Annabel/queries/1

Nederlandse woorden zonder lettergrepensectie

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