Roland Häder (roland)'s status on Sunday, 18-Jan-2015 08:15:20 CET
-
Roland Häder (roland)'s status on Sunday, 18-Jan-2015 08:15:20 CET Roland Häder #TOP10 user list:
SELECT `n`.`profile_id` , `p`.`nickname` , `p`.`profileurl` , COUNT( `n`.`id` ) AS `dents`
FROM `notice` AS `n`
INNER JOIN `profile` AS `p` ON `p`.`id` = `n`.`profile_id`
GROUP BY `n`.`profile_id`
ORDER BY `dents` DESC
LIMIT 10
#SQL