trwiki:Articles which might contain unreliable sources by title

Featured articles: https://quarry.wmflabs.org/run/509944/output/0/html
Featured lists: https://quarry.wmflabs.org/run/509945/output/0/html
Good articles: https://quarry.wmflabs.org/run/509946/output/0/html

ses, islam

SQL

use trwiki_p;
SET sql_mode='PIPES_AS_CONCAT';
select  distinct '# [['||page_title ||']]' as page_title, CONCAT('[[',GROUP_CONCAT(el_to SEPARATOR ']], [['),']]') as link
from externallinks 
  inner join page
    on (page_id=el_from)
where page_namespace =0
and (el_to like '%.blogspot.%'  
  or el_to like '%.tumblr.%' 
  or el_to like '%geocities.%' 
  or el_to like '%.livejournal.%'
  or el_to like '%.tr.gg%'
  or el_to like '%.wordpress.com%'
  or el_to like '%.blogcu.com%'
  or el_to like '%.weebly.com%'
  or el_to like '%.net.tc%'
  or el_to like '%.co.cc%'
  or el_to like '%.azbuz.com%'
  or el_to like '%.somee.com%'
  or el_to like '%osmanli700.gen.tr%'
  or el_to like '%kimkimdir.gen.tr%'
  or el_to like '%ermenisorunu.gen.tr%'
  or el_to like '%canakkale.gen.tr%'
  or el_to like '%ataturk.net%'
  or el_to like '%turkcebilgi.com%')

SQL

Checking query status...