Page MenuHomePhabricator
Paste P7461

aawikibooks ar_rev_id conflicts
ActivePublic

Authored by tstarling on Aug 16 2018, 12:06 AM.
wikiadmin@10.64.0.205(aawikibooks)> select * from (select ar_rev_id, count(*) as n, group_concat(ar_id) as ar_ids from archive group by ar_rev_id) as counts where n>1;
+-----------+---+-----------+
| ar_rev_id | n | ar_ids |
+-----------+---+-----------+
| 3003 | 2 | 29,987 |
| 3004 | 2 | 36,988 |
| 3005 | 2 | 37,989 |
| 3006 | 2 | 47,990 |
| 3007 | 2 | 55,991 |
| 3008 | 2 | 71,1029 |
| 3009 | 2 | 76,1030 |
| 3010 | 2 | 80,1031 |
| 3011 | 2 | 84,1032 |
| 3012 | 2 | 131,1073 |
| 3013 | 2 | 139,1105 |
| 3014 | 2 | 172,1107 |
| 3015 | 2 | 207,1108 |
| 3016 | 2 | 208,1109 |
| 3017 | 2 | 213,1110 |
| 3018 | 2 | 224,1111 |
| 3019 | 2 | 227,1113 |
| 3020 | 2 | 238,1114 |
| 3021 | 2 | 253,1116 |
| 3022 | 2 | 287,1117 |
| 3023 | 2 | 294,1124 |
| 3024 | 2 | 305,1125 |
| 3025 | 2 | 309,1127 |
| 3026 | 2 | 316,1131 |
| 3027 | 2 | 320,1136 |
| 3028 | 2 | 337,1219 |
| 3029 | 2 | 354,1230 |
| 3030 | 2 | 368,1293 |
| 3031 | 2 | 426,1294 |
| 3032 | 2 | 498,1302 |
| 3033 | 2 | 524,1357 |
| 3034 | 2 | 557,1439 |
| 3035 | 2 | 564,1446 |
| 3036 | 2 | 612,1537 |
| 3037 | 2 | 813,1572 |
| 3038 | 2 | 890,1574 |
| 3039 | 2 | 894,1581 |
| 3040 | 2 | 902,1629 |
| 3041 | 2 | 903,1630 |
| 3042 | 2 | 919,1636 |
| 3043 | 2 | 950,1663 |
| 3044 | 2 | 967,1668 |
| 3045 | 2 | 969,1728 |
| 3046 | 2 | 972,1741 |
| 3047 | 2 | 975,1757 |
| 3048 | 2 | 976,1781 |
| 3049 | 2 | 977,1793 |
| 3050 | 2 | 979,1815 |
| 3051 | 2 | 983,1823 |
| 3052 | 2 | 985,1824 |
| 3053 | 2 | 1018,1849 |
| 3054 | 2 | 1355,1858 |
| 3055 | 2 | 1356,1875 |
| 3056 | 2 | 1360,1876 |
| 3057 | 2 | 1361,1877 |
| 3058 | 2 | 1396,1892 |
| 3059 | 2 | 1397,1913 |
| 3060 | 2 | 1427,1921 |
| 3061 | 2 | 1476,1930 |
| 3062 | 2 | 1486,1936 |
| 3063 | 2 | 1492,1939 |
| 3064 | 2 | 1544,1942 |
| 3065 | 2 | 1606,1945 |
| 3066 | 2 | 1672,1992 |
| 3067 | 2 | 1721,2011 |
| 3068 | 2 | 1920,2018 |
| 3069 | 2 | 1924,2019 |
| 3070 | 2 | 1995,2020 |
| 3071 | 2 | 1996,2021 |
| 3072 | 2 | 2022,2074 |
| 3073 | 2 | 2023,2075 |
| 3074 | 2 | 2062,2093 |
| 3075 | 2 | 2071,2094 |
| 3076 | 2 | 2096,2117 |
| 3077 | 2 | 2097,2135 |
| 3078 | 2 | 2098,2136 |
| 3079 | 2 | 2099,2138 |
| 3080 | 2 | 2100,2189 |
| 3081 | 2 | 2101,2221 |
| 3082 | 2 | 2103,2375 |
| 3083 | 2 | 2104,2376 |
| 3084 | 2 | 2107,2377 |
| 3085 | 2 | 2109,2378 |
| 3086 | 2 | 2124,2379 |
| 3087 | 2 | 2174,2380 |
| 3088 | 2 | 2179,2422 |
| 3089 | 2 | 2203,2526 |
| 3090 | 2 | 2206,2527 |
| 3091 | 2 | 2208,2575 |
| 3092 | 2 | 2220,2576 |
| 3093 | 2 | 2249,2582 |
| 3094 | 2 | 2257,2588 |
| 3095 | 2 | 2350,2643 |
| 3096 | 2 | 2351,2656 |
| 3097 | 2 | 2381,2666 |
| 3098 | 2 | 2382,2672 |
| 3099 | 2 | 2383,2673 |
| 3100 | 2 | 2395,2677 |
| 3101 | 2 | 2397,2678 |
| 3102 | 2 | 2457,2681 |
| 3103 | 2 | 2479,2685 |
| 3104 | 2 | 2506,2694 |
| 3105 | 2 | 2531,2737 |
| 3106 | 2 | 2567,2739 |
| 3107 | 2 | 2571,2740 |
| 3108 | 2 | 2574,2779 |
| 3109 | 2 | 2689,2783 |
| 3110 | 2 | 2762,2804 |
| 3111 | 2 | 2763,2997 |
| 3112 | 2 | 2790,3007 |
| 3113 | 2 | 2819,3029 |
| 3114 | 2 | 2855,3038 |
| 3115 | 2 | 2976,3039 |
| 3116 | 2 | 2977,3040 |
| 3117 | 2 | 2979,3042 |
| 3118 | 2 | 3045,3121 |
| 3119 | 2 | 3047,3174 |
| 3120 | 2 | 3083,3183 |
| 3121 | 2 | 3091,3184 |
| 3122 | 2 | 3096,3185 |
| 3123 | 2 | 3102,3188 |
| 3124 | 2 | 3104,3202 |
| 3125 | 2 | 1505,3203 |
| 3126 | 2 | 92,3204 |
| 3127 | 2 | 133,3222 |
| 3128 | 2 | 147,3231 |
| 3129 | 2 | 157,3238 |
| 3130 | 2 | 168,3247 |
| 3131 | 2 | 175,3258 |
| 3132 | 2 | 176,3267 |
| 3133 | 2 | 177,3281 |
| 3134 | 2 | 178,3284 |
| 3135 | 2 | 214,6569 |
| 3136 | 2 | 288,6570 |
| 3137 | 2 | 289,6798 |
| 3138 | 2 | 308,6799 |
| 3139 | 2 | 355,6801 |
| 3140 | 2 | 406,6802 |
| 3141 | 2 | 431,6804 |
| 3142 | 2 | 457,6805 |
| 3143 | 2 | 501,6806 |
| 3144 | 2 | 917,6807 |
| 3145 | 2 | 953,6808 |
+-----------+---+-----------+