Anonymous

SELECT id, cat_id, DATE_FORMAT(date, "%m.%d") as date_md, title, title_url, content, STATUS, comments, views, (SELECT COUNT(*) FROM comments WHERE post_id = posts.id) as num_comm FROM posts ORDER BY date DESC LIMIT 10;