Wikiprojekti:Ympäristötiede Wikipediaan/tmp
- Hae artikkelit jotka on luotu 16.1.2020 00:00: UTC jälkeen (40kpl)
- Hae artikkelit jotka on luotu 16.1.2020 00:00: UTC jälkeen ilman uudelleenohjauksia (30kpl)
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)