The current time is May 18, 2024, 18:38 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 '202404%'
)
GROUP BY a.dab_id
ORDER BY count DESC, dab_title
LIMIT 100, 21
Showing below up to 20 results starting with #101.
View (previous 20) (next 20) (20 | 50 | 100 | 250 | 500)
| 101. Aka (1 new link of 1) |
| 102. Al-Aqsa Mosque (disambiguation) (1 new link of 1) |
| 103. Al-Rusafa (1 new link of 1) |
| 104. Al Nasr SC (1 new link of 1) |
| 105. Alayna (1 new link of 1) |
| 106. Albani (1 new link of 1) |
| 107. Alejandro de la Sota (1 new link of 1) |
| 108. Alexander Rose (1 new link of 1) |
| 109. Alexandros (1 new link of 1) |
| 110. Alexis (1 new link of 1) |
| 111. Ali Nawaz (1 new link of 1) |
| 112. All-Union Communist Party (1 new link of 1) |
| 113. All Together (1 new link of 1) |
| 114. All of the above (1 new link of 1) |
| 115. Almuth (1 new link of 1) |
| 116. Alternative (1 new link of 1) |
| 117. Alternative press (1 new link of 1) |
| 118. Alvis (1 new link of 1) |
| 119. Amarnath (1 new link of 1) |
| 120. Ambi (1 new link of 1) |
View (previous 20) (next 20) (20 | 50 | 100 | 250 | 500)