Dablinks for the Monthly Dab Challenge Created Last Month

The current time is March 29, 2024, 12:12 UTC.

             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 '202402%'
                      )
              GROUP BY a.dab_id
              ORDER BY count DESC, dab_title
         LIMIT 251

There are no results in this query.



Contact: the bot discussion page on the English Wikipedia.
Source code available here.