Dablinks for the Monthly Dab Challenge Created Last Month

The current time is March 3, 2021, 23:16 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 '202102%'
                      )
              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. Immigration to Hong Kong (22 new links of 22)
   2. Phytosanitary (17 new links of 17)
   3. TV1000 (12 new links of 12)
   4. Hüls (11 new links of 11)
   5. Scottish Psalter (11 new links of 11)
   6. Spoliation (10 new links of 10)
   7. Fragility (8 new links of 8)
   8. Siku (8 new links of 8)
   9. Baini (7 new links of 7)
   10. Alex Martin (6 new links of 6)
   11. Johan Müller (6 new links of 6)
   12. Rajasimha (6 new links of 6)
   13. Rayan (6 new links of 6)
   14. Uniform boundedness conjecture (6 new links of 6)
   15. Nasirpur (5 new links of 5)
   16. Tallinn Music School (5 new links of 5)
   17. Beit She'arim (4 new links of 4)
   18. Discovery system (4 new links of 4)
   19. John Griffin (4 new links of 4)
   20. Malolos Congress (4 new links of 5)
   21. Quick response team (4 new links of 4)
   22. Raivo Tamm (4 new links of 4)
   23. Thai royal and noble titles (4 new links of 4)
   24. Thomas Barry (4 new links of 4)
   25. Akkoyunlu (3 new links of 3)
   26. Bethel Church (3 new links of 3)
   27. Donghua (3 new links of 3)
   28. Edward Lane (3 new links of 3)
   29. Freeview (3 new links of 3)
   30. Indigenous people of South Africa (3 new links of 3)
   31. James Wall (3 new links of 3)
   32. John Belton (3 new links of 3)
   33. Manolín (3 new links of 3)
   34. Reggie Walker (3 new links of 3)
   35. Richard Lang (3 new links of 3)
   36. Springer Spaniel (3 new links of 3)
   37. 11 Minutes (2 new links of 2)
   38. 2CH (disambiguation) (2 new links of 2)
   39. Alan Kelly (2 new links of 2)
   40. Ashoka (disambiguation) (2 new links of 2)
   41. Aston (disambiguation) (2 new links of 2)
   42. Boomerang Bay (2 new links of 2)
   43. Boğaz (2 new links of 2)
   44. CYL (2 new links of 2)
   45. Caesar's Commentaries (2 new links of 2)
   46. Cardano (2 new links of 2)
   47. Chenia (2 new links of 2)
   48. Cherry plum (2 new links of 2)
   49. Clone Wars (2 new links of 2)
   50. Council of Ephesus (disambiguation) (2 new links of 2)

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



Contact: my discussion page on the English Wikipedia