Dablinks for the Monthly Dab Challenge Created Last Month

The current time is August 20, 2022, 4:36 UTC. Replication lag is 0 seconds.

             SELECT a.dab_id AS dab_id,
                    a.dab_title AS dab_title,
                    count(*) AS count,
                    lc_amnt AS all_count
               FROM all_dab_links_basic a, monthly_list_count
              WHERE a.dab_id = lc_id
                AND EXISTS
                      (
                       SELECT 1
                         FROM monthly_list_full b
                        WHERE a.dab_id = b.dab_id
                          AND a.article_id = b.article_id
                      )
                AND EXISTS
                      (
                       SELECT 1
                         FROM all_dab_links c
                        WHERE a.dab_id = c.dab_id
                          AND a.article_id = c.article_id
                          AND dab_date LIKE '202207%'
                      )
              GROUP BY a.dab_id
              ORDER BY count DESC, dab_title
         LIMIT 51

Showing below up to 50 results starting with #1.

View (previous 50) (next 50) (20 | 50 | 100 | 250 | 500)

   1. Ropeway (37 new links of 37)
   2. Samastha (27 new links of 27)
   3. Muslim Students Federation (25 new links of 25)
   4. Google Pay (22 new links of 22)
   5. Turanians (18 new links of 18)
   6. Indo-African (15 new links of 15)
   7. Eastern Railway (10 new links of 10)
   8. Tuft (10 new links of 10)
   9. Ana Gutiérrez (8 new links of 8)
   10. Cocompact (8 new links of 8)
   11. Ehsan Khan (8 new links of 8)
   12. Lawrenceville, New York (8 new links of 8)
   13. Autonomous navigation (7 new links of 7)
   14. Brian Roberts (7 new links of 7)
   15. Jutro (7 new links of 7)
   16. Artemiz (6 new links of 6)
   17. Anglo-Maratha Wars (5 new links of 5)
   18. Moulder (5 new links of 5)
   19. Rajwar (5 new links of 5)
   20. Amole (4 new links of 4)
   21. Balanbale (4 new links of 4)
   22. Celestial hierarchy (4 new links of 4)
   23. Chornyi Ostriv (4 new links of 4)
   24. Javanism (4 new links of 4)
   25. Kultuk (4 new links of 4)
   26. Lissus (4 new links of 4)
   27. Mister Philippines (4 new links of 4)
   28. Nimr (4 new links of 4)
   29. Ozeki (4 new links of 4)
   30. Rock Crystal (4 new links of 4)
   31. Saint Edith (4 new links of 4)
   32. Shreveport station (4 new links of 4)
   33. Submarine communications (4 new links of 4)
   34. Walter (4 new links of 4)
   35. White Crane Kung Fu (4 new links of 4)
   36. AOR (3 new links of 4)
   37. Andrea Álvarez (3 new links of 3)
   38. August 2021 Balochistan attacks (3 new links of 3)
   39. Avion (3 new links of 3)
   40. Barac (3 new links of 3)
   41. Bass House (3 new links of 3)
   42. Benefactor (3 new links of 3)
   43. Bibliography of Russian history (3 new links of 3)
   44. Block voting (3 new links of 12)
   45. Bruford (3 new links of 3)
   46. Camp Wilderness (3 new links of 3)
   47. Close Relations (3 new links of 3)
   48. Conservative Catholic (3 new links of 3)
   49. Council of Constantinople (3 new links of 3)
   50. Cowherd (3 new links of 4)

View (previous 50) (next 50) (20 | 50 | 100 | 250 | 500)



Contact: my discussion page on the English Wikipedia