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.