Wikipedia:Fyrstu breytingarnar á íslensku Wikipediu
 | Þessi grein er óvirk og henni er haldið eingöngu vegna sögulegs mikilvægis. |
The first 100 edits on the Icelandic Wikipedia gotten by quering the old table.
- mysql> select old_id,old_user_text,old_namespace,old_title,old_comment,old_timestamp from old order by old_timestamp asc limit 20;
+--------+---------------------------------------+---------------+-------------------------------------------+----------------------------------------------------------+----------------+ | old_id | old_user_text | old_namespace | old_title | old_comment | old_timestamp | +--------+---------------------------------------+---------------+-------------------------------------------+----------------------------------------------------------+----------------+ | 21 | 65.169.32.xxx | 4 | WIKIng | Bli' WIKIng | 20021206184337 | | 2 | cs78140190.pp.htv.fi | 0 | Finnland | * | 20031123234650 | | 3 | adsl2-33-176.du.simnet.is | 0 | Finnland | * | 20031205105410 | | 4 | adsl2-33-176.du.simnet.is | 0 | Finnland | * | 20031205105830 | | 17 | pc174-158.dis.uu.se | 0 | Finnland | * | 20031206230245 | | 16 | pc174-158.dis.uu.se | 0 | Svíþjóð | * | 20031206230624 | | 15 | pc174-158.dis.uu.se | 0 | Noregi | * | 20031206230742 | | 12 | pc174-158.dis.uu.se | 0 | Ísland | * | 20031218023639 | | 13 | 194-144-69-82.xdsl.is | 0 | Ísland | * | 20031220193752 | | 11 | 194-144-69-82.xdsl.is | 0 | Reykjavík | * | 20031220194031 | | 20 | Wolfram | 2 | Wolfram | * | 20031225100653 | | 5 | Wolfram | 0 | Forsíða | * | 20031226111554 | | 6 | 213-213-156-16.xdsl.is | 0 | Forsíða | * | 20040101043721 | | 7 | free3.cache.ed.ac.uk | 0 | Forsíða | * | 20040110160956 | | 8 | free3.cache.ed.ac.uk | 0 | Forsíða | * | 20040110161058 | | 9 | free3.cache.ed.ac.uk | 0 | Forsíða | * | 20040110161142 | | 10 | free3.cache.ed.ac.uk | 0 | Forsíða | * | 20040110161311 | | 23 | free3.cache.ed.ac.uk | 0 | Forsíða | * | 20040110161414 | | 63 | p50861801.dip.t-dialin.net | 0 | Ísland | * | 20040115233240 | | 14 | 213.237.48.112.adsl.ly.worldonline.dk | 0 | Reykjavík | * | 20040120215622 | | 397 | Brion VIBBER | 0 | HomePage | moved to "Main_Page" | 20040125134136 | | 44 | 81.187.43.179 | 0 | Reykjavík | +interwiki | 20040125165916 | | 19 | 81.187.43.179 | 0 | Noregi | +interwiki | 20040125170123 | | 18 | 81.187.43.179 | 0 | Svíþjóð | +interwiki | 20040125170332 | | 104 | 81.187.43.179 | 0 | Finnland | +interwiki | 20040125170549 | | 75 | 81.187.43.179 | 0 | Svíþjóð | | 20040125170617 | | 36 | 81.187.43.179 | 0 | Noregi | | 20040125170657 | | 22 | Wolfram | 2 | Wolfram | | 20040125201443 | | 147 | MediaWiki default | 10 | All_messages | | 20040129114408 | | 80 | Christian List | 4 | WIKIng | da: fi: fo: kl: no: sv: | 20040129181626 | | 143 | Wolfram | 4 | Recentchanges | | 20040130002537 | | 568 | 24.169.73.171 | 1 | Forsíða/Eldri_umræður | | 20040202235631 | | 27 | 212.30.222.56 | 0 | Forsíða | Lagaði html í aðalsíðu | 20040203194420 | | 24 | Sindri | 2 | Sindri | | 20040203205142 | | 39 | Sindri | 2 | Sindri | | 20040203205207 | | 25 | Sindri | 0 | Danmerkur | | 20040205123115 | | 26 | Sindri | 0 | Danmerkur | | 20040205131005 | | 96 | Sindri | 0 | Danmörk | | 20040205131441 | | 89 | Sindri | 0 | Evrópa | Setti inn lýsingu á staðsetningu | 20040205132618 | | 28 | Sindri | 0 | Forsíða | | 20040205132813 | | 29 | Sindri | 0 | Forsíða | | 20040205133633 | | 30 | Sindri | 0 | Forsíða | Bætti við texta um hvernig má afgreiða fallbeygingar | 20040205134400 | | 32 | Sindri | 0 | Forsíða | | 20040205134439 | | 5574 | Sindri | 0 | Nefnifall | | 20040205134717 | | 31 | Sindri | 0 | Föllum | | 20040205134837 | | 1146 | Sindri | 0 | Föll_í_íslensku | | 20040205135006 | | 33 | Sindri | 0 | Forsíða | | 20040205135301 | | 34 | Sindri | 0 | Forsíða | | 20040205135436 | | 35 | Sindri | 0 | Forsíða | | 20040205135509 | | 38 | Sindri | 0 | Forsíða | | 20040205135554 | | 37 | Sindri | 0 | Noregur | | 20040205140143 | | 57 | Sindri | 0 | Noregur | | 20040205140233 | | 40 | Sindri | 0 | Forsíða | | 20040205140639 | | 226 | Sindri | 2 | Sindri | | 20040205150349 | | 41 | Sindri | 0 | Forsíða | | 20040205152030 | | 42 | Sindri | 0 | Forsíða | | 20040205152250 | | 43 | Sindri | 0 | Forsíða | Bætti við linkum í nokkur atriði á forsíðunni | 20040206140729 | | 78 | Steinst | 0 | Forsíða | | 20040206195513 | | 45 | Steinst | 0 | Reykjavík | | 20040206202306 | | 46 | Steinst | 0 | Reykjavík | | 20040206202332 | | 47 | Steinst | 0 | Reykjavík | | 20040206205404 | | 48 | Steinst | 0 | Reykjavík | | 20040206205456 | | 49 | Steinst | 0 | Reykjavík | | 20040206205537 | | 50 | Steinst | 0 | Reykjavík | | 20040206210052 | | 51 | Steinst | 0 | Reykjavík | | 20040206211708 | | 52 | Steinst | 0 | Reykjavík | | 20040206211745 | | 53 | Steinst | 0 | Reykjavík | | 20040206211815 | | 54 | Steinst | 0 | Reykjavík | | 20040206211918 | | 55 | Steinst | 0 | Reykjavík | | 20040206212041 | | 56 | Steinst | 0 | Reykjavík | | 20040206212126 | | 86 | Steinst | 0 | Reykjavík | | 20040206212231 | | 58 | Steinst | 0 | Noregur | | 20040206212403 | | 59 | Steinst | 0 | Noregur | | 20040206214555 | | 60 | Steinst | 0 | Noregur | | 20040206214647 | | 62 | Steinst | 0 | Noregur | | 20040206214727 | | 87 | 129.215.13.83 | 0 | Borgarstjórar_í_Reykjavík | | 20040206235007 | | 82 | 129.215.13.83 | 0 | Auður_Auðuns | | 20040207000905 | | 61 | 129.215.13.83 | 0 | 18._febrúar | | 20040207001032 | | 81 | 129.215.13.83 | 0 | 18._febrúar | | 20040207001120 | | 107 | 129.215.13.83 | 0 | Noregur | | 20040207002358 | | 64 | 129.215.13.83 | 0 | Ísland | | 20040207012746 | | 65 | Steinst | 0 | Ísland | | 20040207013051 | | 66 | Steinst | 0 | Ísland | | 20040207013132 | | 67 | Steinst | 0 | Ísland | | 20040207013326 | | 70 | Steinst | 0 | Ísland | | 20040207013956 | | 68 | Steinst | 0 | Forsetar_Íslands | | 20040207014123 | | 97 | Steinst | 0 | Forsetar_Íslands | | 20040207014142 | | 1109 | Steinst | 0 | Saga_Íslands | | 20040207014238 | | 72 | Steinst | 0 | Íslensk_stjórnmál | | 20040207014303 | | 785 | Steinst | 0 | Sýslur_á_Íslandi | | 20040207014342 | | 259 | Steinst | 0 | Landafræði_Íslands | | 20040207014414 | | 83 | Steinst | 0 | Efnahagur_Íslands | | 20040207014436 | | 77 | Steinst | 0 | Lýðfræðilegar_upplýsingar_um_Ísland | | 20040207014458 | | 487 | Steinst | 0 | Íslensk_menning | | 20040207014533 | | 69 | Steinst | 0 | Lofsöngur | | 20040207014927 | | 156 | Steinst | 0 | Lofsöngur | | 20040207015022 | | 71 | Steinst | 0 | Ísland | | 20040207015110 | | 74 | Steinst | 0 | Ísland | | 20040207015203 | | 73 | Steinst | 0 | Íslensk_stjórnmál | | 20040207015248 | | 5283 | Steinst | 0 | Íslensk_stjórnmál | | 20040207015313 | +--------+---------------------------------------+---------------+-------------------------------------------+----------------------------------------------------------+----------------+ 100 rows in set (0.17 sec)
- mysql> select cur_id,cur_user_text,cur_namespace,cur_title,cur_comment,cur_timestamp from cur where cur_timestamp < 20040207015313 order by cur_timestamp asc;
mysql> select cur_id,cur_user_text,cur_namespace,cur_title,cur_comment,cur_timestamp from cur where cur_timestamp < 20040207015313 order by cur_timestamp asc; +--------+-------------------+---------------+----------------------+------------------------------+----------------+ | cur_id | cur_user_text | cur_namespace | cur_title | cur_comment | cur_timestamp | +--------+-------------------+---------------+----------------------+------------------------------+----------------+ | 1 | ArnoLagrange | 2 | ArnoLagrange | | 20031223091940 | | 13 | Angela | 0 | ArnoLagrange | moved to "User:ArnoLagrange" | 20040125164454 | | 14 | Angela | 0 | Wolfram | moved to "User:Wolfram" | 20040125164516 | | 16 | 62.92.53.130 | 4 | Most_wanted_articles | | 20040129094751 | | 33 | MediaWiki default | 10 | Sitesupportpage | | 20040129114320 | | 77 | MediaWiki default | 10 | Gnunote | | 20040129114320 | | 9 | Wolfram | 2 | Wolfram | | 20040130020125 | | 590 | Sindri | 0 | Danmerkur | | 20040205131111 | | 592 | Sindri | 0 | Evrópu | #redirect [[Evrópa]] | 20040205131559 | | 596 | Sindri | 0 | Nefnifalli | | 20040205134504 | | 598 | Sindri | 0 | Föllum | | 20040205134846 | | 5 | Sindri | 0 | Noregi | #redirect [[Noregur]] | 20040205140104 | | 601 | Sindri | 0 | Þágufalli | | 20040205150954 | | 606 | Steinst | 6 | ISLcoat.gif | Skjaldarmerki Íslands | 20040207013812 | +--------+-------------------+---------------+----------------------+------------------------------+----------------+ 14 rows in set (1.80 sec)