|
|
User:Topbanana/Reports/Duplicate article titleQuery last run on 2nd December 2004 against the 15th November 2004 DB dump. N.B.: This isn't a report as such - there's nothing a regular Wikipedian can do to fix the problem. See also:
mysql> select cur_namespace, cur_title, GROUP_CONCAT( cur_id )
-> from cur
-> group by cur_namespace,cur_title
-> having count(*) > 1;
+---------------+-------------------------------------------------+-------------------------------------------------+
| cur_namespace | cur_title | GROUP_CONCAT( cur_id ) |
+---------------+-------------------------------------------------+-------------------------------------------------+
| 0 | "hybrid_library" | 1130954,1130953 |
| 0 | Appellation_dÆOrigine_Contr¶lÚe | 1002048,1002049 |
| 0 | ArmazÚm | 1127073,1127072 |
| 0 | Ayia_Eirini_(Kefallinia),_Greece | 1105973,1105969 |
| 0 | BPPR | 518639,518640 |
| 0 | Bashar_Assad | 1146718,1146719 |
| 0 | Brazilian_Carnival | 1166834,1166833 |
| 0 | Bristol_Temple_Meads_station | 1146723,1146724 |
| 0 | Charles_O'Ferrall | 1146911,1146912 |
| 0 | Claude_de_Lorraine,_1er_duc_de_Guise | 1146734,1146735 |
| 0 | Coherences_condition | 1164886,1164763 |
| 0 | Earl_Sutherland_Jr. | 1146740,1146741 |
| 0 | Edward_Vere,_Earl_of_Oxford | 1146744,1146745 |
| 0 | Elafius | 1142275,1142274 |
| 0 | Fund-raising | 1146758,1146759 |
| 0 | HW_Austin | 1152219,1152220 |
| 0 | Hi-Fi_Revival | 1146781,1146782 |
| 0 | Macmillan_&_Company | 1095534,1095533 |
| 0 | Me_&_Mr._Johnson | 893922,893920 |
| 0 | Milwaukee_&_Waukesha_Railroad | 891787,891786 |
| 0 | Morus_(plant) | 1146825,1146826 |
| 0 | Ontario_Provincial_Highway_400 | 1143627,1143611 |
| 0 | OttawaÔÇöVanier | 1118429,1118428,1118427 |
| 0 | Owen_Marshall | 1171339,1171335 |
| 0 | Pavan | 1146834,1146835 |
| 0 | Pipestone_County | 1146840,1146841 |
| 0 | Prefabricated | 1146843,1146844 |
| 0 | Roland_Robinson | 1171329,1171328 |
| 0 | Ry¶_Bakura | 918333,918327 |
| 0 | The_monks | 1154734,1153299 |
| 0 | Uninhabited_Planet_Survival | 1171356,1171357,1171358 |
| 0 | Warstorming | 1171338,1171344 |
| 0 | Wounded_in_Action | 1146696,1146697 |
| 0 | Y&R | 1166682,1166680 |
| 0 | ╔tat_QuÚbÚcois | 924935,924928 |
| 1 | Artistic_gymnastics | 607868,607867 |
| 1 | Atlßntico | 1124783,1124782 |
| 1 | Bill_Cartwright | 1072356,1072355 |
| 1 | Blood,_Sweat_and_No_Tears | 1068741,1068742 |
| 1 | CDP1802 | 630486,630485 |
| 1 | Civil_Rights_Act_of_1957 | 792379,792378 |
| 1 | Cod_War | 531449,531448 |
| 1 | Columbian_Exchange | 1020273,1020274 |
| 1 | Common_year_starting_on_Wednesday | 983118,983116 |
| 1 | Delta_Air_Lines | 886914,886913 |
| 1 | Dopamine_reuptake_inhibitor | 731032,731029 |
| 1 | E-101_Beta | 804433,804432 |
| 1 | Etienne_cabet | 1098861,1098860 |
| 1 | Function_(mathematics)/archive | 1147439,1147438 |
| 1 | George_M._Dallas | 646833,646834 |
| 1 | Gilbert_Shelton | 652091,652089 |
| 1 | Goodbye_Cream_(album) | 538974,538973 |
| 1 | Hanns_Kerrl | 492881,492880 |
| 1 | Heimdall | 872212,872211 |
| 1 | Hemophilia | 909037,538514 |
| 1 | Idomeneo | 614044,614043 |
| 1 | Isospin | 798213,798206 |
| 1 | Kids_on_the_Street | 1056773,1056770 |
| 1 | Krishna_Singh | 799332,799326 |
| 1 | Larceny | 793084,793086 |
| 1 | Legal_translation | 910056,910057 |
| 1 | List_of_horse_races | 799374,799370 |
| 1 | Maximum_Sum_41 | 807653,807652 |
| 1 | Naked_funk | 680456,680455 |
| 1 | Peter_Koelewijn | 1105968,1105966 |
| 1 | Rose_O'Neal_Greenhow | 1067732,1067731 |
| 1 | Sam | 760759,760758 |
| 1 | Sanron | 676711,676710 |
| 1 | Second_system_syndrome | 959867,959866 |
| 1 | Strap_it_On | 675377,675370 |
| 1 | Sunshine_Skyway_Bridge | 982549,982550 |
| 1 | Super_Star_Destroyer | 766921,766922 |
| 1 | Trunks | 798171,798167 |
| 1 | Ulysses_S._Grant | 606829,606830 |
| 1 | Ursula_Reitemeyer | 434939,434938 |
| 1 | Vas_deferens | 624660,624659 |
| 1 | Vogue_magazine | 619169,619167 |
| 1 | Vorik | 915629,915630 |
| 2 | 203.51.22.18 | 1146614,1146615 |
| 2 | Apsara | 763473,763472 |
| 2 | Bluenote | 605217,605218 |
| 2 | DarkSoldier | 911459,911458 |
| 2 | Dhelder | 891599,891597 |
| 2 | Ecks | 909090,909087 |
| 2 | Farnik | 908963,908960 |
| 2 | Gaintheworld | 606515,606514 |
| 2 | Garryq | 592175,592176 |
| 2 | HamYoyo/Articles | 703110,703109 |
| 2 | HamYoyo/Tracking/Discussions | 767296,767295 |
| 2 | Jondel | 455658,455659 |
| 2 | Lonely_Jim | 609925,609923 |
| 2 | Mr._Strong_Bad | 908885,908876 |
| 2 | Petelad | 1167174,1167175 |
| 2 | Serge56 | 1166738,1166737 |
| 2 | Silentlight | 863340,863341 |
| 2 | Vortexfugue | 1126419,1126426 |
| 2 | Zvi | 584520,584519 |
| 3 | 198.6.95.95 | 1146607,1146608 |
| 3 | 24.229.75.143 | 839248,839246 |
| 3 | 24.61.28.33 | 805662,805663 |
| 3 | 64.90.21.246 | 994115,994116 |
| 3 | 66.213.10.5 | 803257,803259 |
| 3 | 66.222.27.153 | 608153,608147 |
| 3 | 66.57.97.170 | 675497,675496 |
| 3 | 66.88.74.254 | 530924,530923 |
| 3 | 66.99.8.89 | 536832,536831 |
| 3 | 67.240.137.55 | 628396,628394 |
| 3 | 67.4.111.136 | 798031,798030 |
| 3 | 68.222.15.75 | 878668,878667 |
| 3 | 68.81.243.93 | 903259,903252 |
| 3 | 80.235.132.13 | 505050,505051 |
| 3 | 80.46.18.89 | 1081303,1081304 |
| 3 | 81.133.129.177 | 598781,598777 |
| 3 | 82.37.170.178 | 603958,603959 |
| 3 | 83.104.108.237 | 1067459,1067460 |
| 3 | CCY | 724872,724873 |
| 3 | Combuchan | 860019,860020 |
| 3 | Common_Sense | 426124,426123 |
| 3 | Druid816 | 1097943,1097942 |
| 3 | EC | 856059,856060 |
| 3 | Ebosspt | 620559,620558 |
| 3 | Hpc | 486146,486147 |
| 3 | Johnwalton | 692239,692238 |
| 3 | Keldajon | 625882,625881 |
| 3 | LegCircus | 908978,908979 |
| 3 | Leibniz | 767188,767189 |
| 3 | Lky | 802577,802578 |
| 3 | Loweeel | 607178,607176 |
| 3 | MennoniteHobbit | 682405,682406 |
| 3 | Mona-Lynn | 950401,950402 |
| 3 | Serpens | 960469,960468 |
| 3 | Tomb | 588784,588785 |
| 3 | Whosyourjudas | 1113619,951140 |
| 3 | Zzfly123 | 536741,536742 |
| 4 | Canadian_wikipedians'_notice_board/Saskatchewan | 1108392,1108390,1108389,1108388,1108387,1108386 |
| 4 | Press_Coverage | 486857,486858 |
| 4 | Votes_for_deletion/1605_in_Terrorism | 843701,843707 |
| 4 | Votes_for_deletion/One_religion_state | 894087,894086 |
| 4 | Votes_for_deletion/Pseudologia | 896901,896902 |
| 4 | Votes_for_deletion/Ranjan_Agarwal | 853362,853363 |
| 4 | Votes_for_deletion/Williams_Disease | 866569,866566 |
| 6 | Czestochowa_herb.jpg | 613968,613969 |
| 6 | Darlingtonia_californica.jpg | 797922,797923 |
| 6 | Fair_Haven_Vermont_20040701.jpg | 798202,798174 |
| 6 | GE_Genesis_Amtrak.jpg | 798180,798177 |
| 7 | Cristiano_Ronaldo.jpg | 803164,803165 |
| 7 | Sniper_rifle.jpg | 528911,528910 |
| 8 | February_27_selected_anniversaries | 686972,489620 |
| 8 | Provinces_of_Argentina | 687875,675541 |
| 8 | VfD-Aerican | 688300,620769 |
| 8 | VfD-Antonia_Ruster | 688331,617437 |
| 14 | Republic_of_Singapore_Air_Force | 1146676,1146677 |
+---------------+-------------------------------------------------+-------------------------------------------------+
152 rows in set (48.57 sec)
|
|
07-14-2008 23:18:10
The contents of this article are licensed from Wikipedia.org under the GNU Free Documentation License. How to see transparent copy
The contents of this article are licensed from Wikipedia.org under the GNU Free Documentation License. How to see transparent copy
|
BiologyDaily.com 2005. Legal info Privacy |