Wikiprojekti:Ympäristötiede Wikipediaan/tmp

MariaDB [fiwiki_p]> select pl_title, group_concat(distinct(actor_name), " ") as actor_names, (max(rc_new_len) - min(rc_old_len)) as diff_len, concat("", rc_this_oldid,"&oldid=", min(rc_last_oldid), " diff") as diff from page as p1, pagelinks, recentchanges, actor, page as p2 where p2.page_id=rc_cur_id and p2.page_title=rc_title and p1.page_title IN ("Ympäristötiede_Wikipediaan/tmp", "Ympäristötiede_Wikipediaan", "Viikon_kilpailu/Viikon_kilpailu_2020-03") and p1.page_namespace IN (106, 4) and pl_from=p1.page_id and rc_title=pl_title and rc_actor=actor_id and rc_source IN ("mw.new", "mw.edit" ) and rc_namespace=0 and rc_timestamp > 20200113000649 and p2.page_is_redirect=0 group by rc_title;

pl_title actor_names diff_len diff
Abbottinsukeltaja-antilooppi Jnovikov ,Mira S. 488 diff
Afrikanpikkukalastaja Nitraus ,MAQuire 4256 diff
Akvaattiset_tieteet Urjanhai 28 diff
Alue_ja_ympäristö Urjanhai 48 diff
Anders_Ångström_(meteorologi) MAQuire 13 diff
Ankerias Jnovikov 1654 diff
Anne_Kumpula Paju 8 diff
Ari_Ekroos Paju 5746 diff
Aspergillus MAQuire 2 diff
Bassaminkaijamahonki Jnovikov 7 diff
Bert_Bolin MAQuire 11 diff
Biodiversiteetti Savir ,Tapani.Hopkins 3194 diff
Biogeokemiallinen_kierto Pratodellaspiaggia 235 diff
Biologinen_museo Urjanhai 5 diff
Biopuhdistus Pratodellaspiaggia 804 diff
Biotooppi Urjanhai 374 diff
Bonnin_sopimus Tappinen 2560 diff
CITES Annakatariina -32 diff
Copernicus-ohjelma Sakvaka 10298 diff
Denitrifikaatio Pratodellaspiaggia 614 diff
Dioksiinit Viinamakelainen 1036 diff
Ekologinen_kompensaatio Mira S. ,Spitonus123 10525 diff
Energiaköyhyys Paju 12213 diff
Forssan_luontomuseo Urjanhai 45 diff
Frank Paju 50 diff
Frank_Alois_Pitelka MAQuire 15 diff
Frank_Berninger Paju ,Anr 5672 diff
Globaali_etelä Kulttuurinavigaattori ,Linkkerpar 19324 diff
Global_Assessement_on_Biodiversity_and_Ecosystem_Services_-arviointiraportti Pratodellaspiaggia 1475 diff
Hajajätevesiasetus Vesihuoltaja 6567 diff
Hangon_lintuasema Priinia 946 diff
Harjakala Jnovikov 2024 diff
Harold_F._Greeney MAQuire 15 diff
Helle Ksiben 199 diff
Hiilijalanjälki Abc10 ,Samielge5678 1086 diff
Hiilinielu Ssoimaka 6856 diff
Hinku-verkosto VegeVenla ,Tappinen ,Lentokonefani 5371 diff
Hopeahanhikki Mira S. 713 diff
Huhtahanhikki Mira S. 10 diff
Humboldt-yliopisto Haltiamieli -13 diff
Huulisärki Jnovikov 2890 diff
Hävikkiruoka Evegolightly 710 diff
IPCC Nuuksu 4255 diff
Ihmistieteellinen_eläintutkimus Ratamaki ,Pratodellaspiaggia 408 diff
Ilmastoahdistus Pratodellaspiaggia 391 diff
Ilmaston_lämpenemisen_vaikutukset Alehikoi 3548 diff
Ilmastonmuutos 188.67.25.7 ,Ksiben ,Ipr1 ,AnnaElina ,62.148.126.19 ,AB 291 diff
Ilmastovahti Jtuom ,Jjanhone 5414 diff
Ilmastoviestintä AnnaElina ,Makkool ,89.27.51.87 ,Paju 19146 diff
Ilmo_Massa Paju ,Sulkakynä ,Urjanhai 4486 diff
Intergovernmental_Science-Policy_Platform_on_Biodiversity_and_Ecosystem_Services Pratodellaspiaggia ,Lentokonefani ,Jlehtoma ,Peter Kullberg 10596 diff
Intian_ilmatieteen_laitos Paju 7889 diff
Intianhanhikki Mira S. 545 diff
Isonauraja MAQuire 5 diff
Isosepelkalastaja MAQuire 5 diff
Itämeri Jni ,Syväkuura ,Jnovikov ,212.66.207.102 318 diff
Jaavankalastaja Nitraus ,MAQuire 3548 diff
Janne_Kotiaho Paju ,Jkotiaho 3221 diff
Japanin_ilmatieteen_laitos Paju 5112 diff
Japaninhanhikki Mira S. 5 diff
Jevonsin_paradoksi Pratodellaspiaggia 567 diff
John_Barnard_Dunning MAQuire 15 diff
Jousisoihtupuu Jnovikov 5763 diff
Jukka_Käyhkö 93.106.51.165 0 diff
Jukka_Salo Ileneebro 32 diff
Jyri_Seppälä Paju 5285 diff
Jyväskylän_yliopiston_tiedemuseo Haltiamieli 45 diff
Jää Syväkuura ,Nitraus 1682 diff
Jäämä Pratodellaspiaggia 2373 diff
Jäätikkö Syväkuura 10 diff
Kansalaistiede Sulkakynä ,TaruPeltola 5631 diff
Kartioakankaali Jnovikov ,Mira S. 1909 diff
Kati_Kulovesi Paju 8312 diff
Kaukokulkeutuminen Pratodellaspiaggia 985 diff
Keski-Suomen_luontomuseo Urjanhai 45 diff
Kestävän_kehityksen_tavoitteet Paju 40 diff
Keväthanhikki Mira S. 8 diff
Kieppi,_Kokkolan_luonnontieteellinen_museo Urjanhai 5 diff
Kirjokalastaja MAQuire 5 diff
Kolmivarvaskalastaja Nitraus ,MAQuire 3962 diff
Kreikansorva Jnovikov -192 diff
Kriittinen_eläintutkimus LottL ,ComradeUranium ,Kissa21782 5317 diff
Kristiina_Regina Paju 4009 diff
Kryosfääri Syväkuura ,J Hokkanen 340 diff
Kuivalaskeuma Pratodellaspiaggia 798 diff
Kultahanhikki Mira S. 239 diff
Kultasaippuakala Jnovikov ,KLS 2389 diff
Kuningaskalastaja MAQuire 5 diff
Kyttyräpäästäinen Tappinen ,James Chudrie ,Vyörykkä 1254 diff
Lajien_suojelu James Chudrie ,Tappinen ,MakelainenSanna ,Mira S. ,Annakatariina 1209 diff
Lajikuvaus Tapani.Hopkins ,Mira S. 276 diff
Lea_Kauppi Paju 3151 diff
Liitokala Jnovikov 2167 diff
Lintujen_suojelu Makkool -19 diff
Luettelo_Suomen_suurimmista_aurinkovoimaloista VegeVenla 276 diff
Luettelo_Suomessa_kasvavista_myrkkysienistä Puppe100 11 diff
Luonnontieteellinen_museo Haltiamieli 24 diff
Luontopaneeli Jkotiaho ,Pratodellaspiaggia 4087 diff
Luontopohjaiset_ratkaisut 193.166.21.102 825 diff
Luontosuhde Pynsa ,Mira S. ,Kissa21782 4624 diff
Luontotalo_Arkki Urjanhai 45 diff
Lännenhanhikki Mira S. 5 diff
M._King_Hubbert Haltiamieli 72 diff
Markku_Wilenius Suomalta 12 diff
Markus_Båth MAQuire 13 diff
Mehiläissyöjä MAQuire 4 diff
Metsäkulttuuri Mira S. ,JMLaine ,193.65.82.150 4546 diff
Metsän_hoitava_vaikutus Urjanhai 2070 diff
Metsäsuhde Iroida ,Mira S. 5781 diff
Mikko_Kolehmainen_(professori) Paju 5060 diff
Mindanaonkalastaja MAQuire 5 diff
Molukkienparatiisikalastaja MAQuire 5 diff
Mykobakteerit EilaTo 16 diff
Myrkkynääpikkä Puppe100 0 diff
Météo-France Paju 53 diff
Nepalinhanhikki Mira S. 599 diff
Nokkasärki Jnovikov 412 diff
Norjan_ilmatieteen_laitos Paju 4380 diff
Nukkahanhikki Mira S. 540 diff
Oranssimeriahven Jnovikov ,James Chudrie 190 diff
Orava Tappinen 286 diff
Paavo_Korhonen Haltiamieli 125 diff
Pahtahanhikki Mira S. 74 diff
Paljakkakilpiäinen Mira S. ,Arctic waterbody ,Kospo75 2570 diff
Paula_Kivimaa Paju 5483 diff
Pekka_Kauppi Paju ,Pratodellaspiaggia 2918 diff
Peltohanhikki Mira S. 254 diff
Petteri_Taalas MAQuire 85 diff
Pikkuhanhikki Mira S. 196 diff
Pikkumehiläissyöjä MAQuire 4 diff
Pintavesi Htm 18 diff
Planetaarinen_ruokavalio Risuranta ,Sulkakynä 3700 diff
Pohjanmaan_museo Urjanhai 5 diff
Pohjavesi 46.30.132.239 ,Jikonen 637 diff
Pohjoismaiset_ravitsemussuositukset Sulkakynä ,Ppntori 2303 diff
Polkurisakas Puppe100 540 diff
Porvoonseudun_eläinsuojeluyhdistys Puppe100 1229 diff
Potentilla_wrangelii Mira S. 36 diff
Punainen_kirja 83.145.195.17 ,Puppe100 ,Alehikoi 277 diff
Punakärpässieni Puppe100 1 diff
Pystyhanhikki Mira S. 38 diff
Pölyttäjä Pölyttäjä ,Mira S. 1804 diff
Rae Syväkuura 7 diff
Ramsarin_sopimus Pratodellaspiaggia ,Tappinen 920 diff
Ranja_Hautamäki Maisema-arkkitehti 2597 diff
Rentohanhikki Mira S. 240 diff
Ria_Ruokonen Maisema-arkkitehti 3372 diff
Ruijanpahtahanhikki Mira S. 562 diff
Ruokahävikki Puppe100 ,Sinivuo ,Evegolightly 1431 diff
Rusutjärvi 81.197.163.5 ,Rockys Traffic videos ,Vyörykkä ,KLS ,Urjanhai ,83.245.241.21 1518 diff
Ruth_Patrick MAQuire 17 diff
Rätvänä Mira S. 5 diff
SMHI Paju 84 diff
Sakarahanhikki Mira S. 242 diff
Saksanhanhikki Mira S. 5 diff
Samuli_Siltanen Htm -45 diff
Savukaasu Pratodellaspiaggia 1852 diff
Sentinel Sakvaka 99 diff
Sentinel-sarja Sakvaka 16540 diff
Sisäilma Ksiben 472 diff
Soidensuojelualue Pätkänen 1755 diff
Sormihanhikit Mira S. 5 diff
Suikerohanhikki Mira S. 74 diff
Suo Pätkänen 3244 diff
Suokeltakerttu James Chudrie 19 diff
Suomen_ilmastopaneeli Paju 86 diff
Suomen_luontotyyppien_uhanalaisuus Urjanhai ,MakelainenSanna 2049 diff
Suomen_ympäristökeskus Paju -53 diff
Suosirri Arctic waterbody ,Lentokonefani 405 diff
Surukalastaja MAQuire 5 diff
Särki Jnovikov 1022 diff
Talitiaiset Haltiamieli 40 diff
Talousvesi 193.167.228.180 ,EilaTo 163 diff
Tampereen_Kivimuseo Haltiamieli 45 diff
Tampereen_luonnontieteellinen_museo Urjanhai ,Haltiamieli 317 diff
Tankar Priinia 131 diff
Timo_Järvikoski Sulkakynä ,Paju 3821 diff
Timo_Kumpula Urjanhai ,Paju 2625 diff
Titonia Jnovikov ,Mira S. 3390 diff
Trooppinen_hirmumyrsky Paju 27 diff
Tuamotunkalastaja MAQuire 4 diff
Tukholman_sopimus Pratodellaspiaggia 676 diff
Turkoosikillinen Jnovikov 2896 diff
Turun_yliopiston_eläinmuseo Urjanhai 49 diff
Turun_yliopiston_kasvimuseo Ileneebro ,Urjanhai 6037 diff
Typensidonta Pratodellaspiaggia 256 diff
Täplärisakas Puppe100 382 diff
Täyskierto Syväkuura ,J Hokkanen 1874 diff
Uhanalaisuus Annakatariina ,Mira S. 482 diff
Uhanalaisuusindeksi Alehikoi ,Mira S. 9031 diff
Uhanalaisuusluokitus Annakatariina 1904 diff
Uima-allas Anhok ,193.167.228.180 1391 diff
Valkovatsakalastaja MAQuire 5 diff
Varjostajahaikara Tappinen ,AB 2303 diff
Vedenkäsittely EilaTo 27 diff
Verihanhikki Mira S. 254 diff
Vesihuolto Jikonen ,46.30.132.239 ,Htm 852 diff
Vihermehiläissyöjä MAQuire 4 diff
Virikekasvatus KatjaHilskaKeinanen ,Tappinen 5705 diff
Vuoden_1973_öljykriisi Haltiamieli 11 diff
Yhteiskuntatieteellinen_ympäristötutkimus Urjanhai ,Sulkakynä ,Lentokonefani 7657 diff
Yhteiskuntatieteellisen_ympäristötutkimuksen_seura Pratodellaspiaggia ,Sulkakynä 6314 diff
Ympäristöahdistus Pratodellaspiaggia 211 diff
Ympäristöasiantuntijoiden_keskusliitto Pratodellaspiaggia ,Cary 206 diff
Ympäristöjohtaminen Samielge5678 1527 diff
Ympäristökansalaisuus Sulkakynä ,Urjanhai 3923 diff
Ympäristöoikeudenmukaisuus 193.166.21.102 7085 diff
Ympäristösuunnittelu Pratodellaspiaggia 440 diff
Ympäristötiede Pratodellaspiaggia 176 diff
Yrjö_Haila Anr -10 diff
Århusin_sopimus Pratodellaspiaggia 187 diff
Öljykenttä Haltiamieli 38 diff
pl_title actor_names diff_len diff

215 rows in set (0.21 sec)