21:
17:
47:
79:
along with this program. If not, see <http://www.gnu.org/licenses/: -->
55:
it under the terms of the GNU General Public
License as published by
52:
This program is free software: you can redistribute it and/or modify
76:
You should have received a copy of the GNU General Public
License
58:
the Free
Software Foundation, either version 3 of the License, or
611:"Linked miscapitalizations (limited to the first 1000 entries)"
64:
This program is distributed in the hope that it will be useful,
67:
but WITHOUT ANY WARRANTY; without even the implied warranty of
70:
MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
391:AND cl_to = 'Redirects_from_miscapitalisations'
8:
73:GNU General Public License for more details.
367:JOIN linktarget on p1.page_title = lt_title
364:JOIN categorylinks ON p1.page_id = cl_from
346:/* linkedmiscapitalizations.rs SLOW_OK */
376:JOIN page AS p2 ON pl_from = p2.page_id
373:JOIN pagelinks ON pl_target_id = lt_id
7:
61:(at your option) any later version.
30:This report is updated every day.
28:
394:AND NOT(p1.page_id = p2.page_id)
18:Knowledge (XXG):Database reports
46:Copyright 2021 Kunal Mehta <
1:
756:"linkedmiscapitalizations.rs"
43:Copyright 2018 MZMcBride, WBM
388:AND p1.page_is_redirect = 1
268:"Linked miscapitalizations"
781:
379:AND p2.page_namespace = 0
22:Linked miscapitalizations
228:LinkedMiscapitalizations
204:LinkedMiscapitalizations
37:
385:p1.page_namespace = 0
370:AND lt_namespace = 0
772:
766:
763:
760:
757:
754:
751:
748:
745:
742:
739:
736:
732:
729:
726:
723:
720:
717:
714:
711:
708:
705:
702:
699:
696:
693:
689:
686:
683:
679:
676:
673:
670:
667:
664:
661:
658:
655:
652:
649:
646:
643:
640:
637:
633:
630:
627:
624:
621:
618:
615:
612:
609:
606:
603:
600:
597:
593:
590:
587:
584:
581:
578:
575:
572:
569:
566:
563:
560:
557:
554:
551:
548:
545:
542:
539:
536:
533:
530:
527:
524:
521:
518:
515:
512:
509:
506:
503:
500:
497:
494:
491:
488:
485:
482:
479:
476:
473:
470:
466:
463:
460:
457:
454:
450:
447:
444:
441:
437:
434:
431:
428:
425:
422:
419:
416:
413:
410:
407:
404:
401:
398:
395:
392:
389:
386:
383:
380:
377:
374:
371:
368:
365:
362:
359:
356:
353:
350:
347:
344:
341:
338:
335:
332:
329:
325:
322:
319:
316:
313:
310:
307:
304:
300:
297:
294:
290:
287:
284:
281:
278:
275:
272:
269:
266:
263:
260:
257:
254:
250:
247:
244:
241:
238:
235:
232:
229:
226:
223:
220:
217:
214:
211:
208:
205:
202:
199:
196:
193:
190:
186:
183:
180:
176:
173:
170:
167:
164:
161:
158:
154:
151:
148:
145:
141:
137:
134:
131:
128:
125:
122:
119:
116:
113:
110:
107:
103:
100:
97:
94:
90:
87:
84:
81:
77:
74:
71:
68:
65:
62:
59:
56:
53:
50:
44:
41:
780:
779:
775:
774:
773:
771:
770:
769:
768:
767:
764:
761:
758:
755:
752:
749:
746:
743:
740:
737:
734:
730:
727:
724:
721:
718:
715:
712:
709:
706:
703:
700:
697:
694:
691:
687:
684:
681:
677:
674:
671:
668:
665:
662:
659:
656:
653:
650:
647:
644:
641:
638:
635:
631:
628:
625:
622:
619:
616:
613:
610:
607:
604:
601:
598:
595:
591:
588:
585:
582:
579:
576:
573:
570:
567:
564:
561:
558:
555:
552:
549:
546:
543:
540:
537:
534:
531:
528:
525:
522:
519:
516:
513:
510:
507:
504:
501:
498:
495:
492:
489:
486:
483:
480:
477:
474:
471:
467:
464:
461:
458:
455:
452:
448:
445:
442:
439:
435:
432:
429:
426:
423:
420:
417:
414:
411:
408:
405:
402:
399:
396:
393:
390:
387:
384:
381:
378:
375:
372:
369:
366:
363:
360:
357:
354:
351:
348:
345:
342:
339:
336:
333:
330:
327:
323:
320:
317:
314:
311:
308:
305:
302:
298:
295:
292:
288:
285:
282:
279:
276:
273:
270:
267:
264:
261:
258:
255:
252:
248:
245:
242:
239:
236:
233:
230:
227:
224:
221:
218:
215:
212:
209:
206:
203:
200:
197:
194:
191:
188:
184:
181:
178:
174:
171:
168:
165:
162:
159:
156:
152:
149:
146:
143:
139:
135:
132:
129:
126:
123:
120:
117:
114:
111:
108:
105:
101:
98:
95:
92:
88:
85:
82:
78:
75:
72:
69:
66:
63:
60:
57:
54:
51:
45:
42:
39:
36:
26:
25:
24:
12:
11:
5:
778:
776:
352:p1.page_title,
38:
35:
32:
27:
15:
14:
13:
10:
9:
6:
4:
3:
2:
777:
48:
33:
31:
23:
19:
750:include_str!
29:
153:mysql_async
136:mysql_async
34:Source code
663:format_row
639:<&'
535:page_title
514:page_title
361:page AS p1
175:page_title
490:query_map
421:run_query
299:Frequency
293:Frequency
277:frequency
121:Frequency
620:headings
397:GROUP BY
355:COUNT(*)
109:dbr_link
20: |
707:str_vec
140:prelude
115:str_vec
102:dbreps2
741:static
733:-: -->
698:String
690:-: -->
642:static
634:-: -->
602:static
594:-: -->
453:Result
451:-: -->
349:SELECT
334:static
326:-: -->
291:-: -->
259:static
251:-: -->
213:Report
201:struct
179:String
166:struct
127:Report
93:Result
89:anyhow
735:&
725:&
701:: -->
682:&
669:&
648:: -->
626:&
596:&
586:&
580:intro
553:await
541:count
520:count
502:query
469:: -->
468:: -->
440:&
427:&
415:async
406:1000;
403:LIMIT
382:WHERE
328:&
318:&
312:query
303:Daily
283:&
253:&
243:&
237:title
222:: -->
185:count
49:: -->
16:<
728:self
719:code
695:<
672:self
654:vec!
629:self
589:self
568:rows
496:self
484:conn
478:rows
462:<
456:<
446:Conn
436:conn
430:self
358:FROM
321:self
286:self
246:self
216:<
210:impl
157:Conn
744:str
692:Vec
685:Row
678:row
645:str
636:Vec
605:str
529:Row
505:(),
475:let
465:Row
459:Vec
443:mut
343:r#"
337:str
262:str
225:for
219:Row
198:pub
189:u32
169:Row
163:pub
150:use
133:use
99:use
86:use
716:fn
680::
660:fn
617:fn
577:fn
562:Ok
547:})
438::
418:fn
409:"#
309:fn
301:::
274:fn
234:fn
207:{}
187::
177::
155:::
142:::
138:::
130:};
104:::
91:::
83:*/
40:/*
765:}
762:}
759:)
753:(
747:{
738:'
731:)
722:(
713:}
710:!
704:{
688:)
675:,
666:(
657:}
651:{
632:)
623:(
614:}
608:{
599:'
592:)
583:(
574:}
571:)
565:(
559:;
556:?
550:.
544:,
538:,
532:{
526:|
523:)
517:,
511:(
508:|
499:.
493:(
487:.
481:=
472:{
449:)
433:,
424:(
412:}
400:1
340:{
331:'
324:)
315:(
306:}
296:{
289:)
280:(
271:}
265:{
256:'
249:)
240:(
231:{
195:}
192:,
182:,
172:{
160:;
147:;
144:*
124:,
118:,
112:,
106:{
96:;
80:.
Text is available under the Creative Commons Attribution-ShareAlike License. Additional terms may apply.