Untitled

mysql query need help
Id, user_id, title, content, date

SELECT * FROM `posts` GROUP BY `user_id`
ORDER BY `ID` asc

SELECT * FROM
   (SELECT * FROM posts ORDER BY date desc) AS `result`
    GROUP BY `result`.`user_id`

SELECT max(post_id) AS post_id FROM posts GROUP BY user_id;

SELECT user_id, max(date) AS most_recent FROM posts GROUP BY user_id

SELECT p1.*
  FROM
    (SELECT max(post_id) AS post_id FROM posts GROUP BY user_id) p2
    JOIN p1 ON (p1.post_id = p2.post_id);

SELECT p1.*
  FROM
    (SELECT user_id, max(date) AS most_recent FROM posts GROUP BY user_id) p2
    JOIN p1 ON (p1.user_id = p2.user_id AND p2.most_recent = p1.date);

SELECT  p.*
FROM    (
        SELECT  DISTINCT  user_id
        FROM    posts
        ) pd
JOIN    posts p
ON      p.id =
        (
        SELECT  id
        FROM    posts pi
        WHERE   pi.user_id = pd.user_id
        ORDER BY
                user_id DESC, date DESC, id DEST
        LIMIT 1
        )

SELECT * FROM posts GROUP BY user_id ORDER BY ID desc

SELECT * FROM (SELECT * FROM posts WHERE 1 = 1 ORDER BY ID desc) GROUP BY user_id