Hi,

again I analysed the actual old-table from the german wp. I know found no inconsitencies with the timestamps there. But in the cur-table the following inconsistencies appear (these are exactly the same in the cur-table from 20040313 and from 20040320). May someone can fix this...

-- Ivo Köthnig

ID : the ID of the article TS : the timestamp inv-TS : the inverse timestamp as it apears int the database inv(inv-TS): the inversion of the inverse timestamps which should be the same as TS but does not have this property Touched : timestamp of last touch?!

ID TS inv-TS inv(inv-TS) Touched 9690 20040205162458 79979075824895 20020924175104 20040205162458 10133 20040117225133 79979071868399 20020928131600 20040117230414 10771 20040217154352 79978993874855 20021006125144 20040217154352 11673 20040112202257 79978973876398 20021026123601 20040112202257 11861 20031215231821 79978970825656 20021029174343 20031215231821 16519 20040124122509 79969890815272 20030109184727 20040124122509 18115 20040222190045 79969876899549 20030123100450 20040222190045 20916 20040227204223 79969789897342 20030210102657 20040227204223 21549 20040128183118 79969784818379 20030215181620 20040128183118 21862 20040213160425 79969780878391 20030219121608 20040213160425 22267 20031217094940 79969776857895 20030223142104 20031217094940 22947 20040131171929 79969771858287 20030228141712 20040131171929 24267 20040228221146 79969684924884 20030315075115 20040228221146 25089 20031211031553 79969676854452 20030323145547 20031211031553 26860 20031223174853 79969588768857 20030411231142 20031223174853 27148 20031222215336 79969585804997 20030414195002 20031222215336 27490 20031213141210 79969581825144 20030418174855 20031213141210 28310 20040126155110 79969574884398 20030425115601 20040126155110 29741 20040104180550 79969493886996 20030506113003 20040104180550 29979 20031221190341 79969491917877 20030508082122 20031221190341 30229 20031215043433 79969490786070 20030509213929 20031215043433 30996 20031219235622 79969486827682 20030513172317 20031219235622 31382 20031208184550 79969484844687 20030515155312 20031208184550 31383 20031208190326 79969484844581 20030515155418 20031208190326 32945 20040112230453 79969478816763 20030521183236 20040112230453 33399 20040103231003 79969476878166 20030523121833 20040103231003 34269 20040112190355 79969472914954 20030527085045 20040112190355 36782 20040129104650 79969393839556 20030606160443 20040129104650 36948 20031217020511 79969392844365 20030607155634 20031217020511 37648 20040116040535 79969389847473 20030610152526 20040116040535 37886 20040205022002 79969388848353 20030611151646 20040205022002 38107 20040207190856 79969387856168 20030612143831 20040207190856 38108 20040207190857 79969387856150 20030612143849 20040207190857 38554 20040202033624 79969385806874 20030614193125 20040202033624 38796 20031221151754 79969383996868 20030616003131 20031221151754 38936 20040131114847 79969383817090 20030616182909 20040131114847 39603 20040216193323 79969380857575 20030619142424 20040216193323 39961 20040129121948 79969378915359 20030621084640 20040129121948 41892 20040207222904 79969297855641 20030702144358 20040207222904 42138 20031218234207 79969296817080 20030703182919 20031218234207 42427 20031219234727 79969295776774 20030704223225 20031219234727 43234 20040227131028 79969292774872 20030707225127 20040227131028 43306 20040120161048 79969291886940 20030708113059 20040120161048 43515 20031221210452 79969290896555 20030709103444 20031221210452 43516 20031221210453 79969290896555 20030709103444 20031221210453 44042 20040222130224 79969289776850 20030710223149 20040222130224 44591 20031224004218 79969286999478 20030713000521 20031224004218 46745 20040205191351 79969276867666 20030723132333 20040205191351 46836 20040124155542 79969275996682 20030724003317 20040124155542 48150 20040221172518 79969269778485 20030730221514 20040221172518 48151 20040221172521 79969269778484 20030730221515 20040221172521 48770 20031220184326 79969196877444 20030803122555 20031220184326 50566 20031212170343 79969188859275 20030811140724 20031212170343 51968 20040225142418 79969183817597 20030816182402 20040225142418 53470 20031210120502 79969176916382 20030823083617 20031210120502 53475 20031210120440 79969176915967 20030823084032 20031210120440 54410 20040228215848 79969172856651 20030827143348 20040228215848 54411 20040228215850 79969172856595 20030827143404 20040228215850 54457 20040204201901 79969172828297 20030827171702 20040226094431 55041 20040203112652 79969169779466 20030830220533 20040203112652 55486 20040225103737 79969097904561 20030902095438 20040225103737 56171 20040227021046 79969094807645 20030905192354 20040227021046 56748 20040224203321 79969091939846 20030908060153 20040224203321 60503 20040130152820 79969077896966 20030922103033 20040130152820 61074 20040214230647 79969075855252 20030924144747 20040214230647 62001 20031223230213 79969071939291 20030928060708 20031223230213 64140 20040218122626 79968997816443 20031002183556 20040218122626 64227 20040103133533 79968996904485 20031003095514 20040103133533 66858 20040207013815 79968989909459 20031010090540 20040207013815 72169 20031207114721 79968971848596 20031028151403 20031207114721 72785 20040204164925 79968968988150 20031031011849 20040204164925 73743 20031207114722 79968895859878 20031104140121 20031207114722 74031 20040225074748 79968894856992 20031105143007 20040225074748 74510 20040203070336 79968893788373 20031106211626 20040203070336 75077 20040302163432 79968891809780 20031108190219 20040302163432 75170 20040218155810 79968890998685 20031109001314 20040218155810 75360 20040211005127 79968890825674 20031109174325 20040211005127 75940 20040111150650 79968888824180 20031111175819 20040111150650 75941 20040111150652 79968888824177 20031111175822 20040111150652 76100 20040213213901 79968887899578 20031112100421 20040213213901 76206 20040229205745 79968887837972 20031112162027 20040229205745 77474 20031221120316 79968883866399 20031116133600 20031221120316 79293 20040116153523 79968878999993 20031121000006 20040116153523 79557 20031206213611 79968878826474 20031121173525 20031206221557 79558 20031206213611 79968878826473 20031121173526 20031206221557 80269 20040201012855 79968876777749 20031123222250 20040201012855 80310 20040224034902 79968875996467 20031124003532 20040224034902 80838 20040225151542 79968874817860 20031125182139 20040225151542 81064 20040106135913 79968873858868 20031126141131 20040106135913 81146 20040226214515 79968873797947 20031126202052 20040226214515 81159 20031208211048 79968873789291 20031126210708 20031208211048 81973 20031208220000 79968870898598 20031129101401 20031208220000 83245 20040203112655 79968797774749 20031202225250 20040203112655 84568 20040207223739 79968794914790 20031205085209 20040207223739 84861 20031206122610 79968793886980 20031206113019 20031206122610 85705 20031220190018 79968791896959 20031208103040 20031220190018 85814 20031224113857 79968791847982 20031208152017 20031224113857 86021 20031209190529 79968790996750 20031209003249 20031209190529 86523 20040125021428 79968790789853 20031209210146 20040125021428 86541 20040125022017 79968790787451 20031209212548 20040125022017 86736 20040224202949 79968789914365 20031210085634 20040224202949 88147 20040216164254 79968786864364 20031213135635 20040216164254 88199 20031221212844 79968786849678 20031213150321 20031221212844 88391 20031223131959 79968786786880 20031213213119 20031223131959 88392 20031223131959 79968786786880 20031213213119 20031223131959 88396 20031223131927 79968786786283 20031213213716 20031223131927 88513 20031214091341 79968785908959 20031214091040 20031214091341 88834 20031214221140 79968785804380 20031214195619 20031214221140 88956 20031218135326 79968784974072 20031215025927 20031218135326 89084 20031222104058 79968784884583 20031215115416 20031222104058 89089 20031215134716 79968784884345 20031215115654 20031215134716 89098 20031215173722 79968784878653 20031215121346 20031215173722 89193 20031217211700 79968784846563 20031215153436 20031217211700 89194 20031217211700 79968784846562 20031215153437 20031217211700 89201 20031215224420 79968784844947 20031215155052 20031215224420 90023 20040130105729 79968782885866 20031217114133 20040130105729 90073 20040102131157 79968782855462 20031217144537 20040102131157 91255 20031222070810 79968779864370 20031220135629 20031222070810 91310 20040212142213 79968779847768 20031220152231 20040212142213 91619 20031221151047 79968778878644 20031221121355 20031221151047 91621 20031221151114 79968778878388 20031221121611 20031221151114 92515 20031223215018 79968776787140 20031223212859 20031223215018 92798 20031226203025 79968774925873 20031225074126 20031226203025 92945 20031227115012 79968772885160 20031227114839 20031227115012 93593 20040226120953 79959898905849 20040101094150 20040226120953 93594 20040226121002 79959898905848 20040101094151 20040226121002 94135 20040111191217 79959897797863 20040102202136 20040111191217 94238 20040222215515 79959896969253 20040103030746 20040222215515 94279 20040103105912 79959896896694 20040103103305 20040103105912 95273 20040203170746 79959894884956 20040105115043 20040203170746 95751 20040225002710 79959893885173 20040106114826 20040225002710 96185 20040111144732 79959892854283 20040107145716 20040111144732 97241 20040212171517 79959889798357 20040110201642 20040212171517 97243 20040212171519 79959889798340 20040110201659 20040212171519 97730 20040112075313 79959888788874 20040111211125 20040112075313 97796 20040126155113 79959887987782 20040112012217 20040126155113 98181 20040206105600 79959887836656 20040112163343 20040206105600 98363 20040201001850 79959887775780 20040112224219 20040201001850 100311 20040118162125 79959881934280 20040118065719 20040118162125 101056 20040124213837 79959879865640 20040120134359 20040124213837 101060 20040120135423 79959879864743 20040120135256 20040120135423 101074 20040120142637 79959879857458 20040120142541 20040120142637 101106 20040120165336 79959879838878 20040120161121 20040120165336 101107 20040120165337 79959879838877 20040120161122 20040120165337 101127 20040120171830 79959879828255 20040120171744 20040120171830 101128 20040120171831 79959879828255 20040120171744 20040120171831 101131 20040120172313 79959879827751 20040120172248 20040120172313 101135 20040120173354 79959879826670 20040120173329 20040120173354 101142 20040120174547 79959879825485 20040120174514 20040120174547 101567 20040122063125 79959878838293 20040121161706 20040122063125 101568 20040208214423 79959878837961 20040121162038 20040208214423 102150 20040122205704 79959877806057 20040122193942 20040122205704 102436 20040203100443 79959875907581 20040124092418 20040203100443 102560 20040124171218 79959875828891 20040124171108 20040124171218 102687 20040125021429 79959874995878 20040125004121 20040125021429 103383 20040126154959 79959873845093 20040126154906 20040126154959 103384 20040126155000 79959873845089 20040126154910 20040126155000 103817 20040127210942 79959872789266 20040127210733 20040127210942 103915 20040129161402 79959871947862 20040128052137 20040129161402 104173 20040128183929 79959871816976 20040128183023 20040128184339 104754 20040204213534 79959869898784 20040130101215 20040204213534 104814 20040130121245 79959869884068 20040130115931 20040130121245 105959 20040201215321 79959798786572 20040201213427 20040201215321 105961 20040201215321 79959798786546 20040201213453 20040201215321 106018 20040303203726 79959797996968 20040202003031 20040303203726 106019 20040303203834 79959797996863 20040202003136 20040303203834 107033 20040204104603 79959796765351 20040203234648 20040204104603 107673 20040206104228 79959794987899 20040205012100 20040206104228 108293 20040205225439 79959794776347 20040205223652 20040205225439 108294 20040205225439 79959794776344 20040205223655 20040205225439 108488 20040206123732 79959793879062 20040206120937 20040206123732 108698 20040208164007 79959793818187 20040206181812 20040208164007 108936 20040207112812 79959792887469 20040207112530 20040207112812 109258 20040209110814 79959792767343 20040207232656 20040209110814 109314 20040220140112 79959791994270 20040208005729 20040220140112 109556 20040208121738 79959791886577 20040208113422 20040208121738 109563 20040209205645 79959791885257 20040208114742 20040209205645 109570 20040223122139 79959791884355 20040208115644 20040223122139 109949 20040209104747 79959790998693 20040209001306 20040209104747 110699 20040210195340 79959789838776 20040210161223 20040210195340 110914 20040211130502 79959788995878 20040211004121 20040211130502 110915 20040211130503 79959788995878 20040211004121 20040211130503 111110 20040225110717 79959788867591 20040211132408 20040225110717 111518 20040212214112 79959787849496 20040212150503 20040212214112 111766 20040229024030 79959787779682 20040212220317 20040229024030 111881 20040301160038 79959786909389 20040213090610 20040301160038 111882 20040301160040 79959786909386 20040213090613 20040301160040 112148 20040213213903 79959786805071 20040213194928 20040213213903 112215 20040214133414 79959786775865 20040213224134 20040214133414 113762 20040216172154 79959783828551 20040216171448 20040216172154 114559 20040217221242 79959782779281 20040217220718 20040217221242 115187 20040219001241 79959780999695 20040219000304 20040219001241 115793 20040220093232 79959779917149 20040220082850 20040220093232 116222 20040302145222 79959779798854 20040220201145 20040302145222 116426 20040221102244 79959778898667 20040221101332 20040221102244 116598 20040225140309 79959778838168 20040221161831 20040225140309 116614 20040221163915 79959778836551 20040221163448 20040221163915 117061 20040222094030 79959777906151 20040222093848 20040222094030 117066 20040222095044 79959777905054 20040222094945 20040222095044 117070 20040222095924 79959777904146 20040222095853 20040222095924 117073 20040222100218 79959777899854 20040222100145 20040222100218 117075 20040222100951 79959777899084 20040222100915 20040222100951 117079 20040222102522 79959777897646 20040222102353 20040222102522 117081 20040222103020 79959777897049 20040222102950 20040222103020 117083 20040222103401 79959777896666 20040222103333 20040222103401 117376 20040222180755 79959777819278 20040222180721 20040222180755 117379 20040222181115 79959777818951 20040222181048 20040222181115 117382 20040223173029 79959777818483 20040222181516 20040223173029 117383 20040222181830 79959777818198 20040222181801 20040222181830 117385 20040222182116 79959777817963 20040222182036 20040222182116 117388 20040222182430 79959777817645 20040222182354 20040222182430 117396 20040222183013 79959777817096 20040222182903 20040222183013 117401 20040222183539 79959777816491 20040222183508 20040222183539 117408 20040222184259 79959777815770 20040222184229 20040222184259 117416 20040222185133 79959777814976 20040222185023 20040222185133 117543 20040222215220 79959777784851 20040222215148 20040222215220 117981 20040223172832 79959776846195 20040223153804 20040223172832 117986 20040223154121 79959776845944 20040223154055 20040223154121 117993 20040223154449 79959776845577 20040223154422 20040223154449 117995 20040223154737 79959776845295 20040223154704 20040223154737 117997 20040223154951 79959776845076 20040223154923 20040223154951 118003 20040223155200 79959776844870 20040223155129 20040223155200 118009 20040223160603 79959776839483 20040223160516 20040223160603 118015 20040223161239 79959776838787 20040223161212 20040223161239 118020 20040223162331 79959776837783 20040223162216 20040223162331 118152 20040301195820 79959776798962 20040223201037 20040301195820 119150 20040224233425 79959775794744 20040224205255 20040224233425 119441 20040225080948 79959774919168 20040225080831 20040225080948 119460 20040225130121 79959774914946 20040225085053 20040225130121 119930 20040225161239 79959774838870 20040225161129 20040225161239 121299 20040226182223 79959773817865 20040226182134 20040226182223 121395 20040226194451 79959773805673 20040226194326 20040226194451 121522 20040227000134 79959773789577 20040226210422 20040227000134 121525 20040226235939 79959773789483 20040226210516 20040226235939 121594 20040227040715 79959773778697 20040226221302 20040227040715 121734 20040303144056 79959772998580 20040227001419 20040303144056 121798 20040227040714 79959772959373 20040227040626 20040227040714 122548 20040228002027 79959772776385 20040227223614 20040228002027 123635 20040229141606 79959770899795 20040229100204 20040229141606 123636 20040229141610 79959770899794 20040229100205 20040229141610 124014 20040229184839 79959770827684 20040229172315 20040229184839 124015 20040229184900 79959770827665 20040229172334 20040229184900 125109 20040301200440 79959698806646 20040301193353 20040301200440 125802 20040302094011 79959697914480 20040302085519 20040302094011 125954 20040302103432 79959697896940 20040302103059 20040302103432 127007 20040302201455 79959697798671 20040302201328 20040302201455 127633 20040303103834 79959696896354 20040303103645 20040303103834 127762 20040303140315 79959696879062 20040303120937 20040303140315 128232 20040303223605 79959696835849 20040303164150 20040303223605 128236 20040303223607 79959696835489 20040303164510 20040303223607