Error!
SELECT c.id, c.title, (SELECT COUNT(`pid`) FROM `at_pressrelease` p WHERE p.state = 1 AND p.country = c.id AND p.addtime > 1600826925) AS today FROM at_country c WHERE 1 GROUP BY c.title, c.id ORDER BY COUNT(today) DESC