Statement des Tages

SELECT
    `adminnews1`.`adminnewsdate`,
    `adminnews1`.`adminnewspriority`,
    `admin`.`adminrole`,
    `admin`.`adminfname`,
    `admin`.`adminname`,
    `adminnews1`.`adminnewstext`,
    `adminnews1`.`adminnewsid`,
    `adminnews2`.`posts`
FROM
    `admin`
INNER JOIN `adminnews` AS `adminnews1`
    ON `admin`.`adminid` = `adminnews1`.`adminid`
    AND `adminnews1`.`adminnewsparent` = '0'
INNER JOIN
    (
        SELECT `adminid`, COUNT( `adminnewsid` ) AS `posts`
        FROM `adminnews`
        GROUP BY `adminid`
    ) AS `adminnews2`
    ON `admin`.`adminid` = `adminnews2`.`adminid`
ORDER BY `adminnews1`.`adminnewsdate` DESC
LIMIT 0 , 30;

Oder einfach: Gib mir die neusten News mit Autor und Anzahl der Postings. 🙂