The current time is May 18, 2024, 14:44 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 40, 21
Showing below up to 20 results starting with #41.
View (previous 20) (next 20) (20 | 50 | 100 | 250 | 500)
| 41. Intrasexual competition (2 new links of 7) |
| 42. Iray (2 new links of 2) |
| 43. Janardan Singh (2 new links of 2) |
| 44. Juan Zapata (2 new links of 2) |
| 45. Kota (2 new links of 2) |
| 46. Lake George, New York (2 new links of 2) |
| 47. Lehi (2 new links of 2) |
| 48. Liefde (2 new links of 2) |
| 49. Ludlow, Vermont (2 new links of 2) |
| 50. MI (2 new links of 2) |
| 51. Mandu (2 new links of 3) |
| 52. María Rivas (2 new links of 2) |
| 53. Match (disambiguation) (2 new links of 2) |
| 54. Mohi (2 new links of 2) |
| 55. Muhammad Jamil (2 new links of 2) |
| 56. Newtown, Pennsylvania (2 new links of 4) |
| 57. Ramnagar (2 new links of 2) |
| 58. Sacro (2 new links of 2) |
| 59. Sakado Station (2 new links of 2) |
| 60. Shahkot (2 new links of 2) |
View (previous 20) (next 20) (20 | 50 | 100 | 250 | 500)