[sql]
SELECT
取得カラム名
FROM
`users` AS `User`
LEFT JOIN
works AS `Work`
ON
(`User`.`user_id`=`Work`.`user_id`)
LEFT JOIN
messages AS `Message`
ON
(`Work`.`user_id`=`Message`.`user_id`)
ORDER BY
`User`.`user_id` desc LIMIT 24
[/sql]