Wikipedia:Fyrstu breytingarnar á íslensku Wikipediu

Úr Wikipediu, frjálsa alfræðiritinu

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)