The current time is May 18, 2024, 12:33 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 500, 21
Showing below up to 20 results starting with #501.
View (previous 20) (next 20) (20 | 50 | 100 | 250 | 500)
| 501. Guilty (1 new link of 1) |
| 502. Guilty Conscience (1 new link of 1) |
| 503. Gujarat Giants (1 new link of 1) |
| 504. Guna (1 new link of 1) |
| 505. Gustav Adolf (1 new link of 1) |
| 506. Gustavsberg (1 new link of 1) |
| 507. HCL (1 new link of 1) |
| 508. HD (1 new link of 1) |
| 509. HDC (1 new link of 1) |
| 510. HGV (1 new link of 1) |
| 511. HJS (1 new link of 1) |
| 512. HP (1 new link of 1) |
| 513. HRF (1 new link of 1) |
| 514. Ha Yu (1 new link of 1) |
| 515. Haddington (1 new link of 1) |
| 516. Haileybury (1 new link of 1) |
| 517. Hairspray (1 new link of 1) |
| 518. Hajjaj (1 new link of 1) |
| 519. Hakusan (1 new link of 1) |
| 520. Halle (1 new link of 1) |
View (previous 20) (next 20) (20 | 50 | 100 | 250 | 500)