SELECT a.postid,a.author,a.title,a.post,a.showtime,b.realtime,a.posticon,a.ip
FROM (SELECT * FROM (SELECT * FROM bcb_comments ORDER BY posticon DESC) AS resone GROUP BY title ORDER BY posticon DESC) AS a, (SELECT * FROM (SELECT * FROM bcb_comments ORDER BY realtime DESC) AS restwo GROUP BY title ORDER BY realtime DESC) as b
WHERE a.title = b.title
ORDER BY a.posticon ASC, b.realtime DESC