trwiki:Articles which have external links to Wikimedia projects

SQL

use trwiki_p;
SET sql_mode='PIPES_AS_CONCAT';
select distinct '# [['||page_title ||']]' as output
from externallinks 
  inner join page
    on (page_id=el_from)
where page_namespace =0
and (el_to like '%.wikipedia.%'  
  or el_to like '%.wikisource.%' 
  or el_to like '%.wiktionary.%' 
  or el_to like '%.wikiquote.%'
  or el_to like '%.wikivoyage.%'
  or el_to like '%.wikiversity.%'
  or el_to like '%.mediawiki.%'
  /*or el_to like '%.wikimedia.%'*/
  or el_to like '%.wikinews.%'
  or el_to like '%.wikispecies.%'
  or el_to like '%.wikibooks.%')

SQL

Checking query status...