Error!
SELECT c.cid, c.name, (SELECT COUNT(`pid`) FROM `at_pressrelease` p WHERE p.state = 1 AND p.cid = c.cid AND p.addtime > 1542304000) AS today FROM at_category c WHERE 1=1 GROUP BY c.cid, c.name ORDER BY c.position ASC