Artikels op AfWiki wat na Wikt skakel

Fork of Woorde op Wikt met 'n artikel op Wiki by Naudefj

This query is marked as a draft This query has been published by Naudefj.

SQL

SELECT p.page_title
  FROM afwiki_p.page p
  JOIN afwiki_p.templatelinks pl
    ON p.page_id = pl.tl_from AND pl.tl_namespace = 10 AND pl.tl_title IN ('Wikt', 'Wikt-inlyn')
  JOIN afwiktionary_p.page w
    ON p.page_title = concat(ucase(substr(CONVERT(w.page_title USING latin1), 1,1)), substr(w.page_title, 2)) 
    -- ON p.page_title = w.page_title
       AND w.page_namespace = 0 AND w.page_is_redirect = 0 
       AND w.page_id NOT IN (SELECT tl_from FROM afwiktionary_p.templatelinks WHERE w.page_id = tl_from AND tl_title IN ('info', '-info-'))
  WHERE 
   p.page_namespace = 0 AND p.page_is_redirect = 0
;

SQL

Checking query status...