The current time is May 19, 2024, 23:30 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 70, 21
Showing below up to 20 results starting with #71.
View (previous 20) (next 20) (20 | 50 | 100 | 250 | 500)
| 71. À l'origine (2 new links of 2) |
| 72. ABC Kids (1 new link of 1) |
| 73. AELC (1 new link of 1) |
| 74. AF (1 new link of 1) |
| 75. AIE (1 new link of 1) |
| 76. AL (1 new link of 1) |
| 77. ASA (1 new link of 1) |
| 78. Abbasi (1 new link of 3) |
| 79. Account (1 new link of 1) |
| 80. Active surveillance (1 new link of 1) |
| 81. Ada (1 new link of 1) |
| 82. Administrator (1 new link of 1) |
| 83. Adyar (1 new link of 1) |
| 84. Aftab Khan (1 new link of 1) |
| 85. Afzal Khan (1 new link of 1) |
| 86. Agent (1 new link of 3) |
| 87. Agitation (1 new link of 1) |
| 88. Agonia (1 new link of 1) |
| 89. Ahmed Malik (1 new link of 1) |
| 90. Ahmed Yusuf (1 new link of 1) |
View (previous 20) (next 20) (20 | 50 | 100 | 250 | 500)