Toggle navigation
Home
New Query
Recent Queries
Discuss
Database tables
Database names
MediaWiki
Wikibase
Replicas browser and optimizer
Login
History
Fork
This query is marked as a draft
This query has been published
by
Evolutionoftheuniverse
.
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
Toggle Highlighting
SQL
use trwiki_p; SET sql_mode='PIPES_AS_CONCAT'; select '# [['||page_title ||']]' as page_title, CONCAT('# ',GROUP_CONCAT(el.el_to SEPARATOR ' '),'') as link, COUNT(el.el_to) as cnt, counting.cnt AS totcount, (CAST(COUNT(el.el_to) AS INT)/CAST(counting.cnt AS INT)) AS frac from externallinks AS el inner join page on page_id=el.el_from JOIN (SELECT COUNT(el_to) AS cnt, el_from FROM externallinks AS counting GROUP BY el_from) AS counting ON page_id=counting.el_from # inner join categorylinks on cl_from=page_id and cl_to="Kaliteli_maddeler" where page_namespace =0 and (el.el_to like '%.blogspot.%' or el.el_to like '%.tumblr.%' or el.el_to like '%geocities.%' or el.el_to like '%.livejournal.%' or el.el_to like '%.tr.gg%' or el.el_to like '%.wordpress.com%' or el.el_to like '%.blogcu.com%' or el.el_to like '%.weebly.com%' or el.el_to like '%.net.tc%' or el.el_to like '%.co.cc%' or el.el_to like '%.azbuz.com%' or el.el_to like '%.somee.com%' or el.el_to like '%osmanli700.gen.tr%' or el.el_to like '%kimkimdir.gen.tr%' or el.el_to like '%ermenisorunu.gen.tr%' or el.el_to like '%canakkale.gen.tr%' or el.el_to like '%ataturk.net%' or el.el_to like '%turkcebilgi.com%' or el.el_to rlike '\.k12\.?[a-z]{0,2}/\S' or el.el_to like '%birimcevir.com%' or el.el_to like '%eksisozluk.%' or el.el_to like '%.sourtimes.%' or el.el_to like '%onedio.com%' or el.el_to like '%.tripod.com%' or el.el_to like '%jenerator.name.tr%' or el.el_to like '%muhendisbeyinler.net%' or el.el_to LIKE '%uludagsozluk.com%' or el.el_to LIKE '%savsatli.com%' or el.el_to LIKE '%karakocannostalji.com%' or el.el_to LIKE '%alisarkoyu.com%' or el.el_to LIKE '%akcakocam.com%' or el.el_to LIKE '%sivricehaber.com%' or el.el_to LIKE '%karamanlive.com%' or el.el_to LIKE '%sozlukspot.com%' or el.el_to LIKE '%.wikia.com%' or el.el_to LIKE '%.wikia.org%' or el.el_to LIKE '%itusozluk.com%' or el.el_to LIKE '%quora.com%' or el.el_to LIKE '%answers.com%' or el.el_to LIKE '%sindirella.com%' or el.el_to LIKE '%haberbedava.com%' or el.el_to LIKE '%ensonhaber.com%' or el.el_to LIKE '%anlatio.com%' or el.el_to LIKE '%listelist.com%' or el.el_to LIKE '%bilgiustam.com%' or el.el_to like '%.8m.net%' or el.el_to like '%kimyaokulu.com%' or el.el_to like '%biyografi.info%' or el.el_to like '%blog.milliyet.com.tr%' or el.el_to like '%haberkonseyi.com%' or el.el_to like '%kuran.gen.tr%' or el.el_to like '%kochisar.gen.tr%' or el.el_to like '%siir.gen.tr%' or el.el_to like '%cografya.gen.tr%' or el.el_to like '%turkbirlik.gen.tr%' or el.el_to like '%starwars.gen.tr%' or el.el_to like '%mimarsinan.gen.tr%' or el.el_to like '%biyografisi.gen.tr%' or el.el_to like '%bluepoint.gen.tr%' or el.el_to like '%kelimeler.gen.tr%' or el.el_to like '%cerkes.gen.tr%' or el.el_to like '%commodore.gen.tr%' or el.el_to like '%kafkas.gen.tr%' or el.el_to like '%tarih.gen.tr%' or el.el_to like '%film.gen.tr%' or el.el_to like '%manga.gen.tr%' or el.el_to like '%biliyormuydunuz.gen.tr%' or el.el_to like '%biraz.gen.tr%' or el.el_to like '%folklor.gen.tr%' or el.el_to like '%tarihbilimi.gen.tr%' or el.el_to like '%canakkale.gen.tr%' or el.el_to like '%kimkimdir.net%' or el.el_to like '%cirali.gen.tr%' or el.el_to like '%istanbulspor.gen.tr%' or el.el_to like '%tst.gen.tr%' or el.el_to like '%tarihtebugun.gen.tr%' or el.el_to like '%sosyoloji.gen.tr%' or el.el_to like '%manisamanset.gen.tr%' or el.el_to like '%mustafatasar.gen.tr%' or el.el_to like '%cide.gen.tr%' or el.el_to like '%candanercetin.gen.tr%' or el.el_to like '%bilgievi.gen.tr%' or el.el_to like '%bedenegitimi.gen.tr%' or el.el_to like '%balkanincileri.gen.tr%' or el.el_to like '%balikesir.gen.tr%' or el.el_to like '%balikesir.com%' or el.el_to like '%hukukfakultesi.gen.tr%' or el.el_to like '%hihaphulusi.gen.tr%' or el.el_to like '%hraspi.gen.tr%' or el.el_to like '%hosmanlilar.gen.tr%' or el.el_to like '%horhangencebay.gen.tr%' or el.el_to like '%hnobel.gen.tr%' or el.el_to like '%hmesafe.gen.tr%' or el.el_to like '%hsayfaki.com%' or el.el_to like '%hseyfettinaslan.gen.tr%' or el.el_to like '%hmehmetakifbal.gen.tr%' or el.el_to like '%hkurucasile.gen.tr%' or el.el_to like '%hkalmun.gen.tr%' or el.el_to like '%islamiyet.gen.tr%' or el.el_to like '%drhakanozkul.gen.tr%' or el.el_to like '%su.gen.tr%' or el.el_to like '%cografyabilimi.gen.tr%' or el.el_to like '%eczaneler.gen.tr%' or el.el_to like '%islamisayfa.com%' or el.el_to like '%gorele.gen.tr%' or el.el_to like '%hukuk.gen.tr%' or el.el_to like '%idrar.gen.tr%' or el.el_to like '%%C3%A7e%C5%9Fmeler.gen.tr%' or el.el_to like '%alkol.gen.tr%' or el.el_to like '%anamur.gen.tr%' or el.el_to like '%ankararehberi.gen.tr%' or el.el_to like '%agac.gen.tr%' or el.el_to like '%afet.gen.tr%' or el.el_to like '%acikkapi.gen.tr%' or el.el_to like '%vitae.gen.tr%' or el.el_to like '%arit.gen.tr%' or el.el_to like '%antalya.gen.tr%' or el.el_to like '%aricilik.gen.tr%' or el.el_to like '%windowsxp.gen.tr%' or el.el_to like '%yarimada.gen.tr%' or el.el_to like '%yesilcam.gen.tr%' or el.el_to like '%yesilkoy.gen.tr%' or el.el_to like '%usturakemaldizisi.gen.tr%' or el.el_to like '%swim.gen.tr%' or el.el_to like '%co%C4%9Frafya.gen.tr%' or el.el_to like '%ayer.gen.tr%' or el.el_to like '%atasozleri.gen.tr%' or el.el_to like '%ayetelkursi.gen.tr%' or el.el_to like '%ayvali.gen.tr%' or el.el_to like '%bellek.gen.tr%' or el.el_to like '%bilecik.gen.tr%' or el.el_to like '%bilgiler.gen.tr%' or el.el_to like '%bulten.gen.tr%' or el.el_to like '%byenice.gen.tr%' or el.el_to like '%camiihalisi.gen.tr%' or el.el_to like '%camlihemsin.gen.tr%' or el.el_to like '%canakci.com.tr%' or el.el_to like '%canakci.gen.tr%' or el.el_to like '%canakkalesavasi.gen.tr%' or el.el_to like '%caninsaat.com.tr%' or el.el_to like '%caninsaat.gen.tr%' or el.el_to like '%cennethurmasi.gen.tr%' or el.el_to like '%cesme.gen.tr%' or el.el_to like '%ceviz.gen.tr%' or el.el_to like '%cizgiroman.gen.tr%' or el.el_to like '%dunyanin7harikasi.gen.tr%' or el.el_to like '%duman6.gen.tr%' or el.el_to like '%disimplanti.gen.tr%' or el.el_to like '%dinibilgiler.gen.tr%' or el.el_to like '%demokrasi.gen.tr%' or el.el_to like '%.tr.tc%' or el.el_to like '%e-net.gen.tr%' or el.el_to like '%edebiyatogretmeni.gen.tr%' or el.el_to like '%index.gen.tr%' or el.el_to like '%yilmaz.tc%' or el.el_to like '%ingilizceturkce.gen.tr%' or el.el_to like '%ilkayakkaya.gen.tr%' or el.el_to like '%engelliler.gen.tr%' or el.el_to like '%felsefe.gen.tr%' or el.el_to like '%etiyopyahavayollari.gen.tr%' or el.el_to like '%fecr.gen.tr%' or el.el_to like '%fokus.gen.tr%' or el.el_to like '%fransizcasozluk.gen.tr%' or el.el_to like '%galactica.gen.tr%' or el.el_to like '%balnet.net%' or el.el_to like '%haberdiyarbakir.gen.tr%' or el.el_to like '%hamidiyekoyu.gen.tr%' or el.el_to like '%hpv.gen.tr%' or el.el_to like '%hzmuhammedinhayati.gen.tr%' or el.el_to like '%kopek.gen.tr%' or el.el_to like '%kuantum.gen.tr%' or el.el_to like '%kultursanat.gen.tr%' or el.el_to like '%ipucu.gen.tr%' or el.el_to like '%iskembecorbasi.gen.tr%' or el.el_to like '%islamisohbet.gen.tr%' or el.el_to like '%istatistik.gen.tr%' or el.el_to like '%iznik.gen.tr%' or el.el_to like '%kangruplari.gen.tr%' or el.el_to like '%karsilastir.gen.tr%' or el.el_to like '%kavakli.gen.tr%' or el.el_to like '%kaybolanyillar.gen.tr%' or el.el_to like '%kizarkadas.gen.tr%' or el.el_to like '%mared.gen.tr%' or el.el_to like '%mma.gen.tr%' or el.el_to like '%kurandasevgi.gen.tr%' or el.el_to like '%kuranikerim.gen.tr%' or el.el_to like '%kurkehayir.gen.tr%' or el.el_to like '%kurtulussavasi.gen.tr%' or el.el_to like '%oyunculari.gen.tr%' or el.el_to like '%sarkisozum.gen.tr%' or el.el_to like '%manjaro.gen.tr%' or el.el_to like '%lada.gen.tr%' or el.el_to like '%matrak.gen.tr%' or el.el_to like '%mehmetcik.gen.tr%' or el.el_to like '%memekanseri.gen.tr%' or el.el_to like '%mesutyilmaz.gen.tr%' or el.el_to like '%mgz.gen.tr%' or el.el_to like '%mustafaaydin.gen.tr%' or el.el_to like '%mustafaeraslan.gen.tr%' or el.el_to like '%nazilli.gen.tr%' or el.el_to like '%nazimhikmet.gen.tr%' or el.el_to like '%ngbb.gen.tr%' or el.el_to like '%nur.gen.tr%' or el.el_to like '%ondokuz.gen.tr%' or el.el_to like '%onlinecanliradyo.gen.tr%' or el.el_to like '%osmanl%C4%B1700.gen.tr%' or el.el_to like '%psikoloji.gen.tr%' or el.el_to like '%pku.gen.tr%' or el.el_to like '%pide.gen.tr%' or el.el_to like '%picasa.gen.tr%' or el.el_to like '%pclabs.gen.tr%' or el.el_to like '%pacman.gen.tr%' or el.el_to like '%oyunsever.gen.tr%' or el.el_to like '%ova.gen.tr%' or el.el_to like '%osmanlipadisahlari.gen.tr%' or el.el_to like '%osmanlica.gen.tr%' or el.el_to like '%saanen.gen.tr%' or el.el_to like '%saatlerinanlamlari.gen.tr%' or el.el_to like '%sailormoon.gen.tr%' or el.el_to like '%saklicennet.gen.tr%' or el.el_to like '%sandikli.gen.tr%' or el.el_to like '%sarkisozum.gen.tr%' or el.el_to like '%meltem.gen.tr%' or el.el_to like '%wamp.gen.tr%' or el.el_to like '%uzunkopru.gen.tr%' or el.el_to like '%tv7.gen.tr%' or el.el_to like '%turkdili.gen.tr%' or el.el_to like '%turk-yunan.gen.tr%' or el.el_to like '%trafikisaretleri.gen.tr%' or el.el_to like '%trackmania.gen.tr%' or el.el_to like '%tosya.gen.tr%' or el.el_to like '%tefsir.gen.tr%' or el.el_to like '%sts.gen.tr%' or el.el_to like '%sporhaberleri.gen.tr%' or el.el_to like '%sosyalbilgiler.org%' or el.el_to like '%sosyalbilgiler.gen.tr%' or el.el_to like '%soma.gen.tr%' or el.el_to like '%so.gen.tr%' or el.el_to like '%sinope.gen.tr%' or el.el_to like '%sille.gen.tr%' or el.el_to like '%sgk.gen.tr%' or el.el_to like '%suryaniler.com%' or el.el_to like '%mansetistanbul.com%' or el.el_to like '%medyagunebakis.com%' or el.el_to like '%fandom.com%' or el.el_to like '%groups.google.com%' or el.el_to like '%groups.yahoo.com%' or el.el_to like '%reddit.com%' or el.el_to like '%.tk/%/' or el.el_to like '%.gq/%/' or el.el_to like '%.ml/%/' or el.el_to like '%.ga/%/' or el.el_to like '%.cf/%/' or el.el_to like '%mydictionary.dyndns.org%' or el.el_to like '%birnebun.com%' or el.el_to like '%netfirms.com%' or el.el_to like '%bilgilik.com%' or el.el_to like '%arayan.com%' or el.el_to like '%degisimmedya.com%' or el.el_to like '%kaknus.com%' or el.el_to like '%biyografi.net%' or el.el_to like '%karalahana.com%' or el.el_to like '%hemensaglik.com%' or el.el_to like '%turkuler.com%' or el.el_to like '%alternatifim.com%' or el.el_to like '%kalemguzeli.net%' or el.el_to like '%islamawareness.net%' or el.el_to like '%turkedebiyatiisimlersozlugu.com%' or el.el_to like '%ankarakalesi.com%' or el.el_to like '%porttakal.com%' or el.el_to like '%renkhaber.com%' or el.el_to like '%yasamoykusu.com%' or el.el_to like '%orgfree.com%' or el.el_to like '%edebiyatvesanatakademisi.com%' or el.el_to like '%pspciyiz.biz%' or el.el_to like '%mathforum.org%' or el.el_to like '%kickassclassical.com%' or el.el_to like '%axishistory.com%' or el.el_to like '%edebi.net%' or el.el_to like '%kolonin.org%' or el.el_to like '%turkdiliveedebiyati.com%' or el.el_to like '%deyerler.org%' or el.el_to like '%derkenar.com%' or el.el_to like '%striphaber.com%' or el.el_to like '%yemekliz.com%' or el.el_to like '%dervisan.com%' or el.el_to like '%mustinet.net%' or el.el_to like '%magazinhaberleri.com%' or el.el_to like '%medyagunebakis.com%' or el.el_to like '%egehaber.com%' or el.el_to like '%mansetistanbul.com%' or el.el_to like '%gazetevahdet.com%' or el.el_to like '%polisinsesi.com%' or el.el_to like '%demokrasihaber.com' or el.el_to like '%ciddigazete.com%' or el.el_to like '%medium.com%' or el.el_to like '%kodamcasi.com%' or el.el_to like '%mekanizmalar.com%' or el.el_to like '%art.blog%' or el.el_to like '%business.blog%' or el.el_to like '%car.blog%' or el.el_to like '%code.blog%' or el.el_to like '%data.blog%' or el.el_to like '%design.blog%' or el.el_to like '%family.blog%' or el.el_to like '%fashion.blog%' or el.el_to like '%finance.blog%' or el.el_to like '%fitness.blog%' or el.el_to like '%food.blog%' or el.el_to like '%game.blog%' or el.el_to like '%health.blog%' or el.el_to like '%home.blog%' or el.el_to like '%law.blog%' or el.el_to like '%movie.blog%' or el.el_to like '%music.blog%' or el.el_to like '%news.blog%' or el.el_to like '%photo.blog%' or el.el_to like '%poetry.blog%' or el.el_to like '%politics.blog%' or el.el_to like '%school.blog%' or el.el_to like '%science.blog%' or el.el_to like '%sport.blog%' or el.el_to like '%tech.blog%' or el.el_to like '%travel.blog%' or el.el_to like '%video.blog%' or el.el_to like '%water.blog%' or el.el_to like '%freepgs.com%' or el.el_to like '%khosann.com%' or el.el_to like '%kimkimdir.tv%' or el.el_to like '%neoldu.com%' or el.el_to like '%biyografistan.com%' or el.el_to like '%kimnereli.net%' or el.el_to like '%ismininanlamianalizi.com%' or el.el_to like '%kpssbilimleri.com%' or el.el_to like '%kpsskonu.com%' or el.el_to like '%turkedebiyati.org%' or el.el_to like '%000webhostapp.com%' or el.el_to like '%site88.net%' or el.el_to like '%web44.net%' or el.el_to like '%net78.net%' or el.el_to like '%net46.net%' or el.el_to like '%net63.net%' or el.el_to like '%net76.net%' or el.el_to like '%net84.net%' or el.el_to like '%site40.net%' or el.el_to like '%site90.com%' or el.el_to like '%site50.net%' or el.el_to like '%site90.net%' or el.el_to like '%net23.net%' or el.el_to like '%comze.com%' or el.el_to like '%comoj.com%' or el.el_to like '%comli.com%' or el.el_to like '%comyr.com%' or el.el_to like '%comuf.com%' or el.el_to like '%comuv.com%' or el.el_to like '%netau.net%' or el.el_to like '%netii.net%' or el.el_to like '%netne.net%' or el.el_to like '%host22.com%' or el.el_to like '%comxa.com%' or el.el_to like '%host56.com%' or el.el_to like '%hostei.com%' or el.el_to like '%hostoi.com%' or el.el_to like '%hostzi.com%' or el.el_to like '%net16.net%' or el.el_to like '%webatu.com%' or el.el_to like '%comlu.com%' or el.el_to like '%netai.net%' or el.el_to like '%site11.com%' or el.el_to like '%webege.com%' or el.el_to like '%webuda.com%' or el.el_to like '%vacau.com%' or el.el_to like '%freeiz.com%' or el.el_to like '%herobo.com%' or el.el_to like '%uphero.com%' or el.el_to like '%comeze.com%' or el.el_to like '%comule.com%' or el.el_to like '%c1.biz%' or el.el_to like '%haberdemeti.com%' or el.el_to like '%aktifhaber.com%' or el.el_to like '%strategyturk.com%' or el.el_to like '%habergazetesi.com.tr%' or el.el_to like '%spinnen-forum.de%' or el.el_to like '%kenthaber.com%' or el.el_to like '%habervitrini.com%' or el.el_to like '%edebiyathaber.net%' or el.el_to like '%haber1903.com%' or el.el_to like '%haksozhaber.net%' or el.el_to like '%haber61.net%' or el.el_to like '%akhisarhaber.com%' or el.el_to like '%arages.de%' or el.el_to like '%gazetegercek.com.tr%' or el.el_to like '%samsungazetesi.com%' or el.el_to like '%dengegazetesi.com.tr%' or el.el_to like '%bugazete.com%' or el.el_to like '%forumromanum.org%' or el.el_to like '%xda-developers.com%' or el.el_to like '%nuveforum.net%' or el.el_to like '%forumancientcoins.com%' or el.el_to like '%forum.hrt.hr%' or el.el_to like '%forum.donanimhaber.com%' or el.el_to like '%samsunhaber.com%' or el.el_to like '%haberexen.com%' or el.el_to like '%haberaktuel.com%' or el.el_to like '%haber10.com%' or el.el_to like '%haberciniz.biz%' or el.el_to like '%superhaber.tv%' or el.el_to like '%ajanshaber.com%' or el.el_to like '%nethaber.com%' or el.el_to like '%mynet.com%' or el.el_to like '%habervaktim.com%' or el.el_to like '%konhaber.com%' or el.el_to like '%haber3.com%' or el.el_to like '%haber5.com%' or el.el_to like '%samsunkenthaber.com%' or el.el_to like '%ilkehaber.com%' or el.el_to like '%hurhaber.com%' or el.el_to like '%haberpan.com%' or el.el_to like '%haberankara.com%' or el.el_to like '%demokrathaber.org%' or el.el_to like '%demokrathaber.net%' or el.el_to like '%dogruhaber.com.tr%' or el.el_to like '%haber365.com.tr%' or el.el_to like '%haberx.com%' or el.el_to like '%malatyahaber.com%' or el.el_to like '%haberkulesi.com%' or el.el_to like '%pusulahaber.com.tr%' or el.el_to like '%habershow.com%' or el.el_to like '%haberport.com%' or el.el_to like '%rotahaber.com%' or el.el_to like '%haberevet.com%' or el.el_to like '%ankarahaber.com%' or el.el_to like '%haberekspres.com.tr%' or el.el_to like '%insanhaber.com%' or el.el_to like '%diclehaber.com%' or el.el_to like '%merhabahaber.com%' or el.el_to like '%yuksekovahaber.com%' or el.el_to like '%corumhaber.net%' or el.el_to like '%objektifhaber.com%' or el.el_to like '%samsunsonhaber.com%' or el.el_to like '%focushaber.com%' or el.el_to like '%haberhavadis.com%' or el.el_to like '%kanalahaber.com%' or el.el_to like '%sanathaber.net%' or el.el_to like '%haberiniz.com.tr%' or el.el_to like '%islahhaber.net%' or el.el_to like '%doktordanhaberler.com%' or el.el_to like '%risalehaber.com%' or el.el_to like '%sakaryayenihaber.com%' or el.el_to like '%baskahaber.org%' or el.el_to like '%haberrus.com%' or el.el_to like '%haberhurriyeti.com%' or el.el_to like '%egehaber.com%' or el.el_to like '%haberneo.com%' or el.el_to like '%trhaberler.com%' or el.el_to like '%haberfx.net%' or el.el_to like '%spothaber.com%' or el.el_to like '%tenishaber.com%' or el.el_to like '%haber34.com%' or el.el_to like '%habererk.com%' or el.el_to like '%canlihaber.com%' or el.el_to like '%abchaber.com%' or el.el_to like '%pusulagazetesi.com.tr%' or el.el_to like '%halkgazetesi.com.tr%' or el.el_to like '%erzurumgazetesi.com.tr%' or el.el_to like '%referansgazetesi.com%' or el.el_to like '%diyaloggazetesi.com%' or el.el_to like '%gunisigigazetesi.net%' or el.el_to like '%acikgazete.com%' or el.el_to like '%kocaeligazetesi.com.tr%' or el.el_to like '%anayurtgazetesi.com%' or el.el_to like '%gazeteyenigun.com.tr%' or el.el_to like '%gozlemgazetesi.com%' or el.el_to like '%gazetea24.com%' or el.el_to like '%karadenizgazete.com.tr%' or el.el_to like '%koroglugazetesi.com%' or el.el_to like '%gazetemag.com%' or el.el_to like '%izgazete.net%' or el.el_to like '%sesgazetesi.com.tr%' or el.el_to like '%gazetebirlik.com%' or el.el_to like '%ayakligazete.com.tr%' or el.el_to like '%meydangazetesi.com.tr%' or el.el_to like '%hudutgazetesi.com%' or el.el_to like '%gazeteyeniyuzyil.com%' or el.el_to like '%roportajgazetesi.com%' or el.el_to like '%tokathaber.com.tr%' or el.el_to like '%lpghaber.com%' or el.el_to like '%denizlihaber.com%' or el.el_to like '%kanalahaber.net%' or el.el_to like '%haberkktc.com%' or el.el_to like '%habername.com%' or el.el_to like '%haberdiyarbakir.com%' or el.el_to like '%habermonitor.com%' or el.el_to like '%murekkephaber.com%' or el.el_to like '%08haber.com%' or el.el_to like '%fibhaber.com%' or el.el_to REGEXP '(https?:\/\/|\.)haber.com' or el.el_to like '%magazinhaberleri.com%' or el.el_to like '%kartalhaber.com%' or el.el_to like '%striphaber.com%' or el.el_to like '%habervakti.com%' or el.el_to like '%haberkultur.net%' or el.el_to like '%showhaber.com%' or el.el_to like '%habera.com%' or el.el_to like '%haber24.com%' or el.el_to like '%nethabercilik.com%' or el.el_to like '%halkinhabercisi.com%' or el.el_to like '%haberform.com%' or el.el_to like '%ogunhaber.com%' or el.el_to like '%gaziantephaberler.com%' or el.el_to like '%bthaber.com%' or el.el_to like '%yenihaberden.com%' or el.el_to like '%yuksekovahaber.com.tr%' or el.el_to like '%duzgunhaber.com.tr%' or el.el_to like '%muzikhabercisi.com%' or el.el_to like '%cayhaber.net%' or el.el_to like '%bafrahaber.com%' or el.el_to like '%kurumsalhaberler.com%' or el.el_to like '%sonhaberler.com%' or el.el_to like '%haberdar.com.tr%' or el.el_to like '%habercem.com%' or el.el_to like '%windowsphonehaber.com%' or el.el_to like '%kitaphaber.com.tr%' or el.el_to like '%habervantv.com%' or el.el_to like '%itvhaber.com%' or el.el_to like '%borhaber.net%' or el.el_to like '%renkhaber.com%' or el.el_to like '%habergunluk.com%' or el.el_to like '%bbyhaber.com%' or el.el_to like '%haberajans.com%' or el.el_to like '%istanbulhaber.com.tr%' or el.el_to like '%turizmhabercisi.com%' or el.el_to like '%girisimhaber.com%' or el.el_to like '%haber46.com%' or el.el_to like '%haberartiturk.com%' or el.el_to like '%hakkarihabertv.com%' or el.el_to like '%etikhaber.com%' or el.el_to like '%nucehaber.com%' or el.el_to like '%ohaber.com%' or el.el_to like '%tigrishaber.com%' or el.el_to like '%haber365.com.tr%' or el.el_to like '%siyasihaber3.org%' or el.el_to like '%mersinhaberci.com%' or el.el_to like '%61haber.com%' or el.el_to like '%manisahaberleri.com%' or el.el_to like '%rotahaber.com%' or el.el_to like '%olayhaberler.com%' or el.el_to like '%.gen.al%' or el.el_to like '%erphaber.com%' or el.el_to like '%haberdesin.com%' or el.el_to like '%sosyalmedyahaber.com%' or el.el_to like '%araklihaber.net%' or el.el_to like '%farklihaber8.com%' or el.el_to like '%haberexpres.com.tr%' or el.el_to like '%haber53.com%' or el.el_to like '%akcaabathaber.com%' or el.el_to like '%tv5haber.com%' or el.el_to like '%haber50.com%' or el.el_to like '%sancaktepehaber.pro%' or el.el_to like '%turkiyehaberajansi.com%' or el.el_to like '%siyasihaber.org%' or el.el_to like '%artukluhaber.net%' or el.el_to like '%anahaberim.com%' or el.el_to like '%sabithaber.com%' or el.el_to like '%e5haber.com%' or el.el_to like '%cicegim.net%' or el.el_to like '%androhaber.net%' or el.el_to like '%etkihaber.com%' or el.el_to like '%ankaradanhaber.com%' or el.el_to like '%haber29.net%' or el.el_to like '%tarafsizhaberajansi.com%' or el.el_to like '%ilgazetesi.com.tr%' or el.el_to like '%sakaryagazetesi.com.tr%' or el.el_to like '%gazetearena.com%' or el.el_to like '%gazetevan.com%' or el.el_to like '%edirnegazetesi.com.tr%' or el.el_to like '%gorunumgazetesi.net%' or el.el_to like '%ekipgazetesi.com%' or el.el_to like '%yenigungazetesi.com.tr%' or el.el_to like '%gazetesok.com%' or el.el_to like '%muzikgazetesi.com%' or el.el_to like '%anadolugazetesi.net%' or el.el_to like '%karsigazete.com%' or el.el_to like '%anadolugazetesi.com%' or el.el_to like '%denizligazetesi.com%' or el.el_to like '%gazetetrakya.com%' or el.el_to like '%fenerbahcegazetesi.com%' or el.el_to like '%gercekgazetesi.net%' or el.el_to like '%istikbalgazetesi.com%' or el.el_to like '%hizligazeteci.com%' or el.el_to like '%takagazete.com%' or el.el_to like '%safakgazete.com%' or el.el_to like '%gazeteoku.com%' or el.el_to like '%ayakligazete.com%' or el.el_to like '%gunaydingazetesi.com.tr%' or el.el_to like '%ayazagagazetesi.com%' or el.el_to like '%kocaelibarisgazetesi.com%' or el.el_to like '%kocatepegazetesi.com%' or el.el_to like '%resmi-gazete.org%' or el.el_to like '%flasgazetesi.com.tr%' or el.el_to like '%gundemgazetesi.net%' or el.el_to like '%gencgazete.net%' or el.el_to like '%netgazetesi.net%' or el.el_to like '%boyabatgazetesi.com%' or el.el_to like '%ortamgazetesi.com%' or el.el_to like '%ordugazete.com%' or el.el_to like '%antakyagazetesi.com%' or el.el_to like '%yildirimgazetesi.com%' or el.el_to like '%karsigazete.com.tr%' or el.el_to like '%kastamonugazetesi.com.tr%' or el.el_to like '%vansesigazetesi.com%' or el.el_to like '%gazetemerhaba.com%' or el.el_to like '%umutgazetesi4.org%' or el.el_to like '%gazeteilksayfa.com%' or el.el_to like '%forum.newsarama.com%' or el.el_to like '%vosforums.com%' or el.el_to like '%forum.paradoxplaza.com%' or el.el_to like '%katyperryforum.com%' or el.el_to like '%forumer.com%' or el.el_to like '%goldderbyforums.latimes.com%' or el.el_to like '%dvdforum.org%' or el.el_to like '%forum.shiftdelete.net%' or el.el_to like '%forum.nokia.com%' or el.el_to like '%inforum.com%' or el.el_to like '%forum.alanwake.com%' or el.el_to like '%forum.nasaspaceflight.com%' or el.el_to like '%maxihaber.net%' or el.el_to like '%haberbosnak.com%' or el.el_to like '%pirsushaber.com%' or el.el_to like '%gunhaber.com.tr%' or el.el_to like '%zeytinburnuhaber.org%' or el.el_to like '%trabzonhaber.com.tr%' or el.el_to like '%mersinhaber.com%' or el.el_to like '%8gunhaber.com%' or el.el_to like '%haber1.com%' or el.el_to like '%mirhaber.com%' or el.el_to like '%45haber.com%' or el.el_to like '%gokyuzuhaberci.com%' or el.el_to like '%ortakhaber.com%' or el.el_to like '%birincilighaber.com%' or el.el_to like '%haberveriyorum.net%' or el.el_to like '%haberedikkat.com%' or el.el_to like '%duzceyerelhaber.com%' or el.el_to like '%haberimport.com%' or el.el_to like '%habergazete.com%' or el.el_to like '%samsunhaber.tc%' or el.el_to like '%kizilcahamamhaber.com%' or el.el_to like '%paritehaber.com%' or el.el_to like '%haberruzgari.com%' or el.el_to like '%haberyapi.com%' or el.el_to like '%aydin24haber.com%' or el.el_to like '%sonhaber.com.tr%' or el.el_to like '%jenhaber.com%' or el.el_to like '%kalehaber.net%' or el.el_to like '%dihaber.net%' or el.el_to like '%haberaks.com.tr%' or el.el_to like '%mersinimecehaber.com%' or el.el_to like '%guncelhaber.com%' or el.el_to like '%ilkhabergazetesi.com%' or el.el_to like '%haberinyeri.net%' or el.el_to like '%gencturkhaber.com%' or el.el_to like '%cubukhaber.com%' or el.el_to like '%haberts.com%' or el.el_to like '%haberunye.com%' or el.el_to like '%santralhaber.com%' or el.el_to like '%bighaber.com%' or el.el_to like '%haberdelisi.com%' or el.el_to like '%habercumhuriyeti.com%' or el.el_to like '%bandirmahaber.net%' or el.el_to like '%firathaberajansi.org%' or el.el_to like '%igdirhaber.net%' or el.el_to like '%tarafsizhaber.com%' or el.el_to like '%nethaberci.com%' or el.el_to like '%palhaber.com%' or el.el_to like '%haberdokuz.com%' or el.el_to like '%urfahaber24.com%' or el.el_to like '%haberskop.com%' or el.el_to like '%elazighakimiyethaber.com%' or el.el_to like '%habertaraf.com%' or el.el_to like '%haber.tr.msn.com%' or el.el_to like '%msn.com/tr-tr/haber%' or el.el_to like '%efestenhaberler.com%' or el.el_to like '%sirkethaberleri.com%' or el.el_to like '%vitrinhaber.com%' or el.el_to like '%forum.outdoorhaber.com%' or el.el_to like '%usakhabermerkezi.com%' or el.el_to like '%megahaber.net%' or el.el_to like '%haberhakki.com%' or el.el_to like '%haberajanda.com.tr%' or el.el_to like '%haberlink.com%' or el.el_to like '%midyathaber.com%' or el.el_to like '%israhaber.com%' or el.el_to like '%kentselhaber.com%' or el.el_to like '%habersahifesi.com%' or el.el_to like '%reyhaber.com%' or el.el_to like '%haberden.com%' or el.el_to like '%belgehaber.com%' or el.el_to like '%askerhaber.com%' or el.el_to like '%habertut.com%' or el.el_to like '%haberkonseyi.com%' or el.el_to like '%arguvanhaber.com%' or el.el_to like '%haberkita.com%' or el.el_to like '%rasthaber.com%' or el.el_to like '%haberalemi.net%' or el.el_to like '%afyonhaber.com%' or el.el_to like '%hinishaber.net%' or el.el_to like '%bursahaber.com%' or el.el_to like '%ulkehaber.com%' or el.el_to like '%haber11.net%' or el.el_to like '%haberyirmibir.com%' or el.el_to like '%vuslathaber.com%' or el.el_to like '%manisakulishaber.com%' or el.el_to like '%yerelhaberim.net%' or el.el_to like '%yirmidorthaber.com%' or el.el_to like '%haberfark.net%' or el.el_to like '%kadinhaberleri.com%' or el.el_to like '%stargundem.com%' or el.el_to like '%kayserihaber.com.tr%' or el.el_to like '%serihaber.net%' or el.el_to like '%siyasihaber2.org%' or el.el_to like '%medyahaber.com%' or el.el_to like '%demokrathaber1.net%' or el.el_to like '%haberiyakala.com%' or el.el_to like '%ilkehaber.com%' or el.el_to like '%haberay.com.tr%' or el.el_to like '%semdinlihaber.gen.tr%' or el.el_to like '%haberdarende.com%' or el.el_to like '%hocvanhabergazetesi.com%' or el.el_to like '%sadecehaber.com%' or el.el_to like '%golcukhaber.com.tr%' or el.el_to like '%sechaber.com.tr%' or el.el_to like '%yarinhaber.net%' or el.el_to like '%sinehaber.com%' or el.el_to like '%tarsushaber.com%' or el.el_to like '%5n1khaber.com%' or el.el_to like '%imarhaber.com%' or el.el_to like '%haberizlenim.com%' or el.el_to like '%kayseriehaber.com%' or el.el_to like '%diplomasimuhabirhaber.com%' or el.el_to like '%kapsamhaber.com%' or el.el_to like '%belediyehaber.tv%' or el.el_to like '%urfahabertv.com%' or el.el_to like '%pencerehaber.com%' or el.el_to like '%hendekhaber.com.tr%' or el.el_to like '%samsuninternethaber.com%' or el.el_to like '%tumhaber.com.tr%' or el.el_to like '%haber5.com%' or el.el_to like '%haber71.net%' or el.el_to like '%motohaber.com%' or el.el_to like '%haberdemeti.com%' or el.el_to like '%haberyurdum.com%' or el.el_to REGEXP '(https?:\/\/|\.)tnn.net' or el.el_to like '%habersizdim.com%' or el.el_to like '%haberortak.com%' or el.el_to like '%parlamentohaber.com%' or el.el_to like '%habervole.com%' or el.el_to like '%kuluhaber.net%' or el.el_to like '%haberkonya.com%' or el.el_to like '%kitaphaber.net%' or el.el_to like '%53habermerkezi.net%' or el.el_to like '%haberinrotasi.com%' or el.el_to like '%bodrumhaber.com%' or el.el_to like '%alevihaberajansi.com%' or el.el_to like '%habermuzik.com%' or el.el_to like '%eregliyenihaber.com%' or el.el_to like '%yorumcahaber.com%' or el.el_to like '%haberakademi.net%' or el.el_to like '%haber.ekolay.net%' or el.el_to like '%kalkanhaber.com%' or el.el_to like '%durushaber.com%' or el.el_to like '%reyhanlioncuhaber.com%' or el.el_to like '%konyahaber.com%' or el.el_to like '%yarenturkhaber.com%' or el.el_to like '%manisahabergazetesi.com.tr%' or el.el_to like '%ozgurhaber.com%' or el.el_to like '%haberpodium.com%' or el.el_to like '%uyduhaberlesme.com%' or el.el_to REGEXP '(https?:\/\/|\.)haberler.com' or el.el_to like '%lazhaber.com%' or el.el_to like '%32gunhaber.com%' or el.el_to like '%bolgehaber67.net%' or el.el_to like '%gebzehaber.net%' or el.el_to like '%sanatsalhaber.com%' or el.el_to like '%kuzeyhaber.com%' or el.el_to like '%basketbolhaber.com%' or el.el_to like '%trabzonemlak.com%' or el.el_to like '%haberita.com%' or el.el_to like '%yenihabergazetesi.net%' or el.el_to like '%kaynarcahaber.com%' or el.el_to like '%kadinhaberleri.net%' or el.el_to like '%haberci.com%' or el.el_to like '%haberci53.com%' or el.el_to like '%yeryuzuhaber.com%' or el.el_to like '%adanahabermerkezi.com%' or el.el_to like '%sunhaber.com%' or el.el_to like '%birikimhaber.com%' or el.el_to like '%beypazarihabertv.com%' or el.el_to like '%.kk.tc%' or el.el_to like '%erzurumhabergazetesi.com%' or el.el_to like '%hicrethaber.com%' or el.el_to like '%sutunhaber.com%' or el.el_to like '%manavgathaberi.com%' or el.el_to like '%haber37.net%' or el.el_to like '%inovatifhaber.com%' or el.el_to like '%yaylahaber.com%' or el.el_to like '%moralhaber.net%' or el.el_to like '%haber.turk.net%' or el.el_to like '%akishaber.net%' or el.el_to like '%erkhaber.com%' or el.el_to like '%ekohaber.com.tr%' or el.el_to like '%haber1919.com%' or el.el_to like '%konyahaberler.com%' or el.el_to like '%karsiyakahaber.com%' or el.el_to like '%marastahaber.com%' or el.el_to like '%arthaber.net%' or el.el_to like '%marmarahaber.net%' or el.el_to like '%salpazarihaber.com%' or el.el_to like '%edirnesonhaber.com%' or el.el_to like '%gophaber.com%' or el.el_to like '%medyahabercisi.com%' or el.el_to like '%erzurumhaber25.com%' or el.el_to like '%gazeteler.be%' or el.el_to like '%superyenihaber.net%' or el.el_to like '%edebiyathaberleri.com%' or el.el_to like '%merkurhaber.com%' or el.el_to like '%haberartibir.com.tr%' or el.el_to like '%haberanaliz.net%' or el.el_to like '%yildizhaber.com%' or el.el_to like '%yerelhaberci.com.tr%' or el.el_to like '%haberinvakti.com%' or el.el_to like '%turkhaber.com.ua%' or el.el_to like '%rotahaber.com%' or el.el_to like '%tvemhaber.com%' or el.el_to like '%samsunkulishaber.com%' or el.el_to like '%haberfedai.com%' or el.el_to like '%sureklihaber.com%' or el.el_to like '%akdenizhaberler.net%' or el.el_to like '%habersakarya.com%' or el.el_to like '%presshaber.com%' or el.el_to like '%korhaber.com%' or el.el_to like '%habertempo.net%' or el.el_to like '%haberekspresi.net%' or el.el_to like '%habermrt.com%' or el.el_to like '%haberakar.com%' or el.el_to like '%dizihaber.tv%' or el.el_to like '%otekihaber.net%' or el.el_to like '%haberahval.com%' or el.el_to like '%haberdeposu.net%' or el.el_to like '%haberyazar.com%' or el.el_to like '%habersirasi.com%' or el.el_to like '%serhadhaber.com%' or el.el_to like '%haberlerim.com.tr%' or el.el_to like '%haberlermersin.com%' or el.el_to like '%haberra.com%' or el.el_to like '%haberdizayn.com%' ) AND (el.el_to NOT LIKE '%googleblog.blogspot%' AND el.el_to NOT LIKE '%googlepress.blogspot%' AND el.el_to NOT LIKE '%googleforwork.blogspot%' AND el.el_to NOT LIKE '%googledocs.blogspot%' AND el.el_to NOT LIKE '%googledrive.blogspot%' AND el.el_to NOT LIKE '%nisanyan1.blogspot%' AND el.el_to NOT LIKE '%google-opensource.blogspot%' AND el.el_to NOT LIKE '%gmailblog.blogspot%' AND el.el_to NOT LIKE '%googlesystem.blogspot%' AND el.el_to NOT LIKE '%nisanyan.blogspot%' AND el.el_to NOT LIKE '%googleonlinesecurity.blogspot%' AND el.el_to NOT LIKE '%googleresearch.blogspot%' AND el.el_to NOT LIKE '%googlemobile.blogspot%' AND el.el_to NOT LIKE '%googlevideo.blogspot%' AND el.el_to NOT LIKE '%wikimapiablog.blogspot%' ) GROUP BY page_title ORDER BY cnt desc;
By running queries you agree to the
Cloud Services Terms of Use
and you irrevocably agree to release your SQL under
CC0 License
.
Submit Query
Stop Query
All SQL code is licensed under
CC0 License
.
Checking query status...