Tag Archives: Inner Join

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 […]

Posted in Allgemein | Tagged as: , , , ,