Dablinks for the Monthly Dab Challenge Created Last Month

The current time is August 5, 2025, 2:15 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 '202507%'
                      )
              GROUP BY a.dab_id
              ORDER BY count DESC, dab_title
         LIMIT 700, 51

Showing below up to 50 results starting with #701.

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

   701. Army Reserve (1 new link of 1)
   702. Arrowwood (1 new link of 1)
   703. Arsinoe (1 new link of 1)
   704. Arthur Clark (1 new link of 1)
   705. Artificial mind (1 new link of 1)
   706. Arts education (1 new link of 1)
   707. Arun Singh (1 new link of 1)
   708. Arup (1 new link of 1)
   709. Arvind Kumar (1 new link of 1)
   710. Asad Khan (1 new link of 1)
   711. Asgar Abdullayev (1 new link of 1)
   712. Ashby (1 new link of 1)
   713. Ashland, Louisiana (1 new link of 1)
   714. Ashok Kumar (disambiguation) (1 new link of 1)
   715. Asiatech (1 new link of 1)
   716. Asif Ali (1 new link of 1)
   717. Assembler (1 new link of 1)
   718. Assurance (1 new link of 1)
   719. Assyrian music (1 new link of 1)
   720. Astragalus (1 new link of 2)
   721. Astro Arena (1 new link of 1)
   722. Asynchrony (1 new link of 1)
   723. Athletic (1 new link of 1)
   724. Athletic club (1 new link of 1)
   725. Atman (1 new link of 2)
   726. Atmos (1 new link of 1)
   727. Attack (1 new link of 2)
   728. Attention deficit (1 new link of 1)
   729. Attraction (1 new link of 1)
   730. Au (1 new link of 1)
   731. Auburn (1 new link of 1)
   732. Aughnacloy (1 new link of 1)
   733. Aurangabad Lok Sabha constituency (1 new link of 1)
   734. Aurangabad district (1 new link of 1)
   735. Austerity (disambiguation) (1 new link of 1)
   736. Austin (1 new link of 2)
   737. Australia A (1 new link of 1)
   738. Australian Imperial Force (1 new link of 1)
   739. Authenticity (1 new link of 1)
   740. Authority (disambiguation) (1 new link of 1)
   741. Autonomous church (1 new link of 1)
   742. Autonomous navigation (1 new link of 1)
   743. Autotrader EchoPark Automotive 400 (1 new link of 1)
   744. Auxiliary (1 new link of 1)
   745. Ava (1 new link of 1)
   746. Avcılar (1 new link of 1)
   747. Avtar Singh (1 new link of 1)
   748. Awan (1 new link of 1)
   749. Awl (1 new link of 2)
   750. Axis (1 new link of 1)

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



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