Queries on enwikibooks_p on the toolserver. Patrolled edits with no entry in the patrol log: mysql> SELECT recentchanges.rc_this_oldid, recentchanges.rc_user_text, recentchanges.rc_namespace, recentchanges.rc_title, recentchanges.rc_timestamp FROM recentchanges LEFT JOIN logging ON rc_namespace=log_namespace AND rc_title=log_title AND log_type='patrol' WHERE rc_new=1 AND rc_patrolled=1 AND log_type IS NULL order by rc_timestamp; +---------------+----------------+--------------+--------------------------------------------------------------------------+----------------+ | rc_this_oldid | rc_user_text | rc_namespace | rc_title | rc_timestamp | +---------------+----------------+--------------+--------------------------------------------------------------------------+----------------+ | 1031748 | Mike.lifeguard | 3 | 137.158.196.246 | 20071116180940 | | 1031756 | Mike.lifeguard | 3 | 131.123.184.225 | 20071116181535 | | 1031758 | Mike.lifeguard | 3 | Polluks | 20071116181711 | | 1031761 | Mike.lifeguard | 3 | RedCoat | 20071116182125 | | 1031772 | Mike.lifeguard | 3 | 213.42.21.150 | 20071116182936 | | 1031861 | Darklama | 3 | 68.92.155.136 | 20071116184810 | | 1031869 | Mike.lifeguard | 110 | Water_Safety | 20071116190511 | | 1031872 | Mike.lifeguard | 14 | Wikijunior_Water_Safety | 20071116190832 | | 1032023 | Mike.lifeguard | 3 | 24.45.179.21 | 20071116223843 | | 1032026 | Mike.lifeguard | 3 | 71.51.124.230 | 20071116225004 | | 1032031 | Mike.lifeguard | 0 | Water_safety | 20071116225721 | | 1032033 | Mike.lifeguard | 3 | 195.229.236.245 | 20071116230326 | | 1032035 | Mike.lifeguard | 110 | Water_Safety/Backyard_Pools | 20071116230722 | | 1032061 | Mike.lifeguard | 3 | 200.218.141.107 | 20071116235309 | | 1032333 | Mike.lifeguard | 3 | 216.240.49.99 | 20071117031825 | | 1032353 | Mike.lifeguard | 3 | 69.151.14.220 | 20071117032801 | | 1032354 | Mike.lifeguard | 3 | Nkocharh | 20071117032843 | | 1032433 | Mike.lifeguard | 3 | Jacques_Bergeron | 20071117041152 | | 1032438 | Mike.lifeguard | 3 | Firecircle | 20071117041345 | | 1032467 | Mike.lifeguard | 3 | 202.137.99.3 | 20071117043619 | | 1032950 | Mike.lifeguard | 3 | 24.214.120.212 | 20071117193346 | | 1032953 | Mike.lifeguard | 3 | Johannes | 20071117193744 | | 1032980 | Mike.lifeguard | 3 | 131.123.177.127 | 20071117200408 | | 1033559 | Jomegat | 3 | Mtnbiker | 20071118153328 | | 1033667 | Mattb112885 | 3 | Ecomeau | 20071118165544 | | 1033675 | Jomegat | 3 | 141.154.36.86 | 20071118170206 | | 1033679 | Jomegat | 3 | 71.100.0.106 | 20071118170436 | | 1033857 | Mike.lifeguard | 3 | Doug_craft | 20071119000220 | | 1033866 | Mike.lifeguard | 3 | Ahemmeri | 20071119000439 | | 1033869 | Mike.lifeguard | 3 | 72.154.204.221 | 20071119000638 | | 1033870 | Mike.lifeguard | 3 | 76.247.155.247 | 20071119000716 | | 1033872 | Mike.lifeguard | 3 | 81.57.19.103 | 20071119000817 | | 1033897 | Whiteknight | 4 | Licensing_guidelines | 20071119005459 | | 1033976 | Whiteknight | 0 | WB:M | 20071119034717 | | 1033978 | Whiteknight | 0 | WB:MEDIA | 20071119034752 | | 1034089 | Robert Horning | 0 | WB:FU | 20071119113843 | | 1034133 | Mike.lifeguard | 109 | Solitaire | 20071119140632 | | 1034162 | Mike.lifeguard | 3 | Mistress_Selina_Kyle | 20071119152058 | | 1034181 | Mike.lifeguard | 3 | 80.193.66.130 | 20071119153414 | | 1034188 | Mattb112885 | 3 | PaigeSHawkins | 20071119153904 | | 1034224 | Mike.lifeguard | 3 | 216.226.108.200 | 20071119164337 | | 1034240 | Jomegat | 3 | 81.159.217.183 | 20071119170412 | | 1034528 | Mike.lifeguard | 3 | Wahsu | 20071120003344 | | 1034538 | Mike.lifeguard | 0 | First_Aid/Appendix_E:_First_Aid_Kits | 20071120004444 | | 1034553 | Whiteknight | 2 | Whiteknight/Stylesheets/User:Wknight8111 | 20071120010258 | | 1034601 | Mike.lifeguard | 3 | Ladiesman217xxx | 20071120013649 | | 1034611 | Mike.lifeguard | 1 | JavaScript/Functions | 20071120014753 | | 1034644 | Mike.lifeguard | 3 | Racehonda43 | 20071120023459 | | 1034666 | Withinfocus | 0 | Muggles'_Guide_to_Harry_Potter/Places/Headmaster's_Office,_Hogwarts | 20071120031817 | | 1034730 | Mike.lifeguard | 10 | Cc-by-sa-2.5-ca | 20071120042723 | | 1034731 | Mike.lifeguard | 11 | Cc-by-sa-2.5-ca | 20071120042743 | | 1034732 | Mike.lifeguard | 10 | CC-Layout | 20071120042812 | | 1034738 | Mike.lifeguard | 14 | CC-BY-SA-2.5-CA | 20071120043016 | | 1034762 | Mike.lifeguard | 7 | First_Aid_for_Canada.pdf | 20071120053926 | | 1034763 | Mike.lifeguard | 3 | Rrs207 | 20071120054217 | | 1034769 | Mike.lifeguard | 3 | 81.129.141.104 | 20071120054715 | | 1034885 | Mike.lifeguard | 2 | Mike.lifeguard/purge.js | 20071120083253 | | 1034895 | Mike.lifeguard | 2 | Mike.lifeguard/sixtabs.js | 20071120084007 | | 1034896 | Mike.lifeguard | 2 | Mike.lifeguard/blockmods.js | 20071120084036 | | 1034898 | Mike.lifeguard | 2 | Mike.lifeguard/edittop.js | 20071120084147 | | 1034899 | Mike.lifeguard | 2 | Mike.lifeguard/addtabs.js | 20071120084241 | | 1034901 | Mike.lifeguard | 2 | Mike.lifeguard/specialadmin.js | 20071120084328 | | 1034911 | Mike.lifeguard | 2 | Mike.lifeguard/history.js | 20071120085559 | | 1034912 | Mike.lifeguard | 2 | Mike.lifeguard/sleeper.js | 20071120085638 | | 1034914 | Mike.lifeguard | 2 | Mike.lifeguard/autodel.js | 20071120085839 | | 1034946 | Mike.lifeguard | 3 | Ngch89 | 20071120093831 | | 1034947 | Mike.lifeguard | 3 | 194.223.81.75 | 20071120094331 | | 1034961 | Mike.lifeguard | 3 | 205.210.223.130 | 20071120100459 | | 1034962 | Mike.lifeguard | 3 | 204.65.0.24 | 20071120100506 | | 1034975 | Mike.lifeguard | 3 | Xiuli_zhuang | 20071120102017 | | 1034978 | Mike.lifeguard | 3 | 203.187.230.99 | 20071120102140 | | 1034980 | Mike.lifeguard | 3 | 63.147.134.5 | 20071120102211 | | 1034983 | Mike.lifeguard | 3 | 86.158.5.154 | 20071120102337 | | 1034985 | Mike.lifeguard | 3 | 203.145.189.66 | 20071120102357 | | 1034986 | Mike.lifeguard | 3 | 71.233.131.22 | 20071120102458 | | 1034991 | Mike.lifeguard | 3 | 64.229.197.22 | 20071120102626 | | 1034995 | Mike.lifeguard | 3 | Houney_lee | 20071120110048 | | 1034996 | Mike.lifeguard | 3 | Pbteen32904 | 20071120110053 | | 1034997 | Mike.lifeguard | 3 | Joaospam | 20071120110057 | | 1034998 | Mike.lifeguard | 3 | Cubrad | 20071120110351 | | 1035256 | Urbane | 3 | AbuUzair | 20071120193843 | | 1035258 | Urbane | 3 | Kalan | 20071120193922 | | 1035259 | Urbane | 3 | ToddC | 20071120193933 | | 1035271 | Mike.lifeguard | 3 | Skyliner778 | 20071120195425 | | 1035283 | Urbane | 3 | Nputhika | 20071120200709 | | 1035336 | Whiteknight | 2 | Whiteknight/WEP | 20071120212101 | | 1035509 | Mike.lifeguard | 3 | 216.96.106.130 | 20071121011205 | | 1035510 | Mike.lifeguard | 103 | Chicken_Rice_Salad | 20071121011254 | | 1035519 | Mike.lifeguard | 3 | Countrymike | 20071121012033 | | 1035521 | Mike.lifeguard | 3 | 68.187.163.190 | 20071121012202 | | 1035530 | Mike.lifeguard | 3 | Wanlee | 20071121014435 | | 1035634 | Xixtas | 2 | Xixtas/Counting_Baby_Animals/Three_kittens | 20071121042158 | | 1035663 | Mike.lifeguard | 3 | AdventChildren06 | 20071121044101 | | 1035664 | Mike.lifeguard | 3 | 70.174.113.223 | 20071121044115 | | 1035749 | Whiteknight | 3 | Feraudyh | 20071121132241 | | 1035816 | Mike.lifeguard | 3 | TwoWings | 20071121151912 | | 1035825 | Mike.lifeguard | 3 | Lishevita | 20071121152628 | | 1035878 | Whiteknight | 10 | To_cookbook | 20071121170032 | | 1035882 | Whiteknight | 0 | WB:WIJ | 20071121171218 | | 1035904 | Mike.lifeguard | 2 | SomeRandomEditor | 20071121175840 | | 1035905 | Mike.lifeguard | 3 | SomeRandomEditor | 20071121175853 | | 1035955 | Jomegat | 0 | Adventist_Youth_Honors_Answer_Book/Camping/Fire/Trench | 20071121194340 | | 1035957 | Mike.lifeguard | 3 | Dabrace1984 | 20071121195244 | | 1036282 | Mike.lifeguard | 0 | First_Aid/Meta_pages | 20071122045619 | | 1036301 | Mike.lifeguard | 0 | First_Aid/List_of_Images | 20071122051541 | | 1036311 | Mike.lifeguard | 3 | Kouzoudis | 20071122054622 | | 1036312 | Mike.lifeguard | 3 | 24.225.243.37 | 20071122054740 | | 1036336 | Mike.lifeguard | 109 | Nonverbal_communication | 20071122062033 | | 1036341 | Mike.lifeguard | 109 | Social_skills | 20071122062317 | | 1036466 | Mattb112885 | 3 | 78.86.87.252 | 20071122145849 | | 1036533 | Mike.lifeguard | 4 | Votes_for_deletion/Teaching_Assistant_in_France_Survival_Guide/Directory | 20071122190948 | | 1036549 | Mike.lifeguard | 3 | Cryo75 | 20071122192205 | | 1036566 | Mike.lifeguard | 3 | 58.152.51.44 | 20071122193817 | | 1036568 | Mike.lifeguard | 3 | 67.212.26.180 | 20071122194116 | | 1036571 | Mike.lifeguard | 3 | 24.74.141.222 | 20071122194606 | | 1036674 | Mike.lifeguard | 1 | First_Aid/CPR_summary/Archive_1 | 20071122230632 | | 1036715 | Mike.lifeguard | 14 | Talk_archives | 20071122231130 | | 1036719 | Mike.lifeguard | 14 | Archival_templates | 20071122231355 | | 1036800 | Mike.lifeguard | 3 | Darkpyro1 | 20071122234453 | | 1036806 | Mike.lifeguard | 3 | 124.104.148.161 | 20071123000855 | | 1036809 | Mike.lifeguard | 3 | 74.193.54.15 | 20071123001041 | | 1036835 | Mattb112885 | 3 | 69.227.151.150 | 20071123012151 | | 1036892 | Jomegat | 3 | 202.45.119.133 | 20071123035006 | | 1036980 | Mike.lifeguard | 3 | SoraxD | 20071123080138 | | 1037045 | Xixtas | 3 | Beaver | 20071123142759 | | 1037127 | Mike.lifeguard | 3 | 122.167.54.156 | 20071123172539 | | 1037149 | Whiteknight | 0 | Artificial_Neural_Networks/Control | 20071123184657 | | 1037166 | Mike.lifeguard | 3 | 71.115.71.240 | 20071123193107 | | 1037226 | Mike.lifeguard | 1 | First_Aid/Appendix_E:_First_Aid_Kits | 20071123231059 | | 1037622 | Mike.lifeguard | 10 | User4 | 20071124182104 | | 1037715 | Jomegat | 3 | Dgprouty | 20071124211716 | | 1037752 | Whiteknight | 3 | Icurays1 | 20071124224759 | | 1037882 | Mike.lifeguard | 3 | Kaus_Austrol | 20071125003727 | | 1038049 | Mike.lifeguard | 3 | The_Scarlet_Letter | 20071125074958 | | 1038165 | Mike.lifeguard | 3 | Qwerty_Binary | 20071125180504 | | 1038186 | Mike.lifeguard | 3 | Connor.rosen | 20071125191049 | | 1038189 | Mike.lifeguard | 3 | 4.178.33.201 | 20071125191139 | | 1038196 | Mike.lifeguard | 3 | Hedleypanama | 20071125191733 | | 1038201 | Mike.lifeguard | 3 | 24.62.236.10 | 20071125192251 | | 1038204 | Mike.lifeguard | 2 | Mike.lifeguard/Deletion_reasons | 20071125193548 | | 1038435 | Whiteknight | 2 | Whiteknight/C++_Programming | 20071126003052 | | 1038529 | Mike.lifeguard | 3 | 71.197.67.169 | 20071126021306 | | 1038538 | Mike.lifeguard | 3 | Eintelligences | 20071126024510 | | 1038548 | Mike.lifeguard | 3 | J834_4562 | 20071126030612 | | 1038603 | Mike.lifeguard | 3 | Mbisanz | 20071126043755 | | 1039058 | Mike.lifeguard | 3 | Dajoshi | 20071127003337 | | 1039063 | Mike.lifeguard | 3 | TheresaC | 20071127003633 | | 1039065 | Mike.lifeguard | 3 | Lin29 | 20071127003702 | | 1039077 | Mike.lifeguard | 3 | 69.243.242.211 | 20071127005322 | | 1039079 | Mike.lifeguard | 3 | 140.111.66.27 | 20071127005406 | | 1039086 | Mike.lifeguard | 3 | 24.90.155.230 | 20071127010934 | | 1039092 | Mike.lifeguard | 0 | Zoo_Tycoon_and_Zoo_tycoon_2 | 20071127012332 | | 1039095 | Mike.lifeguard | 0 | Random_page | 20071127013813 | | 1039131 | Mike.lifeguard | 3 | 71.161.26.182 | 20071127024426 | +---------------+----------------+--------------+--------------------------------------------------------------------------+----------------+ 154 rows in set (0.02 sec) Edits by sysops with a manually-patrolled entry in the log book: mysql> select recentchanges.rc_this_oldid, recentchanges.rc_user_text, recentchanges.rc_namespace, recentchanges.rc_title, recentchanges.rc_timestamp from logging,recentchanges,user_groups where rc_new = '1' and recentchanges.rc_timestamp > '20071116180443' and ug_user = rc_user and ug_group = 'sysop' and log_type = 'patrol' and log_params like concat(recentchanges.rc_this_oldid, '\n%\n0'); +---------------+----------------+--------------+-------------------+----------------+ | rc_this_oldid | rc_user_text | rc_namespace | rc_title | rc_timestamp | +---------------+----------------+--------------+-------------------+----------------+ | 1031901 | Mike.lifeguard | 3 | Undone-girl | 20071116201020 | | 1031903 | Mike.lifeguard | 3 | Singingwolfboy | 20071116201028 | | 1031922 | Mike.lifeguard | 3 | Kelekci.n | 20071116204522 | | 1031931 | Mike.lifeguard | 3 | 84.159.47.238 | 20071116205042 | | 1031939 | Mike.lifeguard | 3 | 65.25.105.176 | 20071116210434 | | 1031905 | Mike.lifeguard | 110 | Water_Safety/meta | 20071116201146 | +---------------+----------------+--------------+-------------------+----------------+ 6 rows in set (2.61 sec)